These external interfaces with Global Truck Locator (GTL) are supported only on our private dealer Extranet: Dealer.PACCAR.Com. This site is secure and you must have an authorized user id and password in order to connect to the server.
We support two generalized interfaces to GTL, a data download and a data upload. Each interface is unique and has its own proprietary methods and data layouts. Each interface is secured separately; being authorized for one interface, does not give you access to the second interface. If you need access to both interfaces you must request access to both.
PACCAR does not support third party data interfaces to GTL. We only support the two data interfaces described herein. We do not support any scheduled processes to facilitate our data interfaces. Our business associates, at their discretion, invoke these interfaces externally to PACCAR. We do not support any form of FTP for our data interfaces due to security concerns with FTP. We only allow the HTTP protocol for transmission of data for GTL. We are in the process of implementing HTTPS, exclusively for the transmission protocol.
The external data download interface allows our business associates to extract Global Truck Locator data from our database and create a delimited data file, for use in some external process. We supply dealer data, information about our dealers (names, addresses, phone numbers, etc) and truck data, information about trucks that our dealers have available for sale. We also supply optional pictures/images for each truck.
This document describes the data that is available, the relationships between the data and the processes and procedures necessary to access the data.
GTL has been rewritten from a Cold Fusion/Windows NT 4.0 environment to an ASP/Visual Basic COM/Windows 2000 environment. This means better performance on our servers and reduced response time for you, our business associates.
We have expanded the data that is available for download, to our business associates, to include virtually all the data that is available on our database. This eliminates the need for special formats to each business associate. You simply choose what data you need out of our extensive data format.
Truck pictures are no longer stored on a database, but on the web servers file system. This makes downloading pictures immensely easier by just specifying a URL. You no longer need to run a special script to extract the picture from the database. The script is provided for backward compatibility reasons, although internally it just navigates to the correct picture on the file system.
While this may not be immediately beneficial to our North American business associates, GTL now supports multiple languages and is being implemented in Europe in five different languages. This gives us the capability to support Spanish and French Canadian in our North American markets. We still do not support the double byte character set. The big difference here is data being downloaded is now in the UTF-8 encoded format and not ASCII, using code page 65001.
We require the following information from our business associates, in order to access the download interface of GTL.
GTL External Data Download Interface Access Request |
|
Primary contact person |
|
|
Name: |
|
|
Title: |
|
|
Email: |
|
|
Phone: |
|
Company Information |
|
|
Company: |
|
|
Address: |
|
|
City, State Postal Code: |
|
|
Phone: |
|
|
FAX: |
|
|
Web Site: |
|
User Access Information |
|
|
User Id: |
|
|
User Id rules: User Ids should be the first and last name of user with an intervening space or a period "." Examples "john doe" or "john.doe". |
|
|
Password: |
|
|
Password rules: Passwords must be a minimum of six characters in length and contain both upper and lower case letters, numbers and at least one special symbol (!, @, #, $, %, ^, &, *, etc). |
|
If you require additional User Ids, just attach a second sheet listing each User Id and Password combination. Email the completed request to dealerservices@paccar.com or FAX to Dealer Services at 425-254-6003. Both should contain "GTL External Data Download Interface Access Request" in the subject.
All scripts for downloading data from Global Truck Locator are located at the following URL for the North American, English, instance of the application:
Proxy
A proxy is no longer required to gain access to this web site from the Internet.
User Id/Password
To access this web site you must authenticate by using your User Id and Password as confirmed at sign-up time. Your User Id only allows you to run scripts in the Public directory. Directory browsing is not allowed.
PACCAR Division
There are several PACCAR divisions per application instance.
North America Instance:
European Instance:
Dealerships
There are an infinite number of dealerships per division.
Trucks
There are an infinite number of trucks per dealership, and two basic data formats, one for North America and one for Europe. You are automatically given the correct format, depending on your application instance.
Truck Pictures
There are zero to three pictures associated with a truck. Pictures, if they exist (they are optional), are stored in four different sizes:
Script Execution and Parameters
Script execution and input parameters are all standard URL encoding. See the Web Site section above for the location of the script directory. The URL encoding is as follows:
The script name is appended to the end of the Web Site URL. The script name and script parameters are separated by a single "?" question mark. Each script parameter is separated by an "&" ampersand.
Examples:
Script Responses
All responses are returned using Character Set "UTF-8", Code Page "65001", and MIME type "text/plain" except for the truck picture, which is returned as MIME type "image/jpeg". Fields are separated by a vertical bar character, "|" (7C).
Response Data Layout
The detail data is laid out as follows:
position-1|position-2|position-3| |position-n(end-of-line-marker)
Generally the records are returned as follows:
Start-data-marker
[Header-record] (optional)
Detail-record-1
Detail-record-2
"
Detail-record-n
Ending-data-marker
The header record is optional and will only appear if "Header=Y" is used on the requesting URL.
End Of Line Marker Version 1
Each line ends with two vertical bar characters, "||" (7C7C) combination.
End Of Line Marker Version 1A and Version 2
Each line ends with a carriage return/line feed (0D0A) combination.
Starting Data Marker Version 1 and 1A only
Output always begins with a set of fixed characters and the date and time, as in:
*** START OF DATA 1999/10/12 14:42:56 ***
An input routine must ignore all spaces and line feed "garbage" up to the point of this start-of-data marker.
Starting Data Marker Version 2 only
Output always begins with a set of fixed characters and the date and time, as in:
*** START OF DATA Generated=1999/10/12 14:42:56 Version=2 ***
An input routine must ignore all spaces and line feed "garbage" up to the point of this start-of-data marker.
Ending Data Marker All Versions
Output always ends with:
*** END OF DATA ***
Name DealerDownload.ASP
Description Download Dealer Data. You can request dealer data to be returned for a specific PACCAR division which will return multiple rows or you can request dealer data to be returned by a specific PACCAR dealer code which will return only one row of data. Version is required if you want any format other than Version "1" format.
|
Parameters |
DivCd=d |
Where "d"
is one of the following: |
|
DlrCd=annn |
Where "annn" is a specific PACCAR dealer code. This parameter will list a single dealer. To list the dealer codes you must dump all the dealers for a division, which will give you all the dealers codes for that division. DivCd and DlrCd are mutually exclusive; one and only one of them is Required. Do not use both of them. | |
|
Version=v |
Where "v"
is a specific version of the scripts and is one of the following: | |
|
Header=h |
Where "h" is either a "Y" for yes produce a header row in the data file or "N" for no do not produce a header row in the data file. Header is Optional and if not specified with default to Header=N. | |
|
Sort=s |
Where "s"
is the sort code and is the following: |
Examples
Response Sample
*** START OF DATA 1999/10/12 14:42:56 ***
A025|Allied Truck Sales Co|4216 Southway Street Southwest||Canton|OH|44706|US|(330)477-8127|(330)477-6359|P
*** END OF DATA ***
Data Layout Version 1 and Version 1A
|
Field # |
Header Name |
Full Name |
Description |
|
DLR_CD |
Dealer Code |
PACCAR dealer code. | |
|
DLR_NM |
Dealer Name |
Self-explanatory. | |
|
DLR_ADR_LN1 |
Dealer Address Line 1 |
Self-explanatory. | |
|
DLR_ADR_LN2 |
Dealer Address Line 2 |
Self-explanatory. | |
|
DLR_CTY |
Dealer City |
Self-explanatory. | |
|
DLR_ST_PRV |
Dealer State/Province Code |
Standard USPS two character codes. | |
|
DLR_PST_CD |
Dealer Postal Code |
Self-explanatory. | |
|
CNR_CD |
Dealer Country Code |
Standard ISO two character
country codes: | |
|
DLR_PH_NO |
Dealer Phone Number |
Self-explanatory. | |
|
DLR_FAX_PH_NO |
Dealer Fax Number |
Self-explanatory. | |
|
DIV_CD |
Division Code |
PACCAR Division Code: |
Data Layout Version 2
|
Field # |
Header Name |
Full Name |
Description |
|
DLR_ID |
Dealer Id |
Internal unique Dealer Id number. | |
|
DLR_CD |
Dealer Code |
PACCAR dealer code. | |
|
DLR_ADM_ST_ID |
Dealer Admin Status Id |
Internal unique Dealer Admin Status Id number. | |
|
DLR_ADM_ST_DES |
Dealer Admin Status Description |
Administrative Status for
Dealer: | |
|
DFL_CRY_TYP_CHA_ID |
Default Currency Type Id |
Internal unique Default Currency Type Id number. | |
|
CRY_ISO_CD |
ISO Currency Code |
Default currency for the
dealer uses ISO three character currency codes: | |
|
LNG_ID |
Language Id |
Internal unique Language Id number. | |
|
LNG_CD |
Language Code |
Dealers default language
uses ISO two character language codes: | |
|
LNG_TXT |
Language Description |
Text description of above code. | |
|
DIV_ID |
Division Id |
Internal unique Division Id number. | |
|
DIV_CD |
Division Code |
PACCAR Division Code: | |
|
DIV_NM |
Division Name |
Text name of above division. | |
|
DLR_NM |
Dealer Name |
Self-explanatory. | |
|
DLR_CTT_FRS_NM |
Dealer Contact First Name |
Self-explanatory. | |
|
DLR_CTT_LST_NM |
Dealer Contact Last Name |
Self-explanatory. | |
|
DLR_PH_NO |
Dealer Phone Number |
Self-explanatory. | |
|
DLR_FAX_PH_NO |
Dealer FAX Number |
Self-explanatory. | |
|
DLR_EML_ADR |
Dealer Email Address |
Self-explanatory. | |
|
LOC_MAP_URL_TXT |
Location Map URL |
URL for map showing where dealer is located. | |
|
WEB_SIT_URL_TXT |
Web Site URL |
Dealer Web Site URL. | |
|
DLR_TRK_WNT_EML_ADR |
Dealer Truck Wanted Email Address |
Dealer Email Address for emailing Trucks Wanted Requests to. | |
|
DLR_SBT_CD |
Dealer Sub-Type Code |
Dealer Sub Type Code describes
the application instance of the data: | |
|
ADR_ID |
Address Id |
Internal unique Address Id number. | |
|
ST_PRV_CHA_ID |
State/Province Id |
Internal unique State/Province Id number. | |
|
CNR_CHA_ID |
Country Id |
Internal unique Country Id number. | |
|
ADR_TYP_ID |
Address Type Id |
Internal unique Address
Type Id number. | |
|
LN1_ADR |
Address Line 1 |
Self-explanatory. | |
|
LN2_ADR |
Address Line 2 |
Self-explanatory. | |
|
CTY_NM |
City Name |
Self-explanatory. | |
|
PST_CD |
Postal Code |
Self-explanatory. | |
|
ADR_TYP_DES |
Address Type Description |
Description of Address
Type: | |
|
ST_CD |
USPS State/Province Code |
United States Postal Service State and Province Codes | |
|
CNR_CD |
ISO Country Code |
ISO two character Country
Codes: |
Name TruckDownload.ASP
Description Download Truck Data. You can request truck data to be returned for a specific PACCAR division or you can request truck data to be returned by a specific PACCAR dealer code Both will return multiple rows of data. Version is required if you want any format other than Version "1" format.
|
Parameters |
DivCd=d |
Where "d"
is one of the following: |
|
DlrCd=annn |
Where "annn" is a specific PACCAR dealer code. This parameter will list a single dealer. To list the dealer codes you must dump all the dealers for a division, which will give you all the dealers codes for that division. DivCd and DlrCd are mutually exclusive; one and only one of them is Required. Do not use both of them. | |
|
Version=v |
Where "v"
is a specific version of the scripts and is one of the following: | |
|
Header=h |
Where "h" is either a "Y" for yes produce a header row in the data file or "N" for no do not produce a header row in the data file. Header is Optional and if not specified with default to Header=Y. | |
|
Sort=s |
Where "s"
is the sort code and is the following: |
Examples
Response Sample
** START OF DATA 1999/10/12 14:42:56 ***
INT|9300|1985|a14389|40000|DIESEL|CONV|CUM|15 SPEEDS|N|H200|cummins recon engine at 360,000 ,wet line dual exhaust
*** END OF DATA ***
Data Layout Version 1 and Version 1A
|
Field # |
Header Name |
Full Name |
Description |
|
TRK_MAK_CD: |
Truck Manufacturer |
Truck Make Manufacturing
Code: | |
|
TRK_MDL_TXT |
Truck Model |
Truck Model Description. | |
|
TRK_MDL_YR |
Truck Model Year |
Four character model year. | |
|
SER_CHS_ID |
Truck Serial Number |
PACCAR serial number. The last six to eight digits of the VIN. | |
|
RR_AXL_CPC_MEA |
Rear Axle Capacity |
In pounds | |
|
TRK_FL |
Fuel |
Always "Diesel". | |
|
TRK_CLS_CD |
Truck Class |
Truck cab configuration: | |
|
ENG_MAK_CD |
Engine Manufacturer |
Engine Make Manufacturing
Code: | |
|
XMN_TYP_DES |
Transmission Speed |
Following descriptive text: | |
|
TRK_PIC_IND |
Truck Picture Indicator |
Indicates whether a picture
for this truck exists or not: | |
|
DLR_CD |
Dealer Code |
PACCAR dealer code. | |
|
CMT_TXT |
Comments |
Free form descriptive text. All carriage returns line feeds are stripped out of the comment. |
Data Layout Version 2
|
Field # |
Header Name |
Full Name |
Description |
|
Common Fields to Both North America and Europe |
|||
|
SER_CHS_ID |
Serial Chassis Id |
PACCAR serial number. The last six to eight digits of the VIN. | |
|
TRK_MAK_CD |
Truck Manufacturer Code |
Truck Make Manufacturing
Code:. | |
|
TRK_MDL_TXT |
Truck Model Text |
Truck Model Description. | |
|
TRK_MDL_YR |
Truck Model Year |
Four character model year. | |
|
VEH_ID_NO |
Vehicle Identification Number |
Industry standard identification number. | |
|
DLR_STK_ID |
Dealer Unit Stocking Id |
Free form text for dealers usage. | |
|
BD_TYP_CD |
Body Type Code |
Body Type Code: | |
|
VEH_TYP_CD |
Vehicle Type Code |
Vehicle Type Codes: | |
|
CLR_DES |
Color Description |
Self-explanatory. | |
|
ENG_MAK_CD |
Engine Manufacturer Code |
Engine Make Manufacturing
Code: | |
|
ENG_MDL_ID |
Engine Model Id |
Engine Model Description. | |
|
ENG_HP_NO |
Engine Horsepower Number |
Self-explanatory. | |
|
ENG_BRK_IND |
Engine Brake Indicator |
Indicates whether this
truck has an engine brake: | |
|
XMN_TYP_CD |
Transmission Type Code |
Transmission Type Codes: | |
|
SSP_TYP_CD |
Suspension Type Code |
Suspension Type Codes: | |
|
TRK_MIL_NO |
Truck Mileage Number |
Odometer - Self-explanatory. | |
|
MIL_DIS_UOM_CD |
Mileage Distance Unit of Measure Code |
Distance unit of measure: | |
|
RR_AXL_RTO_NO |
Rear Axle Ratio Number |
Self-explanatory. | |
|
RR_TIR_SIZ_TXT |
Rear Tire Size Text |
Self-explanatory. | |
|
RR_TIR_SIZ_DIM_UOM_CD |
Rear Tire Size Dimension Unit of Measure Code |
Dimension unit of measure: | |
|
FRT_TIR_SIZ_TXT |
Front Tire Size Text |
Self-explanatory. | |
|
FRT_TIR_SIZ_DIM_UOM_CD |
Front Tire Size Dimension Unit of Measure Code |
Dimension unit of measure: | |
|
WB_MEA |
Wheel Base Measurement |
Self-explanatory. | |
|
WB_DIM_UOM_CD |
Wheel Base Dimension Unit of Measure Code |
Dimension unit of measure: | |
|
ALM_WHL_QTY |
Aluminum Wheel Quantity |
Self-explanatory. | |
|
RTL_PR_AMT |
Retail Price Amount |
Retail Price. If zero "CALL" on price. | |
|
RTL_CRY_TYPE_CD |
Retail Currency Type Code |
Currency type code uses
ISO three character currency codes: | |
|
ASK_PR_AMT |
Asking Price Amount |
Wholesale Price. If zero "CALL" on price. | |
|
ASK_CRY_TYPE_CD |
Asking Currency Type Code |
Currency type code uses
ISO three character currency codes: | |
|
ACQ_MTH_CD |
Acquisition Method Code |
Acquisition Codes: | |
|
MFG_WTY_IND |
Manufacturer Warranty Indicator |
Indicates whether this
truck has any OEM warranty left: | |
|
ASR_PGM_TYP_CD |
Assurance Program Type Code |
Assurance Programs | |
|
DLR_CD |
Dealer Code |
PACCAR dealer code. | |
|
AVL_DT |
Availability Date |
Future date the truck is to be available. | |
|
CRE_DT_TM |
Create Date/Time |
Date and time this truck listing was created. | |
|
LST_UPD_DT_TM |
Last Update Date/Time |
Date and time this truck was last update + 30 days. | |
|
CMT_TXT |
Comments Text |
Free form descriptive text. All carriage returns line feeds are stripped out of the comment. | |
|
TRK_PIC_REL_URL |
Truck Picture Relative URL |
"/TruckImages/Raw"
is the default | |
|
TRK_LIS_ID |
Truck Listing Id |
Internal unique Identifier for the truck listing. | |
|
TRK_PIC_ID1 |
Truck Picture Id #1 |
Name of JPG file. Formatted
as: | |
|
TRK_PIC_ID2 |
Truck Picture Id #2 |
Name of JPG file. Formatted
as: | |
|
TRK_PIC_ID3 |
Truck Picture Id #3 |
Name of JPG file. Formatted
as: | |
|
North American Fields Only |
|||
|
FRT_AXL_CPC_MEA |
Front Axle Capacity Measurement |
Self-explanatory. | |
|
FRT_AXL_CPC_UOM_CD |
Font Axle Capacity Unit of Measure Code |
Capacity unit of measure: | |
|
SLP_BNK_TYP_CD |
Sleeper Bunk Type Code |
Sleeper Bunk Type Codes: | |
|
SLP_ROF_TYP_CD |
Sleeper Roof Type Code |
Sleeper Roof Type Codes: | |
|
TRK_CLS_CD |
Truck Class Code |
Truck cab configuration: | |
|
RR_AXL_CPC_MEA |
Rear Axle Capacity Measurement |
Self-explanatory. | |
|
RR_AXL_CPC_UOM_CD |
Rear Axle Capacity Unit of Measure Code |
Capacity unit of measure: | |
|
SLP_CAB_SIZ_MEA |
Sleeper Cab Size Measurement |
Self-explanatory. | |
|
SLP_CAB_SIZ_DIM_UOM_CD |
Sleeper Cab Size Unit of Measure Code |
Dimension unit of measure: | |
|
BPR_TO_BOC_MEA |
Bumper to Back of Cab Measurement |
Self-explanatory. | |
|
BPR_TO_BOC_DIM_UOM_CD |
Bumper to Back of Cab Dimension Unit of Measure Code |
Dimension unit of measure: | |
|
ITE_INF_TXT |
Interior Information Text |
Free form descriptive text. | |
|
European Fields Only |
|||
|
TIR_CND_CD |
Tire Condition Code |
Tire Condition Codes: | |
|
GVW_MEA |
Gross Vehicle Weight Measurement |
Self-explanatory. | |
|
GVW_CPC_UOM_CD |
Gross Vehicle Weight Capacity Unit of Measure Code |
Capacity unit of measure: | |
|
CFG_TYP_CD |
Configuration Type Code |
Truck Axle/Drive Configuration
Codes: | |
|
EMS_STD_CD |
Emission Standards Code |
Emission Standards Codes: | |
|
CAB_TYP_CD |
Cab Type Code |
Cab Type Codes: | |
|
ABS_IND |
Anti-Braking System Indicator |
Indicates whether this
truck has an Anti Braking System: | |
|
NIP_IND |
Noise Insulation Package Indicator |
Indicates whether this
truck has Noise Insulation Package: | |
|
BD_HGT_MEA |
Body Height Measurement |
Self-explanatory. | |
|
BD_LTH_MEA |
Body Length Measurement |
Self-explanatory. | |
|
BD_WTH_MEA |
Body Width Measurement |
Self-explanatory. | |
|
BODY_DIM_UOM_CD |
Body Dimension Unit of Measure Code |
Dimension unit of measure: | |
|
LFT_HD_STR_IND |
Left Hand Steering Indicator |
Indicates whether this
truck has Left Hand Steering: | |
|
RGS_ID |
Registration Id |
Self-explanatory. | |
|
RGS_DT |
Registration Date |
Date of Registration. | |
Name TruckPictureDownLoad.ASP
Description Download Truck Picture. This script is provided only for backward compatibility with version 1 & 1A. There is no reason to use this script for Version 2 since you can now navigate directly to the desired truck pictures for any given truck. Using the Truck Picture Relative URL and the Truck Picture Ids as provided in the results of the Truck Download script, all of the pictures are accessible directly on the web server.
|
Parameters |
MfgNm=m |
Where "m"
is one of the following Manufacturer Names: |
|
SerNo=s |
Where "s" is a specific serial/chassis number. Usually the last six to eight digits of the VIN. Required parameter. |
Example
OR
To navigate directly to a picture use the web site URL given at the beginning of this document. Append to that the value provided Truck Picture Relative URL from the results of the Truck Download process. It will contain the default value of "/TruckImages/Raw". This is the directory where the raw pictures are stored. The following directories can be navigated to also:
The names of the pictures in each of the above directories are formatted as:
Where:
tt is type of picture
rw Raw directory
dt Detail directory
br Brochure directory
th Thumbnail directory
ttttt is the truck listing id.
ppppp is a unique picture id.
.JPG is a constant.
So an example might be:
The picture type of the file name must match the sub directory.
Backward Compatibility
We have provided backward compatibility to give our business associates enough time to convert any business systems using the older UTL (Used Truck Locator) external data interfaces to the new GTL Version 2. This backward compatibility has a expiration date of December 31, 2001. After that point in time only GTL Version 2, and above, external data interfaces will be accepted.
Problem Reporting/Assistance
Contact Dealer Services at 1-800-524-2405. Specify you are having problems or need assistance with the GTL External Data Download Interface. Dealer services will attempt to do 1st level problem determination and log the problem into our problem management system. If Dealer Services is unable to assist you in the problem, 2nd level support will be notified. Depending on the priority of the problem will determine your call back time period.
Once you have been contacted by 2nd level support you deal directly with that level until the problem is resolved. This may involve multiple support areas, depending on the nature of the problem. Once the problem has been resolved, you should receive a call back from Dealer Services, confirming that the problem was resolved and allowing us to formally close the problem.