Technical Resources

Technical Resources

Upload instructions

Uploading a salary file

The first step is to log in to Online Services with your username and password. Online Services includes access to edit program reports, file uploads and file downloads. Salary files must be in comma-separated value (CSV) or TXT format.

Select “Salary File Upload.” A dialogue box will appear allowing you to browse for the file you wish to transmit. Once you have selected the file, the file name will appear beside the “Browse” button. You may enter a description of the file (i.e., TRAF September 2022). Click “Upload File” to upload the file. Once completed, the Status column will show “Processed” or “Error.” If the Status field shows that the file has been processed, proceed to editing your file (see instructions below). If there is an error, click on “Error Log” to determine where the error occurred. Go to your file, fix the error, re-save the file and re-upload it.

Uploading a miscellaneous file

Any file, other than your salary file, can be uploaded following these instructions. Log in to Online Services as above. Click on “File Management.” A dialogue box will appear allowing you to browse for the file you wish to transmit. Once you have selected the file, the file name will appear beside the “Browse” button. Click “Upload File” to upload the file. TRAF will receive an email advising that a miscellaneous file has been uploaded.

Editing a salary file

Once your salary file has been uploaded successfully, you can begin editing the file. Click on the 5250 session, which will open a new tab in your web browser. Log in with your 5250 session username and password. Note: This password changes periodically so it may be different than your Online Services password. Choose Option 1, and enter an “x” to enter your division batches. With an “x,” select the batch you wish to edit. Proceed to edit your batch using the Edit Program Checklist.

Comma-separated value format

In order to upload a file, it should contain plain text data in a CSV or TXT format.

A CSV file is a text file that contains one line per record of data, and all the fields within a record are separated by commas.

Examples:

CA,123456789,49,2155,2001,7,3,2032.27,122,200,50000,0,0,0,0,0,Whyte,Lily,19500401,F,12345

CA,456789123,49,2155,2001,6,3,670.65,61,200,33000,0,0.5,0,20000102,0,Greene,Kelly,19740321,F,23456

CA,456789123,49,2155,2001,6,74,30.48,2,200,33000,0,0,0,20000102,0,Greene,Kelly,19740321,F,23456

Notice that each record is on its own line and each line has the same number of fields separated by commas.

Transaction Layouts

TRAF’s Transaction Layout reporting system shows the format and data required for your reports.