I've been asked to provide data to our state government (for reporting purposes) as an xml format file

Could someone suggest a starting point or maybe give me a brief outline on the steps to creating an XML output file?

I could dump this to a text file and hard-code the tags, but it looks like WebFocus should be able to do this without all that extra work.

any hints would be appreciated

Here's what the XML output file should like where the tag contains the data to be extracted :


< !-- The xsi:noNamespaceSchemaLocation and xmlns:xsi attributes in the below header line are optional; they may be used for local validation, but are not required for file submission. -->



B
05153


Buster
Bronco
Richard
Jr
1988-12-12
M


05153
0000002




B
05153


Beaver
Eaton
Tee
III
1967-12-25
M


05153
0000003

This message has been edited. Last edited by: Kerry,

Please post your XML within the code tags .

What is the format of the source data.

Does the state government require a specific XML format.

Yo can use ON TABLE HOLD AS xxx FORMAT XML

While HOLD FORMAT XML doese create an XML document it is a representation of a REPORT and that may not be what you want.

You can create a synonym for an XML structure using (in order of preference) an XSD (XML Schema Definition), DTD or a sample XML document.

Then with DataMigrator you can map to the pre-defined XML structure.

sorry again, I'm trying to get the XML to show up as text

here is the schema we were provided with:

xs:schema>
−
<xs:annotation>
−
<xs:documentation>
Version History: Major Version Collection, Minor Version 1
</xs:documentation>
</xs:annotation>
−
<xs:element name="IHERequestforUICGroup">
−
<xs:complexType>
−
<xs:sequence>
−
<xs:element maxOccurs="unbounded" name="IHERequestforUIC">
−
<xs:complexType>
−
<xs:sequence>
<xs:element minOccurs="1" maxOccurs="1" name="SubmittingEntity" type="SubmittingEntityType"/>
<xs:element minOccurs="1" maxOccurs="1" name="PersonalCore" type="PersonalCoreType"/>
<xs:element minOccurs="1" maxOccurs="1" name="IHEEntityDemographics" type="IHEEntityDemographicsType"/>
<xs:element minOccurs="0" maxOccurs="1" name="PersonalDemographics" type="PersonalDemographicsType"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute fixed="Collection" name="SchemaVersionMajor" type="xs:string" use="required"/>
<xs:attribute fixed="1" name="SchemaVersionMinor" type="xs:string" use="required"/>
<xs:attribute fixed="108" name="CollectionId" type="xs:int" use="required"/>
<xs:attribute fixed="IHERequestforUIC" name="CollectionName" type="xs:string"/>
<xs:attribute name="SubmittingSystemVendor" type="xs:string" use="required"/>
<xs:attribute name="SubmittingSystemName" type="xs:string" use="required"/>
<xs:attribute name="SubmittingSystemVersion" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
−
<xs:complexType name="SubmittingEntityType">
−
<xs:sequence>
<xs:element minOccurs="1" maxOccurs="1" name="SubmittingEntityTypeCode" type="SubmittingEntityTypeCodeType"/>
<xs:element minOccurs="1" maxOccurs="1" name="SubmittingEntityCode" type="SubmittingEntityCodeType"/>
</xs:sequence>
</xs:complexType>
−
<xs:simpleType name="SubmittingEntityTypeCodeType">
−
<xs:restriction base="xs:string">
<xs:enumeration value="A"/>
<xs:enumeration value="B"/>
<xs:enumeration value="D"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="SubmittingEntityCodeType">
−
<xs:restriction base="xs:string">
<xs:minLength value="5"/>
<xs:maxLength value="10"/>
</xs:restriction>
</xs:simpleType>
−
<xs:complexType name="PersonalCoreType">
−
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="1" name="UIC" type="UICType"/>
<xs:element minOccurs="1" maxOccurs="1" name="LastName" type="LastNameType"/>
<xs:element minOccurs="1" maxOccurs="1" name="FirstName" type="FirstNameType"/>
<xs:element minOccurs="0" maxOccurs="1" name="MiddleName" type="MiddleNameType"/>
<xs:element minOccurs="0" maxOccurs="1" name="StudentSuffix" type="StudentSuffixType"/>
<xs:element minOccurs="1" maxOccurs="1" name="DateOfBirth" type="DateOfBirthType"/>
<xs:element minOccurs="0" maxOccurs="1" name="MultipleBirthOrder" type="MultipleBirthOrderType"/>
<xs:element minOccurs="1" maxOccurs="1" name="Gender" type="GenderType"/>
</xs:sequence>
</xs:complexType>
−
<xs:simpleType name="UICType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[0-9]{10,10}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="LastNameType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[A-Za-z'\-.,\s]{1,50}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="FirstNameType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[A-Za-z'\-.,\s]{1,50}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="MiddleNameType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[A-Za-z'\-.,\s]{1,50}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="StudentSuffixType">
−
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:maxLength value="10"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="DateOfBirthType">
−
<xs:restriction base="xs:date">
<xs:minInclusive value="1753-01-01"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="MultipleBirthOrderType">
−
<xs:restriction base="xs:int">
<xs:maxInclusive value="9"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="GenderType">
−
<xs:restriction base="xs:string">
<xs:enumeration value="M"/>
<xs:enumeration value="F"/>
</xs:restriction>
</xs:simpleType>
−
<xs:complexType name="IHEEntityDemographicsType">
−
<xs:sequence>
<xs:element minOccurs="1" maxOccurs="1" name="SchoolFacilityNumber" type="SchoolFacilityNumberType"/>
<xs:element minOccurs="0" maxOccurs="1" name="StudentIdNumber" type="StudentIdNumberType"/>
</xs:sequence>
</xs:complexType>
−
<xs:simpleType name="SchoolFacilityNumberType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[0-9]{5,5}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="StudentIdNumberType">
−
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:maxLength value="20"/>
</xs:restriction>
</xs:simpleType>
−
<xs:complexType name="PersonalDemographicsType">
−
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="1" name="ResidentLEANumber" type="ResidentLEANumberType"/>
<xs:element minOccurs="0" maxOccurs="1" name="StudentResidentCounty" type="StudentResidentCountyType"/>
<xs:element minOccurs="0" maxOccurs="1" name="CountryOfBirth" type="CountryOfBirthType"/>
<xs:element minOccurs="0" maxOccurs="1" name="YearOfEntry" type="YearOfEntryType"/>
<xs:element minOccurs="0" maxOccurs="1" name="StreetAddress" type="StreetAddressType"/>
<xs:element minOccurs="0" maxOccurs="1" name="StreetAddress2" type="StreetAddress2Type"/>
<xs:element minOccurs="0" maxOccurs="1" name="PersonalDemographicsCity" type="PersonalDemographicsCityType"/>
<xs:element minOccurs="0" maxOccurs="1" name="State" type="StateType"/>
<xs:element minOccurs="0" maxOccurs="1" name="ZipCode" type="ZipCodeType"/>
<xs:element minOccurs="1" maxOccurs="1" name="Ethnicity" type="EthnicityType"/>
<xs:element minOccurs="0" maxOccurs="1" name="Phone" type="PhoneType"/>
</xs:sequence>
</xs:complexType>
−
<xs:simpleType name="ResidentLEANumberType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[0-9]{5,5}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="StudentResidentCountyType">
−
<xs:restriction base="xs:string">
<xs:enumeration value="01"/>
<xs:enumeration value="02"/>
<xs:enumeration value="03"/>
<xs:enumeration value="04"/>
<xs:enumeration value="05"/>
<xs:enumeration value="06"/>
<xs:enumeration value="07"/>
<xs:enumeration value="08"/>
<xs:enumeration value="09"/>
<xs:enumeration value="10"/>
<xs:enumeration value="11"/>
<xs:enumeration value="12"/>
<xs:enumeration value="13"/>
<xs:enumeration value="14"/>
<xs:enumeration value="15"/>
<xs:enumeration value="16"/>
<xs:enumeration value="17"/>
<xs:enumeration value="18"/>
<xs:enumeration value="19"/>
<xs:enumeration value="20"/>
<xs:enumeration value="21"/>
<xs:enumeration value="22"/>
<xs:enumeration value="23"/>
<xs:enumeration value="24"/>
<xs:enumeration value="25"/>
<xs:enumeration value="26"/>
<xs:enumeration value="27"/>
<xs:enumeration value="28"/>
<xs:enumeration value="29"/>
<xs:enumeration value="30"/>
<xs:enumeration value="31"/>
<xs:enumeration value="32"/>
<xs:enumeration value="33"/>
<xs:enumeration value="34"/>
<xs:enumeration value="35"/>
<xs:enumeration value="36"/>
<xs:enumeration value="37"/>
<xs:enumeration value="38"/>
<xs:enumeration value="39"/>
<xs:enumeration value="40"/>
<xs:enumeration value="41"/>
<xs:enumeration value="42"/>
<xs:enumeration value="43"/>
<xs:enumeration value="44"/>
<xs:enumeration value="45"/>
<xs:enumeration value="46"/>
<xs:enumeration value="47"/>
<xs:enumeration value="48"/>
<xs:enumeration value="49"/>
<xs:enumeration value="50"/>
<xs:enumeration value="51"/>
<xs:enumeration value="52"/>
<xs:enumeration value="53"/>
<xs:enumeration value="54"/>
<xs:enumeration value="55"/>
<xs:enumeration value="56"/>
<xs:enumeration value="57"/>
<xs:enumeration value="58"/>
<xs:enumeration value="59"/>
<xs:enumeration value="60"/>
<xs:enumeration value="61"/>
<xs:enumeration value="62"/>
<xs:enumeration value="63"/>
<xs:enumeration value="64"/>
<xs:enumeration value="65"/>
<xs:enumeration value="66"/>
<xs:enumeration value="67"/>
<xs:enumeration value="68"/>
<xs:enumeration value="69"/>
<xs:enumeration value="70"/>
<xs:enumeration value="71"/>
<xs:enumeration value="72"/>
<xs:enumeration value="73"/>
<xs:enumeration value="74"/>
<xs:enumeration value="75"/>
<xs:enumeration value="76"/>
<xs:enumeration value="77"/>
<xs:enumeration value="78"/>
<xs:enumeration value="79"/>
<xs:enumeration value="80"/>
<xs:enumeration value="81"/>
<xs:enumeration value="82"/>
<xs:enumeration value="83"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="CountryOfBirthType">
−
<xs:restriction base="xs:string">
<xs:enumeration value="AD"/>
<xs:enumeration value="AE"/>
<xs:enumeration value="AF"/>
<xs:enumeration value="AG"/>
<xs:enumeration value="AI"/>
<xs:enumeration value="AL"/>
<xs:enumeration value="AM"/>
<xs:enumeration value="AN"/>
<xs:enumeration value="AO"/>
<xs:enumeration value="AQ"/>
<xs:enumeration value="AR"/>
<xs:enumeration value="AS"/>
<xs:enumeration value="AT"/>
<xs:enumeration value="AU"/>
<xs:enumeration value="AW"/>
<xs:enumeration value="AX"/>
<xs:enumeration value="AZ"/>
<xs:enumeration value="BA"/>
<xs:enumeration value="BB"/>
<xs:enumeration value="BD"/>
<xs:enumeration value="BE"/>
<xs:enumeration value="BF"/>
<xs:enumeration value="BG"/>
<xs:enumeration value="BH"/>
<xs:enumeration value="BI"/>
<xs:enumeration value="BJ"/>
<xs:enumeration value="BM"/>
<xs:enumeration value="BN"/>
<xs:enumeration value="BO"/>
<xs:enumeration value="BR"/>
<xs:enumeration value="BS"/>
<xs:enumeration value="BT"/>
<xs:enumeration value="BV"/>
<xs:enumeration value="BW"/>
<xs:enumeration value="BY"/>
<xs:enumeration value="BZ"/>
<xs:enumeration value="CA"/>
<xs:enumeration value="CC"/>
<xs:enumeration value="CD"/>
<xs:enumeration value="CD"/>
<xs:enumeration value="CF"/>
<xs:enumeration value="CG"/>
<xs:enumeration value="CH"/>
<xs:enumeration value="CI"/>
<xs:enumeration value="CK"/>
<xs:enumeration value="CL"/>
<xs:enumeration value="CM"/>
<xs:enumeration value="CN"/>
<xs:enumeration value="CO"/>
<xs:enumeration value="CR"/>
<xs:enumeration value="CS"/>
<xs:enumeration value="CU"/>
<xs:enumeration value="CV"/>
<xs:enumeration value="CX"/>
<xs:enumeration value="CY"/>
<xs:enumeration value="CZ"/>
<xs:enumeration value="DE"/>
<xs:enumeration value="DJ"/>
<xs:enumeration value="DK"/>
<xs:enumeration value="DM"/>
<xs:enumeration value="DO"/>
<xs:enumeration value="DZ"/>
<xs:enumeration value="EC"/>
<xs:enumeration value="EE"/>
<xs:enumeration value="EG"/>
<xs:enumeration value="EH"/>
<xs:enumeration value="ER"/>
<xs:enumeration value="ES"/>
<xs:enumeration value="ET"/>
<xs:enumeration value="FI"/>
<xs:enumeration value="FJ"/>
<xs:enumeration value="FK"/>
<xs:enumeration value="FM"/>
<xs:enumeration value="FO"/>
<xs:enumeration value="FR"/>
<xs:enumeration value="GA"/>
<xs:enumeration value="GB"/>
<xs:enumeration value="GD"/>
<xs:enumeration value="GE"/>
<xs:enumeration value="GF"/>
<xs:enumeration value="GG"/>
<xs:enumeration value="GH"/>
<xs:enumeration value="GI"/>
<xs:enumeration value="GL"/>
<xs:enumeration value="GM"/>
<xs:enumeration value="GN"/>
<xs:enumeration value="GP"/>
<xs:enumeration value="GQ"/>
<xs:enumeration value="GR"/>
<xs:enumeration value="GS"/>
<xs:enumeration value="GT"/>
<xs:enumeration value="GU"/>
<xs:enumeration value="GW"/>
<xs:enumeration value="GY"/>
<xs:enumeration value="HK"/>
<xs:enumeration value="HM"/>
<xs:enumeration value="HN"/>
<xs:enumeration value="HR"/>
<xs:enumeration value="HT"/>
<xs:enumeration value="HU"/>
<xs:enumeration value="ID"/>
<xs:enumeration value="IE"/>
<xs:enumeration value="IL"/>
<xs:enumeration value="IM"/>
<xs:enumeration value="IN"/>
<xs:enumeration value="IO"/>
<xs:enumeration value="IQ"/>
<xs:enumeration value="IR"/>
<xs:enumeration value="IS"/>
<xs:enumeration value="IT"/>
<xs:enumeration value="JE"/>
<xs:enumeration value="JM"/>
<xs:enumeration value="JO"/>
<xs:enumeration value="JP"/>
<xs:enumeration value="KE"/>
<xs:enumeration value="KG"/>
<xs:enumeration value="KH"/>
<xs:enumeration value="KI"/>
<xs:enumeration value="KM"/>
<xs:enumeration value="KN"/>
<xs:enumeration value="KP"/>
<xs:enumeration value="KR"/>
<xs:enumeration value="KW"/>
<xs:enumeration value="KY"/>
<xs:enumeration value="KZ"/>
<xs:enumeration value="LA"/>
<xs:enumeration value="LB"/>
<xs:enumeration value="LC"/>
<xs:enumeration value="LI"/>
<xs:enumeration value="LK"/>
<xs:enumeration value="LR"/>
<xs:enumeration value="LS"/>
<xs:enumeration value="LT"/>
<xs:enumeration value="LU"/>
<xs:enumeration value="LV"/>
<xs:enumeration value="LY"/>
<xs:enumeration value="MA"/>
<xs:enumeration value="MC"/>
<xs:enumeration value="MD"/>
<xs:enumeration value="MG"/>
<xs:enumeration value="MH"/>
<xs:enumeration value="MK"/>
<xs:enumeration value="ML"/>
<xs:enumeration value="MM"/>
<xs:enumeration value="MN"/>
<xs:enumeration value="MO"/>
<xs:enumeration value="MP"/>
<xs:enumeration value="MQ"/>
<xs:enumeration value="MR"/>
<xs:enumeration value="MS"/>
<xs:enumeration value="MT"/>
<xs:enumeration value="MU"/>
<xs:enumeration value="MV"/>
<xs:enumeration value="MW"/>
<xs:enumeration value="MX"/>
<xs:enumeration value="MY"/>
<xs:enumeration value="MZ"/>
<xs:enumeration value="NA"/>
<xs:enumeration value="NC"/>
<xs:enumeration value="NE"/>
<xs:enumeration value="NF"/>
<xs:enumeration value="NG"/>
<xs:enumeration value="NI"/>
<xs:enumeration value="NL"/>
<xs:enumeration value="NO"/>
<xs:enumeration value="NP"/>
<xs:enumeration value="NR"/>
<xs:enumeration value="NU"/>
<xs:enumeration value="NZ"/>
<xs:enumeration value="OM"/>
<xs:enumeration value="PA"/>
<xs:enumeration value="PE"/>
<xs:enumeration value="PF"/>
<xs:enumeration value="PG"/>
<xs:enumeration value="PH"/>
<xs:enumeration value="PK"/>
<xs:enumeration value="PL"/>
<xs:enumeration value="PM"/>
<xs:enumeration value="PN"/>
<xs:enumeration value="PR"/>
<xs:enumeration value="PS"/>
<xs:enumeration value="PT"/>
<xs:enumeration value="PW"/>
<xs:enumeration value="PY"/>
<xs:enumeration value="QA"/>
<xs:enumeration value="RE"/>
<xs:enumeration value="RO"/>
<xs:enumeration value="RU"/>
<xs:enumeration value="RW"/>
<xs:enumeration value="SA"/>
<xs:enumeration value="SB"/>
<xs:enumeration value="SC"/>
<xs:enumeration value="SD"/>
<xs:enumeration value="SE"/>
<xs:enumeration value="SG"/>
<xs:enumeration value="SH"/>
<xs:enumeration value="SI"/>
<xs:enumeration value="SJ"/>
<xs:enumeration value="SK"/>
<xs:enumeration value="SL"/>
<xs:enumeration value="SM"/>
<xs:enumeration value="SN"/>
<xs:enumeration value="SO"/>
<xs:enumeration value="SR"/>
<xs:enumeration value="ST"/>
<xs:enumeration value="SV"/>
<xs:enumeration value="SY"/>
<xs:enumeration value="SZ"/>
<xs:enumeration value="TC"/>
<xs:enumeration value="TD"/>
<xs:enumeration value="TF"/>
<xs:enumeration value="TG"/>
<xs:enumeration value="TH"/>
<xs:enumeration value="TJ"/>
<xs:enumeration value="TK"/>
<xs:enumeration value="TL"/>
<xs:enumeration value="TM"/>
<xs:enumeration value="TN"/>
<xs:enumeration value="TO"/>
<xs:enumeration value="TR"/>
<xs:enumeration value="TT"/>
<xs:enumeration value="TV"/>
<xs:enumeration value="TW"/>
<xs:enumeration value="TZ"/>
<xs:enumeration value="UA"/>
<xs:enumeration value="UG"/>
<xs:enumeration value="UM"/>
<xs:enumeration value="US"/>
<xs:enumeration value="UY"/>
<xs:enumeration value="UZ"/>
<xs:enumeration value="VA"/>
<xs:enumeration value="VA"/>
<xs:enumeration value="VC"/>
<xs:enumeration value="VE"/>
<xs:enumeration value="VG"/>
<xs:enumeration value="VI"/>
<xs:enumeration value="VN"/>
<xs:enumeration value="VU"/>
<xs:enumeration value="WF"/>
<xs:enumeration value="WS"/>
<xs:enumeration value="YE"/>
<xs:enumeration value="YT"/>
<xs:enumeration value="ZA"/>
<xs:enumeration value="ZM"/>
<xs:enumeration value="ZW"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="YearOfEntryType">
−
<xs:restriction base="xs:int">
<xs:minInclusive value="1900"/>
<xs:maxInclusive value="2100"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="StreetAddressType">
−
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:maxLength value="100"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="StreetAddress2Type">
−
<xs:restriction base="xs:string">
<xs:minLength value="0"/>
<xs:maxLength value="100"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="PersonalDemographicsCityType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[A-Za-z'\-.,\s0-9]{1,20}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="StateType">
−
<xs:restriction base="xs:string">
<xs:enumeration value="AA"/>
<xs:enumeration value="AE"/>
<xs:enumeration value="AK"/>
<xs:enumeration value="AL"/>
<xs:enumeration value="AP"/>
<xs:enumeration value="AR"/>
<xs:enumeration value="AS"/>
<xs:enumeration value="AZ"/>
<xs:enumeration value="CA"/>
<xs:enumeration value="CO"/>
<xs:enumeration value="CT"/>
<xs:enumeration value="DC"/>
<xs:enumeration value="DE"/>
<xs:enumeration value="FL"/>
<xs:enumeration value="FM"/>
<xs:enumeration value="GA"/>
<xs:enumeration value="GU"/>
<xs:enumeration value="HI"/>
<xs:enumeration value="IA"/>
<xs:enumeration value="ID"/>
<xs:enumeration value="IL"/>
<xs:enumeration value="IN"/>
<xs:enumeration value="KS"/>
<xs:enumeration value="KY"/>
<xs:enumeration value="LA"/>
<xs:enumeration value="MA"/>
<xs:enumeration value="MD"/>
<xs:enumeration value="ME"/>
<xs:enumeration value="MH"/>
<xs:enumeration value="MI"/>
<xs:enumeration value="MN"/>
<xs:enumeration value="MO"/>
<xs:enumeration value="MP"/>
<xs:enumeration value="MS"/>
<xs:enumeration value="MT"/>
<xs:enumeration value="NC"/>
<xs:enumeration value="ND"/>
<xs:enumeration value="NE"/>
<xs:enumeration value="NH"/>
<xs:enumeration value="NJ"/>
<xs:enumeration value="NM"/>
<xs:enumeration value="NV"/>
<xs:enumeration value="NY"/>
<xs:enumeration value="OH"/>
<xs:enumeration value="OK"/>
<xs:enumeration value="OR"/>
<xs:enumeration value="PA"/>
<xs:enumeration value="PR"/>
<xs:enumeration value="PW"/>
<xs:enumeration value="RI"/>
<xs:enumeration value="SC"/>
<xs:enumeration value="SD"/>
<xs:enumeration value="TN"/>
<xs:enumeration value="TX"/>
<xs:enumeration value="UT"/>
<xs:enumeration value="VA"/>
<xs:enumeration value="VI"/>
<xs:enumeration value="VT"/>
<xs:enumeration value="WA"/>
<xs:enumeration value="WI"/>
<xs:enumeration value="WV"/>
<xs:enumeration value="WY"/>
<xs:enumeration value="AB"/>
<xs:enumeration value="BC"/>
<xs:enumeration value="MB"/>
<xs:enumeration value="NB"/>
<xs:enumeration value="NL"/>
<xs:enumeration value="NS"/>
<xs:enumeration value="NT"/>
<xs:enumeration value="NU"/>
<xs:enumeration value="ON"/>
<xs:enumeration value="PE"/>
<xs:enumeration value="QC"/>
<xs:enumeration value="SK"/>
<xs:enumeration value="YT"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="ZipCodeType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[A-Za-z'\-.,\s0-9]{5,10}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="EthnicityType">
−
<xs:restriction base="xs:string">
<xs:pattern value="[0-6]{6,6}"/>
</xs:restriction>
</xs:simpleType>
−
<xs:simpleType name="PhoneType">
−
<xs:restriction base="xs:string">
<xs:minLength value="1"/>
<xs:maxLength value="10"/>
</xs:restriction>
</xs:simpleType>
</xs:schema>
{/code]

