The Dealer Contacts FTP process is designed to receive a complete, up-to-date list of contacts for each dealer via a CSV import. The ContactTypeNames field accepts a comma-separated list of contact type codes; any contact types not included for a dealer will be removed from that dealer's record in Aimbase. Similarly, if existing contacts are omitted from the file, they will be deactivated in Aimbase. This approach ensures that the data in Aimbase reflects only what is explicitly provided in the import file.
To indicate the end of the file, the final row of the CSV should contain the letter E in column A. This marker is used to confirm that the file has been transmitted in full and is ready for processing.
Required Headers
The file must include the following headers in the first row:
- DealerNumber
- DealerLocation
- FirstName
- LastName
- IsActive
- ContactTypeNames
- Title
- PrimaryPhoneNumber
- SecondaryPhoneNumber
- Fax
- CountryCode
Field Details
| Field | Required | Field Type | Length | Description |
| DealerNumber | X |
Text | 20 | |
| DealerLocation |
|
Text | 10 | |
| FirstName |
|
Text | 80 | |
| LastName |
|
Text | 80 | |
X |
Text | 100 | ||
| IsActive | X |
Boolean | 1 | 1 = true, 0 = false |
| ContactTypeNames |
|
Text | - | This field should contain a comma-separated list of contact type codes associated with the contact. A complete list of valid codes will be provided by your Rollick representative. Only the contact types listed here will remain active for the dealer in Aimbase—any missing types will be removed. |
| Title |
|
Text | 25 | |
| PrimaryPhoneNumber |
|
Text | 20 | |
| SecondaryPhoneNumber |
|
Text | 20 | |
| Fax |
|
Text | 20 | |
| CountryCode |
|
Text | 2 |
Example File (Excel View)
