It is important that the data to be imported are cleaned before import to assure high quality so that it can be used efficiently by the marketing tools.

Contacts can be imported by the customer using SAM or by a service executed by SecuTix.

The customer give the contacts in a file that respect the SecuTix format

In special cases Contact data can be imported from a non SecuTix formatted source.  A special project will be set up for this.

The contacts are individuals or structures.

The contacts can be qualified with various criteria and the structures can be qualified with various type of structure.

Services provided

For the contacts the followings services are provided

• Create new contacts (With SAM or as a service)
• Update contacts  (With SAM or as a service)
• Inactivate contacts (As service)
• Delete contacts (As service)
• Qualify our contacts: define criteria’s for the contacts (As service)

• Qualify our structures: define type of structure (As service)

• Special service: Import from non SecuTix formated data (As service)

Prerequisites

To be able to import contacts, you need following tasks to be finished

• The contact data must be cleaned: Adress must be correst, duplicated must be removed, older data must be deleted
• The structure types, if any, must have been defined (see Define criteria’s for the contacts)
• The criteria and criterion elements must have been defined (see /wiki/spaces/DOCEN/pages/41620787)
• Each contact has a contact number. New contact must have new contact numbers. A specific range is reserved for existing contact numbers (How to know this range ? SecuTix or tzhe customer atgive contact number ?).

File formats

For all imports as a service, the file format is described in Contact import Format (Extended) and example Excel files are given. If this format is not respected, special actions have to be performed on the input files and may imply higher costs.

No information is mandatory and data with missing fields will also be imported.

Create / update / modify contacts

See detailed information on these sub pages :

• To create new contacts, go to Contact creation.
• To update existing contacts, go to Contact update
• To set a criteria or a strucure type to a contact, go to Setting a criteria or a structure type to a contact

Remove contacts information

See these subpages for detailed information :

• To invalidate existing contacts, without loosing information, go to /wiki/spaces/DOCEN/pages/41621345
• To delete existing contacts, go to Delete contact
• To anonymize contacts, go to Anonymize contact
• To erase all contact information, go to /wiki/spaces/DOCEN/pages/41621343

We accept the following data format to be imported.

• CSV not SecuTix formatted
• Excel
• Rodrigue database dump,
• SecuTix 1
• Any Oracle, SQL Server, MySql, Postgresql, Filemaker, Access database

We can analyze the provided data and propose an action plan to import this data.