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

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

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

User Experiences

Development Activity

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

Release Feed

Below the last 3 release feeds:

2025-10-02 12:12:57: [tag:github.com,2008:Repository/9081590/1.4.1 1.4.1]; by MancunianSam
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

Activity Feed

Below the last 5 activity feeds:

2025-12-04 11:58:26: [tag:github.com,2008:Grit::Commit/00938f5faa43be8169670b7a2e27bc621a602876 Merge pull request #619 from digital-preservation/dependabot/maven/or…]; by MancunianSam https://github.com/MancunianSam
2025-12-04 11:52:17: [tag:github.com,2008:Grit::Commit/e82cbd53d8b69f8705e26ff576dc102893e07b19 Merge pull request #610 from digital-preservation/dependabot/maven/io…]; by MancunianSam https://github.com/MancunianSam
2025-12-04 11:52:11: [tag:github.com,2008:Grit::Commit/a6b372d3d16f1c57879e83505a3eaad40ee36852 Merge pull request #611 from digital-preservation/dependabot/maven/sp…]; by MancunianSam https://github.com/MancunianSam
2025-12-04 11:52:06: [tag:github.com,2008:Grit::Commit/64f3b8ed8b5ccd0a75ba19ef0289e61b6bbbee04 Merge pull request #612 from digital-preservation/dependabot/maven/co…]; by MancunianSam https://github.com/MancunianSam
2025-12-04 11:52:01: [tag:github.com,2008:Grit::Commit/5e57104d44a63c4952e90a708821b23d60bec786 Merge pull request #613 from digital-preservation/dependabot/maven/or…]; by MancunianSam https://github.com/MancunianSam

@@ 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. -->
-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 [http://digital-preservation.github.io/csv-schema/csv-schema-1.0.html CSV Schema Language version 1.0], released simultaneously.  Further information in [http://blog.nationalarchives.gov.uk/blog/csv-validator-new-digital-preservation-tool/ post on The National Archives blog]
+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 [http://digital-preservation.github.io/csv-schema/csv-schema-1.0.html CSV Schema Language version 1.0], released simultaneously.  Further information in [http://blog.nationalarchives.gov.uk/blog/csv-validator-new-digital-preservation-tool/ post on The National Archives blog].
+[[http://digital-preservation.github.io/csv-schema/csv-schema-1.1.html CSV Schema Language version 1.1] was released on 25 January 2016, alongside [http://digital-preservation.github.io/csv-validator/ CSV Validator 1.1].
+====Download====
+You can download CSV Validator under https://github.com/digital-preservation/csv-validator/releases.
 == 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. -->