| Author |
Flatfile Problems with empty nodes and child nodes
|
|
| Cordula 2004-06-08, 3:20 am |
| Hello,
like Deborah and so many others i try to handle an incoming flat file.
excuse für my bad english....
I have to get a tagged flat file into biztalk 2004. It looks like this (i will attach the file and the XSD in this thread - this is just to get an idea of what i try)
000000033MA1TFILE F168381000000000000000000000000000090004
0320021028200207250000000000000000000000
000000100731520020722
000000033MA1TFILE F2684332233000004 000000000005054114306188000006 4332233000004 HIT 59 Verbr.Mar
000000033MA1TFILE FA684316723000002 00000000000500807ÄOHLE HANDELSGRUPPE ÄERVICE GMBH &
000000033MA1TFILE FV68Retouren
000000033MA1TFILE FL68Frei Haus
000000033MA1TFILE F36800001800560 KDARTNR505411/800560 4306188005605
000000033MA1TFILE F468000010000000000000000000000000000000
000000000000000+ 0000000000000000000000000000000+ 00000000000
000000033MA1TFILE F7680000300000C344014 00000000000200020060415
000000033MA1TFILE F36800001800561 KDARTNR505412/800561 4306188005612
000000033MA1TFILE F468000010000000000000000000000000000000
000000000000000+ 0000000000000000000000000000000+ 00000000000
000000033MA1TFILE F7680000300000C344014 00000000000200020060415
000000033MA1TFILE F8680062133759 66010075 POSTBANK Himmelstadt
000000033MA1TFILE F968000000000001510000000000001410000000
0000000000000000000014100000000000000000
0000000000000000000000000
000000033MA1TFILE FX68Transportrückvergütung
There are several lines, identified by a tag (XH68/F168/F268/FA68/FV68..) with offset 19. Each line are fields under a positional node.
Each line can be repeted and there are groups of nodes wich can be repeated. The most of the lines can be empty.
To handle the empty nodes i have followed the suggestion to add 'parser_optimization="complexity" lookahead_depth="0"
suppress_empty_nodes="false" generate_empty_nodes="true"
allow_early_termination="false" 'in my schema and it works.
But now i have another problem:
The line-nodes are children of an delimited node with child-delimiter hexadecimal 0x0D 0x0A (line-end)
I have defined a child node for the lines F3, F4, ... to be able to repeat them. But after the line F4 he can not identifie the F8 line. HE stop after line 11.
He search for everything but not F8, F9 or FX.
Ther error message in HAT:
There was a failure executing ther receive pipeline "XXXXXXXX" Source: "Flat file disassembler"
Receive Location: "C:\....."
Reason: Unexpected data found while looking for
'F768' at offset 19
'F368' at offset 19
'\r\n'
'FP68' at offset 19
He don´t look für F4 because F3 does occur minimum one time.
My schema look like this
Node
F1
F2
FA
FV
FL
FK
Position (with his childs:
F3
F4
FR
F5
F7 )
F8
F9
FX
Every hint would be helpful!
Thanks
Cordula | |
| Cordula 2004-06-08, 3:35 am |
| Hello,
i´ve seen that my example of the flat file in the thread is not very helpful. Please look the attached example!!
And here i will attache my schema (in a .txt file because .xsd is nocht allowed to attach)
Thanks
Cordula | |
| Cordula 2004-06-08, 3:36 am |
| quote:
Originally posted by Cordula
Hello,
i´ve seen that my example of the flat file in the thread is not very helpful. Please look the attached example!!
And here i will attache my schema (in a .txt file because .xsd is nocht allowed to attach)
Thanks
Cordula
| |
| David Downing [MSFT] 2004-06-09, 8:31 am |
| Cordula,
I don't see your schema and test instance files attached, can you please
repost with the files attached?
Thank you,
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| Cordula 2004-06-09, 10:54 am |
| Hello Dave,
thanks for replying
The attachement can be find in the small footnote of posting 1 and 3 at the end you can see "Attachment: rg000012.txt" or "Attachment: wkinvtest.txt". When you click on it, you will see the files.
You don´t see it or to open them don´t work?
I will paste the text of the files in the post, perhaps it ist helpful. And i will attach the files the same way as below.
Thanks
Cordula
000000017FR1FILE XH68000000000000000000000000000000000170
00000000000000000000000 IP 4025849000000 4000000000000000000000000000001271526 1040324
000000017FR1FILE F168380000000000000000000000000000012715
2620040107200401050000000000000000000000
000000528467420040107 00000000004857700200401054399901479647 00000000000006928 4010996000003 DE129443689 0000000000000000000000000000000000000000
000EUR0160000000000000000000000+00000000
0000000 2004011500800300000000000000000+00000000
0000000+2004020603000000000000000000000+
000000000000000+200402060000000000040001
1FR1FILE 030 1040324
000000017FR1FILE F2684399901479647 000000000000069284010996000003 4399901479647 INGRID GELDBACH DROGERIE DEUSTER ABR.UEBER IP-BIELEFELD NEUSTAEDTER STR. 42-44 D 35066 FRANKENBERG Fertigwarenlager 4 1000000000000086684025849000000 4399901479647 1040324
000000017FR1FILE FA684399901479647 00000000000006928INGRID GELDBACH DROGERIE DEUSTER ABR.UEBER IP-BIELEFELD NEUSTAEDTER STR. 42-44 D 35066 FRANKENBERG 1040324
000000017FR1FILE F3680000120956 4086200209562 CL.LINE GES.WAS.O.ALK 000000000003000001000000000005360+001000
0000000016080+000000000016080+0101600000
000000002570+000000000735000000007350000
00DE000000000000000 1040324
000000017FR1FILE F46800001000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000100000C328022 00000000000300020051223 1040324
000000017FR1FILE F3680000220958 4086200209586 CL.LINE GES.PEELING 000000000002000001000000000004820+001000
0000000009640+000000000009640+0101600000
000000001540+000000000200000000002000000
00DE000000000000000 1040324
000000017FR1FILE F46800002000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000200000C341011 00000000000200020060328 1040324
000000017FR1FILE F3680000320873 4086200208732 SSL AUGENBALSAM 000000000002000001000000000008040+001000
0000000016080+000000000016080+0101600000
000000002570+000000000068000000000680000
00DE000000000000000 1040324
000000017FR1FILE F46800003000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000300000C344014 00000000000200020060415 1040324
000000017FR1FILE F3680000404517 4086200045177 MSL AUSGLEICHS-CREME 000000000003000001000000000009920+001000
0000000029760+000000000029760+0101600000
000000004760+000000000423000000004230000
00DE000000000000000 1040324
000000017FR1FILE F46800004000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000400000C344012 00000000000300020060417 1040324
000000017FR1FILE F3680000521013 4086200210131 SAL TAGESPFLEGE 000000000001000001000000000014210+001000
0000000014210+000000000014210+0101600000
000000002270+000000000133000000001330000
00DE000000000000000 1040324
000000017FR1FILE F46800005000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000500000C312013 00000000000100020050902 1040324
000000017FR1FILE F3680000621014 4086200210148 SAL TAGESPFL.E.RICH 000000000002000001000000000014480+001000
0000000028960+000000000028960+0101600000
000000004630+000000000268000000002680000
00DE000000000000000 1040324
000000017FR1FILE F46800006000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000600000C341013 00000000000200020060325 1040324
000000017FR1FILE F3680000721016 4086200210162 SAL NACHTPFL.E.RICH 000000000001000001000000000016620+001000
0000000016620+000000000016620+0101600000
000000002660+000000000133000000001330000
00DE000000000000000 1040324
000000017FR1FILE F46800007000000000000000+000000000000000
0000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 0000000000000000000000000000000+ 00000000000000000000 1040324
000000017FR1FILE F7680000700000C343013 00000000000100020060408 1040324
000000017FR1FILE F8680062133759 66010075 POSTBANK KARLSRUHE KRIEGSTRASSE 100 76118 KARLSRUHE 1040324
000000017FR1FILE F968000000000571830+000000000492960+0000
00000000000 000000000492960+000000000000000+00000000
0000000+000000000078870+0160000000000007
8870+00000000000000000000+00000000049296
0+000000000000000+000000000000000+000000
000000000+000000000000000+00000000000000
0+000000000000000+000000000000000+000000
000000000+000000000000000+00000000000000
0000000000000000 000000000000000000000000000000 000000000000000+000000000000000+00000009
560000000095600048 1040324 | |
| Cordula 2004-06-09, 11:00 am |
| Sorry Dave the schema is too big to paste it in the post. I will attach it. If it don´t work i will restart with a smaller example.
Please give a sign.
Thanks
Cordula | |
| Cordula 2004-06-17, 3:32 am |
| Hi,
if for someone my big example with all the details ist too much, i am very glad for all hints, how to build a Schema to process a flat file with several lines delimited by the line-end.
The lines are identified with a tag with offset.
And the structure of the file is, that there are lines which represent the header. Some lines for each position (theses lines are repeated) and sone lines with End-Data like sums and so on.
For each line it is possible that it don´t occur. The first line (which is the first line of the header) ist always there.
Feel free to share any kinds of ideas and hints with me. I don´t search for a complete solution. Just for ideas how to continue.
And if someone else has build a similar solution, he or she could send it to me and i can analyze it on my one to learn where i was going wrong.
Thanks
Cordula | |
| David Downing [MSFT] 2004-06-20, 11:10 pm |
| Cordula,
I'm not able to download your file... can you cut/paste your schema and
test instance using notepad directly into another newsgroup post.
Thank you,
--
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
|
|
|
|