on 12-07-2010 7:14 AM
Hi Experts,
Scenario: File(FCC) to Proxy
Error: CSV file picking up from source directory but its showing empty in sender CC (Actual file contains data in source directory) and find below attached Conversion parameters. Please let me know if any changes in the configuration.
Document Name: MT_Legacy
Document Name space: http://retails.com/pi/LEGACY/Purchasing/TECHNICAL_DATA
Recordset structure: Header,,Items,
Recordset sequence: Ascending
Keyfiled names: NumFacture,Constant
ignoreRecordsetName----
true
Header.fieldNames----
a,s,d,f,g,e
Header.keyFieldInStructure----
ignore
Header.keyFieldValue----
05
Header.endSeparator----
nl
Header.fieldSeparator----
;
Similar to Items also
Query: is this error related to source file (unexpected format) or Sender File CC configuration.
Regards,
FHM
Hi Haq,
I see that there are two keyfield names in your content conversion. Are they for different nodes?
" Keyfiled names: NumFacture,Constant "
And also the you have provided key field value as 05 and what about the other key field?
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi HK,
I see that there are two keyfield names in your content conversion. Are they for different nodes?
" Keyfiled names: NumFacture,Constant "
Yes...those are coming from two different nodes like one from Header and another one from Items.
And also the you have provided key field value as 05 and what about the other key field?
Another key field value have given 43
one more thing Key filed value must be always constant right?
Thanks,
Hi,
Check the RecordSet Structure configuration.
I guess it follows the convention of NameA, nA,NameB, nB.....
where nA or nB....= 1, 2, ....,* i.e. the occurance of the field.
In you case it should be: Header,1,Item,*
-Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What is the Key Field Type you have mentioned??
If its String than enter the below parameter for header and item as mentioned below:
Header.keyFieldValue----
"05"
Also, I hope the single quotes are used for parameter endSeparator value:
Header.endSeparator----
'nl'
Do you see any issue in Audit log entry of the sender CC?
-Rahul
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.