CSV Import

I'm new to Omeka and am trying to import items using the CSV Import plugin. I installed the plug in, selected the CSV file and mapped the fields to elements.

I have two fields in my CSV file that contain URLs to image files on our server. I may have gone wrong here by mapping these fields to elements as well as checking off the "file" option.

Nearly two hours after starting the import, it is still "in process." My file has 251 items in it and is 101 kb in size. Should I assume that the process has failed? Should I get an error message if the process fails?

Thank you.
beth

Beth,

You probably need to change the path to your php executable file so that the plugin can begin the process. Unfortunately, the plugin is currently unable to detect whether you have specified correct location of the php executable file. Here's what I would do. First, find out the location of the php executable file, also known as the php-cli. You may need to ask your webhost or system admin to help you find this file. Then go into the CsvImport plugin configuration page and enter the path to this php file under "Path to PHP-CLI".

Let me know if this helps.

Thanks for pointing this out. I overlooked that step. I'll follow-up with our administrator to determine where this file resides. I'll let you know if that resolves the problem.

beth

Is there a way to kill a hanging "Import in Progress"? I jumped right in with the test.csv file before confirming the PHP-CLI path. BTW, it is /usr/local/php5/bin/php if you're on Dreamhost (more at http://wiki.dreamhost.com/PHP#Forcing_PHP_for_HTML_files). Now the test file works fine but I still have the Import in Progress from my first attempt listed with no action button. Is this a big deal? Is it continuing to use up resources?

No big deal -- if the process died after you started it, there's no way for Omeka to know (since it died), thus the hanging message. I think if you uninstall the plugin and reinstall it, then the "import in progress" message will go away.

HI,

I have changed the path to your php executable file and the import began processing. However, I received an "invalid csv file" error. To create the csv file, I opened a txt file in Excel and saved it as a csv. Not sure what the problem is with the file, so I'll have to determine that before trying the import again. Do you have any suggestions for validating the csv file?

Thank you.
beth

Hi,

I am now trying to import a different file using the CSV import plugin. When mapping the columns to elements/files, etc., I no longer have the option to select the "tags" or "file" options.

I have only the "Map to element" option. With my original CSV file, I have all three options.

Any ideas?

Thanks.
beth

Please ignore most recent post above. Seems to be resolved.

Thanks.