If you are going to import a file via FTP to upload Dealers into Aimbase, you must follow this file format guide.
Use an excel spreadsheet, but be sure to save it as a .csv file. The field name will be the column headers in your file and below them in each column, you will have a value. For example, PurchaseDt is the Field Name and the Value is below it in YYYYMMDD format.
You can add as many dealers to one file as you want. Each individual dealer will be a row.
Once you have completed your file, go to our instructional guide on how to use a FTP software to upload your file successfully.
Field Name | Required | Format | Description |
ACTION | X | “A”, "D" “E” | Specifies action to be performed on data row; A= New Dealer, D = Inactivate existing dealer, E= End record, designates end of file |
DLRNUMBR | X | Dealer Number of the dealer that sold the product to the customer. Main dealer number prefix; used in combination with dealer location number to uniquely identify a dealer; if Dealer Number is not provided reporting will not be available at a dealer level | |
DLRLOCTN | Location number of the dealer that sold the product; sub dealer number; used in combination with the dealer location number to uniquely identify a dealer; If Dealer Location Number is not provided reporting will not be available at a dealer level; used only if dealer has sub locations that need to be identified separately from the main location | ||
DLRNAME | X | Dealer Name as it appears in Aimbase | |
PCONTACT | Primary Contact Name | ||
ADDRES1 | X | Mailing Address 1; Max length 256 characters | |
ADDRES2 | Mailing Address 2; Max length 256 characters | ||
CITY | X | Mailing City | |
STATE | Mailing State | ||
POSTCODE | X | US 5 or 5+4 zip code, or Canadian 6 digit code | Mailing Postal Code |
COUNTRY | X | Dealer Country; use ISO 3166 two-digit country codes; ISO 3166 two-digit country codes are available here | |
PHONE | Dealer Phone | ||
FAX | Dealer Fax | ||
Dealer email | |||
URL | Dealer URL | ||
REGION | Region Name | Manufacturer-defined Geography level 1 | |
TERRITORY | Territory Name | Manufacturer-defined Geography level 2 | |
DISTRICT | District Name | Manufacturer-defined Geography level 3 | |
BRANDS | AC, MC, HR | a comma separated list of brand codes that are assigned to the dealer | |
DEALERTYPE | “S” or “D” | The code of the dealer type |