Forums » CSVImport and names separated by commas

RSS feed for this topic

Info

  • Posted in Plugins
  • Started 11 months ago by danimon
  • 5 posts by 2 users
  • Latest reply from SheilaBrennan

  1. danimon Posted 11 months ago

    Hi,

    After installing Omeka 1.4 and changing the tab delimiter to another value (to avoid the use of commas) I have been able to import names in the format 'Surname, Name' but the problem is that although in the CSV file the surname and the name are separated by a space (after the comma) when it get ingested in Omeka the Name appears immediately after the comma, so it appears as Smith,Tom instead of Smith, John.

    This issue came accross in the past in the following thread http://groups.google.com/group/omeka-dev/browse_thread/thread/a504e119d115578b/4ba168ed9f207d04?lnk=gst&q=delimiter#4ba168ed9f207d04 , but not sure if it was planned to be fixed in the new Omeka version.

    It is there an easy way of changing the code to get this fixed?

    Thanks a lot,

  2. SheilaBrennan (Omeka Outreach Team) Posted 11 months ago

    What version of the plugin are you using? The current tagged version -- avail in the plugin directory --(1.3-1.3), doesn't provide a way to designate a new delimiter other than a comma.

    We are, however, updating the plugin so that you can determine the column delimiter in the CSV Import's admin page. I believe the delimiter will have to be a character, and not a space, in order to be read.

  3. danimon Posted 11 months ago

    Hi Sheila, I'm using version 1.3 of the CSV plugin.

    I don't think I explain myself correctly. I don't want to change the column delimiter but the tag delimiter.

    Omeka 1.4 allows to change the tag delimiter in the Settings page. I have change it to a semicolom and have imported the following CSV file successfully into Omeka:

    title,"date","tags"
    item 1,"2000","economy;medicine;Smith, John"
    item 2,"2001","sociology;medicine;Duncan, Stephen"

    However, like I explained before although in the CSV file the surname and the name are separated by a space (after the comma) when it get ingested in Omeka the Name appears immediately after the comma, so it appears as Smith,Tom instead of Smith, John.

    Not sure if the new version of the version of the CSVImport plugin will help to fix this but I think it is a different issue.

    Thanks,

    Daniel

  4. danimon Posted 11 months ago

    Hi again,

    Sheila, just to let you know that I have solve the problem changing the code of the CSVImport plugin in the following file:

    /plugins/CsvImport/models/CsvImport/Import.php

    in the lines 241 and 268, after explode and implode the comma has to been change for a semicolom.

    This change allows to import names (in the form "Smith, John") leaving the white space after the comma.

    Anyway, it is good to know that the new version of the plugin will allow to change the tag delimiter from the admin pages.

    Regards,
    Daniel

  5. SheilaBrennan (Omeka Outreach Team) Posted 11 months ago

    Great, glad to hear you fixed it yourself! I apologize for misunderstanding your initial question.

    Good luck with the project!

Reply

You must log in to post.