xml file transfer

This should cover W3C XML Schema, Relax NG and DTD related problems.
akrils
Posts: 1

xml file transfer

Fri Jan 12, 2018 2:21 pm

Could please someone help me to create xsl file for transforming xml file format created with FileMaker:

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!-- This grammar has been deprecated - use FMPXMLRESULT instead -->
-<FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult">
<ERRORCODE>0</ERRORCODE>
<DATABASE>horizon.fmp12</DATABASE>
<LAYOUT/>
-<ROW RECORDID="3" MODID="5">
<Epasts>name@domain.xx</Epasts>
<IenakumaVeids>1011</IenakumaVeids>
<IenakumuPeriodsLidz>2017-01-31</IenakumuPeriodsLidz>
<IenakumuPeriodsNo>2016-01-01</IenakumuPeriodsNo>
<Ienemumi>3000.26</Ienemumi>
<IesniegsanasVeids>1</IesniegsanasVeids>
<Izdevumi>0.00</Izdevumi>
<IzmaksasDatums>2017-06-22</IzmaksasDatums>
<IzmaksasMenesis>6</IzmaksasMenesis>
<NeapliekamieIenakumi>0.00</NeapliekamieIenakumi>
<NmrKods>11111111111</NmrKods>
<Nodoklis>300.83</Nodoklis>
<ParskGads>2017</ParskGads>
<ParskMen>6</ParskMen>
<PersonasKods>22222222222</PersonasKods>
<Sagatavotajs>Name Surname</Sagatavotajs>
<Talrunis>44444444</Talrunis>
<VardsUzvards>Name1 Surname1</VardsUzvards>
</ROW>
-<ROW RECORDID="4" MODID="7">
<Epasts>name@domain.xx</Epasts>
<IenakumaVeids>1011</IenakumaVeids>
<IenakumuPeriodsLidz>2017-01-31</IenakumuPeriodsLidz>
<IenakumuPeriodsNo>2016-01-01</IenakumuPeriodsNo>
<Ienemumi>3000.29</Ienemumi>
<IesniegsanasVeids>1</IesniegsanasVeids>
<Izdevumi>0.00</Izdevumi>
<IzmaksasDatums>2017-06-22</IzmaksasDatums>
<IzmaksasMenesis>6</IzmaksasMenesis>
<NeapliekamieIenakumi>0.00</NeapliekamieIenakumi>
<NmrKods>11111111111</NmrKods>
<Nodoklis>300.73</Nodoklis>
<ParskGads>2017</ParskGads>
<ParskMen>6</ParskMen>
<PersonasKods>33333333333</PersonasKods>
<Sagatavotajs>Name Surname</Sagatavotajs>
<Talrunis>44444444</Talrunis>
<VardsUzvards>Name2 Surname2</VardsUzvards>
</ROW>
</FMPDSORESULT>


to file format:

Code: Select all

<?xml version="1.0" encoding="WINDOWS-1257"?>
-<DokPFPISKv2 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<ParskGads>2017</ParskGads>
<ParskMen>6</ParskMen>
<NmrKods>11111111111</NmrKods>
<IesniegsanasVeids>1</IesniegsanasVeids>
<Epasts>name@domain.xx</Epasts>
<Talrunis>44444444</Talrunis>
<Sagatavotajs>Name Surname</Sagatavotajs>
-<Tab>
-<R>
<PersonasKods>22222222222</PersonasKods>
<VardsUzvards>Name1 Surname1</VardsUzvards>
<IenakumaVeids>1011</IenakumaVeids>
<IenakumuPeriodsNo>2016-01-01</IenakumuPeriodsNo>
<IenakumuPeriodsLidz>2017-01-31</IenakumuPeriodsLidz>
<IzmaksasDatums>2017-06-22</IzmaksasDatums>
<IzmaksasMenesis>6</IzmaksasMenesis>
<Ienemumi>3000.26</Ienemumi>
<NeapliekamieIenakumi>0.00</NeapliekamieIenakumi>
<Izdevumi>0.00</Izdevumi>
<Nodoklis>300.83</Nodoklis>
</R>
-<R>
<PersonasKods>33333333333</PersonasKods>
<VardsUzvards>Name3 Surname3</VardsUzvards>
<IenakumaVeids>1011</IenakumaVeids>
<IenakumuPeriodsNo>2016-01-01</IenakumuPeriodsNo>
<IenakumuPeriodsLidz>2017-01-31</IenakumuPeriodsLidz>
<IzmaksasDatums>2017-06-22</IzmaksasDatums>
<IzmaksasMenesis>6</IzmaksasMenesis>
<Ienemumi>3000.29</Ienemumi>
<NeapliekamieIenakumi>0.00</NeapliekamieIenakumi>
<Izdevumi>0.00</Izdevumi>
<Nodoklis>300.73</Nodoklis>
</R>
</Tab>
</DokPFPISKv2>


Thanks a lot!
Radu
Posts: 5376

Re: xml file transfer

Fri Jan 12, 2018 2:30 pm

Hi,

This is a forum mostly for reporting problems related to Oxygen XML Editor.
For generic XSLT processing questions like yours you can write for example on StackOverflow.
You can also search for an XSLT tutorial online and try to build your own XSLT.

Regards,
Radu
Radu Coravu
<oXygen/> XML Editor
http://www.oxygenxml.com

Return to “XML Schemas”

Who is online

Users browsing this forum: No registered users and 0 guests