Difference between revisions of "CSV Validator"

	Validation of CSV files against user-defined schema
Homepage:	http://digital-preservation.github.io/csv-validator/
License:	Mozilla Public Licence version 2.0
Platforms:	Cross platform (Scala 2.10/Java Virtual Machine)
Function:	Metadata Processing,Validation
Content type:	Spreadsheet,Document,Research Data
Appears in COW:	Creating a SIP from content downloaded from OneDrive (or other Cloud based source), Digital archiving workflow (high-level)

Latest revision as of 09:53, 2 September 2021

Description[edit]

The CSV Validator is designed to allow validation of CSV files against user defined schema. It was developed at The National Archives (UK) to allow the validation of metadata files being received in CSV format. This was driven by the fact that CSV data is very easy to create for all users, via spreadsheet tools, or at worst any text editor. However, there was previously no straightforward way of checking that the received CSV files actually had the expected number of columns, or that those columns contained data of the type expected. Version 1.0 of the tool was released in July 2014, additional developer involvement is encouraged. The CSV Validator serves as reference implementation for the CSV Schema Language version 1.0, released simultaneously. Further information in post on The National Archives blog.

[CSV Schema Language version 1.1 was released on 25 January 2016, alongside CSV Validator 1.1.

Download[edit]

You can download CSV Validator under https://github.com/digital-preservation/csv-validator/releases.

User Experiences[edit]

Development Activity[edit]

All development activity is visible on Github: https://github.com/digital-preservation/csv-validator/commits

Release Feed[edit]

Below the last 3 release feeds:

2025-03-06 16:18:55: [tag:github.com,2008:Repository/9081590/1.4.0 CSV Validator 1.4.0]; by techncl
2024-03-01 14:22:31: [tag:github.com,2008:Repository/9081590/1.3.0 CSV Validator 1.3.0]; by sparkhi
2023-12-01 17:05:14: [tag:github.com,2008:Repository/9081590/1.3.0-RC3 1.3.0-RC3]; by sparkhi

Activity Feed[edit]

Below the last 5 activity feeds:

2025-04-15 08:46:13: [tag:github.com,2008:Grit::Commit/bc7d4b4fd7423b3f2708bc8de24ee7244c966ff5 Merge pull request #579 from digital-preservation/dependabot/maven/ca…]; by MancunianSam https://github.com/MancunianSam
2025-04-14 09:02:06: [tag:github.com,2008:Grit::Commit/fdf98b43004b9f6b21741e9ba1419668fa10f857 Merge pull request #580 from digital-preservation/dependabot/maven/io…]; by sparkhi https://github.com/sparkhi
2025-04-14 09:01:01: [tag:github.com,2008:Grit::Commit/fc233d87bc71044f04988496f0785f634c7f3eb3 Merge pull request #581 from digital-preservation/dependabot/maven/co…]; by sparkhi https://github.com/sparkhi
2025-04-14 00:37:51: [tag:github.com,2008:Grit::Commit/96ecefcb2ccdfb7f21bfce9e415b578b8088ec4a Bump commons-io:commons-io from 2.18.0 to 2.19.0]; by dependabot https://github.com/dependabot
2025-04-07 00:35:48: [tag:github.com,2008:Grit::Commit/1aa690f0cbe7718e59e6be02ae804e31193b8276 Bump io.fabric8:docker-maven-plugin from 0.45.1 to 0.46.0]; by dependabot https://github.com/dependabot

@@ Line 1: / Line 1: @@
-<!-- Use the structure provided in this template, do not change it! -->
+{{Infobox tool
+|image=Csv-validator-started-gui.png
-{{Infobox_tool
 |purpose=Validation of CSV files against user-defined schema
-|image=Csv-validator-started-gui.png
 |homepage=http://digital-preservation.github.io/csv-validator/
 |license=[http://www.mozilla.org/MPL/2.0/ Mozilla Public Licence version 2.0]
 |platforms=Cross platform (Scala 2.10/Java Virtual Machine)
+|function=Metadata Processing, Validation
+|content=Spreadsheet, Document, Research Data
 }}
+{{Infobox tool details}}
-<!-- Add one ore more categories to describe the function of the tool. Choose carefully, and view the list of existing categories first (see the Navigation sidebar on the left). The following are common category examples, remove those that don't apply -->
-[[Category:Metadata Processing]]
-[[Category:Validation]]
-<!-- Add relevant categories to describe the content type that the tool addresses. Choose carefully, and view the list of existing categories first (see the Navigation sidebar on the left). If the tool works on any content type, do not add a category. The following are common category examples, remove those that don't apply -->
-[[Category:Spreadsheet]]
-[[Category:Document]]
-[[Category:Research Data]]
 == Description ==
 <!-- Describe the what the tool does, focusing on it's digital preservation value. Keep it factual. -->
@@ Line 29: / Line 20: @@
 == User Experiences ==
 <!-- Add hotlinks to user experiences with the tool (eg. blog posts). These should illustrate the effectiveness (or otherwise) of the tool. -->
+* [https://www.dpconline.org/handbook/tool-demos/csvvalidator-demo Tool demo with videos] in the [https://www.dpconline.org/handbook DPC Handbook]
+* [https://openpreservation.org/blogs/droid-report-as-basis-for-collection-integrity-checks/ DROID report as basis for collection integrity checks]
 == Development Activity ==
 <!-- Provide *evidence* of development activity of the tool. For example, RSS feeds for code issues or commits. -->
 All development activity is visible on Github: https://github.com/digital-preservation/csv-validator/commits
-<!-- Add the Ohloh.com ID for the tool, if known. -->
+====Release Feed====
-{{Infobox_tool_details
+Below the last 3 release feeds:
-|ohloh_id=
+<rss max=3>https://github.com/digital-preservation/csv-validator/releases.atom</rss>
-}}
 ====Activity Feed====
 Below the last 5 activity feeds:
 <rss max=5>https://github.com/digital-preservation/csv-validator/commits/master.atom</rss>
-.
+<!-- Add the Ohloh.com ID for the tool, if known. -->