[Vtigercrm-developers] 5.4.0 Import Madness

Alan Lord alanslists at gmail.com
Wed Jan 29 10:15:21 GMT 2014


Had a customer who got a right pickle this morning.

Was importing some records via CSV for a custom module.

In his spreadsheet he'd written "Vendor::::blah blah" instead of 
"Vendors::::blah blah" for a UI10 Column.

This essentially broke the import process and he wasn't able to stop it. 
I had to run a query on the temporary import table

> UPDATE vtiger_import_1
> SET vendorlink = REPLACE(vendorlink, 'Vendor::::', 'Vendors::::');

to fix it so the scheduler would then run.

That is *terribly* unforgiving and he had no errors - just a blank screen.

Any suggestions on fixing this so the import fails at the start, rather 
than when it is too late?

Cheers

Al



More information about the vtigercrm-developers mailing list