Skip to Content
avatar image
Former Member

Help with FCC on receiver side

Hey guys

i have an XML structure on the receiver side as follows

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

<ns0:MT_Invoices xmlns:ns0="urn:NOVInvoiceToSCO">

<Invoice>

<InvoiceProperties>

<InvoiceNumber>sdds</InvoiceNumber>

<InvoiceDate>dsd</InvoiceDate>

<VendorNumber>dsd</VendorNumber>

<InvoiceTypeCode>rer</InvoiceTypeCode>

<PrimaryCurrency>

<CurrencyCode>dd</CurrencyCode>

<ExchangeRate>dsd</ExchangeRate>

</PrimaryCurrency>

<PaymentTerms>sd</PaymentTerms>

</InvoiceProperties>

<InvoiceDetails>

<InvoiceLineItem>

<WorkOrdernumber>dsd</WorkOrdernumber>

<LineItemNumber>dsd</LineItemNumber>

<InvoiceQuantity>

<Quantity>ds</Quantity>

<UnitOfMeasureCode>ds</UnitOfMeasureCode>

</InvoiceQuantity>

<LineItemInformation>

<LineItemMaterialNumber>sds</LineItemMaterialNumber>

<LineItemDescription>dsd</LineItemDescription>

</LineItemInformation>

<Pricing>

<UnitPrice>

<MonetaryAmount>dsd</MonetaryAmount>

<UnitOfMeasureCode>dsd</UnitOfMeasureCode>

<CurrencyCode>sds</CurrencyCode>

</UnitPrice>

</Pricing>

<LineItemtotal>

<MonetaryAmount>sd</MonetaryAmount>

<CurrencyCode>ds</CurrencyCode>

</LineItemtotal>

<Requisition>

<Number>ds</Number>

<LineItemNumber>ds</LineItemNumber>

</Requisition>

<Status>sd</Status>

</InvoiceLineItem>

</InvoiceDetails>

<InvoiceSummary>

<TotalLineItems>ds</TotalLineItems>

<InvoiceTotal>

<MonetaryAmount>ds</MonetaryAmount>

<CurrencyCode>ds</CurrencyCode>

</InvoiceTotal>

<Tax>

<TaxTypeCode>sd</TaxTypeCode>

<TaxAmount>

<MonetaryAmount>ds</MonetaryAmount>

<CurrencyCode>s</CurrencyCode>

</TaxAmount>

<TaxReference>ds</TaxReference>

</Tax>

</InvoiceSummary>

</Invoice>

</ns0:MT_Invoices>

<InvoiceProperties> is the header

<InvoiceDetails>is the data

<InvoiceSummary>is the trailer

i am using the following on the receiver side under FCC

Recordset Structure: Invoices,Invoice,InvoiceProperties,PrimaryCurrency,InvoiceDetails,InvoiceLineItem,InvoiceQuantity,LIneItemInformation,Pricing,UnitPrice,LineItemTotal,Requisition,InvoiceSummary,InvoiceTotal,Tax,TaxAmount

Invoices.fieldSeparator 'nl'

Invoice.fieldSeparator ,

Invoice.endSeparator 'nl'

InvoiceProperties.fieldSeparator ,

InvoiceProperties.endSeparator 'nl'

PrimaryCurrency.fieldSeparator ,

PrimaryCurrency.endSeparator ,

InvoiceDetails.fieldSeparator ,

InvoiceDetails.endSeparator 'nl'

InvoiceLineItem.fieldSeparator ,

InvoiceLineItem.endSeparator 'nl'

InvoiceQuantity.fieldSeparator ,

InvoiceQuantity.endSeparator ,

LineItemInformation.fieldSeparator ,

LineItemInformation.endSeparator ,

Pricing.fieldSeparator ,

Pricing.endSeparator ,

UnitPrice.fieldSeparator ,

UnitPrice.endSeparator ,

LineItemTotal.fieldSeparator ,

LIneItemTotal.endSeparator ,

Requisition.fieldSeparator ,

Requisition.endSeparator ,

InvoiceSummary.fieldSeparator ,

InvoiceSummary.endSeparator 'nl'

InvoiceTotal.fieldSeparator ,

InvoiceTotal.endSeparator ,

Tax.FieldSeparator ,

Tax.endSeparator ,

TaxAmount.fieldSeparator ,

TaxAmount.endSeparator ,

Now i want the output of the following form

Header

Data

Trailer

Note:Data has occurence 0--* and both header and trailer have occurence 1

i m unable to get the CSV file on the receiver side,can anbody cross check my parameters and lemme know whr i m wrong?

thanx

ahmad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 16, 2007 at 03:36 PM

    Hi,

    See

    Recordset Structure: Invoices,Invoice,,InvoiceProperties,PrimaryCurrency,InvoiceDetails,*,InvoiceLineItem,InvoiceQuantity,LIneItemInformation,Pricing,UnitPrice,LineItemTotal,Requisition,InvoiceSummary,InvoiceTotal,Tax,TaxAmount

    remaining are same.

    try if not use for occurrence 1.

    Regards

    Chilla

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      well i waz using record.fieldSeparator =,

      and record.endSeparator='nl' and the endSeparator was not workin

      so i thought of a way around and tried to use

      record.endSeparator=,

      record.beginSeparator='nl'

      but thie beginSeparator doesn't seem to work,its displayed in the receiver file as 'nl' itself

      thanx

      ahmad

  • avatar image
    Former Member
    Mar 16, 2007 at 03:47 PM

    Hi Ahmad,

    give recordsetstructure : InvoiceProperties,1,InvoiceDetails,*,InvoiceSummary,1

    and in key-value pair give:

    InvoiceProperties.fieldFixedLengths : length of fields of InvoiceNumber,InvoiceDate..etc similarly for InvoiceDetails and InvoiceSummary

    InvoiceProperties.fieldSeparator , similarly for InvoiceDetails and InvoiceSummary

    Then you will get your req CSV file.

    Thanks,

    Rajeev Gupta

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ahmad,

      <i>also shud i replace the whole key-value pair with wat u said or jst change the values</i> - replace the whole key-value pair with what i have said......just to be on safe side, copy your file comm channel with someother name but do not activate this copy of comm channel........then you can easily change your file comm channel with my data....i think you can get your CSV file with the parameters i have specified....

      Thanks,

      Rajeev Gupta