Martyn Houghton Posted October 15, 2019 Posted October 15, 2019 Could the SQL Importer be extended to give a reason/warning in the log when skipping or failing to process a contact record. This way it would be easier to locate those updates which have not been able to be applied. The only way to locate them at the moment is page through the log file and look for the single line. Also, when the tool errors can the text just be a normal colour rather than red on black which is quite hard to read. I have tried changing the command prompt to change the default background colour, but to no avail as the tool sets both the background and foreground colours for the error message output. Cheers Martyn
Steve G Posted October 15, 2019 Posted October 15, 2019 Hi @Martyn Houghton, Re: your first point, I can only replicate that if the import config is set to Create only, and a matching contact has been found in your Hornbill instance - if there's been an error in the upsert, then you would actually get those written to the log... I've added WARN entry to the log for each of these though, to make them easily identifiable: I've just released v1.6.0 of the Contact Import Tool with the following changes: Added option for CLI output to be in the terminal-default colours only Added additional log output when Create is selected in config, and Contact already exists in Hornbill Removed hard-coded list of mapped columns, so now any Contact column can be populated entirely by config To switch the colours off in the CLI, just add -nocol=true to the command, and you can now add any additional columns to the import mapping by adding new properties, and stripping the h_ prefix from the column name, incase we add any more columns to the contacts entity in future: You can get the latest build from here: https://github.com/hornbill/goDb2HcontactImport/releases/latest Hope this helps! Cheers, Steve 1
Martyn Houghton Posted October 16, 2019 Author Posted October 16, 2019 @Steve G That's excellent. Thanks for very quick response. I will download it now as have another migration coming up soon as well. 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