W3C home > Mailing lists > Public > public-lod@w3.org > December 2012

Re: CSV to RDF converter

From: Hugh Williams <hwilliams@openlinksw.com>
Date: Thu, 13 Dec 2012 01:54:29 +0000
To: public-lod <public-lod@w3.org>
Message-Id: <6C129BEC-F85A-4C41-BD96-F1290EC0DCC2@openlinksw.com>
Hi Ying,

Note Virtuoso can be use to map CSV files to SQL either by bulk loading if there are many files as detailed at:

	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtCsvFileBulkLoader

or via the Virtuoso Conductor from the “Database -> Import” tab if you only have a single or few CSV files to load as detailed at:

	http://docs.openlinksw.com/virtuoso/htmlconductorbar.html#conductorbar

Once the CSV data has been loaded/imported into the Virtuoso as SQL tables, you could then use with R2RML or Virtuoso RDFViews to map the relational representation to RDF as detailed at

	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtR2RML
	http://www.openlinksw.com/dataspace/dav/wiki/Main/VOSSQL2RDF
	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtRdb2RDFViewsGeneration

Also, note the Virtuoso Sponger Middleware includes a CSV sponger (rdf’izer) extractor cartridge that can automatically map web accessible CSV files into RDF as detailed at:

	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtSponger
	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtSpongerCartridgeSupportedDataSourcesNonRDF

It is also possible to write your own  custom sponger extractor or meta cartridges to control the form of RDF transformation performed as detailed at:

	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtSpongerCartridgeProgrammersGuide

The CSV (or any other supported format)  files can also be uploaded into Virtuoso WebDAV rdf_sink folders and automatically invoke the sponger service to transform to RDF as detailed at:

	http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoRDFSinkFolder

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 12 Dec 2012, at 21:31, Kingsley Idehen wrote:

> On 12/12/12 4:15 PM, Barry Norton wrote:
>> 
>> Ying, this might sound like a stupid question, but if you want SQL features why not pull your CSV into a relational DB table then R2RML it into RDF (since mappings will allow you arbitrary SQL)?
> 
> +1
> 
> 
> Links:
> 
> 1. http://www.w3.org/TR/r2rml/
> 2. http://www.w3.org/2001/sw/rdb2rdf/wiki/Implementations .
> 
> 
> Kingsley
>> 
>> Barry
>> 
>> 
>> 
>> On 12/12/2012 21:08, Ying Ding wrote:
>>> Hi,
>>> 
>>> I am looking for a open source software to convert csv file to RDF based on one pre-defined ontology. Also, this converter should support complicated SQL queries (e.g., Group BY query and IF/THEN/ELSE query) while defining the mapping between csv to our pre-defined ontology.
>>> 
>>> thanks
>>> ying
>>> 
>>> 
>> 
>> 
>> 
>> 
> 
> 
> -- 
> 
> Regards,
> 
> Kingsley Idehen	
> Founder & CEO
> OpenLink Software
> Company Web: http://www.openlinksw.com
> Personal Weblog: http://www.openlinksw.com/blog/~kidehen
> Twitter/Identi.ca handle: @kidehen
> Google+ Profile: https://plus.google.com/112399767740508618350/about
> LinkedIn Profile: http://www.linkedin.com/in/kidehen
> 
> 
> 
> 
> 


Received on Thursday, 13 December 2012 01:37:41 UTC

This archive was generated by hypermail 2.4.0 : Thursday, 24 March 2022 20:30:02 UTC