Project data can be uploaded in batches via the Utilities menu. This function may be of use to users who have already organized their CMAQ project data using a spreadsheet or database application. The process is a two-step process: First, data is uploaded into the system, and then it is sent to the database. Users at all levels can Upload Project Information, which entails formatting the data and sending it to a server maintained by FHWA.
Prior to uploading project data, first put it into the required format as discussed in Appendices 1 & 2. Systems that can output text files in coma-delineated format can be used to prepare data to be uploaded in a batch into the CMAQ Tracking System.
To upload project information, click on the Utilities tab and select Upload Project Information link and click the Browse button to select a file.
You are now able to select a file from your computer to upload. Once the file is selected, click the Open button, and then click the Upload File button to proceed.
NOTE: The system will scan uploaded data for proper formatting according to Appendix 1 at the end of this document. The system will reject data that is not in the proper format, and will report error messages as appropriate.
A confirmation page will appear, displaying the contents of the file and the number of CMAQ projects uploaded. At this point the user can review the data and has the option to Discard Project Data if there are any errors. The confirmation page will also display the user's UPACS ID to indicate that the information is coming from that user and that the user will be the point of contact for any issues with that project file.
Once files have been successfully uploaded, a user with approval rights at your level will need to send the files to the database using the Send to Database command. Then, the project data has to go through the normal approval process
Note: If there is uploaded data waiting to be sent to the database by you (or someone else in your organization with the same approval rights), when you first log into the CMAQ system you will see a note to that effect.