Upload Qtracs Vehicles Utility 1.6
How to setup & use the Upload Qtracs Vehicles Utility:
Setup:
1. Ensure the Java Virtual Machine 1.6 or greater is running on your machine. This can be determined by executing "java -version" at a command prompt. Java is case sensitive, so the command must be lowercase. You should see output similar to the image below. If you do not see similar output, go to http://www.java.com and install the JVM suitable for your machine. Make sure you install the correct 32 or 64 bit JVM.
2. Unzip the attached zip file to the folder of your choice. Please leave the folder structure inside the zip file intact. /QESTSTools/lib
3. Confirm successful installation by calling UploadQtracsVehicles.bat. The following window should appear. If you don't, check your java version again and the logfile.txt in the folder where the zip was extracted for further details.
Upload Vehicles Utility reads a csv file depicted in the format below and creates vehicles in a Qtracs Portal Account. This csv file should be pipe-delimited "|" with each value surrounded by double quotes.
"scac"|"vehicleid"|"vehiclename"|"UA"
""|"ktz200"|"katies mcp200"|"0105347121"
1. Run the UploadQtracsVehicles.bat file. You should see the following window. If you don't, check your java version again and the logfile.txt in the folder where the zip was extracted for further details.
2. Enter the portal credentials and location of the .csv file and click Process.
3. A completion window will indicate when the import is complete.
4. Review the logfile.txt in the folder where the utility was unzipped. It will contain the results of the upload. **Please note: this file is overwritten every time the utility is ran.