CSV Connector

Installation

1. Download the connector .dll file to your computer - Download Connectors? Click here
2. Run 12d Synergy Administrator
3. Connect to your server
4. In the left pane, click Connectors
5. In the Connectors pan, click Load New Connectors (found at the bottom of the screen
6. Click the Upload Assembly button
7. Browse to and upload the previously downloaded connector .dll file
8. In the confirmation popup, click OK
9. Click the Close button

Configuration

The CSV Connector has the following configuration options:

• Contact File: Click to select a CSV file from within Synergy that contains the contact data that you would like to import.
• Company File: Click to select a CSV file from within Synergy that contains the company data that you would like to import.
• Job File: Click to select a CSV file from within Synergy that contains the job data that you would like to import.

Import File Format

The CSV Connector currently supports contact, company and job imports from CSV files.

CSV Files

There must be a separate CSV file for contacts, companies and jobs. CSV files must include the names of each field in the first row. Spaces and underscores in the field names are interchangeable.

Contact Fields

Required Fields

If the email address matches an existing contact in 12d Synergy, it will update the details of the existing contact. Otherwise, a new contact will be created.

• First_Name
• Last_Name
• E-mail_Address (Also accepts 'Email' or 'E-mail')

Optional Fields

• Phone
• Mobile
• Address
• City
• Region
• Country
• PostCode
• PostalAddress
• PostalCity
• PostalRegion
• PostalCountry
• PostalPostCode
• Fax
• SecodaryEmail
• Position
• Company (This will add the contact as a staff member of the company that matches this company name)

Job Fields

Required Fields

If the job name matches an existing job in 12d Synergy, it will update the details of the existing job. Otherwise, a new job will be created.

• JOB_NAME (Also accepts '_PROJECT_NAME', 'PROJECT_NAME', '_PROJECT NAME' or 'NAME')

Company Fields

If the company name matches an existing company in 12d Synergy, it will update the details of the existing company. Otherwise, a new company will be created.

Required Fields

• COMPANY_NAME (Also accepts 'NAME')

Custom Fields (Contact, Jobs and Companies)

Custom fields can be imported by first going to 'Load Custom Fields Attributes' and selecting the fields and attribute names that you want to import.

Before running a connector for the first time you must:

• Create a backup of your 12d Synergy database
• Test your mappings via the 'Run Test' button

Read your version's 12d Synergy Administration manual for detailed instructions on how to setup connectors here.