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
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