Jump to content

SQL Contact Importer - Telephone


Martyn Houghton
 Share

Recommended Posts

The example json configuration file, needs to be updated as "organisation_id" should be "organization_id". 

image.png.52c6a86dfbe449a40aa0a02fd4b9923d.png

Plus you need to pass in the container_id of the organisation and not the actual organisation id.

Below is our example, as the sample json file in the download does not even have organization_id in it at all.

    },
    "ContactMapping":{
        "logon_id":"{{.FIELD1}}",
        "firstname":"{{.FIELD2}}",
        "lastname":"{{.FIELD3}}",
        "company":"{{.FIELD4}}",
        "email_1":"{{.FIELD5}}",
        "email_2":"",
        "tel_1":"{{.telext1}}",
        "tel_2":"",
        "jobtitle":"{{.FIELD6}}",
        "description":"",
        "notes":"",
		"organization_id":"{{.telext2}}",
        "country":"{{.FIELD7}}",
        "language":"",
        "private":"0",
        "rights":"0",
        "contact_status":"0",
		"custom_1":"DTH1",
		"custom_2":"",
		"custom_3":"",
		"custom_4":"",
		"custom_5":"",
		"custom_6":""
    }

Hopefully this will help future users of the tool.

Cheers

Martyn

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...