xml file transfer

This should cover W3C XML Schema, Relax NG and DTD related problems.
akrils
Posts: 1
Joined: Fri Jan 12, 2018 12:59 pm

xml file transfer

Post by akrils » 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: 6335
Joined: Fri Jul 09, 2004 5:18 pm

Re: xml file transfer

Post by Radu » 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

Post Reply