CSV Importing ValueSuggest Terms


#1

Hello!

(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?


#2

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?


#3

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


#4

@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

not

Subject Chromosomes
http://homosaurus.org/v2/chromosomes


#5

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.


#6

@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)?


#7

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? :


#8

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.


#9

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: