Skip to Content
avatar image
Former Member

Conversion file adapter

Hi all,

I have the following xml:

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

<ns:PayLinkV1 xmlns:ns="urn:basf:sa:fi:cash">

<payRecord>

<recType>PAY</recType>

<countryCode>032</countryCode>

...

<payFlag />

<filler />

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000GAL1</description>

<filler />

</invoice>

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000GAL2</description>

<filler />

</invoice>

</payRecord>

<payRecord>

<recType>PAY</recType>

<countryCode>032</countryCode>

...

<payFlag />

<filler />

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000CIT3</description>

<filler />

</invoice>

<invoice>

<recType>VOI</recType>

<countryCode>032</countryCode>

...

<description>0001A0000CIT2</description>

<filler />

</invoice>

</payRecord>

<trailer>

<recType>TRL</recType>

<qtyTransaction>000000000000000</qtyTransaction>

<qtyAmount>000000000000000</qtyAmount>

<qtyRec>000000000000000</qtyRec>

<qtyRecNo>000000000000000</qtyRecNo>

<filler />

</trailer>

</ns:PayLinkV1>

I need to convert it in one text file with this layout:

fields of payrecord

fields of invoice

fields of invoice

...

fields of payrecord

fields of invoice

fields of invoice

...

fields of trailler

In may file conversion type has the following configuration:

Recordset structure: payRecord,invoice,trailer

payRecord.fieldFixedLengths: 3,3,10,6,3...

invoice.fieldFixedLengths: 3,3,10,15...

trailer.fieldFixedLengths: 3,15,15...

But in the file adapeter occurs one error with this configuration.Anybody have an ideia to do it?

thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 17, 2006 at 01:14 PM

    Hi!

    What exactly is the error message?

    Regards, Joerg

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Elton,

      The error clearly states that you have a mismatch with the number of fields. So can you once again recheck this?

      ---Satish