Hello Bryan, I guess you already noticed that unfortunately there is no easy way of importing DBpedia rdf data into Virtuoso, at least it needs some care. I didn't try to import the last version 3.8 yet but there are some things that you can try.
There is a more up to date blog post by the same author with DBpedia 3.7: http://joernhees.de/blog/2012/05/25/setting-up-a-local-dbpedia-3-7-mirror-with-virtuoso-6-1-5/ To reach your aim you should care for every described step and check if the problem still exists with your Virtuoso version / DBpedia version / in your DBpedia language. Some things to check in your case: 1) It seemed you tried to import file "contents-nq.txt". This file just contains the urls of the DBpedia data files, that you need to download first. If sth. went wrong use delete from DB.DBA.LOAD_LIST; to clean the load list again. 2) Are you sure you want to import nq files? They contain the format (s p o i) with i representing provenance information. Virtuoso creates different graphs for each i. If you don't need this data, just use nt files and specify a single graph "http://dbpedia.org" within the ld_dir_all command like described in the blog post. 3) The block post states that Virtuoso can only import plain (uncompressed) or gzipped files. Maybe that's the reason for your undefined namespace prefix error when trying to import a bzipped file. Benjamin (PS: I forgot to cc my mail some hours ago to the virtuoso-list) Am 06.02.2013, 11:58 Uhr, schrieb bryan rasmussen <[email protected]>: > Hi, > > I am still struggling with getting dbpedia (the danish version > downloadable here http://downloads.dbpedia.org/3.8/da) into virtuoso > > I followed the tutorial out here > http://joernhees.de/blog/2010/10/31/setting-up-a-local-dbpedia-mirror-with-virtuoso/ > - although on windows. > > After I do the select from my load list to check how it went I get: > > 1 Rows. -- 31 msec. > SQL> SELECT * FROM DB.DBA.LOAD_LIST; > ll_file > ll_graph > ll_state ll_started ll_done ll_host > ll_work_ti > me ll_error > VARCHAR NOT NULL > VARCHAR > INTEGER TIMESTAMP TIMESTAMP INTEGER > INTEGER > VARCHAR > _______________________________________________________________________________ > > E:\dbpedia\dk/contents-nq.txt > http://da.dbpedia.org > 2 2013.2.6 11:43.7 0 2013.2.6 11:43.8 0 0 > NULL > 37000 SP029: TURTLE RDF loader, line 1: Undefined namespace prefix at > http://d > ownloads.dbpedia.org/3.8/da/article_categories_da.nq.bz2 > E:\dbpedia\dk/global.graph > http://da.dbpedia.org > 2 2013.2.6 11:43.7 0 2013.2.6 11:43.8 0 0 > NULL > 37000 SP029: TURTLE RDF loader, line 1: Undefined namespace prefix at > http://d > a.dbpedia.org > > 2 Rows. -- 47 msec. > SQL> > > > Any suggestions, anywhere I can go ask if not here? > > Thanks, > Bryan Rasmussen > > On Wed, Feb 6, 2013 at 2:18 AM, bryan rasmussen > <[email protected]> wrote: >> Hi, >> I'm trying to import the danish dbpedia, I do the following in isql: >> >> DB.DBA.TTLP_MT(file_to_string_output('E:\\dbpedia\\dk\\category_labels_da.nq\\category_labels_da.nq'), >> '', 'http://localhost:8890/DAV/dbpedia/dk', 512); >> >> The data is of the format: >> >> <http://da.dbpedia.org/resource/Kategori:Tal> >> <http://www.w3.org/2000/01/rdf-schema#label> "Tal"@da >> <http://da.wikipedia.org/wiki/Kategori:Tal?oldid=6062900> . >> <http://da.dbpedia.org/resource/Kategori:Tidsperioder> >> <http://www.w3.org/2000/01/rdf-schema#label> "Tidsperioder"@da >> <http://da.wikipedia.org/wiki/Kategori:Tidsperioder?oldid=5757820> . >> <http://da.dbpedia.org/resource/Kategori:Kemi> >> <http://www.w3.org/2000/01/rdf-schema#label> "Kemi"@da >> <http://da.wikipedia.org/wiki/Kategori:Kemi?oldid=6045968> . >> >> and so on and so forth. >> >> sparql select * from <http://da.dbpedia.org/resource/Kategori> where >> {?s ?p ?o}; >> >> and I get >> The statement execution did not return a result set. >> >> I also tried to use the quad store upload and it told me >> >> You have attempted to upload invalid data. You can only upload RDF, >> Turtle, N3 serializations of RDF Data to the RDF Data Store. >> >> So - >> >> 1. I would like to upload the data - at least in some cases - for >> example for demo purposes, is there any tool anyone knows of that can >> change dbpedia extracted data into a format that virtuoso will accept >> >> 2. how do I write the query above so that I can get some data out? >> >> Thanks, >> Bryan Rasmussen > > ------------------------------------------------------------------------------ > Free Next-Gen Firewall Hardware Offer > Buy your Sophos next-gen firewall before the end March 2013 > and get the hardware for free! Learn more. > http://p.sf.net/sfu/sophos-d2d-feb > _______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users ------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb _______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
