Uploading a CSV to Import Data Uploading a CSV to Import Data

Uploading a CSV to Import Data

Chandra Bergmann Chandra Bergmann

Data Grid Portal Pages allow users to upload .CSV files in order to import data into an App Object in AirData. This provides a mechanism to bring existing data into AirData with ease, and it supports all data types that are available when creating an App Object. 

The information contained within a .CSV file can be appended to the information already contained within a Data Grid by simply clicking on the appropriate icon to the upper right of the Portal Page and then selecting the appropriate .CSV file from your computer:

2021-08-18_16-46-54__1_.gif

Note that data contained in an uploaded .CSV will be appended to the data that already exists in AirData, it will not overwrite it. For instance, after the .CSV file from the gif above has been processed, the data will display as follows. Note that it contains all rows displayed previously, as well as the additional two rows of data given by the uploaded .CSV file:

2021-08-18_16-51-15.png

Processing a CSV File

Information from within a .CSV file must be verified and imported before being added to AirData and displayed as part of a Data Grid. This can take some time, and so appended data will not immediately be seen upon submitting a .CSV file.

You will be sent an email upon the confirmed success or failure of your upload. Upon a successful upload, you will be able to see the changes you have made in the Data Grid upon refreshing the Portal Page.

Appropriately Formatting CSV Files

In order for the data contained in a .CSV file to be uploaded into AirData, the format of the data must match the format of the AirData App Object exactly. For instance, the uploaded .CSV file in the opening example was formatted as follows:

2021-08-18_16-45-08.png

Or, as a raw .CSV:

Name,Number
Dan,4
Elliot,5

Note that the data contained in the above .CSV file matches the AirData App Objects, Example App Object, exactly. Information parsing is case-sensitive, so even the capitalization on each object property must be the same as is defined in AirData.

If the data contained inside the .CSV file does not match the formatting of the App Object in any way, it will fail to be added to AirData, and you will receive an email to that effect.

Was this article helpful?

1 out of 1 found this helpful