• Log In / Create Account

Contents 1 About CSV Import 2 Download 3 Features 4 Needed Features 5 Preparing for CSV Import 6 Installing and Configuring 7 Undo an Import

About CSV Import

The CSV Import plugin allows users to import items from a simple CSV (comma separate value) file, and then map the CSV column data to multiple elements, files, and/or tags. Each row in the file represents metadata for a single item.

When using this plugin, you may only import one item type (document, still image, sound, et al) at a time. You may perform multiple imports.

Download

Version:

• 1.2
• 1.1
• 1.0

Features

The plugin also has the following features:

• Automatically downloads files from the URLs specified in column data and attaches it to the item.
• Automatically tags items with tags specified in column data.
• Imports multiple CSV files at the same time.
• Undos--or deletes-- imports.
• Allows users to view and clear import history

Needed Features

• Re-Import CSV file, updating old items, adding new records, and optionally deleting missing elements that only exist in the previous import.

Preparing for CSV Import

1. You will need to normalize your data before importing. Check to be sure that the first row of your CSV file contains column names, and that every row has the same number of columns.
2. Check to see if any of the text contains commas, and if it does surround that segment with double-quotes.
3. Remember, every row represents 1 item, and all items in the file have the same item type.
4. Look over the Dublin Core and Item Type metadata to be sure you can easily map the fields in your CSV file to the Omeka installation. Make any modifications in fields or types as necessary. (See Managing_Item_Types)

Installing and Configuring

1. Download and install the CSV Importer(see Installing_a_Plugin).
2. Install the CSV Import Plugin on the Settings->Plugins page.
3. Upload CSV files to the plugins/CsvImport/csv_files directory on your server.
4. Click the CSV Import administrative tab.
5. Click the Import tab.
6. Select a CSV file, the Item Type of the rows, the Collection of the imported items, and other optional import settings.
7. Click the Next button.
8. Map the columns of the CSV file to item elements, tags, and/or files.
9. Click the Import CSV File button
10. Click the Status tab.
11. Note: You when uninstalling the application will NOT delete imported items, but it will delete the history of importing those items, along with the ability to undo those imports.
12. In version 1.1-1.2, if you get the following error message in the CSV plugin interface admin/csv-import:

Your PHP-CLI path setting is invalid.

Please change the setting in pathtoyourinstallation/application/config/config.ini

If you do not know how to do this, please check with your system or server administrator.

you must edit the config.ini file found here: /application/config/config.ini

Some servers run multiple versions of PHP, so ask your web host or system administrator to assist if you do not know the correct path.

Undo an Import

1. Click on CSV Import administrative tab.
2. Click Status tab.
3. Click Undo link for the Import you want to undo. This will delete all items for this import.

Omeka is a project of the Center for History and New Media, George Mason University. Omeka and the Omeka logo are registered trademarks. Copyright © 2007–2010 CHNM.