E N D
1. DoD Per Diem Rates with XML Schema
2. Demo Goals Convert ASCII files to XML instances
Generate XML Schema based on one instance
Refine XML Schema by adding types
Validate instances against XML Schema
Use XSLT to convert XML to HTML for display (server-side and client-side)
3. DoD Per Diem Rates Tables Available as semi-colon delimited ASCII files
Connow.txt - Includes Military Installations; 1136 entries
Conusnm.txt - No Military Installations; 690 entries
Conusmil.txt - Military Installations only; 446 entries
4. Semi-Colon Delimited ASCII
5. Convert ASCII Files to XML Instances XML Spy reads delimited files and lets you assign element names
7. Generate XML Schema Based on single XML instance
Uses enumerations to constrain numbers
Other two instances fail to validate with this generated schema
Could prevent the enumerated constraints
12. Refine XML Schema Consider all 3 XML instances, looking at range of data
Define data types
Date formats (not same as xsd:date)
Restricted integer ranges
Discovered 4 irregularities in per diem data
3 counties missing (one file had delimiters, one did not)
1 rate (out of 1136 times 4) contained decimal value; all others were integers
14. Irregular Data – Missing County
15. Use XSLT to Display as HTML
16. XSLT with Sort by Rate
17. Next Steps [Pending GSA Direction] Contact DoD about data irregularities
Make element names ISO/IEC 11179-compliant
Contribute to Registry
Consider creating Web services to
Retrieve entire table
Retrieve one entry based on location