Skip to Content
0
Former Member
Oct 03, 2005 at 08:43 AM

Problem with File Content Converion at the Receiver Side

40 Views

Hello

I have an xml file which is in this format.

<?xml version="1.0" encoding="UTF-8"?>

<ns0:OUTPUT_ITALY_FORMAT_TYPE xmlns:ns0="urn:sli-payment-files:prototype">

<FEBRITRH>

<Filler/>

<RH/>

<ABI_Code/>

<SIA_Code>65318</SIA_Code>

<Creation_Date/>

<File_Identifier/>

<Filler1/>

<Application_Center/>

</FEBRITRH>

<FEBRIT61>

<Filler/>

<SixtyOne/>

<Accnt_Number>0000001</Accnt_Number>

<Filler1/>

<Blank/>

<Number/>

<Description/>

<Accnt_Code/>

<Bank_DIgit/>

<ABI_Code>06230</ABI_Code>

<Bank_Number>01653</Bank_Number>

<Bank_accnt>000043185249</Bank_accnt>

<Currency_code>EUR</Currency_code>

<Accnt_date>030204</Accnt_date>

<Constant/>

<Amnt/>

<Filler2/>

<FEBRIT62>

<Filler/>

<Constant/>

<Accnt_number>0000001</Accnt_number>

<Record_number>1</Record_number>

<Value_date>040204</Value_date>

<Posting_Date>030204</Posting_Date>

<Constant1>C</Constant1>

<Amnt>0000000000471.58</Amnt>

<Transaction_Code>Z2</Transaction_Code>

<Bank_Code>Z1</Bank_Code>

<Blank/>

<Reference_Number>2535394</Reference_Number>

<Reference>86</Reference>

<Additional_reference>VERS.ASS.IST./SU PIAZZA/CIRCOLARI/</Additional_reference>

</FEBRIT62>

<FEBRIT63>

<Filler/>

<Constant/>

<Accnt_Number/>

<Record_Number/>

<Text>POSTALI/TURIST</Text>

</FEBRIT63>

</FEBRIT61>

<FEBRIT64>

<Filler/>

<Constant/>

<Accnt_Number/>

<Currency_code/>

<Accntg_Date/>

<Constant1>C</Constant1>

<Amnt>0000000000471.58</Amnt>

<Constant2/>

<Cash_balance/>

<Filler1/>

<Balance/>

</FEBRIT64>

<FEBRITEF>

<FEBRITEF_1/>

<FEBRITEF_2/>

<FEBRITEF_3/>

<FEBRITEF_4/>

<FEBRITEF_5/>

<FEBRITEF_6/>

<FEBRITEF_7/>

<FEBRITEF_8/>

<FEBRITEF_9/>

<FEBRITEF_10/>

<FEBRITEF_11/>

<FEBRITEF_12/>

</FEBRITEF>

</ns0:OUTPUT_ITALY_FORMAT_TYPE>

Now i need to convert the above file into a text file when i get the o/p in xml format. I have tried using file content conversion but i am not able to get the solution right. Could anyone let me know as to how should i specify the recordset structure parameters if i need a comma between the fields in each of the structures.Also if u could let me know the other important parameters it could be of great help.

Thanks and Regards

Sharat