W3C home > Mailing lists > Public > public-csv-wg@w3.org > January 2016

Re: CSV metadata generator and editor

From: Jürgen Umbrich <juergen.umbrich@wu.ac.at>
Date: Tue, 26 Jan 2016 09:11:00 +0100
To: Mao Li <maol@microsoft.com>
Cc: "h1251063@s.wu.ac.at" <h1251063@s.wu.ac.at>, Foam Liu <foamliu@microsoft.com>, "gregg@greggkellogg.net" <gregg@greggkellogg.net>, "public-csv-wg@w3.org" <public-csv-wg@w3.org>, "sebastian.neumaier@wu.ac.at" <sebastian.neumaier@wu.ac.at>, Jürgen Umbrich <juergen@umbrich.net>
Message-ID: <etPan.56a72a14.7b99af8.28d@localhost>
Hi Li, 

> I've just tried the tool and it's cool! Thanks for your great work!
thanks for your reply and we are very happy that you like our prototype so far:) 


> One of my recent projects need to maintain schema definitions for data stored in csv files.  
> So I'd like to know whether we can leverage your tool and make our contribution to it? Do  
> you have any plan to make it open source and which license would you like to use?
Yes, we do have these plans indeed. We will push and try to open source the framework on github at the end of this week. We will try to provide enough documentation to get started with the code.
Regarding the license, we thought about MIT license but are open for any suggestion in case another open source license would be a better fit.  

> BTW, I think one feature we need but missing in this tool, is specify foreign keys, and  
> more refined type constraints such as cell value length.
Thats sounds great. From our side, we will also add some basic xsd-datatype detection in the next days.


Best and we will keep you updated
  Jürgen 


>  
> Thanks,
> Mao Li
>  
> --------------------------------------------------------------------------------------------------------------------------------------------------  
>  
> Hi all,
>  
>  
>  
> one of our students ( Manuel Undesser in CC) developed as part of his bachelor thesis a  
> UI for generating and editing the metadata of CSV files which is compliant with the CSV  
> on the Web metadata standard.
>  
>  
>  
> the current early alpha status and test version is available at: http://data.wu.ac.at/csvengine/  
>  
>  
>  
>  
>  
> We would be very happy for any feedback, comments, criticism, suggestions, bug reports,  
> etc... ;)
>  
>  
>  
> We plan to release our editor in the near future to the public with the hope that such a tool  
> will help to further drive the adoption of the metadata standard and ease the generation  
> of an initial version.
>  
> We will also release the source code on github after another round of testing, improvements  
> and adding documentation.
>  
> Again, any additional suggestions are highly appreciated.
>  
>  
>  
> Obviously, there are already a list of further improvements, which can be roughly grouped  
> into three areas:
>  
> 1) automatically generate comprehensive metadata (e.g., detect column datatypes,  
> primary keys, etc..)
>  
> 2) detect existing metadata and preload it into the editor, so that a user can edit existing  
> metadata
>  
> 3) UI and usability improvements
>  
>  
>  
>  
>  
> Best
>  
> Jürgen
>  
>  

--
Dr. Jürgen Umbrich  
WU Vienna, Institute for Information Business
Received on Tuesday, 26 January 2016 08:11:40 UTC

This archive was generated by hypermail 2.3.1 : Tuesday, 26 January 2016 08:11:40 UTC