Re: Notepad++ plug-in to validate CSV data

Hi,

bit of a late reply, sorry for that. Just wanted to let you know that in
the latest update of the CSV Lint plugin v0.4.6.5 there has been an update
to generating the W3C CSV schema JSON.
It now outputs correct JSON and adheres more closely to the standards as
described on the w3c.org website.

So the plugin doesn't use an official C# implementation/library of the CSVW
specs but it can generate a CSVW compliant schema JSON based on any csv
file.
See how the plugin works in this example output file ->
https://github.com/BdR76/CSVLint/blob/master/testdata/schema.json
You can also install Notepad++ and the plugin (via Plugin Admin) and then:

1. Open a csv file
2. go to the menu Plugins > CSV Lint > Generate metadata
3. select "W3C CSV schema JSON"

The only caveat is fixed width text files. I couldn't find a specification
for this on the W3C website, so how to handle fixed width column positions.
I've added my own implementation which adds the list of end-postions in the
dialect-part.

If there is any specification for fixed width type files, let me know and
I'll update the plugin

regards,
Bas de Reuver

On Sat, Oct 30, 2021 at 8:38 PM Gregg Kellogg <gregg@greggkellogg.net>
wrote:

> This definitely seems like a useful tool, but does it make use of the CSVW
> metadata standards? If it is part of the CSVW ecosystem, we could possibly
> add an entry to the group homepage to highlight it for those that might be
> interested.
>
> If there is a C# implementation of the CSVW specs, that would be good to
> note, as well.
>
> Gregg Kellogg
> gregg@greggkellogg.net
>
> On Oct 28, 2021, at 1:02 AM, Bas de Reuver <bdr1976@gmail.com> wrote:
>
> Hi,
>
> I saw the website of the CSV for web hasn't been updated in a long time
> https://www.w3.org/community/csvw/ but if anyone is interested, I've
> created a plug-in for Notepad++ that can validate csv files.
>
> Initially it was just for checking datetime/decimal formatting errors. It
> can detect datatypes and validate the data, and in the most recent update
> it also has syntax highlighting for the columns. It even works with fixed
> width files (not sure if anyone still uses those) and can reformat the data
> to different csv formats.
>
> Feel free to check it out here, and if you can let me know what you think.
> https://github.com/BdR76/CSVLint/
>
> cheers,
> Bas de Reuver (The Netherlands)
>
>
>