on 10-16-2013 4:04 PM
Hi,
I'm generating a file by adapter SFTP and the generate file is XML.
I'm using Additional Parameters as following:
FileType = Text
But is not working...
Other question; I need to eliminate the first line of my file but is not working too:
FILENAME.addHeaderLine | 0 |
FILENAME.keyFieldValue | 1 |
FILENAME.keyFieldInStructure | ignore |
Can you help?
tks
Hi,
AFAIK, for file content conversion in SFTP you have to use Message Transform bean. Also refer to the below discussion:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You need to specify how the fields in the text file will be separated i.e comma separated, semi colon separated etc. or you can specify the fixed lengths of the fields. Please refer to the parameters xml.fieldFixedLengths & xml.fieldSeparator in the document link suggested by Iñaki Vila. It is also mentioned in the document that if you want a CSV file, use the parameter xml.fieldSeparator
Hi Adarsh...
The fields have fixed lengths...how I will separate the fields in text file?
Example:
SAP (Internal Table separate by columns)
0001 000000001 0000000000010
0002 000000002 0000000000020
0003 000000003 0000000000030
File in SFTP (txt)
0001 000000001 0000000000010
0002 000000002 0000000000020
0003 000000003 0000000000030
Separate by ';' the command is 'nl', in this case by tab how is?
tks.
Hi,
For tab separated values, the value for parameter xml.fieldSeparator will be '0x09' ...Also refer to the below links:
Hi,
You need to modify then entries for Key fields. You should also provide the value of the key fields:
In your case, the values of key fields should have been provided as:
xml.HEADER.keyFieldName = IDENT_REG
&
xml.ITEM.keyFieldName = IDENT_REG_I
Also provide two new entries for key field values as:
xml.HEADER.keyFieldValue = XXXX
xml.ITEM.keyFieldValue = XXXX
Here XXXX refers to the value with which you will identify whether the given line is Header or ITEM.
Please refer to the section Complex Conversion of the below link:
http://help.sap.com/saphelp_nw04/helpdata/EN/24/4cad3baabd4737bab64d0201bc0c6c/content.htm
Also go through the way in which key field is provided in below link:
Hi Rodrigo,
Are you using the MessageTransformBean in order to transform the XML?
Check the receiver conversion in this link http://help.sap.com/saphelp_nw04/helpdata/EN/24/4cad3baabd4737bab64d0201bc0c6c/content.htm
Or you want to create a file with the exact XML that you have in the payload?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.