on 03-04-2014 1:42 PM
Hi All,
We got a change request for one our interface. The scenario is File to IDOC. PI is receiving .CSV file from FTP which may contains multiple line ITEMS.But PI is creating one IDOC with single Header segment and multiple line item segments. Here as per the new requirement changes am sending File name to one of the target field in IDOC by using UDF code.
Now we received another request from client, like each line item in the .CSV file may contain one Company_code. So we need to send the file name to target field (at line item level) at run time, which I have achieved already by using UDF.
But here the requirement is, I need to capture the Company_code from each line item in the Text file and need to send this to one of the target field at ITEM level.
For Example:
Below is my .CSV file contains 2 line Items
20120514;20120514; ;1000;1070001E0;;1070001E0;;;10;;COMPANY1
20120514;20120514; ;1000;1070001E0;;1070001E0;;;10;;COMPANY2
My file name is Orders*txt
So I need to capture the file name and should combined this with COMPANY1 like ----> OrdersCOMPANY1.txt which I need to transfer to one of the filed (Company_code) in the fisrt line item segment in the target IDOC
In the same for second line item ---> OrdersCOMPANY2.txt need to send to the Company_code field in to the second line ITEM.
So can any one please tell how I cam
Hi,
for this u can get the filename by using the dynamic configuration ...
then concat the dynamic configuration output and the last field in the csv file and assgn to the target field.
You can assign the udf to one variable in the mapping.
VARIABLE
CONCAT ----------------> TARGET FIELD.....
CSV File last field
Thanks,
Sreenivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj - in your content conversion for lineitem .. read the additional attribute as well.
Change your source strcture and additional field company_code
As you are already sending the filename for each line item using the UDF.. it's just you need to modify your UDF to take another input i.e. Company Code.
or
If your PI version is > 7.1 use the graphical variable to hold the filename..
and while sending the company code information for every item just use the concat function to append filename & company code..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.