User Tools

Site Tools


uis_exporter

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
uis_exporter [2018/09/25 23:38] – UIS Exporter Manual jeremykellsuis_exporter [2021/02/23 05:00] (current) – [Running the Application] ghachey
Line 9: Line 9:
 ===== Generated Tables: ===== ===== Generated Tables: =====
  
-The following tables in **Bold** are generated by this application – The remaining tables request data not currently available in FEDEMIS+The following tables in **Bold** are generated by this application – The remaining tables are currently not supported or the data is not available in the data warehouse.
  
   * A1: General information on the data collected in the questionnaire   * A1: General information on the data collected in the questionnaire
Line 30: Line 30:
 ===== Required Setup ===== ===== Required Setup =====
  
-  * Download zip file containing the application from(FILL THIS IN) +  * Download file containing the application {{ :user-manual:uis_exporter.zip |}} 
-  * Extract contents of zip file to a directory on your PC +  * Extract contents of file to a directory on your PC 
-  * Open the .config file and modify/fill in the required details (typically just the EMIS SQL server details).  Save this file.+  * Open the //EmisExporter.exe.config// file and modify/fill in the required details (typically just the EMIS SQL server details).  Save the file.
  
-{{:emisexporter.exe.config.png?400|}}+{{ :emis-exporter-config.png?nolink |}}
    
  
Line 40: Line 40:
  
  
-  * Double click on the exe file to start the application.+  * Double click on the //EmisExporter.exe// file to start the application.
   * When prompted, select the Year for the dataset you want to extract.   * When prompted, select the Year for the dataset you want to extract.
   * Click Continue to start the extract – This will likely take a couple of minutes to complete.   * Click Continue to start the extract – This will likely take a couple of minutes to complete.
Line 46: Line 46:
   * Please verify that the data is correct before submitting to UIS   * Please verify that the data is correct before submitting to UIS
  
-{{:emis_exporter.png?400|}}+{{:uis-exporter.jpg?400|}}
  
-===== Additional Design Notes =====+<note tip>If you need to process the file again (e.g. you updated some missing data) make sure you close excel  as you will get an error.</note> 
 + 
 +<note warning>Normal user information stops here. What follows is for developers.</note> 
 + 
 +===== Additional Design Notes for Developer =====
    
-The codebase for this application is currently online at https://github.com/JeremyKells/emis-exporter+The codebase for this application is currently online at https://github.com/JeremyKells/emis-exporter/tree/FSM
 The Application is designed to use a two step process to create the extract. The Application is designed to use a two step process to create the extract.
  
uis_exporter.1537918695.txt.gz · Last modified: 2021/02/02 02:10 (external edit)