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:

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
2023-12-01 17:00:46: [tag:github.com,2008:Repository/9081590/1.3.0-RC2 1.3.0-RC2]; by sparkhi

Activity Feed[edit]

Below the last 5 activity feeds:

2024-11-21 12:13:38: [tag:github.com,2008:Grit::Commit/57fbb70b4e0f94d951f15bc8d487ffb7944d2891 Merge pull request #513 from digital-preservation/DR2-1969-assisted-f…]; by MancunianSam https://github.com/MancunianSam
2024-11-15 12:05:54: [tag:github.com,2008:Grit::Commit/95c357171832ff3af823812d001e07dec345ba07 Make the input fields lazy]; by MancunianSam https://github.com/MancunianSam
2024-11-15 09:50:18: [tag:github.com,2008:Grit::Commit/cfddda2a1fee5401d7559617f2cf0528db90cf6e Test on java21]; by MancunianSam https://github.com/MancunianSam
2024-11-15 09:47:28: [tag:github.com,2008:Grit::Commit/f7ea3b713deedc196a7b72ca050b71f221346b34 Replace 8 with 11]; by MancunianSam https://github.com/MancunianSam
2024-11-15 09:43:42: [tag:github.com,2008:Grit::Commit/dbf10a60e283a029152dfa7bc285a6031f222e44 Remove java 8 from tests]; 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. -->
-Full details of development can be seen in the GitHub repository https://github.com/digital-preservation/csv-validator/releases
+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.
-{{Infobox_tool_details
+====Release Feed====
-|ohloh_id=
+Below the last 3 release feeds:
-}}
+<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. -->