Shell Programming and Scripting

Can any one please share a unix script for validating the export of a mapping which is in XML format

Any help would be great for me.

Thanks

XML parse and validation is not a shell task, probably not even awk but PERL, C++, JAVA. Look for a bland xml validator first. Then write a simple (sed or awk) reformatter if the data does not have a handy line orientation. I assume the content is a roughly rectangular matrix. Finally, what constitutes a valid mapping?

Yes, the mapping should be a valid one and the naming conventions should should be as per the standard codes. That is basically the script should check the XML file and validate the naming conventions of all the objects in the mapping.

Where are these "naming conventions" defined? Where are "the standard codes" defined?

It is simple enough to check that the XML file is well-formed and valid. It is far more difficult to check that the XML conforms to some schema, i.e. the permitted content of the XML file. For that you need an XML schema, a RelaxNG schema or any other of the various XML schema languages that are available.

Yes, for schema type checking, you need a tool that is XSD capable, and the XSD of the file. JAVA and C++ parsers can take the XSD optionally and check XML streams as they flow and xml complete object once they arrive, but it slows processing, so we didn't! We did our own, limited checking, enough to ensure things were stable.

XSD just says the container and payload are legal, but to validate it against most business data rules is outside that: uniqueness, external relational and cross field edits, inter-record dependencies, etc.