Hello,
We are importing items into Omeka using CSV adn once we try to import ten or so items we get this error.CSV is successfully importing up to 6 items at presente but we need to import more.
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4294963953 bytes) in ....../Zend/File/Transfer/Adapter/Abstract.php on line 1302
We've had a couple reports of this problem, and it appears to be a PHP issue stemming somehow from the pattern of the file. You might have some luck simply reordering rows in your CSV file.
John,
Thanks! Do the rows need to be reordered alphabetically or just reordered in any pattern?
Mary
It's hard to say anything with certainty about this issue.
What happens is a function call just intended to detect what type of file the uploaded CSV is just sometimes hits some pathological case. There's no one order that necessarily works better, it's just an attempt to change the pattern enough to avoid the problem. Some users have reported success by reordering rows, reordering columns, and/or splitting the file into smaller ones.
John,
Thanks! We have Version 2.0.2 of the CSV import plug-in. Would 2.0.3 work better in resolving this issue?
Mary
Changing the version of the plugin isn't likely to do anything; the problem is at the level of PHP, apparently. (Though it wouldn't hurt.)
John,
Hello,
Is the config.ini for omeka the one located at /omeka/application/config.ini ?
My CsvImportPlugin.php files suggests using the code
plugins.CsvImport.columnDelimiter = ","
plugins.CsvImport.memoryLimit = "128M"
plugins.CsvImport.requiredExtension = "txt"
plugins.CsvImport.requiredMimeType = "text/csv"
plugins.CsvImport.maxFileSize = "10M"
plugins.CsvImport.fileDestination = "/tmp"
plugins.CsvImport.batchSize = "1000"
Do you think putting this code in the Omeka config.ini file could solve the problem?
Mary