and here is an example of what an output file should look like:
[code]
<?xml version="1.0" encoding="utf-8"?>
<!-- The xsi:noNamespaceSchemaLocation and xmlns:xsi attributes in the below header line are optional; they may be used for local validation, but are not required for file submission. -->
<IHERequestforUICGroup SchemaVersionMinor="1" SubmittingSystemVersion="1.0" CollectionName="IHERequestforUIC" SubmittingSystemVendor="Henry Ford Community College" CollectionId="108" SchemaVersionMajor="Collection" SubmittingSystemName="Henry Ford Commuinity College" xsi:noNamespaceSchemaLocation="http://cepi.state.mi.us/msdsxml/IHERequestforUICCollection1.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <IHERequestforUIC>
    <SubmittingEntity>
      <SubmittingEntityTypeCode>B</SubmittingEntityTypeCode>
      <SubmittingEntityCode>05153</SubmittingEntityCode>
    </SubmittingEntity>
    <PersonalCore>
      <LastName>Buster</LastName>
      <FirstName>Bronco</FirstName>
      <MiddleName>Richard</MiddleName>
      <StudentSuffix>Jr</StudentSuffix>
      <DateOfBirth>1988-12-12</DateOfBirth>
      <Gender>M</Gender>
    </PersonalCore>
    <IHEEntityDemographics>
      <SchoolFacilityNumber>05153</SchoolFacilityNumber>
      <StudentIdNumber>0000002</StudentIdNumber>
    </IHEEntityDemographics>
  </IHERequestforUIC>
