School Demographics: Generic SuperDB Import

The Generic SuperDB Import allows you to update an existing generic SuperDB table using a CSV (comma-delimited) or TXT (Tab-delimited) file. Before initiating the import process, ensure you have a CSV or TXT file containing all the necessary data for import. 

To begin the process, navigate to the School > Demographics Dashboard. On the Import tile, select Generic, then click on SuperDB Import

1. If this is the first time doing an import, select . If an Import as previously been completed and a Template has been saved, choose a Template from the list.
   
2. The Select File and Map Fields window opens. Here you can select a file, map the file fields to the Generic Super DB Fields and save this as a template.
   Note: The Select File and Map Fields window is slightly different depending on if New Import or Template was selected.
   New Import
   
   From Template
   
   
   

   Select File and Map Fields
   A	Import to Table: Select the Generic SuperDB table. Select File: Click to select the CSV or TXT file containing the data to be imported.
   B	Map Fields: Map the data from the file to the corresponding fields in the SuperDB table. Be sure to map each field accurately to ensure the data is imported into the correct SupeDB fields. The name of the Fields in the File are listed along the top. Below on the Map To line, select to map the data column to the correct Generic SuperDB field. The Select a Field dialog box will open. Use the Search bar to look for the field or scroll. Click the field name and choose Select. Continue this to map all fields needed in the file. It is not necessary to map all columns. If any column in the file exists that does not need to be imported, the column can remain as Not Mapped. Scroll to the right along the bottom to view additional field columns.
   C	To use this for another import, select Save as Template. This will save the field mappings and selecting settings. The Template will appear on the Import: Generic SuperDB Data window:
   D	Clickto cancel the import process. Your progress will not be saved.  Click to continue.

3. After clicking Next, the Analyze The File/Trial Run window will open. Here you will see the test results run prior to completing the import. In the example import below the following test results will display:
   • Number of rows updated. Select View Details to see which rows
   • If there is any additional information as to why data could not be imported, it will be listed here, and the reason can be viewed by selecting View Details.
   • The number of fields not mapped. Select View Details to see which fields.
4. Select Import if the Test Results are correct and the data is ready to be imported.
5. You will receive a message once the import is completed. Select Click here to download log to view the log in excel. To view the log at a later date, it is also available to view under School > Demographics > Import > Generic.