When you have loaded your data into tables, you need to check that your data was ingested into the Senate platform so that you can provide access to others.
Note: If you have a large amount of data to upload, it could take a while. You can go on to the next steps (creating views and packages) while you wait. Make sure you come back to check the upload.
There are two things to do:
- Check that the upload job completed.
- If there are errors, create a new table and fix them.
Checking the upload
From the menu select, Manage Data.
On the Manage Data screen, click the Load Jobs tab.
The Load Jobs screen lists data jobs that have been submitted and whether they were loaded successfully.
If your job is not listed, the platform is probably still working with it. Click Refresh Data after a few minutes.
When you have located your job, check for any errors:
- If the validation status is Passed, it means that your data is ready for access.
- If the validation status is Failed, it means that your data is not ready for sharing. If there are errors, click Show Errors.
Errors, if any, for your job are listed.
Common table load errors
Common causes of errors include
- a mismatch between the type of data you specified when setting up your columns and the actual data in your file. For example, some columns have been set up in a table as data type double and int, which are numbers, but the data in the file has a comma in it, meaning Senate has regarded it as text.
- a mismatch between column size in the file and table; i.e. the number of columns in the file does not match with the number of columns in your table.
Fixing upload errors
How you go about correcting load errors will depend on what’s wrong.
- Check that you have selected the correct field delimiter; selecting the incorrect delimiter could lead to errors and a mismatch between column size in the file and table. Also compare the number of columns in your file against the number of columns expected in the table.
- Check whether your file has any headers and indicate whether or not there is a header when creating a new table.
- Alternatively, you may want to consider changing the data type of the columns in your Senate database if it does not match with the data type in your file. Note: A new table will need to be created, as it is not possible to edit columns in Senate.