You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by elio hbeich <el...@gmail.com> on 2019/02/14 13:59:05 UTC
CSV to rdf
Dear all
Do you have any suggestion about tools or XSLT that can transform CSV to
RDF
Thank you in advance,
Elio HBEICH
Re: CSV to rdf
Posted by Claus Stadler <cs...@informatik.uni-leipzig.de>.
Hi all,
We have created SparqlIntegrate, examples at: https://github.com/SmartDataAnalytics/SparqlIntegrate/tree/develop/doc
It uses Jena's plugin system to register SPARQL functions and property functions(*) for CSV, XML and JSON processing.
So its another SPARQL-based approach.
(*) https://jena.apache.org/documentation/query/library-propfunc.html
Cheers,
Claus
On 14.02.19 15:19, Martynas Jusevičius wrote:
> https://github.com/AtomGraph/CSV2RDF
>
> Not XSLT but SPARQL-based, yet the transformation concept is similar.
>
> I'm the author :)
>
> On Thu, Feb 14, 2019 at 2:59 PM elio hbeich <el...@gmail.com> wrote:
>> Dear all
>>
>> Do you have any suggestion about tools or XSLT that can transform CSV to
>> RDF
>>
>> Thank you in advance,
>> Elio HBEICH
Re: CSV to rdf
Posted by Martynas Jusevičius <ma...@atomgraph.com>.
https://github.com/AtomGraph/CSV2RDF
Not XSLT but SPARQL-based, yet the transformation concept is similar.
I'm the author :)
On Thu, Feb 14, 2019 at 2:59 PM elio hbeich <el...@gmail.com> wrote:
>
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
Re: CSV to rdf
Posted by Claude Warren <cl...@xenei.com>.
Try Any23 (http://any23.apache.org/) its job in life is to covert from
other formats to RDF and it has a CSV conversion module.
Claude
On Thu, Feb 14, 2019 at 1:59 PM elio hbeich <el...@gmail.com> wrote:
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
>
--
I like: Like Like - The likeliest place on the web
<http://like-like.xenei.com>
LinkedIn: http://www.linkedin.com/in/claudewarren
Re: CSV to rdf
Posted by Adrian Gschwend <ml...@netlabs.org>.
On 15.02.19 09:50, Conal Tuohy wrote:
> I have used (and I can recommend) CSV2RDF from
> https://github.com/theodi/csv2rdf which is compliant to the W3C's CSV on
> the Web specification. You can generate RDF from CSV file by creating a
> metadata file (in JSON format) which describes the CSV. It uses URI
> Templates to specify how to convert CSV values into resource identifiers.
>
> NB this is different to Martynus's software of the same name.
I would also recommend CSV on the Web. Unfortunately the Ruby
implementation has quite bad performance, for that reason we wrote our
own streaming-based implementation.
https://github.com/rdf-ext/rdf-parser-csvw
There is no cli-tool right now, we use this in pipelines. For example:
https://github.com/zazuko/blv-tierseuchen-ld/
regards
Adrian
Re: CSV to rdf
Posted by Conal Tuohy <co...@gmail.com>.
On Thu, 14 Feb 2019 at 23:59, elio hbeich <el...@gmail.com> wrote:
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
>
I have used (and I can recommend) CSV2RDF from
https://github.com/theodi/csv2rdf which is compliant to the W3C's CSV on
the Web specification. You can generate RDF from CSV file by creating a
metadata file (in JSON format) which describes the CSV. It uses URI
Templates to specify how to convert CSV values into resource identifiers.
NB this is different to Martynus's software of the same name.
--
Conal Tuohy
http://conaltuohy.com/
@conal_tuohy
+61-466-324297
Re: CSV to rdf
Posted by Andrii Berezovskyi <an...@kth.se>.
Alex,
Strictly speaking it's not. R2RML, RML's predecessor, however, is indeed a W3C recommendation.
And just to be clear, RML is great!
/Andrew
> On 2019-02-18 , at 16:25, Alex To <to...@gmail.com> wrote:
>
> I'm surprised that no one mentioned RML (http://rml.io/) which is a W3C
> standard and the Java library https://github.com/RMLio/rmlmapper-java/
>
> I've been happily using this library to transform XML, CSV from web
> services.
>
> Regards
>
>
> On Sat, Feb 16, 2019 at 12:34 AM John A. Fereira <ja...@cornell.edu> wrote:
>
>>
>> When this question has come up in the past I’ve recommended the VIVO
>> Harvester tool (https://github.com/vivo-project/VIVO-Harvester) which can
>> transform content to RDF from many different sources (csv, jdbc database,
>> json, xml, web services). It consists of a suite of tools for ingesting
>> content into the VIVO semantic web application but could be used for
>> creating RDF in general (it is based on Jena). It essentially transforms
>> from one of the supported data sources into a “flat” rdf structure which
>> can then be transformed into RDF which models the desired ontology using
>> XSLT. Note that database such as MySQL can get loaded from a CSV file,
>> and then a tool like D2R Map could be used to transform content from the
>> database to RDF.
>>
>> On 2/14/19, 11:31 PM, "Conal Tuohy" <co...@gmail.com> wrote:
>>
>> Elio, this small XSLT may be a helpful example:
>>
>> https://github.com/TEIC/Stylesheets/blob/dev/profiles/default/csv/from.xsl
>>
>> It opens the CSV file, splits it into lines, and then generates a new
>> TEI
>> XML document in which it simply re-encodes the tabular data using TEI
>> <table>, <row>, and <cell> elements. You can see how you could use the
>> same
>> technique, but output RDF/XML or TriX, if that's what you want to do.
>>
>> Regards
>>
>> Conal
>>
>> On Thu, 14 Feb 2019 at 23:59, elio hbeich <el...@gmail.com>
>> wrote:
>>
>>> Dear all
>>>
>>> Do you have any suggestion about tools or XSLT that can transform
>> CSV to
>>> RDF
>>>
>>> Thank you in advance,
>>> Elio HBEICH
>>>
>>
>>
>> --
>> Conal Tuohy
>> http://conaltuohy.com/
>> @conal_tuohy
>> +61-466-324297
>>
>>
>>
>
> --
>
> Alex To
>
> PhD Candidate
>
> School of Computer Science
>
> Knowledge Discovery and Management Research Group
>
> Faculty of Engineering & IT
>
> THE UNIVERSITY OF SYDNEY | NSW | 2006
>
> Desk 4e69 | Building J12| 1 Cleveland Street
>
> M. +61423330656 <%2B61450061602>
Re: CSV to rdf
Posted by Alex To <to...@gmail.com>.
I'm surprised that no one mentioned RML (http://rml.io/) which is a W3C
standard and the Java library https://github.com/RMLio/rmlmapper-java/
I've been happily using this library to transform XML, CSV from web
services.
Regards
On Sat, Feb 16, 2019 at 12:34 AM John A. Fereira <ja...@cornell.edu> wrote:
>
> When this question has come up in the past I’ve recommended the VIVO
> Harvester tool (https://github.com/vivo-project/VIVO-Harvester) which can
> transform content to RDF from many different sources (csv, jdbc database,
> json, xml, web services). It consists of a suite of tools for ingesting
> content into the VIVO semantic web application but could be used for
> creating RDF in general (it is based on Jena). It essentially transforms
> from one of the supported data sources into a “flat” rdf structure which
> can then be transformed into RDF which models the desired ontology using
> XSLT. Note that database such as MySQL can get loaded from a CSV file,
> and then a tool like D2R Map could be used to transform content from the
> database to RDF.
>
> On 2/14/19, 11:31 PM, "Conal Tuohy" <co...@gmail.com> wrote:
>
> Elio, this small XSLT may be a helpful example:
>
> https://github.com/TEIC/Stylesheets/blob/dev/profiles/default/csv/from.xsl
>
> It opens the CSV file, splits it into lines, and then generates a new
> TEI
> XML document in which it simply re-encodes the tabular data using TEI
> <table>, <row>, and <cell> elements. You can see how you could use the
> same
> technique, but output RDF/XML or TriX, if that's what you want to do.
>
> Regards
>
> Conal
>
> On Thu, 14 Feb 2019 at 23:59, elio hbeich <el...@gmail.com>
> wrote:
>
> > Dear all
> >
> > Do you have any suggestion about tools or XSLT that can transform
> CSV to
> > RDF
> >
> > Thank you in advance,
> > Elio HBEICH
> >
>
>
> --
> Conal Tuohy
> http://conaltuohy.com/
> @conal_tuohy
> +61-466-324297
>
>
>
--
Alex To
PhD Candidate
School of Computer Science
Knowledge Discovery and Management Research Group
Faculty of Engineering & IT
THE UNIVERSITY OF SYDNEY | NSW | 2006
Desk 4e69 | Building J12| 1 Cleveland Street
M. +61423330656 <%2B61450061602>
Re: CSV to rdf
Posted by "John A. Fereira" <ja...@cornell.edu>.
When this question has come up in the past I’ve recommended the VIVO Harvester tool (https://github.com/vivo-project/VIVO-Harvester) which can transform content to RDF from many different sources (csv, jdbc database, json, xml, web services). It consists of a suite of tools for ingesting content into the VIVO semantic web application but could be used for creating RDF in general (it is based on Jena). It essentially transforms from one of the supported data sources into a “flat” rdf structure which can then be transformed into RDF which models the desired ontology using XSLT. Note that database such as MySQL can get loaded from a CSV file, and then a tool like D2R Map could be used to transform content from the database to RDF.
On 2/14/19, 11:31 PM, "Conal Tuohy" <co...@gmail.com> wrote:
Elio, this small XSLT may be a helpful example:
https://github.com/TEIC/Stylesheets/blob/dev/profiles/default/csv/from.xsl
It opens the CSV file, splits it into lines, and then generates a new TEI
XML document in which it simply re-encodes the tabular data using TEI
<table>, <row>, and <cell> elements. You can see how you could use the same
technique, but output RDF/XML or TriX, if that's what you want to do.
Regards
Conal
On Thu, 14 Feb 2019 at 23:59, elio hbeich <el...@gmail.com> wrote:
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
>
--
Conal Tuohy
http://conaltuohy.com/
@conal_tuohy
+61-466-324297
Re: CSV to rdf
Posted by Conal Tuohy <co...@gmail.com>.
Elio, this small XSLT may be a helpful example:
https://github.com/TEIC/Stylesheets/blob/dev/profiles/default/csv/from.xsl
It opens the CSV file, splits it into lines, and then generates a new TEI
XML document in which it simply re-encodes the tabular data using TEI
<table>, <row>, and <cell> elements. You can see how you could use the same
technique, but output RDF/XML or TriX, if that's what you want to do.
Regards
Conal
On Thu, 14 Feb 2019 at 23:59, elio hbeich <el...@gmail.com> wrote:
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
>
--
Conal Tuohy
http://conaltuohy.com/
@conal_tuohy
+61-466-324297
Re: CSV to rdf
Posted by Jean-Marc Vanel <je...@gmail.com>.
I use my tool , based on Jena and Any23 :
https://github.com/jmvanel/semantic_forms/blob/master/doc/en/administration.md#semantize-raw-stuff
I you have questions or troubles, mail me privately , I'm willing to
enhance the doc or the code, and making a pre-release .
Jean-Marc Vanel
<http://163.172.179.125:9111/display?displayuri=http://jmvanel.free.fr/jmv.rdf%23me>
+33 (0)6 89 16 29 52
Twitter: @jmvanel , @jmvanel_fr ; chat: irc://irc.freenode.net#eulergui
Chroniques jardin
<http://semantic-forms.cc:1952/backlinks?q=http%3A%2F%2Fdbpedia.org%2Fresource%2FChronicle>
Le jeu. 14 févr. 2019 à 14:59, elio hbeich <el...@gmail.com> a écrit :
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
>
Re: CSV to rdf
Posted by Zak Mc Kracken <za...@yahoo.it.INVALID>.
TARQL is great!
https://tarql.github.io/
On 14/02/2019 13:59, elio hbeich wrote:
> Dear all
>
> Do you have any suggestion about tools or XSLT that can transform CSV to
> RDF
>
> Thank you in advance,
> Elio HBEICH
>