Edward juarez immigration - Why CSV import results into ERROR?

Hello

My name is Edward juarez immigration

When i try to do bulk upload using CSV import tool. It results in error. Please tell me how to fix this problem.

Thanks
Edward juarez immigration

At what point in the import are you getting the error? What is the text of the error you are getting?

Hi mebrett,

I dnt know what to do with this error. Take a look

ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Incorrect string value: '\xB7'\x0A\x0AN\x0A...' for column 'text' at row 1' in /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('INSERT INTO om...', Array)
#6 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert('ElementText', Array)
#7 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/models/Mixin/ElementText.php(654): Omeka_Record_AbstractRecord->save()
#8 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/models/Mixin/ElementText.php(93): Mixin_ElementText->saveElementTexts()
#9 [internal function]: Mixin_ElementText->afterSave(Array)
#10 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Omeka/Record/AbstractRecord.php(251): call_user_func_array(Array, Array)
#11 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Omeka/Record/AbstractRecord.php(280): Omeka_Record_AbstractRecord->delegateToMixins('afterSave', Array, true)
#12 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Omeka/Record/AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks('afterSave', Array)
#13 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/models/Item.php(322): Omeka_Record_AbstractRecord->save()
#14 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/models/Builder/Item.php(204): Item->saveFiles()
#15 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/globals.php(554): Builder_Item->addFiles('Url', 'http://www.diga...', Array)
#16 /Library/Server/Web/Data/Sites/pasomeka.digark.info/plugins/CsvImport/models/CsvImport/Import.php(715): insert_files_for_item(Object(Item), 'Url', 'http://www.diga...', Array)
#17 /Library/Server/Web/Data/Sites/pasomeka.digark.info/plugins/CsvImport/models/CsvImport/Import.php(583): CsvImport_Import->_addItemFromRow(Array)
#18 /Library/Server/Web/Data/Sites/pasomeka.digark.info/plugins/CsvImport/models/CsvImport/Import.php(331): CsvImport_Import->_importLoop(0)
#19 [internal function]: CsvImport_Import->start()
#20 /Library/Server/Web/Data/Sites/pasomeka.digark.info/plugins/CsvImport/models/CsvImport/ImportTask.php(39): call_user_func(Array)
#21 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/libraries/Omeka/Job/Process/Wrapper.php(29): CsvImport_ImportTask->perform()
#22 /Library/Server/Web/Data/Sites/pasomeka.digark.info/application/scripts/background.php(61): Omeka_Job_Process_Wrapper->run(Array)
#23 {main}

Thanks
Edward juarez Immigration

Hi,

This is less related to CsvImport than to your data, that contains unescaped characters. Did you try to change the delimiter or the separator, or change the format of your file (utf-8)?

Sincerely,

Daniel Berthereau
Infodoc & Knowledge management

Hey Daniel

Thanks for your suggestion but I have no idea how to change the separator and file format that you are talking about. Can you please explain me in points how to change the format.

Thanks
Edward juarez Immigration

Hi,

In your spreadsheet, when you "save as" csv, you can choose another column delimiter. Try a character that you don't use in your files, as the pipe "|" or the "ยง", and add the "double quote" for each cell. Then you can choose the column delimiter in the main view of CsvImport.

Sincerely,

Daniel Berthereau
Infodoc & Knowledge management

okay i got it daniel, thanks for your help.

Thanks

Edward juarez Immigration