Re: [Dbpedia-discussion] Invalid character in infobox-mappingbased-loose.nt when trying to load DBPedia in virtoso

[Kingsley I. <ki...@op...>]

Marvin Lugair wrote:
> Hi,
> I am trying to load the new DBPedia in Virtuoso,
> I am getting the error below, any ideas?
>
> Marvin
>
>
> *** Error 37000: [Virtuoso Driver][Virtuoso Server]SP029: TURTLE RDF loader, line 1032914: Invalid character in INITIAL expression at <
> at line 0 of Top-Level:
> ttlp_mt (file_to_string_output ('data/infobox-mappingbased-loose.nt'), '', 'http://dbpedia.org')
> BAD FILE.  data/infobox-mappingbased-loose.nt
> Checkpoint start at: 17:13:45
>
>
>
>
>       
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Dbpedia-discussion mailing list
> Dbp...@li...
> https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
>
>   
Marvin,

This is a known problem re. the .ttl files.

We are preparing an installer for Virtuoso+DBpedia that will 
automatically build DBpedia from scratch. The installer is going to be 
push-button i.e., you run in the background and wait for an email to 
tell you DBpedia is built and ready for use.

Short-term, you could do:
cat <problem-file.ttl>| sed -e 
"s/^dbpedia:/<http:\/\/dbpedia.org\/resource\//g" | sed -e "s/^<[^ 
]*/&>/g" > <new-file>.

Then:
select ttlp_mt (file_to_string_output ('<new-file'), '', 
'http://dbpedia.org');  --- assuming Graph IRI <http://dbpedia.org> .

-- 


Regards,

Kingsley Idehen	      Weblog: http://www.openlinksw.com/blog/~kidehen
President & CEO 
OpenLink Software     Web: http://www.openlinksw.com