on 06-15-2011 10:54 AM
HI All,
We have a requirement like ,we have to convert the .txt file to xml format and send to Enterprise portal system.the .txt file looks like this...
-
Schedule D - District/Port List (by District Code) [Produced13APR11]
-
District | Port | Name
Code | Code |
-
01 | | PORTLAND, ME
| 0101 | PORTLAND, ME
| 0102 | BANGOR, ME
| 0103 | EASTPORT, ME
| 0104 | JACKMAN, ME
| 0105 | VANCEBORO, ME
| 0106 | HOULTON, ME
| 0107 | FORT FAIRFIELD, ME
| 0108 | VAN BUREN, ME
| 0109 | MADAWASKA, ME
| 0110 | FORT KENT, ME
| 0111 | BATH, ME
| 0112 | BAR HARBOR, ME
| 0115 | CALAIS, ME
| 0118 | LIMESTONE, ME
| 0121 | ROCKLAND, ME
| 0122 | JONESPORT, ME
| 0127 | BRIDGEWATER, ME
| 0131 | PORTSMOUTH, NH
| 0132 | BELFAST, ME
| 0152 | SEARSPORT, ME
| 0181 | LEBANON AIRPORT
| 0182 | MANCHESTER USER FEE AIRPORT, NH
-
Can any one suggest your valuble suggestions to me....
Thanks
SAYEE.
Hi,
File to File senario....write file content conversion for sender side as it is text file. receiver side receiver side u can spesify in data tye...it will gives the XML file.
Generally our PI will give output directlt as a XML file if you give file name ends with .xml. for text file only u need to cretae FCC...
Thanks
Edited by: VenkatSivaramakrishna on Jun 15, 2011 4:05 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Use content conversion in the sender file adapter:
http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sayee,
You need to write File Content Coversion in the Sender Communication Channel.
Create a sender channel with parameters:
i) Transport Protocol - File System (NFS) or FTP
ii) Message Protocol - File Content Conversion
If you are using PI 71. and above, you will have a tab called content conversion and there you need to write the conversion logic.
Cheers,
Souvik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You need to set up at least 3 mandatory parameters:
<node>.fieldSeparator u2013 can be a comma for a CSV file, or any other separator. You can specify the hex code here, e.g. for a tab separated file you could provide u20180×09u2019 (including quotes).
<node> .endSeparator u2013 signifies the end of a record, u2018nlu2019 (including quotes) indicates a new line character.
<node> .fieldNames u2013 list of field names in each record.
Specify the following in the sender cc.
Adapter Type :FILE
Transport Protocol : FILE SYSTEM
Message Protocol : File content conversion
Adapter Engine : Integration Server
Specify the source directory and the file name from where you have to pick the file.
Recordset Structure : Item,*
Recordsets per message : *
Key Field Name : kz
Key Field Type :String
Setting, can be something like this:
Name Value
Item.keyFieldValue I
Item.fieldFixedLengths
Item.fieldNames
District,Port,Name
Item.endSeparator
'nl'
ignoreRecordSet
true
> know that to use FCC but i want the sample how to convert the data to .txt to xml i have giv
Please refer this
1) [link |http://www.riyaz.net/blog/xipi-file-content-conversion-for-simple-structure/technology/sap/75/]for the sample
2) [link|http://www.riyaz.net/blog/xipi-file-content-conversion-for-complex-structures/technology/sap/79/] for the sample
User | Count |
---|---|
86 | |
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.