How to upload records
Attention. To upload records to a data group, you must ensure the following:
-
Submissions has level 2 subscription.
-
The upload feature for the data group is enabled.
-
You are logged in with the role StatutoryAdmin.
You can upload up to 10,000 records to data groups from Excel files to add, update, and delete records. You should only upload records to data groups that are reported manually.
Upload records from Excel files to data groups as follows:
-
Create a file in Excel for uploading records and add the records to modify.
Attention. You can create the template using information described in acronym taxi documentation as detailed in data groups. Alternatively, you can download records from the required data group and use the downloaded files as a template.
- The file type must be an Excel workbook (
*.xlsx
). - The file name must be the same name as the data group, such as
Course of Study.xlsx
. - The position of columns cannot be changed, and any additional columns will be ignored.
- The name of the sheets in the Excel file cannot be changed. Sheets with changed names will be ignored.
- The characters allowed in the
SMSref
areupper case eh to z, lower case eh to z, 0-to9 dash, dot, underscore, tilda, open parenthesis, close parenthesis, apostrophe, exclamation mark, star, colon, at, comma, semi colon
. - The
DeleteIndicator
is consideredFALSE
by default. Therefore, if left empty,FALSE
is used.
- The file type must be an Excel workbook (
-
Add the records that you need to upload or modify.
-
On the data group, go to upload and browse to the Excel file on your computer. Then, wait while the upload process finishes noting any errors that are highlighted.
-
Refresh the page to view the uploaded records, which appear at the top of the grid.