Difference between revisions of "CSV Validator"

From COPTR
Jump to navigation Jump to search
(Release 1.0)
 
(7 intermediate revisions by 4 users not shown)
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
 
|purpose=Validation of CSV files against user-defined schema
|image=Csv-validator-started-gui.png
 
 
|homepage=http://digital-preservation.github.io/csv-validator/
 
|homepage=http://digital-preservation.github.io/csv-validator/
 
|license=[http://www.mozilla.org/MPL/2.0/ Mozilla Public Licence version 2.0]
 
|license=[http://www.mozilla.org/MPL/2.0/ Mozilla Public Licence version 2.0]
 
|platforms=Cross platform (Scala 2.10/Java Virtual Machine)
 
|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 ==
 
== Description ==
 
<!-- Describe the what the tool does, focusing on it's digital preservation value. Keep it factual. -->
 
<!-- 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 ==
 
== User Experiences ==
 
<!-- Add hotlinks to user experiences with the tool (eg. blog posts). These should illustrate the effectiveness (or otherwise) of the tool. -->
 
<!-- 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 ==
 
== Development Activity ==
 
<!-- Provide *evidence* of development activity of the tool. For example, RSS feeds for code issues or commits. -->
 
<!-- 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. -->

Latest revision as of 09:53, 2 September 2021



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)




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-01-08 16:16:37
[tag:github.com,2008:Grit::Commit/e09c1aaa0f0138f19d013e19dfd168c007ec1cd3 Merge pull request #484 from digital-preservation/dependabot/maven/jo…]
by sparkhi https://github.com/sparkhi
2024-01-08 00:12:26
[tag:github.com,2008:Grit::Commit/9f0477aec1bd958f81ad9b9444773d6a76f9b529 Bump joda-time:joda-time from 2.12.5 to 2.12.6]
by dependabot https://github.com/dependabot
2024-01-04 17:02:35
[tag:github.com,2008:Grit::Commit/504ff40afc10620140e801653efd8850fbcfad14 Merge pull request #480 from digital-preservation/dependabot/maven/or…]
by sparkhi https://github.com/sparkhi
2024-01-04 15:44:57
[tag:github.com,2008:Grit::Commit/e5fe840475f78e95b5300cf12ebdee31e2d0eef8 Merge pull request #476 from digital-preservation/dependabot/maven/or…]
by sparkhi https://github.com/sparkhi
2024-01-04 15:44:28
[tag:github.com,2008:Grit::Commit/1eca5c77f7248ae1bf8837bb471a641d1db51530 Merge pull request #481 from digital-preservation/dependabot/maven/co…]
by sparkhi https://github.com/sparkhi