</IHERequestforUICGroup>

You can produce this format XML document, but it will not be easy.

I have in the past created something similar.

The concept is to build the XML part by part.

For example:

• FILEDEF a collection file (Append).
  
• -WRITE any headers, non repetative
  
• DEFINE/TABLE COMPUTE a string that contains a logical row, like the PersonalCore tag.
  
• SAVE to the collection file.
  
• Process the next logical row.
  
• Make sure any other tags are added at the right time.
  

The actual layout, new lines, etc, are not that important, but if it is needed, then these can be added during the process.

There may be other ways to do this. Perhaps even calling an external function.

Here's a sample of the synonym that you can automatically create from the Data Management Console from the XSD.

With DataMigrator you can use the synonym as a target and create transformations to map to it like any other target type.

[SOLVED]

I think I'm going to take Waz's advice for this project. That strategy was the first thought I had, I just wanted to be sure there wasn't a way to 'automagically' map the data we pull off to the format of the template.

thanks all

What I suggested we do here and it works well, but it is a specific xml format.

I haven't looked closely at your XML and schema files, but you can probably create an XML file containing the data you need (using HOLD FORMAT XML) and transform that into the appropriate format using XSLT.

I haven't done any of the kind in WebFOCUS, but it's possible to write a simple servlet on the application server that you call with a few parameters. That servlet in turn calls a fex to retrieve the XML data (as described above) and combines that with the XSLT sheet into the format you need.

Generating the correct format directly is probably more efficient, but it will probably be cumbersome and inflexible.