RDF Mapping import

goodyear2017

Hi everyone,im trying to create a Mapping for RDF files, so i can import records in Collective Access. I have attached the Mapping and the RDF file ( as .txt since the forum wont allow me to upload it as .rdf) and the screenshot of the Web-GUI. When i try to import RDF files with this mapping, nothing happens (i've waited for over an hour). The import doesnt finish and it won't throw any errors. The php_errors.log file doesnt contain anything neither.I also tried various XPath queries and i verified them with an online XPath query tester, no matter what i offer, the mapping won't succeed. I hope someone can give me a hint or share his/her RDF Mapping with me. Thanks a lot in advance. I wish everyone nice holidays :D

goodyear2017

Some examples of other XML Mappings would be great too, thank you.

Julia

What does the import log say at /app/log?

goodyear2017

Thanks for your quick response. At least i now know where to look :) Well it says :2016-12-28 8:28:58 - INFO --> Started import of /tmp/phpTN2UGb using mapping rdf2016-12-28 8:28:58 - DEBUG --> Finished reading input source at    0.0013 seconds2016-12-28 8:28:58 - DEBUG --> Found 0 rows in input source2016-12-28 8:28:58 - DEBUG --> Finished analyzing mapping at    0.0027 seconds2016-12-28 8:28:58 - INFO --> Import of /tmp/phpTN2UGb completed using mapping rdf: 0 imported/0 skipped/0 errorsSo i guess CA doesnt like my XPath Query. The "basePath" setting is required in case i have more than one record in one RDF file, am i right about this?

seth

basePath should be an XPath expression that selects a non-root tag to be taken as root for purposes of the mapping.

goodyear2017

@seth Thank you. Do you have any XML Import Mapping examples, that you can share with me? I would really appreciate it.There must be someone out there, who has a working XML Import Mapping ...

Julia

@goodyear2017 here you go:

goodyear2017

@Julia thank you so much for the Mapping, do you have the Source file too ?

Julia

The source data is the Getty ULAN linked open data.

goodyear2017

@Julia thx.Well i looked at your ULAN mapping, it doesnt look too different from my RDF mapping (syntax wise). Still the app/log keeps saying, it doesn't find any rows in input source :2017-01-04 5:56:07 - INFO --> Started import of /tmp/phpwFAsAy using mapping rdf2017-01-04 5:56:07 - DEBUG --> Finished reading input source at    0.0013 seconds2017-01-04 5:56:07 - DEBUG --> Found 0 rows in input source2017-01-04 5:56:07 - DEBUG --> Finished analyzing mapping at    0.0029 seconds2017-01-04 5:56:07 - INFO --> Import of /tmp/phpwFAsAy completed using mapping rdf: 0 imported/0 skipped/0 errorsAre there any mandatory table.elements when i create a mapping?

goodyear2017

