All columns to be imported must be formatted as text in the Excel sheet. If this is not done, you risk that data will not be imported into 24SevenOffice.
Contacts or Private Customers | |
Import Name | Explanation |
Contact First Name | first name |
Contact Last Name | Surname |
Contact Name | First name Last name (This is if you do not separate first name / Last name in each separate column) |
Contact Role Phone | Phone Job |
Contact Role Mail | Email Job |
Contact Role Mobile | Mobile Phone Jobs |
ContactRoleFax | Fax Job |
Contact Role Position | Position (Role) Job |
ContactDateRegistrered | The date the contact is registered. Format: day of year (31.01.2008) |
ContactDateChanged | The date of contact was last changed. Format: day of year (31.01.2008) |
ContactDateOfBirth | date of birth |
ContactAdressStreet | Address |
ContactAdressPostCode | zip code |
ContactAdressPostArea | City |
ContactAddress | visiting address |
Contact Country | Country |
Contact Phone | Telephone Private |
ContactPhone2 | Telephone Private 2 |
Contact Mail | Email Private |
ContactEmail2 | Email Private 2 |
ContactEmail3 | Email Private 3 |
Contact Mobile | Mobile phone Private |
ContactMobile2 | Mobile Phone Private 2 |
ContactFax | Fax Private |
ContactIsConsumer | Defines whether the contact is private or not. Set to 1 by private customer. If the import consists of both private customers and contacts, this field is set to 1 for private customers and blank for regular contacts. |
ContactIsEmployee | Defines whether or not the contact is employed. Set to 1 when employed, and 0 = not employed. |
ContactCustomerId | Private Customer Number (Can be specified. If you do not specify this, the customer is assigned the next available customer number in the customer number series) |
ContactInvoiceEmail | Invoice email address. Only possible to import to private customers. Therefore, you must also import customer number using ContactCustomerId for this field to update. |
Contact Nickname | nicknames |
Contact Note | note |
ContactOwner | Owner / Responsible for Contact (Employed in your company) |
ContactRoleCompanyId | Customer number to which the contact may be linked. |