CSV Importing ValueSuggest Terms

brimwats · July 31, 2019, 10:14pm

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

controlled vocabs
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?

jflatnes · August 1, 2019, 7:26pm

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?

brimwats · August 1, 2019, 8:22pm

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

brimwats · August 8, 2019, 2:01pm

@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

jflatnes · August 9, 2019, 8:52pm

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.

brimwats · August 9, 2019, 10:39pm

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

brimwats · August 12, 2019, 3:04pm

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

jflatnes · August 12, 2019, 6:25pm

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.

brimwats · August 12, 2019, 6:44pm

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.