Rule type Source CA table.elementMapping (//rdf:Description)/foaf:nick/text() ca_entities.preferred_labels Setting name Setting valueSetting name mein_rdfSetting code rdfSetting inputFormats RDFSetting table ca_entitiesSetting type entitySetting numInitialRowsToSkip #number#Setting existingRecordPolicy overwrite_on_idnoSetting errorPolicy ignoreSetting archiveMapping noSetting archiveDataSets noSetting basePath Setting locale DEFAULT<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE rdf:RDF [ <!ENTITY dcmitype "http://purl.org/dc/dcmitype/" > <!ENTITY dcterms "http://purl.org/dc/terms/" > <!ENTITY foaf "http://xmlns.com/foaf/0.1/" > <!ENTITY gn "http://www.geonames.org/ontology#" > <!ENTITY gnd "http://d-nb.info/standards/elementset/gnd#" > <!ENTITY lvont "http://lexvo.org/ontology#" > <!ENTITY ore "http://www.openarchives.org/ore/terms/" > <!ENTITY owl "http://www.w3.org/2002/07/owl#" > <!ENTITY rdf "http://www.w3.org/1999/02/22-rdf-syntax-ns#" > <!ENTITY rdfs "http://www.w3.org/2000/01/rdf-schema#" > <!ENTITY vs "http://www.w3.org/2003/06/sw-vocab-status/ns#" > <!ENTITY wsp "http://wissensspeicher.bbaw.de/ontology/" > <!ENTITY xsd "http://www.w3.org/2001/XMLSchema#" > ]> <rdf:RDF xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:foaf="http://xmlns.com/foaf/0.1/" xmlns:gn="http://www.geonames.org/ontology#" xmlns:gnd="http://d-nb.info/standards/elementset/gnd#" xmlns:lvont="http://lexvo.org/ontology#" xmlns:ore="http://www.openarchives.org/ore/terms/" xmlns:owl="http://www.w3.org/2002/07/owl#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:rdfs="http://www.w3.org/2000/01/rdf-schema#" xmlns:vs="http://www.w3.org/2003/06/sw-vocab-status/ns#" xmlns:wgs84_pos="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:wsp="http://wissensspeicher.bbaw.de/ontology/" xmlns:xsd="http://www.w3.org/2001/XMLSchema#" xml:base="http://wissensspeicher.bbaw.de/rdf/resources/registres.rdf"> <rdf:Description rdf:about="http://wissensspeicher.bbaw.de/rdf/resources/registres.rdf"> <rdf:type rdf:resource="&foaf;Document"/> <dcterms:created rdf:datatype="&xsd;date">2014-04-01</dcterms:created> <dcterms:modified rdf:datatype="&xsd;date">2016-07-25</dcterms:modified> </rdf:Description> <rdf:Description rdf:about="http://wissensspeicher.bbaw.de/rdf/normdata/Registres"> <rdf:type rdf:resource="&wsp;Project"/> <dcterms:abstract xml:lang="de">Zum 300. Geburtstag Friedrichs II. verÃ¶ffentlicht die Berlin-Brandenburgische Akademie der Wissenschaften online alle Plenarsitzungsprotokolle der vom PreuÃŸenkÃ¶nig erneuerten AcadÃ©mie Royale des Sciences et Belles-Lettres de Prusse aus den Jahren 1746 bis 1786.</dcterms:abstract> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Dumont"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Fechner"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Hanrahan"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Unger"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Knobloch"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Blohm"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Enke"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Knobloch"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Krauth"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Schnoepf"/> <dcterms:contributor rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Wiederkehr"/> <dcterms:language rdf:resource="http://lexvo.org/id/iso639-3/fra"/> <dcterms:temporal rdf:nodeID="temp-registres-1"/> <dcterms:temporal rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Neuzeit"/> <dcterms:type rdf:resource="http://wissensspeicher.bbaw.de/rdf/projectType/bbawCategories#Initiative"/> <dcterms:valid rdf:datatype="&dcterms;Period">start=2010; end=2012; name=Laufzeit</dcterms:valid> <foaf:homepage rdf:resource="http://akademieregistres.bbaw.de"/> <foaf:name xml:lang="fr">Registres de l'Academie</foaf:name> <foaf:nick>registres</foaf:nick> <foaf:status xml:lang="de">abgeschlossen</foaf:status> <gnd:contributingCorporateBody rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Archiv"/> <gnd:contributingCorporateBody rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Bibliothek"/> <gnd:contributingCorporateBody rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Telota"/> <gnd:hierarchicalSuperior rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/BBAW"/> </rdf:Description> <rdf:Description rdf:nodeID="temp-registres-1"> <rdf:type rdf:resource="&dcterms;PeriodOfTime"/> <rdf:value rdf:datatype="&dcterms;Period">start=1746-06-02; end=1786-07-20; name=Plenarsitzungsprotokolle der AcadÃ©mie Royale des Sciences et Belles-Lettres de Prusse</rdf:value> <rdfs:label xml:lang="de">Plenarsitzungsprotokolle der AcadÃ©mie Royale des Sciences et Belles-Lettres de Prusse</rdfs:label> </rdf:Description>  <rdf:Description rdf:about="http://wissensspeicher.bbaw.de/rdf/normdata/Registres/Protokolle"> <rdf:type rdf:resource="&ore;Aggregation"/> <dcterms:isPartOf rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Registres"/> <dcterms:publisher rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/BBAW"/> <foaf:homepage rdf:resource="http://akademieregistres.bbaw.de"/> <dcterms:title xml:lang="de">Registres de l'Academie</dcterms:title> </rdf:Description> <rdf:Description rdf:about="http://akademieregistres.bbaw.de"> <rdf:type rdf:resource="&wsp;DigitalResource"/> <ore:isAggregatedBy rdf:resource="http://wissensspeicher.bbaw.de/rdf/normdata/Registres/Protokolle"/> </rdf:Description> </rdf:RDF>

goodyear2017

That's how the Configuration Check looks like. I'm using php7 and chose dublincore_2014.xml profile during installation. I'm really frustrated right now, i've tried everything, i could think of, yet it keeps finding 0 rows.

goodyear2017

At long last i've found the solution!!One must set :Setting        basePath              /otherwise it won't find an entry point.I found another weird error though. When i set "Type" to anything other than "text" it throws "[Error] Could not insert new record for object:  Type must be specified", what's wrong with that? Can't one set any Type ?

Julia

Type has to be set to one of the list items defined in the list object_types. "Text" is defined there presumably if you're not getting an error for that value. Make sure to use the list item code, not the name value.

goodyear2017

Here is my working RDF Importmapping.