Hi,
I am trying to CSV import a document with some fields and a file for each item but ends always in "Import Error". Activating Omeka log outputs following trace:
2015-09-01T14:10:55+02:00 ERR (3): [CsvImport][#27] exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Column 'text' cannot be null' in omeka/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 omeka/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 omeka/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)
#3 omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#4 omeka/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array)
#5 omeka/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTO om...', Array)
#6 omeka/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert('ElementText', Array)
#7 omeka/application/models/Mixin/ElementText.php(671): Omeka_Record_AbstractRecord->save()
#8 omeka/application/models/Mixin/ElementText.php(93): Mixin_ElementText->saveElementTexts()
#9 [internal function]: Mixin_ElementText->afterSave(Array)
#10 omeka/application/libraries/Omeka/Record/AbstractRecord.php(251): call_user_func_array(Array, Array)
#11 omeka/application/libraries/Omeka/Record/AbstractRecord.php(280): Omeka_Record_AbstractRecord->delegateToMixins('afterSave', Array, true)
#12 omeka/application/libraries/Omeka/Record/AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks('afterSave', Array)
#13 omeka/application/models/Item.php(335): Omeka_Record_AbstractRecord->save()
#14 omeka/application/models/Builder/Item.php(204): Item->saveFiles()
#15 omeka/application/libraries/globals.php(567): Builder_Item->addFiles('Url', 'http://sebinaol...', Array)
#16 omeka/plugins/CsvImport/models/CsvImport/Import.php(720): insert_files_for_item(Object(Item), 'Url', 'http://sebinaol...', Array)
#17 omeka/plugins/CsvImport/models/CsvImport/Import.php(588): CsvImport_Import->_addItemFromRow(Array)
#18 omeka/plugins/CsvImport/models/CsvImport/Import.php(336): CsvImport_Import->_importLoop(0)
#19 [internal function]: CsvImport_Import->start()
#20 omeka/plugins/CsvImport/models/CsvImport/ImportTask.php(39): call_user_func(Array)
#21 omeka/application/libraries/Omeka/Job/Process/Wrapper.php(29): CsvImport_ImportTask->perform()
#22 omeka/application/scripts/background.php(61): Omeka_Job_Process_Wrapper->run(Array)
#23 {main}
Following is also an example of CSV rows:
Monografia;ABBONDANZA, Vincenzo;Dizionario storico delle vite di tutti i monarchi ottomani fino al regnante gran signore Acmet IV, e delle più ragguardevoli cose appartenenti a quella monarchia / dato alla luce da Vincenzo Abbondanza romano a e dal medesimo dedicato all'Em. e Rev. principe il sig. cardinale D. Domenico Orsini d'Aragona;In Roma : per Luigi Vescovi e Filippo Neri;1786;"XXXII, 392 p. ; 4° (20 cm)";RARI OTT IV 060;http://sebinaol.unior.it/sebina/repository/catalogazione/documenti/Dizionario%20storico%20delle%20vite%20(127137).pdf
Monografia;ABBONDANZA, Vincenzo;Dizionario storico delle vite di tutti i monarchi ottomani fino al regnante gran signore Acmet IV, e delle più ragguardevoli cose apparenenti a quella monarchia;In Venezia : per Fr. Pitteri e Fr. Sansoni;1788;"XXVIII, 326 p. ; 8° (19 cm)";RARI OTT IV 018;http://sebinaol.unior.it/sebina/repository/catalogazione/documenti/Dizionario%20storico%20delle%20vite%20di%20tutti%20i%20monarchi%20ottomani.pdf
CSV Plugin version: 2.0.3
Omeka Version: 2.3
Any kind suggestion please?
Thanks!