Sponsored Content
Top Forums Shell Programming and Scripting How to: Validate a CSV file using an XSD? Post 302527961 by luinzi on Monday 6th of June 2011 06:33:38 AM
Old 06-06-2011
How to: Validate a CSV file using an XSD?

Hi All,

I was wondering if there is a utility/perl library/way of validating the contents of a CSV file using an XSD.

i.e. Customer csv (including Header & Trailer)

Cust_num, Cust_nme, Cust_typ, Cust_act_dte, Cust_loc,
101,Joe's Pizza,Retail,10121979,Detroit,
102,Sony Corp,Commercial,10101946,Tokyo,
103,K-CO Foods,Wholesale,01041987,London,
3

The XSD to validate against would contain:

<xs:element name="Cust_num," type="xsSmilieositiveInteger"/>
<xs:element name="Cust_nme" type="xs:string" minOccurs="0"/>
<xs:element name="Cust_typ" type="xs:string" minOccurs="0"/>
<xs:element name="Cust_act_dte" type="xs:date" />

Please let us have your thoughts?

Many Thanks

Luinzi
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

validate csv file load

Hi All, I am using sqlldr to load my csv files into the database. The code in the sh script is as follows. sqlldr ${DBUSER}/${DBPASS}@${ORACLE_SID} \ data=myCSV.data \ bad=myCSV.bad \ control=myCSV.ctl \ ... (0 Replies)
Discussion started by: rahulrathod
0 Replies

2. Shell Programming and Scripting

How to validate a CSV file?

Hi. I think some people have already asked this, but the answers/questions seem to be about validating the contents inside a CSV file. I am simply after a simple variable solution (ie 0 = false, 1 = true) that I can use in my script to say that file so-and-so is actually a CSV file, or in some... (4 Replies)
Discussion started by: ElCaito
4 Replies

3. Shell Programming and Scripting

XMLLINT COMMAND IN UNIX TO VALIDATE XML AGAINST XSD

Hi i am baby to unix shell script. how do i validate xml agaist xsd and transforms xml using xslt. Thanks Mohan (2 Replies)
Discussion started by: mohan.cheepu
2 Replies

4. Shell Programming and Scripting

Help required converting XSD to XML file in PERL

Hi, Please find below the xsd. <?xml version="1.0" encoding="ISO-8859-1" ?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="fruitorder"> <xs:complexType> <xs:sequence> <xs:element name="orderperson"... (2 Replies)
Discussion started by: vanitham
2 Replies

5. Shell Programming and Scripting

Validate xml agaist xsd is ksh

how do i validate xml agaist xsd is ksh? (1 Reply)
Discussion started by: LiorAmitai
1 Replies

6. Programming

problem with xsd file creation

Hi every one, I am new to xml data files,I have two xml files with same data but only small difference as shown below <List> <number>1101</number> <Area>inner walls in a room.</Area> <Detection>less pressure.</Detection> <reason> <normal> <Component Num="15"... (1 Reply)
Discussion started by: veerubiji
1 Replies

7. Shell Programming and Scripting

Validating XML file using XSD in UNIX

Hi, I have a xml file and a xsd file(xml schema file). Here using unix script i wanted to validate the xml file by referring to xsd file. The validation is in terms of Datatype,Field length and null values. If the data present in the xml file is not matching in terms of datatype,field length... (3 Replies)
Discussion started by: shree11
3 Replies

8. Shell Programming and Scripting

Script to ingest a csv, validate data and insert into Oracle

Hi all i would appreciate your help... I am looking for a set of unix commands which i can use to 1) ingest a csv file with a known format 2) validate the filename 3) validate the data/datatypes 4) Insert into an oracle db Can you help get me started? yogz888 (1 Reply)
Discussion started by: yogz888
1 Replies

9. UNIX for Beginners Questions & Answers

Validate csv file

Hi guys, i want to validate the no.of colums in a csv file ,but if there is a comma(,) in any of the data values it should skip and count only valid (,) commas. e.g 1.abc,pqrs,1234,567,hhh result :4 2.abc,pqrs,1234,567,hhh,"in,valid",end12 result:6 here script should skip the comma inside... (10 Replies)
Discussion started by: harry123
10 Replies

