CSV Importing ValueSuggest Terms



(Also opened as a github issue here.

I’d like to be able to import a number of ‘items’ (really archives/books/locations described with linked data) via import. CSV import seems to be the only one that works consistently for me, but I cant’t figure out how to import

  1. controlled vocabs
  2. instances when there are multiple fields (e.g. the dc:title is a URI and a Label.)

Here’s an example of what I get when I export:

dcterms:title dcterms:creator dcterms:description dcterms:subject dcterms:spatial dcterms:temporal skos:relatedMatch o-module-mapping:marker dcterms:title dcterms:creator dcterms:subject dcterms:description
http://www.azqueerarchives.org/ Arizona Queer Archives Institute for LGBT Studies at the University of Arizona http://id.loc.gov/authorities/subjects/sh92005716;http://id.loc.gov/authorities/subjects/sh2007003708;http://id.loc.gov/authorities/subjects/sh85061780;http://id.loc.gov/authorities/subjects/sh95005870;http://id.loc.gov/authorities/subjects/sh2004003369;http://id.loc.gov/authorities/subjects/sh2016000237;http://id.loc.gov/authorities/subjects/sh95001199 http://www.geonames.org/6252001;http://www.geonames.org/5551752;http://www.geonames.org/4526648;http://www.geonames.org/5308655;http://www.geonames.org/5389489 http://id.loc.gov/authorities/subjects/sh85037058;http://id.loc.gov/authorities/subjects/sh96004149;http://id.loc.gov/authorities/subjects/sh96005467;http://id.loc.gov/authorities/subjects/sh96010818;http://id.loc.gov/authorities/subjects/sh85010752;http://id.loc.gov/authorities/subjects/sh96005475;http://id.loc.gov/authorities/subjects/sh96005468 http://homosaurus.org/v2/transsexualPeople;http://homosaurus.org/v2/crossdressers;http://homosaurus.org/v2/intersexPeople;http://homosaurus.org/v2/homosexuality;http://homosaurus.org/v2/lesbianMovement;http://homosaurus.org/v2/LGBTQPeople;http://homosaurus.org/v2/queerArchives;http://homosaurus.org/v2/bisexualPeople;http://homosaurus.org/v2/archivesLGBTQ;http://homosaurus.org/v2/HIVAIDS 2 http://www.azqueerarchives.org/ Arizona Queer Archives http://id.loc.gov/authorities/subjects/sh92005716;http://id.loc.gov/authorities/subjects/sh2007003708;http://id.loc.gov/authorities/subjects/sh85061780;http://id.loc.gov/authorities/subjects/sh95005870;http://id.loc.gov/authorities/subjects/sh2004003369;http://id.loc.gov/authorities/subjects/sh2016000237;http://id.loc.gov/authorities/subjects/sh95001199 Institute for LGBT Studies at the University of Arizona

Any insight to what I’m doing wrong?


I’m not totally clear what the table you posted is representing and the particular problems you’re having. Can you reword or clarify: what are the results you are expecting and what are you getting?


Sure. The item when viewed from Omeka should have prelinked subject headings like so

Clicking the link brings you to the associated subject heading

What I posted there is the CSV that I download but I can’t figure out how to make it so that it uploads that way


@jflatnes – is there another way I could explain? I’m basically trying to understand how I get items via CSV import to show up as

Subject Chromsomes


Subject Chromosomes


CSV Import hasn’t previously had support for importing URLs with labels attached, but its just-released new version does: if you import a column as a URI type with data like http://example.com Example Label it will extract the part after the first space as the label and set it on the created values.


@jflatnes thank you so much! I really appreciate the note! Do you know if importing it like this does the same thing as @Daniel_KM 's ValueSuggest under the hood (eg makes a rdf triple)?


And one more question: how do you structure a CSV file to handle multiple entries of the same thing, eg the “subject” or “spatial” groupings here? :


Any “URI” value in Omeka S is represented as an RDF triple with the link URI as the “object.” I don’t know if the ValueSuggest module you’re referring to is a different version than the “normal” one, but there’s nothing special about what it does.

Multiple entries are supported in CSV using the “multivalue” options: you set a multivalue separator character in the advanced settings tab, then use the “options” wrench for a column to mark it as multivalue. The importer will split the cell on the character you put in under the advanced settings.


That’s what I thought.

So I’ll go
http...com Archive;http...com LBGTQ; etc

Thank you @jflatnes–I really appreciate you taking the time. :slight_smile: