| Author |
Message
|
| rkford11 |
 Posted: Fri Jan 31, 2014 12:00 am Post subject: TDS message model issue |
 |
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
I am working on modelling the following message and have defined TDS message set with Variable Length Elements Delimited (Data element seperation). Have got a Group which starts with ABC (part of input and not TAG) and ends with XYZ and records with in the group are seperated with new line (/r/n) and also the group with new line(/r/n).
But the first segment parses fine where as segment "DEF" (multiple records with delimiter /r/n) does not.
I have also defined the Root complex type to " All Elements Delimited "
Tried defining GROUP Indicator as "ABC" for first record, and "DEF" for 2nd record and so on
Is there something i am missing. Please guide me thru this.
ABC3KLI13456 000000000000000000000AB 109033304021
DEF_DTSDT401201030300
DEF_IDRID444-784781-140113135806
DEFKJIDF FTH733454001131234
GHISHTHE XX SFF
GHICN YY KJA
GHIYUROSSEE - ZZ RGE
JKLX3 001345.10000N084.52000WLLD AO ARV X000000
JKL TT ADE
XYZTRESHAHA
Thanks |
|
| Back to top |
|
 |
| kimbert |
| Posted: Fri Jan 31, 2014 3:02 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
That is a good attempt at describing your data format, but unfortunately I still have to ask for more detail.
Please can you
- state which version of WMB you are using
- explain exactly what tree structure you want to end up with
- use [c o d e ] tags so that the indentation is preserved
- supply as much detail as possible about the rules of this data format
Some of what you said makes sense, but other parts confused me. You seemed to say that segment 'ABC' ends with 'XYZ' but that would imply that it takes up most of your example message. So where's the 'DEF' segment?
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| rkford11 |
| Posted: Fri Jan 31, 2014 9:40 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
Thanks Kimbert. We are using V7 of WMB. We are having a group message that starts of with 'ABC' and ends with 'XYZ'.
ABC is the first record containing multiple variable length elements.
similary 'DEF' (occurs 1 to many) is second record with multiple variable length elements. 'GHI' is 3rd record and so on 'XYZ' is the last record in the group. Each record in the group starts in a new line.
The input to the message flow is a single file containing 1 to n groups.
And each group in the file is also separted by new line.
I have defined root element for the group and complex type (VLED) for each record in the group.
fyi, ABC, DEF......XYZ are part of data in the record.
Thanks
| kimbert wrote: |
That is a good attempt at describing your data format, but unfortunately I still have to ask for more detail.
Please can you
- state which version of WMB you are using
- explain exactly what tree structure you want to end up with
- use [c o d e ] tags so that the indentation is preserved
- supply as much detail as possible about the rules of this data format
Some of what you said makes sense, but other parts confused me. You seemed to say that segment 'ABC' ends with 'XYZ' but that would imply that it takes up most of your example message. So where's the 'DEF' segment? |
|
|
| Back to top |
|
|
| dogorsy |
| Posted: Mon Feb 03, 2014 2:11 am Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
still missing the following info:
| Quote: |
| - state which version of WMB you are using |
i.e, V7 is not enough, you need to specify 7.x.x.x |
|
| Back to top |
|
|
| kimbert |
| Posted: Mon Feb 03, 2014 4:01 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Can you give a little more information about this:
| Quote: |
| Have got a Group which starts with ABC (part of input and not TAG) |
If you *know* that the record starts with 'ABC' then you do not require the indicator field to be present in the message tree. Or is there some other requirement?
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
| rkford11 |
| Posted: Mon Feb 03, 2014 3:32 pm Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
Version of WMB is 7.0.0.4.
Record starts with 'ABC' and and end with 'XYZ' record . FYI, records in the group can repeat.
GROUP: { ABC 123 122 3344 ddg -- Record
DEF eeer 33 444 55 -- Record
DEF ryty 333 4443
......
......
XYZ rrrr ttt eee 123 -- Record}
And in a single file there can be multiple Groups.
Thanks |
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Feb 04, 2014 3:29 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
Make 'ABC' the tag for the first record, 'DEF' the tag for the second record, and so on for all tagged records. Set Data Element Separation to 'Tagged Delimited' on all complex types and make sure that maxOccurs and minOccurs are set correctly everywhere.
If necessary, take a debug-level user trace to see what the TDS parser is doing with the data.
Give that a try, and let us know what happens - including any error messages that you see, and the results of any experiments that you have conducted.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too. |
|
| Back to top |
|
|
|
|
