Martyn Houghton Posted November 19, 2018 Posted November 19, 2018 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 Posted November 19, 2018 Author Posted November 19, 2018 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 Posted November 19, 2018 Author Posted November 19, 2018 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 Posted November 19, 2018 Author Posted November 19, 2018 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 Posted November 20, 2018 Author Posted November 20, 2018 Just a further not, you can adjust the "Query" section in the "SQLConf" in order to do as selective update or load. Cheers Martyn
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now