[Vtigercrm-developers] 5.4.0 Import Madness

[Prasad]

Oops!

Running through data-sanitization tool might be a solution if the data-is
developed by hand.

Regards,
Prasad

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
 *I* Blog <https://blogs.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <https://discussions.vtiger.com>*I*
Website<https://www.vtiger.com/>


On Wed, Jan 29, 2014 at 3:45 PM, Alan Lord <alanslists at gmail.com> wrote:

> 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
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140129/7a52ff22/attachment.html>