| SUPEROFFICE FIELD | DESCRIPTION | TYPE OF DATA REQUIRED | DUPLICATE CHECK | REMARK |
|---|
| Country | Country of the person | Full country name (Tip: Use transformations like NO=Norway) | no | Transformations for DataBridge Import |
| ID | Unique internal Person ID | Integer | yes | WARNING: This is the unique person ID in the database, not visible in the SuperOffice user interface |
| Company ID | Unique internal company ID | Integer | no | The company key field so the contact person will be linked to the company card, if there is no link, the person is imported as seperate entity |
| First name | Firstname of the person | Text string | yes |
|
| Middle name | Middle name of the person | Text string | no | If this is a seperate column, but the middle name field is not used in SuperOffice, use the transformation option to merge fields, see: |
| Last name* | Last name of the person | Text string - Mandatory | yes | Transformations for DataBridge Import |
| Title | Title | Text string | no |
|
| Academic title | Academic title | Text string | no |
|
| Birthdate | DateTime | Date and time | no | Date formats |
| Mr/Mrs | Text String | Text string | no |
|
| Info | The big note field of a person | Text string | no |
|
| Number | Person number | Text string | yes |
|
| Former employee | Former employee | True/False, 0/1 various values can be used (see section interests) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24248401/Specifications+of+the+Import+fields+in+DataBridge |
| Use as mailing address | Use this address for mailings | True/False, 0/1 various values can be used (see section interests) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24248401/Specifications+of+the+Import+fields+in+DataBridge |
| No Mailings | Receive no mailings | True/False, 0/1 various values can be used (see section interests) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24248401/Specifications+of+the+Import+fields+in+DataBridge |
| Position | The position in the organisation | Text string (missing items can be added automatically) | no | https://infobridgekb.atlassian.net/wiki/spaces/ND/pages/24510872/Importing+list+items |
| E-mail | The email address | Text string | yes |
|
| Direct phone | Direct phone number | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automatically add the +31 based on country. |
| Mobile phone | Mobile phone number | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automatically add the +31 based on country. |
| Internet phone | Internet phone or Skype ID | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automatically add the +31 based on country. |
| Private phone | Private phone number | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automatically add the +31 based on country. |
| Direct fax | Direct fax number | Text string | no | With international numbers add the +sign or don't add the international part. (e.g. +31). Then SO will automatically add the +31 based on country. |
| Chat | Chat applicate name | Text string | no |
|
| Web site | Person web site | Text string | no |
|
| Our contact | Who is responsible | SuperOffice initials or full name | no | https://kb.infobridge.com/hc/en-us/articles/115000892905-Link-a-record-to-an-associate-in-SuperOffice |
| Language | Preferred Language | Text string | no |
|
| addres line 1 | Private address line 1 | Text string | yes |
|
| addres line 2 | Private address line 2 | Text string | yes |
|
| addres line 3 | Private address line 3 | Text string | yes |
|
| city | City | Text string | yes |
|
| county | County | Text string | yes |
|
| state | State | Text string | yes |
|
| zip code | Zip code | Text string | yes |
|