[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