on 12-04-2009 1:22 AM
Hello all,
I have a File to IDOC scenario where the file is a flat file where the structure is like this.
the structure is very volatile,
a record set would start with 001 and end with 999. for each record a sales order has to be created. creating multiple sales orders from Idoc is not a problem but I just need all your help in defining the FCC paramets for this file.
001|327737|
002|NEW|
004|1|
005|2077|
006|091021|
007|26|
008|600000134|Trailwood Transport Ltd.|
010|69216|LBS|
011|10159|
050|1177|416|
999|327737|11|
001|327863|
002|NEW|
004|1|
005|1610|
006|091021|
007|16|
007|21|
008|600000101|TRAVELERS TRANSPORTATION SERVICES|
010|42595|LBS|
011|091909A|
050|1177|256|
999|327863|11|
001|327876|
002|NEW|
004|1|
005|1359|
006|091026|
007|16|
008|600000021|BRUCE R SMITH LIMITED|
010|42231|LBS|
011|93468|
050|1697|1050|
050|1697|1050|
050|1697|1050|
050|1697|1050|
999|327876|11|
Also the file name is something like: abc.yymmdd , the extension of the file keeps changing every day. Please suggest me how do I acheive this.
Thanks for your help in advance.
Regards,
Kalpana.
Edited by: Kalpana Timmapuram on Dec 4, 2009 2:22 AM
Hi Kalpana,
"the file name is something like: abc.yymmdd , the extension of the file keeps changing every day"
For this, you can use the file name scheme as abc.
For FCC, you can consider 1 recordset at a time.
FCC parameters are:
recordset.fieldNames : Write the names of the fields separated by comma
recordset.fieldSeparator:
Pls specify the field names as well here, so that I ca get you the exact FCC parameters.
-Tanaya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kalpana,
Also the file name is something like: abc.yymmdd
the file name u can give as abc.*
which will choose all files starting with abc.
For the FCC i think it's better u access the whole record at a time
like
001|327737| will be 1 record and
002|NEW|
004|1|
005|2077|
006|091021|
007|26|
008|600000134|Trailwood Transport Ltd.|
010|69216|LBS|
011|10159|
050|1177|416|
999|327737|11|
all will be one single records...
You can split the records into fields based upon the I in mapping and will get the exact structure...
Babu
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 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.