Overview

Describes the file layout for third party or other PACCAR applications to upload into the Global Truck Locator database. The file that is uploaded and processed is a ZIP file, which contains a data file, a separate image file for every truck that has a picture and a text file containing email address where the status of upload of that particular zip file could be reported back. The data file format is a comma delimited (CSV) file. Each image file must be a standard JPEG formatted image. We no longer support GIF images regardless of the upload format.

The upload process has been enhanced to allow for the addition of additional data and truck pictures, but in order to use these new features you must generate the upload file in the new format. The old format is still supported and will be until December 31, 2001, to give you time to perform any conversion on your processes to the new format.

Version

Version 1.0 – June 2001

ZIP File Contents

DATA File Layout

All records are laid out as follows:

The DATA file records are laid out as follows:

Header-record

This is the first row in the CSV comma separated file. The only function of this row is to indicate the order in which the information is expected. Users are welcome to describe the items in this row with more descriptive names as per their systems as long as they don’t change the sequence of the items. This top row is totally ignored by the GTL upload system.

If users decide not to have any description in this row, make sure to leave the first row blank and start listing trucks from second row.

This is an example of the header row and first row of data as contained in a comma delimited file with a .csv extension.

How to create a .CSV file

To create a comma delimited file open a new page in Microsoft Excel and type in the data sequentially as illustrated below in Column Name or leave the first row blank and start listing trucks from the second row.  Choose File - Save As option from the menu.  Choose your destination folder, enter a file name, change the File as type to:  CSV (Comma delimited) (*.csv).  When you click Save, a pop up message will appear that reads, The selected file type does not support workbooks that contain multiple sheets. click OK and proceed.

Format for VERSION 1.

Other Supported Version

Un-numbered version from UTL: Please refer to UTLUploadFileFormatNA.doc for details.

This version was used in old UTL version of truck upload. It will continue to be supported for backward compatibility until 12/31/2001.

Important: Since the processing of TruckUpload has changed you no longer will get the results of your upload online. You may include a text file named config.txt within your zip file that contains your email address on the first line. This email address will be used to return the status of the upload process of that particular zip file.

Inclusion of this config.txt is optional but recommended.

Valid Values

• VERSION: Currently version #1 is supported along with the previous (UTL-1) unnumbered version.

• DLR_CD: Dealer Code e.g. A265, A266, R200, R203 etc

• TRK_MDL_YR: In the range of current year to last 50 years. E.g. 2001-1951

If current month is past April (the cut over for next year model) then the valid range is Next year to last 51 years. E.g. 2002-1952 if a truck is uploaded anytime after the month of April 2001.

• TRK_MAK_MFG_NM:

5.TRK_MDL_CD: Valid value of this field depends on TRK_MAK_MFG_NM.

6. SER_CHS_ID: A unique serial number assigned by the manufacturer of the truck, i.e. B9X6SJ674577 Acceptable values: At least six characters. Should not contain any blanks.

7. TRK_MIL_NO: Mileage.

Acceptable values: At least two-digit integer. Number zero if unknown.

8. TRK_MIL_TYP_DES:

9. TRK_ENG_HP_NO: Engine HorsePower

Acceptable values: Three-digit integer in the range of 200 to 400. Number zero if unknown

10. TRK_XMN_SPDS_DES:

11. TRK_SSP_TYP_DES:

12. TRK_VEH_TYP_DES:

13. TRK_BD_TYP_DES

14. WHL_SL_AMT: Wholesale amount.

Acceptable range: Any number no greater than 9,999,999.

15. ASK_PRC_CRY_TYP

16. TRK_WB_NO: Wheel base number.

Acceptable values: Three-digit integer in the range of 100 and 500.

17. TRK_RR_AXL_RTO: Rear Axle ratio.

Acceptable values: Number zero if unknown or three digit integer in the format of n.nn. Valid range is from 2.00 to 5.00

18. TRK_CLR_DES: Color description of the vehicle.

19. STK_UNT_NUM: Unit Stock number. Free format text field for dealer’s usage.

20. RTL_PR_AMT: Retail Price Amount or Asking Price

Acceptable values: Number zero if unknown or any number no greater than 999,999.

21. ALM_WHL_CNT: Aluminum wheel count.

Acceptable values: Must be a one or two digit integer in the range of 2 to 20.

22. TRK_VEH_ID_NO: Vehicle Identification number. Must be no more than 17-character string.

23. ACQ_MTH_DES: Acquisition Method.

24. EXT_ONL_LIS_IND

25. CMT_TXT: General comments.

26. FILENAME1: Picture File name.

27. FILENAME2: Picture File name.

28. FILENAME3: Picture File name.

29. TRK_CLS_CHA_DES

30. SLP_ROF_TYP_CHA_DES

31. ENG_MAK_DES

32. RR_AXL_CPC_MEA: Rear Axle Capacity.

Acceptable values: At least five-digit integer in the range of 10,000 to 70,000. Number zero if unknown.

33. SLP_CAB_SIZ_MEA: Special Cab Size measurement.

Acceptable values: Number zero (0) if unknown or any integer in the range of 36 to 192.

34. ENG_MDL_ID: Engine Model ID. Free form text field.

35. RR_TIR_SIZ_TXT: Rear Tire size. Free form text.

36. ASR_PGM_TYP_CHA_DES

37. MFG_WTY_IND

38. BPR_TO_BOC_MEA: Number of inches from truck bumper to back of cab.

Acceptable values: This is not a required field but if provided should be two-digit integer in the range of 60 to 600.

39. PDF_SPEC_FILE: Truck Specification. This is optional. If provided, it should be a PDF file containing additional specifications of the truck. Truck upload is the only way to provide this file to GTL. This file shows up as a hyperlink on the Detail page within GTL web site.

40. PDF_PIC_FILE: Additional pictures (more than 3 that GTL can already accept) of the vehicle. This PDF file shows up as a hyperlink on the Detail page within GTL web site.

41. FRT_AXL_CPC_MEA: Front Axle Capacity. Must be 5-digit number between 10000 and 70000. Another acceptable value is 0 (zero) if the value is not known.

42. FRT_TIR_SIZ_TXT: Front Tire Size. Integer number.

43. ENG_BRK_IND: Engine Brake Indicator.

44. SLP_BNK_TYP_CHA_ID: Sleeper Bunk Type.

45. AVL_DT: Available date. Date in the format of mm/dd/yy

Config File Layout

Upload looks for a specific text file with the name config.txt. This text file is expected to contain return email addresses (one or more) on the first line separated with semi colons (;) to report status of the upload.

E.g.: johndoe@somewhere.com;janedoe@somewhere.com

Upload process goes ahead processing the zip CSV file even if Config.txt file is missing from the zip file or if doesn’t have proper email addresses on the first line. Just the status reporting of the upload is ignored.