CiviCRM Community Forums (archive)

Hi,

I spent a lot of time today finding out the hard way, that there is no validation when trying to import non-integer data into a CiviCRM custom data type that is declared in civicrm as an integer. Rather than tell me that there is data that can't be imported, it would simply bomb out with the web browser trying to open "Contact" as an application with screen output being downloaded as a text file to the web browser.

Of course my data should have been correct, but it takes just one record out of the typical 10,000 that I upload in one go to be wrong, for this to happen.

Now that I know what to look for, great, but it really did take a good few hours of elimanation work before I found the exact problem.

It would be really nice if as a feature, there was some kind of extra data validation done by CiviCRM when it imports, with some user friendly error messages, as it would save a lot of people a lot of time!

Keep up the good work!

Hi Lobo,

Just reproduced it on the demo 3.3 server.

Created a custom field called IntegerCustomField, with data type Integer.

Then uploaded a simple test file with

"King", "George", "10 01"

mapping "King" to first name, "George" to last name and "10 01" to IntegerCustomField

And it bombs with a load of html code and all that, etc.