Page Comparison

Steps to upload data via the

...

Data Importer portal

1.

Anchor
Start Start

Open up the Data Importer portal by using the url http://biaweb.forest.usf.edu/BIADataLoad/Import/FileTypeSelection

Image Added

2. Click on the 'Start Submission' Button or 'Log in' link on top of the screen.  This will bring up the NetID logon screen

Image Removed

2you to the Microsoft Azure SSO log-in screen where you will log into your USF account.

3. After logging in, the 'File selection' screen will be displayed. Only files to which the user has been granted access will be displayed.

34. Click on on the 'Download Template' link next to the file type that you are interested in uploading . This will bring up the Excel template that can be saved to any folder.

45. The Excel file has 2 tabssheets. Tab Sheet 1 'Data Upload Template' contains sample data. Tab   This Sheet 2 'Data Definitions' contains the meta data details and how data should be input. 

Image Added

5. Add 6. Remove the sample data and add your data to the downloaded file for the current review year. Save and Sheet 1.  The first sheet is the only sheet that will be uploaded.   Save your file, then click on the "Upload File' button on the 'File Selection' screen. This will take you to the upload screen pictured below.

Image Removed

6.

7.

Anchor
Upload Upload

Drag and drop your excel file into the browser upload window or use the browse feature to select your file and click on the 'Validate File' button

78. If there are no errors in the file, the following Data Validation screen will be displayed.

Image Removed

8display the 'No errors were found during validation' message. 

Image Added

Note
If there are any warnings, the warnings will be displayed. However this will not prevent you from uploading the file and you can proceed to the next step . If there are any errors, follow this error section to resolve it as you will not be able to proceed to step 9 i.e Finalize Import step.

9. Click on the 'Finalize Import' button to complete the upload process. The following screen "Import Completed' message will be displayed to indicate that your file was uploaded successfully. 

Note
After uploading data successfully, any changes should be communicated to ODS to get the approval before uploading again.

910. Click on the 'Return' button to go back to the Data Importer 'File Selection' home screen. 

10

. You have successfully completed the upload process.

Note:

Anchor
Error Error

If there are any errors in the file validation(step 6), the following message will be displayedData Validation screen will display the Error count and clicking on it will show the error details,. The error message can be saved using the 'Save Log' buttonlink.  Fix the errors in the file and Clicking on the 'Save Log' will download the errors into a text file to be worked on later or shared with someone who is actually putting together the excel file.  Once the corrected file is ready, click on 'Back' to re try the file upload on step 7. or log back later to the portal to start the process again at step 1