SQL Contact Importer - Telephone

[Martyn Houghton]

The telephone number field in h_sys_contacts is a text field, but the definition used in the SQL Importer on the Wiki (https://wiki.hornbill.com/index.php/SQL_Contact_Import) defines it as a number field.

Can I just change the define text format?

Cheers

Martyn

[Martyn Houghton]

Following on from the above, I presume I could also add a second telephone number column to match to h_tel_2, or would that require a code change?

Cheers

Martyn

[Martyn Houghton]

Looking at the code on GitHub, it would appear that you can also import the following additional fields.

• tel_2
• email_2
• description
• notes
• language

Can you confirm that is correct?

Cheers

Martyn

[Martyn Houghton]

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

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

[Martyn Houghton]

Just a further not, you can adjust the "Query" section in the "SQLConf" in order to do as selective update or load.

Cheers

Martyn