I have no idea where to start but someone mentioned that I could convert an xml file to a csv file using an xslt.
This is a sample of my xml file
Transactions will have different names. The xml file needs to be exported in the format see below
<transaction name="build">
<WizardInitialize templateName="PlPre"/>
<GetNextWizardDialog templateName="PlPre" forward="true"/>
<SelectPositions templateName="PlPre" currentDialog="wiz_PlPreSc
gp" hierarchy="PROD" dimension="SCGP">
<position dimension="SCGP" name="10"/>
<position dimension="SCGP" name="11"/>
<position dimension="SCGP" name="12"/>
</SelectPositions>
<SelectPositions templateName="PlPre" currentDialog="wiz_PLclss"
hierarchy="CLND" dimension="YEAR">
<position dimension="YEAR" name="YEAR2008"/>
</SelectPositions>
<WizardFinish templateName="PlPre"/>
</transaction>
EXPORT FORMAT
The first tag the name is used in STARTTXN and ENDTXN all tags in between have a SUBTXN
I have no idea where to start. I'm using xmlspy.
STARTTXN,BUILD
SUBTXN,<WizardInitialize templateName="PlPre"/>
SUBTXN,<GetNextWizardDialo
g templateName="PlPre" forward="true"/>
SUBTXN,<SelectPositions templateName="PlPre" currentDialog="wiz_PlPreSc
gp" hierarchy="PROD" dimension="SCGP">
SUBTXN,<position dimension="SCGP" name="10"/>
SUBTXN,<position dimension="SCGP" name="11"/>
SUBTXN,<position dimension="SCGP" name="12"/>
SUBTXN,</SelectPositions>
SUBTXN,<SelectPositions templateName="PlPre" currentDialog="wiz_PLclss"
hierarchy="CLND" dimension="YEAR">
SUBTXN,<position dimension="YEAR" name="YEAR2008"/>
SUBTXN,</SelectPositions>
SUBTXN,<WizardFinish templateName="PlPre"/>
ENDTXN,BUILD
Start Free Trial