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

Re: CSV metadata generator and editor

From: Ivan Herman <ivan@w3.org>
Date: Mon, 1 Feb 2016 14:56:13 +0100
Cc: Mao Li <maol@microsoft.com>, "h1251063@s.wu.ac.at" <h1251063@s.wu.ac.at>, Foam Liu <foamliu@microsoft.com>, "gregg@greggkellogg.net" <gregg@greggkellogg.net>, W3C CSV on the Web Working Group <public-csv-wg@w3.org>, "sebastian.neumaier@wu.ac.at" <sebastian.neumaier@wu.ac.at>
Message-Id: <AB20C8C0-6FC5-470D-88EE-E8E2EB4B6CF3@w3.org>
To: Jürgen Umbrich <juergen.umbrich@wu.ac.at>
Thanks for this!

You rock:-)

Ivan

> On 1 Feb 2016, at 13:43, Jürgen Umbrich <juergen.umbrich@wu.ac.at> wrote:
> 
> 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
> 
> 
> 
> 


----
Ivan Herman, W3C
Digital Publishing Lead
Home: http://www.w3.org/People/Ivan/
mobile: +31-641044153
ORCID ID: http://orcid.org/0000-0003-0782-2704





Received on Monday, 1 February 2016 13:56:27 UTC

This archive was generated by hypermail 2.3.1 : Monday, 1 February 2016 13:56:27 UTC