After location data is uploaded to DataManager, you can modify the data as needed by submitting a new data file containing the data you want to change. For example, you can change the location name, city, or zip code of any location.
Note: You can also change some data values directly in the DataManager interface. See Update Location Information.
1. Open the Location File Template in Microsoft Excel®.
2. Type or copy location data into the columns. Note the following:
– Do not delete columns from the template or change the header text.
– Enter only permitted values in the fields. See descriptions of columns and valid values for length limits and special characters. Commas are not permitted.
– The first file you submit must contain the District/Area column. Prior to testing, the first three columns, District/Area, School/Building, and Class, must be completed and submitted to Riverside. The remaining columns are optional and do not require information.
– The District/Area, School/Building, and Class fields must be identical in all three data files (Location, Staff/User, and Student)
– You can either type the data directly into the cells of the template, or you can copy and paste data from another file into the template.
3. When you have finished adding data to the template, click File, and then click Save As. The Save As dialog box appears.
4. In the Save in list, browse, as needed, and select the directory where you plan to retrieve the file when uploading.
5. In the Filename box, type a name for the file. The file naming convention for the data file to update location information is as follows:
upd_myrpcftpname_testfamily_location_mmddyy.csv
where:
– myrpcftpname is the username for the SFTP site on RPCFTP. Enter the username that was provided to the Account Holder in the Welcome Information email.
– testfamily is the test family name. Enter "default" if you plan to use this data file for more than one test family.
– mmddyy is the date you want associated with the data file, usually today’s date.
See File Naming Conventions for Data Files for more information about naming new data files.
6. In the Save as type list, save the file with a comma-separated values extension (.csv).
7. Click Save, and close the file. The file is ready to upload.
See Also: