Forums » CSV Import and Commas/Quoation Marks

RSS feed for this topic

Info

  • Posted in Plugins
  • Started 2 years ago by gnosis_omeka
  • 8 posts by 2 users
  • Latest reply from gnosis_omeka

  1. gnosis_omeka Posted 2 years ago

    The following instructions:
    http://omeka.org/codex/Plugins/CsvImport

    Note:
    Check to see if any of the text contains commas, and if it does surround that segment with double-quotes.

    So I formatted my subjects like this:

    """Bleeker, Barent""",Northern Inland Lock Navigation Company,"""Lansing, Jacob""",stock certificate,New York (State),Erie Canal

    but as the following item reveals the import jumbles up the item tags:

    http://library.gc.cuny.edu/omeka/items/show/249

    Subjects are correct, but not tags. What might be happening?

  2. wanderingwill (Omeka Dev Team) Posted 2 years ago

    Are the subjects above an example row in your csv file?

    And you mapped this column to the Subject element, and checked the tags checkbox?

  3. gnosis_omeka Posted 2 years ago

    Yes the subjects above are from an example row in my csv file and I mapped this column to the subject elements and checked the tags checkbox.

  4. wanderingwill (Omeka Dev Team) Posted 2 years ago

    I think this may be a bug. I'm looking into it.

  5. gnosis_omeka Posted 2 years ago

    Interestingly, when I save my excel file into a CSV it adds two sets of quotation marks around the subjects as in the following example from one of my items (should it work this way?):

    New York (State),Erie Canal,Construction,Commissioners,Expenditures,Report,Western Inland Lock Navigation Company,"""Schuyler, Philip""","""Banyar, Goldsbrow""","""Watson, Elkanah"""

  6. wanderingwill (Omeka Dev Team) Posted 2 years ago

    So after looking at it some more, I determined that the issue is not a bug, but a restriction on our data model. In Omeka, tags cannot have commas in them. Commas are delimiters. The restriction is not specific to the Csv Import plugin. For example, if you try to add '"Bleeker, Barent"' to a tag in the admin, it will add two tags: '"Bleeker' and 'Barent"'. This is what happens in the Csv Import plugin too. So in short, tags cannot have commas in them. If you will have to normalize your data. Instead of '"Bleeker, Barent"', you will have to have 'Barent Bleeker'.

  7. gnosis_omeka Posted 2 years ago

    Will,

    How do you think this was built:

    http://nycdigital.org/items/show/174

    notice how:

    Additional Creator(s)
    Tharchin, G., 1890-1976

    has commas and is Tagged/hyperlinked.

  8. gnosis_omeka Posted 2 years ago

    found at from Jason Kucsma from Metro that Kevin Reiss is developing an Omeka plugin that allows this functionality to happen.

    Thank you.

Reply

You must log in to post.