Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
PlanningEnvironmentReal Estate

HEP Events Guidance Publications Awards Contacts

CMAQ Project Tracking System User's Guide

7. Utilities: Uploading Project Information

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.

Step 1: Upload Project Information

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.

screenshot of Utilities page with Utilities tab Upload Project Information link and Browse button highlighted

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.

screenshot of Choose File window with Open and Update File highlighted

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.

screenshot of confirmation page with number of CMAQ projects and the user's UPACS ID highlighted

Step 2: Send to Database

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.

Updated: 7/6/2011
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000