10. Shell Programming and Scripting

Script to validate header in a csv file

Hi All; I am struggling to write a script that validates file header. Header file would be like below with TAB separated TRX # TYPE REF # Source Piece Code Destination Piece Code every time I need to check the txt file if the header was same as above fields if validation success... (6 Replies)
Discussion started by: heye18
6 Replies
SOAP::WSDL::XSD::Typelib::SimpleType(3pm)		User Contributed Perl Documentation		 SOAP::WSDL::XSD::Typelib::SimpleType(3pm)

NAME
SOAP::WSDL::XSD::Typelib::SimpleType - simpleType base class DESCRIPTION
This module implements a base class for designing simple type classes modelling XML Schema simpleType definitions. SYNOPSIS
# example simpleType derived by restriction # XSD would be: # <simpleType name="MySimpleType"> # <restriction base="xsd:string" /> # </simpleType> package MySimpleType; use Class::Std::Fast::Storable constructor => 'none'; # restriction base implemented via inheritance use SOAP::WSDL::XSD::Typelib::Builtin; use SOAP::WSDL::XSD::Typelib::SimpleType; use base qw( # derive by restriction 'SOAP::WSDL::XSD::Typelib::SimpleType::restriction', # restriction base 'SOAP::WSDL::XSD::Typelib::Builtin::string' ); # example simpleType derived by list. # XSD would be: # <simpleType name="MySimpleListType"> # <list itemTipe="xsd:string" /> # </simpleType> package MySimpleListType; use Class::Std::Fast::Storable constructor => 'none'; # restriction base implemented via inheritance use SOAP::WSDL::XSD::Typelib::Builtin; use base ('SOAP::WSDL::XSD::Typelib::SimpleType', 'SOAP::WSDL::XSD::Typelib::Builtin::list', # derive by list 'SOAP::WSDL::XSD::Typelib::Builtin::string' # list itemType ); How to write your own simple type Writing a simple type class is easy - all you have to do is setting up the base classes correctly. The following rules apply: o simpleType derived via list simpleType classes derived via list must inherit from these classes in exactly this order: SOAP::WSDL::XSD::Typelib::SimpleType SOAP::WSDL::XSD::Typelib::Builtin::list # derive by list The::List::ItemType::Class # list itemType The::List::ItemType::Class can either be a builtin class (see SOAP::WSDL::XSD::Builtin) or another simpleType class (any other class implementing the right methods is supported too, but not for the faint of heart). o simpleType derived via restriction simpleType classes derived via restriction must inherit from these classes in exactly this order: SOAP::WSDL::XSD::Typelib::SimpleType # you may leave this out SOAP::WSDL::XSD::Typelib::SimpleType::restriction # derive by restriction The::Restriction::Base::Class # restriction base The::Restriction::Base::Class can either be a builtin class (see SOAP::WSDL::XSD::Builtin) or another simpleType class. The slight inconsistency between the these variants is caused by the restriction element, which has different meanings for simpleType and complexType definitions. BUGS AND LIMITATIONS
o Thread safety SOAP::WSDL::XSD::Typelib::SimpleType uses Class::Std::Fast::Storable which uses Class::Std. Class::Std is not thread safe, so SOAP::WSDL::XSD::Typelib::SimpleType is neither. o union union simple types are not supported yet. o XML Schema facets No facets are implemented yet. LICENSE AND COPYRIGHT
Copyright 2004-2007 Martin Kutter. This file is part of SOAP-WSDL. You may distribute/modify it under the same terms as perl itself AUTHOR
Martin Kutter <martin.kutter fen-net.de> REPOSITORY INFORMATION
$Rev: 851 $ $LastChangedBy: kutterma $ $Id: SimpleType.pm 851 2009-05-15 22:45:18Z kutterma $ $HeadURL: https://soap-wsdl.svn.sourceforge.net/svnroot/soap-wsdl/SOAP-WSDL/trunk/lib/SOAP/WSDL/XSD/Typelib/SimpleType.pm $ perl v5.10.1 2010-12-21 SOAP::WSDL::XSD::Typelib::SimpleType(3pm)
All times are GMT -4. The time now is 06:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy