Page Comparison

There are three utilities that can export into excel and then import back into RTA. They are vehicleVehicles, parts Parts and VMRS export/imports. Here is the how to using the parts "How To", using Parts as the example, but it works the same for the others.

1. Go to the file path System > Utilities > Parts > Export/Import and enter in the level 3 password.
   Image RemovedImage Added
   
   
2. Make sure that "Export" is selected, choose your parameters, and then put in your file location. After verifying the location, hit click "OK". " This will save the export file as a .txt file.
   Image RemovedImage Added
   
   
3. Once you have saved the file, open up a blank excel document. Go to File > Open and search for where you saved the documentfile. You will need to switch the file type from excel files to all files in the bottom right of this window from Excel files to "All Files" so that you can locate the .txt file. Select the file and hit click "Open."
   Image Modified
   
   
4. The following message will may be displayed:
   Image RemovedImage Added
   Select "Yes." and a text Import Wizard will show up.
   
   
5. By default, you should be able to click 'Next' through Steps 1 & 2, but just to confirm, Step 1 of 3 should be set to "Delimited". Click Next.
   Image RemovedImage Added
   
   
6. Step 2 of 3 should be set to "Tab". Click "Next."
   Image RemovedImage Added
   
   
7. In Step 3 of 3 of the Import Wizard, there is a 'Data preview' pane shown at the bottom. Drag the scroll bar at the bottom of this display all the way to the right. In the very last column, hold down the shift key and click your mouse at the top of the last column. This should select or highlight all columns in black. Finally, change or select "Text" for the column Column data format. This will change all of the column headers to 'Text'. Then click "Finish."
   Image RemovedImage Added
   
   
8. Now you have an excel doc Excel file that you can edit. Make sure you leave all of the data formats the same if this is a file that you plan on importing back into RTA. For example, the facility PART_FACILITY column has leading zeroes and if changed it will not import back in into RTA properly. If you are adding new part, vehicles, etc, make sure the data format is the same.
9. Once you have made all the desired changes, again make sure to save the file as a .txt file so it can be imported back into RTA. To import this file back into RTA, go back to System > Utility > Parts > Export/Import, enter in the level 3 password.
10. Now, make sure you select "Import," if you added parts/vehicles, make sure you also select add 'Add non-file'. If not, just select/locate the file using the magnifying glass and hit click "OK". " It will then run through and process your records.
    Image Removed
    Image Added