[ 
https://issues.apache.org/jira/browse/CSV-109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16577481#comment-16577481
 ] 

lbruun commented on CSV-109:
----------------------------

Microsoft's 
[Schema.ini|http://msdn.microsoft.com/en-us/library/ms709353(v=vs.85).aspx] has 
some of the same goals as the W3's ["Model for Tabular Data and 
Metadata"|https://www.w3.org/TR/tabular-data-model/] which is tracked in 
CSV-230. Not to dismiss someone else's need but I would rather that the project 
prioritized implementing support for the W3 standard (which is open, global, 
non-proprietary) rather than Microsoft's attempt. However, truth be told, 
Microsoft's Schema.ini predates the W3 standardization by many years so at the 
time when this ticket was opened I would have voted for it. :)  (the W3 
standard wasn't finalized until 2016 I think)

> Support external CSV schema definition
> --------------------------------------
>
>                 Key: CSV-109
>                 URL: https://issues.apache.org/jira/browse/CSV-109
>             Project: Commons CSV
>          Issue Type: Wish
>          Components: Parser
>    Affects Versions: 1.0
>            Reporter: Jay Zylstra
>            Priority: Minor
>             Fix For: Patch Needed, 1.x
>
>
> As XML has XSD, so CSV needs an external schema definition file which defines 
> the schema of the flat file format and the values it contains.  
> Programmatically adding constraints, as supported by 
> {{org.supercsv.cellprocessor.constraint.StrRegEx}}, are useful but not 
> portable.  Fortunately, Microsoft has already created such a CSV schema 
> definition file format called 
> [Schema.ini|http://msdn.microsoft.com/en-us/library/ms709353(v=vs.85).aspx].
> It is my suggestion to add file and data parsing validation to Apache Commons 
> CSV by adopting support for _Schema.ini_, bringing this long overdue 
> functionality to the Java world.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to