Help with FCC on receiver side

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hey Chilla

I m getting a chequered flag in MONI,but in RWB under message monitoring it shows the status as waiting,and i m not getting file on the receiver side as well.

where shud i check for this?

thanx

ahmad

[Former Member · Accepted solution]

Hi Ahmad,

go to RWB -> component monitoring ->adapter monitoring ->File adapter....see the error in your recever file comm channel......rectify this error.....save and activate your comm channel in ID.....then again exectue your scenario.....then you will get your target output file......

Thanks,

Rajeev Gupta

[Former Member · Accepted solution]

Hey Rajeev

its the first time i m working on PI7.0 SP9 and under adapter monitoring in RWB,i definately see the adapters but when i click them,it says,"File Adapter monitoring is now part of Channel monitoring,its different from Xi3.0 where i cud have seen all the adapters and their status(Green or Red)

how should i check the adapters in PI7.0

and the error log i m getting in message monitoring is

2007-03-15 11:19:02 Warning Channel CC_sender: Empty document found. Proceed without sending message

2007-03-15 11:19:02 Success File "
scosap002\ed1_interfaces\nov\input" deleted after processing

thanx

ahmad

[Former Member · Accepted solution]

Ahmad

ur input file is empty. put a file which as data in it and check.

[Former Member · Accepted solution]

Hey guys

my problem is almost solved,i can see the CVS file on the receiver side,m having jst one small but irritating problem.

i dont know why but when ever i use 'nl' as the endSeparator instead of moving to a new line its displayed as it is('nl') in the output file

i m on PI7.0 SP09

thanx

ahmad

[Former Member · Accepted solution]

what r u Content cnversion parameters

i see fieldEndSeparator as comma and ,nl. you use only one

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hey Rajeev

do you want me to replace whole of my receordset structure

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

with InvoiceProperties,1,InvoiceDetails,*,InvoiceSummary,1 or u want me to make only the changes in occurence?

also shud i replace the whole key-value pair with wat u said or jst change the values ?

thanx

ahmad

[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