This utility, first introduced in 7.2.4, now increases what areas you can import data into RTA. These Beginning with 7.2.5.64, these now include Departments, Customers, Equipment, Vehicles, Vendors, Parts and , Employee, Vehicle Class Codes, Part Kit, Part Kit Component, Part VMRS, VMRS Work Order, Vehicle GDF, Part Vendor, GDF Master, PO/Vendor GDF. The Export and Import functions are now separated into two sub-menus. This utility prompts for system password level 3.
How to Create a Column Template (Column Headers Only)
- Export out all the available header names by going to System > Utilities > Import/Export > Export Import (STIE)Save and STII)
- Select file or files you want to create a template and click on the Template button in the tool bar.
- File will automatically be saved to C:\Fleet and you can open that file with a spreadsheet
- Compile your master record data in a spreadsheet and copy over the appropriate data you wish to import and save as a text file
- Then go to System > Utilities > Import/Export > Import (STII)
- Check the box of the file you wish to import and choose the file path where the file you wish to import was saved.
- Double Click the options window for selected file and select Add Non-file and/or Update Existing boxes
- Choose whether you wish to Preview, Test or Run the import. Then click Import
For more information go to the page Import / and Export Utilities