on 03-16-2007 3:32 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.