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-09 10:30:50: [tag:github.com,2008:Grit::Commit/51008d974d0b6a7b7ef2d8875b8088d86c1d589d Merge pull request #624 from digital-preservation/manual-version-bump]; by sparkhi https://github.com/sparkhi
2025-12-09 10:20:43: [tag:github.com,2008:Grit::Commit/3b4842eaf41a3ebc43fb5bbba3e8029cb45a20e5 Manual version number update as 1.4.1 is already released]; by sparkhi https://github.com/sparkhi
2025-12-09 10:17:04: [tag:github.com,2008:Grit::Commit/f608dd7d19a37bb04a7b7be22777762a5306178a Merge pull request #623 from marmoure/bugfix/expose-ValidatorBuilder]; by sparkhi https://github.com/sparkhi
2025-12-08 14:28:40: [tag:github.com,2008:Grit::Commit/fff50f4ee0007b1fc915f19d99b10f11de094130 [bugfix] expose `ValidatorBuilder` class outside the package.]; by marmoure https://github.com/marmoure
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

@@ 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====
@@ Line 27: / 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. -->