Skip Navigation
Oklahoma State University
Transportation Services

Parking and Transportation Services

Motorpool FRS File Conversion

The purpose of this form is to convert a FRS file exported from SQ7. It inserts a "Billed Date" description and a "UnitID" to each record.

  1. Click on Choose File, and browse to the location where FRS Export file is stored, for example, Q:\VTracker\AIExport\FRS_Exports.
  2. Click on "Submit" button.
  3. Open the file if it is not already open and inspect its content. Each file must have at least three lines: A header, A detail and A footer
  4. File content in any other format is invalid.
  5. Here is a sample of file format.
  6. Copy the converted to Banner Finance\Motorpool.

FRS File Sample

FRS Files are uploaded to the Banner Finace\Motopool folder (V:\Drive).


        MPL             120230807 
        MPL             2J25 0V155676000000024064MVSS-Repair     W0948730  V955676  C  1      123456      987454
        MPL             300000576000023412412