[Issues with SQL contact import]

@Steve Giller @Victor  Its in the photo home > system > user & guest access > guest accounts


also the option to tell a new user to reset their own password aint an option, it appears disabled, how do I unable this? 


 

[Issues with SQL contact import]

@Steve Giller @Victor

[Issues with SQL contact import]

ok I got the csv working to upload users in bulk!

but I got a new issue, when trying to login it doesnt work, I have to manually change the password again for the user to be able to login https://customer.hornbill.com/dataquestuk so I created more test users but when I try to change the password in bulk, it doesnt work.

[Issues with SQL contact import]

Can I get a full list on the contact mapping for the .json I dont think I am entering it correctly

[Issues with SQL contact import]

@Steve Giller @mojahidm

[Issues with SQL contact import]

6 hours ago, Dataquest said:

Hi,

 

I'm still getting some issue, any ideas where its going wrong?


2022/04/01 08:43:42 [DEBUG] Processing Contact [%!s(<nil>)]
2022/04/01 07:43:42 [DEBUG] Create Contact: [%!s(<nil>)]
2022/04/01 07:43:42 [DEBUG] Contact Create/Update XML: <params><application>com.hornbill.core</application><entity>Contact</entity><returnModifiedData>true</returnModifiedData><returnRawValues>true</returnRawValues><primaryEntityData><record><h_jobTitle>&lt;no value&gt;</h_jobTitle><h_phone>&lt;no value&gt;</h_phone><h_email>&lt;no value&gt;</h_email><h_lastName>&lt;no value&gt;</h_lastName><h_name>&lt;no value&gt;</h_name><h_password>&lt;no value&gt;</h_password><h_firstName>&lt;no value&gt;</h_firstName><h_mobile>&lt;no value&gt;</h_mobile><h_role>&lt;no value&gt;</h_role><h_userType>&lt;no value&gt;</h_userType><h_userId>&lt;no value&gt;</h_userId></record></primaryEntityData></params>
2022/04/01 07:43:42 [ERROR] Contact Create Failed. MethodResult Not OK from [entityAddRecord] : The specified column could not be found: h_phone

SQL_Contact_Import_2022-04-01T08-43-42+01-00.log 1.96 kB · 0 downloads tester001.csv 211 B · 1 download

@Victor any ideas?

[Issues with SQL contact import]

On 3/30/2022 at 5:25 PM, Steve Giller said:

There is no h_user_id field in the Contacts table.

The wiki uses h_logon_id, which is the recommended identifier for a Contacts import.

@Steve Giller still having issue, see my latest reply

 

[Issues with SQL contact import]

Hi,

 

I'm still getting some issue, any ideas where its going wrong?


2022/04/01 08:43:42 [DEBUG] Processing Contact [%!s(<nil>)]
2022/04/01 07:43:42 [DEBUG] Create Contact: [%!s(<nil>)]
2022/04/01 07:43:42 [DEBUG] Contact Create/Update XML: <params><application>com.hornbill.core</application><entity>Contact</entity><returnModifiedData>true</returnModifiedData><returnRawValues>true</returnRawValues><primaryEntityData><record><h_jobTitle>&lt;no value&gt;</h_jobTitle><h_phone>&lt;no value&gt;</h_phone><h_email>&lt;no value&gt;</h_email><h_lastName>&lt;no value&gt;</h_lastName><h_name>&lt;no value&gt;</h_name><h_password>&lt;no value&gt;</h_password><h_firstName>&lt;no value&gt;</h_firstName><h_mobile>&lt;no value&gt;</h_mobile><h_role>&lt;no value&gt;</h_role><h_userType>&lt;no value&gt;</h_userType><h_userId>&lt;no value&gt;</h_userId></record></primaryEntityData></params>
2022/04/01 07:43:42 [ERROR] Contact Create Failed. MethodResult Not OK from [entityAddRecord] : The specified column could not be found: h_phone

SQL_Contact_Import_2022-04-01T08-43-42+01-00.log tester001.csv

[Issues with SQL contact import]

Hi,

I was following this guide https://wiki.hornbill.com/index.php?title=SQL_Contact_Import I'm trying import a .CSV but I'm having some issue, please advise.

tester001.csv