180 likes | 220 Views
XML Translation. 2010 RCRAInfo National Users Conference. Joe Carioti EPA – Headquarters Office of Resource Conservation and Recovery ---------------------------------------------------------- Dwane Young EPA – Headquarters Office of Resource Conservation and Recovery. What is XML?.
E N D
XML Translation 2010 RCRAInfo National Users Conference
Joe CariotiEPA – HeadquartersOffice of Resource Conservation and Recovery----------------------------------------------------------Dwane YoungEPA – HeadquartersOffice of Resource Conservation and Recovery
What is XML? • XML stands for Extensible Markup Language • Having metadata and actual data together • By looking at the document (file), the data has meaning • Allows multiple applications to use the data • Allows for platform independence
XML Terms • Attribute: A part of an element that provides additional information about that element • Child: An XML element that is contained within another element • Element: An XML element is the central building block of any XML document • Nesting: Placing one element inside another • Parent: An XML element that contains another element
XML Terms (cont.) • Tag: The markup characters that indicate the start or end of an element - but not the element content itself • Valid: An XML document that is verified correct against a DTD or schema • Well-formed: An XML document that follows the rules set forth by the XML specification, including having an XML declaration, correct comments, all tags are closed, all attributes are quoted, every document has one "container" element
Relation to Hierarchical • Draw on board
Why is RCRAInfo using XML? • There are various systems that provide data to RCRAInfo or want data from RCRAInfo • Having a standard language allows RCRAInfo to complete its business • Others are able to complete their business with the same dataset
How is XML Used by RCRAInfo? • RCRAInfo accepts data submissions in an XML format • RCRAInfo is looking into publishing data in an XML format
Excel to XML Demo • Use Excel to produce XML
Benefits to Using XML • Designed for automation • Not necessarily impacted by changes to the RCRAInfo data structure • Don’t have to include all of the data elements (leave out what you don’t use) • Only have to include ‘Primary Key’ information once, it is inherited for all of the child tables • Data are self-describable
How to Send XML to RCRAInfo • Use the Exchange Network (EN) • A set of web services used to transport data or metadata in an XML format • EN Operations Authenticate Submit Download Query Solicit GetStatus
RCRAInfo CDX Flow XML Data Flow
EN RCRA Submit • Submit RCRA data via CDX • Type of node or node client used is irrelevant • Status codes of submit (What do they mean?) • Received • Pending • Complete • Failed • Receiving Error Reports (automatic email notifications) • Failed status, what really failed • Schema failure • Fail RCRAInfo edit checks
Demo Submittal • Demonstrate the submittal of an XML file via an Exchange Network Client
Generating XML • Programmatic approach • Tool approach • Notepad
For More Informaiton • RCRAInfo Exchange Network Site: http://www.exchangenetwork.net/exchanges/waste/rcra.htm • RCRAInfo Exchange Network Wiki: http://www.exchangenetworkwiki.com/wiki/index.php/RCRAInfo