Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries [Thread Prev] >Thread Next - Re: Modifying Format/Structure of XML File Modifying Format/Structure of XML FileTo: NULL Date: 2/28/2006 6:56:00 PM I have data in Access 2003 that I want to import into another application.
The application requires a specific format to import XML files. Below are
two samples. The first shows the XML file that I get when I export from
Access. The second shows the format I need. What is the correct term for
making such a change and what tool should I use?
Access Format:
<JV_DOC_HDR>
<DOC_CD><JVA></DOC_CD>
<DOC_DEPT_CD><005></DOC_DEPT_CD>
<DOC_ID><OW01453963005></DOC_ID>
<DOC_VERS_NO><1></DOC_VERS_NO>
</JV_DOC_HDR>
<JV_DOC_LNGRP>
<DOC_CD><JVA></DOC_CD>
<DOC_DEPT_CD><005></DOC_DEPT_CD>
<DOC_ID><OW01453963005></DOC_ID>
<DOC_VERS_NO><1></DOC_VERS_NO>
<DOC_LNGRP_NO><24138607></DOC_LNGRP_NO>
</JV_DOC_LNGRP>
<JV_DOC_ACTG>
<DOC_CD><JVA></DOC_CD>
<DOC_DEPT_CD><005></DOC_DEPT_CD>
<DOC_ID><OW01453963005></DOC_ID>
<DOC_VERS_NO><1></DOC_VERS_NO>
<DOC_ACTG_NO><24138608></DOC_ACTG_NO>
<DOC_ACTG_LN_NO><1></DOC_ACTG_LN_NO>
<DOC_LNGRP_NO><24138607></DOC_LNGRP_NO>
<FUND_CD><0123></FUND_CD>
<DEPT_CD><005></DEPT_CD>
<ACTG_LN_DSCR><OUTDATED WARRANT WARRANT NUMBER = 01453963 ISSUE
DATE = 06222005></ACTG_LN_DSCR>
</JV_DOC_ACTG>
<JV_DOC_ACTG>
<DOC_CD><JVA></DOC_CD>
<DOC_DEPT_CD><005></DOC_DEPT_CD>
<DOC_ID><OW01453963005></DOC_ID>
<DOC_VERS_NO><1></DOC_VERS_NO>
<DOC_ACTG_NO><24138609></DOC_ACTG_NO>
<DOC_ACTG_LN_NO><2></DOC_ACTG_LN_NO>
<DOC_LNGRP_NO><24138607></DOC_LNGRP_NO>
<FUND_CD><0123></FUND_CD>
<DEPT_CD><005></DEPT_CD>
<ACTG_LN_DSCR><OUTDATED WARRANT WARRANT NUMBER = 01453963 ISSUE
DATE = 06222005></ACTG_LN_DSCR>
</JV_DOC_ACTG>
Format Needed:
<AMS_DOCUMENT DOC_CAT="JV" DOC_TYP="JV" DOC_CD="JVA" DOC_DEPT_CD="005"
DOC_UNIT_CD="null" DOC_ID="OW01453963005" DOC_VERS_NO="1"
AUTO_DOC_NUM="false" DOC_IMPORT_MODE="OE">
<JV_DOC_HDR AMSDataObject="Y">
<DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
<DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
<DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
<DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
</JV_DOC_HDR>
<JV_DOC_LNGRP AMSDataObject="Y">
<DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
<DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
<DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
<DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
<DOC_LNGRP_NO Attribute="Y"><![CDATA[24138607]]></DOC_LNGRP_NO>
</JV_DOC_LNGRP>
<JV_DOC_ACTG AMSDataObject="Y">
<DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
<DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
<DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
<DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
<DOC_ACTG_NO Attribute="Y"><![CDATA[24138608]]></DOC_ACTG_NO>
<DOC_ACTG_LN_NO Attribute="Y"><![CDATA[1]]></DOC_ACTG_LN_NO>
<DOC_LNGRP_NO Attribute="Y"><![CDATA[24138607]]></DOC_LNGRP_NO>
<FUND_CD Attribute="Y"><![CDATA[0123]]></FUND_CD>
<DEPT_CD Attribute="Y"><![CDATA[005]]></DEPT_CD>
<ACTG_LN_DSCR Attribute="Y"><![CDATA[OUTDATED WARRANT WARRANT
NUMBER = 01453963 ISSUE DATE = 06222005]]></ACTG_LN_DSCR>
</JV_DOC_ACTG>
<JV_DOC_ACTG AMSDataObject="Y">
<DOC_CD Attribute="Y"><![CDATA[JVA]]></DOC_CD>
<DOC_DEPT_CD Attribute="Y"><![CDATA[005]]></DOC_DEPT_CD>
<DOC_ID Attribute="Y"><![CDATA[OW01453963005]]></DOC_ID>
<DOC_VERS_NO Attribute="Y"><![CDATA[1]]></DOC_VERS_NO>
<DOC_ACTG_NO Attribute="Y"><![CDATA[24138609]]></DOC_ACTG_NO>
<DOC_ACTG_LN_NO Attribute="Y"><![CDATA[2]]></DOC_ACTG_LN_NO>
<DOC_LNGRP_NO Attribute="Y"><![CDATA[24138607]]></DOC_LNGRP_NO>
<FUND_CD Attribute="Y"><![CDATA[0123]]></FUND_CD>
<DEPT_CD Attribute="Y"><![CDATA[005]]></DEPT_CD>
<ACTG_LN_DSCR Attribute="Y"><![CDATA[OUTDATED WARRANT WARRANT
NUMBER = 01453963 ISSUE DATE = 06222005]]></ACTG_LN_DSCR>
</JV_DOC_ACTG>
</AMS_DOCUMENT>
| ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
