Re: CSV metadata generator and editor

Hi Mao Li, 

we pushed our Metadata editor to a public github repository[1] under the MIT License and added some documentation about the installation process. 

We still want to add the xsd-datatype detection to the editor and add some more documentation how to adapt the templates. 
Also, we are currently integration a validator service which is build around the python csvmetadata validator from Sebastian[2] (however, we cover only 50% of the test cases but this should be improved soon as well). 

And sorry for the delay, we thought we can push our code to github on friday last week. 

Please directly contact us (Sebastian Neumaier and me) for any further question or use the github page to trigger public discussion. 
Would be great if we can work together and make this editor really useful. 

best
  Jürgen

[1] https://github.com/ODInfoBiz/csvengine-ui
[2] https://github.com/sebneu/csvw-parser


-----Original Message-----
From: Mao Li <maol@microsoft.com>
Reply: Mao Li <maol@microsoft.com>
Date: 26 January 2016 at 09:52:31
To: jueumb@gmail.com <jueumb@gmail.com>
Cc: h1251063@s.wu.ac.at <h1251063@s.wu.ac.at>, sebastian.neumaier@wu.ac.at <sebastian.neumaier@wu.ac.at>, public-csv-wg@w3.org <public-csv-wg@w3.org>, Foam Liu <foamliu@microsoft.com>, gregg@greggkellogg.net <gregg@greggkellogg.net>
Subject:  Re: CSV metadata generator and editor

> Hi Juergen,
>  
> I've just tried the tool and it's cool! Thanks for your great work!
>  
> 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?
>  
> 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.
>  
> 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 Monday, 1 February 2016 12:43:59 UTC