Author |
Message
|
wraymore |
Posted: Thu Apr 16, 2009 1:18 pm Post subject: TDS Question - field with sub fields and repeating Resolved |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
WMB 6.0.0.8
AIX 5.8
HL7 input message
Code: |
ZRL|1|BN|LabCorp Burlington|1447 York Court^^Burlington^NC^272153361|8007624344||MD^Hancock^William F^^^^MD|||||
ZOI|5|100111^SPECIM^E^STATUS REPORT~829574^MONOGR^I^Monogram Trofile~551697^GENOSU^R^GenoSure~998085^VENIPU^S^Venipuncture~X14500^MDP30^S^Oxon Hill,MD 301-567-2819~||||
EOP|0427||||
EOF|||||
|
The ZOI segment contains a field that has sub fields with the group of sub fields repeating up to 40 times. Sub fields are delimited by ^ and the ~ is the repeat delimiter.
Code: |
Tag: ZOI|
Number of Occurrences: 5|
Test Item: 100111^
Test Name: SPECIM^
Status: E^
Order Name: STATUS REPORT~
Test Item: 829574^
Test Name: MONOGR^
Status: I^
Order Name: Monogram Trofile~
Test Item: 551697^
Test Name: GENOSU^
Status: R^
Order Name: Genosure~
Test Item: 998085^
Test Name: VENIPU^
Status: S^
Order Name: Venipuncture~
Test Item: X14500^
Test Name: MDP30^
Status: S^
Order Name: Oxon Hill, MD 301-567-2891~|
Future Field 4: |
Future Field 5: |
Future Field 6: |
Future Field 7: |
Future Field 8: <CR><LF>
|
From Trace Node:
Code: |
(0x01000013):ZRL = (
(0x0300000B):ZRL.2.TransmissionSequenceNumber = '1'
(0x0300000B):ZRL.3.FacilityMnemonic = 'BN'
(0x0300000B):ZRL.4.FacilityName = 'LabCorp Burlington'
(0x01000013):ZRL.5.FacilityLocation = (
(0x0300000B):ZRL.5.1.FacilityAddress = '1447 York Court'
(0x0300000B):ZRL.5.3.FacilityCity = 'Burlington'
(0x0300000B):ZRL.5.4.FacilityStateProvince = 'NC'
(0x0300000B):ZRL.5.5.FacilityZipPostalCode = '272153361'
)
(0x0300000B):ZRL.6.FacilityPhoneNumber = '8007624344'
(0x0300000B):ZRL.7.FacilityContact = ''
(0x01000013):ZRL.8.FacilityDirector = (
(0x0300000B):ZRL.8.1.FacilityDirectorTitle = 'MD'
(0x0300000B):ZRL.8.2.FacilityDirectorLastName = 'Hancock'
(0x0300000B):ZRL.8.3.FacilityDirectorFirstName = 'William F'
(0x0300000B):ZRL.8.7.FacilityDirectorDegree = 'MD'
)
(0x0300000B):ZRL.9.FutureField = ''
(0x0300000B):ZRL.10.FutureField = ''
(0x0300000B):ZRL.11.FutureFeild = ''
(0x0300000B):ZRL.12.FutureField = ''
(0x0300000B):ZRL.13.FutureField = ''
)
(0x01000013):ZOI = (
(0x0300000B):ZOI.2.NumberOfOccurences = '5'
(0x01000013):ZOI.3.TIXTestData = (
(0x0300000B):ZOI.3.1.TIXTestNumber = '100111'
(0x0300000B):ZOI.3.2.TIXTestName = 'SPECIM'
(0x0300000B):ZOI.3.3.TIXTestStatus = 'E'
(0x0300000B):ZOI.3.4.OrderedItemName = 'STATUS REPORT'
)
(0x01000013):ZOI.3.TIXTestData = (
(0x0300000B):ZOI.3.1.TIXTestNumber = '829574'
(0x0300000B):ZOI.3.2.TIXTestName = 'MONOGR'
(0x0300000B):ZOI.3.3.TIXTestStatus = 'I'
(0x0300000B):ZOI.3.4.OrderedItemName = 'Monogram Trofile'
)
(0x01000013):ZOI.3.TIXTestData = (
(0x0300000B):ZOI.3.1.TIXTestNumber = '551697'
(0x0300000B):ZOI.3.2.TIXTestName = 'GENOSU'
(0x0300000B):ZOI.3.3.TIXTestStatus = 'R'
(0x0300000B):ZOI.3.4.OrderedItemName = 'GenoSure'
)
(0x01000013):ZOI.3.TIXTestData = (
(0x0300000B):ZOI.3.1.TIXTestNumber = '998085'
(0x0300000B):ZOI.3.2.TIXTestName = 'VENIPU'
(0x0300000B):ZOI.3.3.TIXTestStatus = 'S'
(0x0300000B):ZOI.3.4.OrderedItemName = 'Venipuncture'
)
(0x01000013):ZOI.3.TIXTestData = (
(0x0300000B):ZOI.3.1.TIXTestNumber = 'X14500'
(0x0300000B):ZOI.3.2.TIXTestName = 'MDP30'
(0x0300000B):ZOI.3.3.TIXTestStatus = 'S'
(0x0300000B):ZOI.3.4.OrderedItemName = 'Oxon Hill,MD 301-567-2819'
)
)
(0x01000013):EOP = (
(0x0300000B):EOP.2.MessageControlID = '0427'
(0x0300000B):EOP.3.FutureField = ''
(0x0300000B):EOP.4.FutureField = ''
(0x0300000B):EOP.5.FutureField = ''
(0x0300000B):EOP.6.FutureField = ''
)
(0x01000013):EOF = (
(0x0300000B):EOF.2.FutureField = ''
(0x0300000B):EOF.3.FutureField = ''
(0x0300000B):EOF.4.FutureField = ''
(0x0300000B):EOF.5.FutureField = ''
(0x0300000B):EOF.6.FutureField = ''
)
|
I defined ZOI.3.TIXTestData as:
Complex Type, All Elements Delimited, Group Terminator: <HL7_RS>,
Delimiter: <HL7_CS>, Suppress Absent Element Delimiter: End of Type, Observe Element Length is checked.
It is listing the tests in the trace, however, the Future fields are not as in the other segments. What am I missing? I have tried groups and nested complex types to no avail. I did not even get the test data to list out with the groups and nested complex types.
Last edited by wraymore on Thu May 14, 2009 7:45 am; edited 1 time in total |
|
Back to top |
|
 |
kimbert |
Posted: Thu Apr 16, 2009 1:56 pm Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
I presume your questions is 'Why do segments ZRL, EOP, EOF contain the FutureField components, but ZOI does not?'
Without a detailed understanding of your message model, it is hard to answer that question. You would need to provide full details of how the ZOI segment is modelled. If you want me to help, you will need to change this into a TDS problem instead of an HL7 problem.
So
- Remove all segments apart from ZRL and ZOI
- Remove all components which are not relevant to this problem
- Change the delimiters from <HL7_CS> etc to hard-coded values
- Create a test input message which demonstrates the problem
- Post the input message, the ( full simplified ) message model, and the Trace node output which results.
Sorry if that sounds like a lot of work. The alternatives are
- upgrade to v6.1.0.3 and see whether the TDS user trace output gives a clue
- raise a PMR |
|
Back to top |
|
 |
rekarm01 |
Posted: Thu Apr 16, 2009 10:18 pm Post subject: Re: TDS Question - field with sub fields and repeating |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 1415
|
Maybe this will help translate HL7 (v2.x) to TDS:- An HL7 message consists of one or more HL7 segments, each terminated with a segment terminator (default <CR>, no <LF>).
- An HL7 segment consists of a 3-character segment name, and one or more HL7 fields, each delimited by a field separator character (default <HL7_FS>, or '|').
- An HL7 field consists of one or more HL7 repetitions, each delimited by a repetition separator character (default <HL7_RS>, or '~').
- An HL7 repetition consists of one or more HL7 components, each delimited by a component separator character (default <HL7_CS>, or '^').
"ZOI.3.TIXTestData" is a repeating field. It should have Repeating Element Delimiter = <HL7_RS>, or '~'.
Each repetition consists of one or more components; it should have a complex type, with All Elements Delimited, Delimiter = <HL7_CS>, or '^', and Supress Absent Element Delimiters = End of Type.
Other miscellaneous observations:- Putting periods in element names can make ESQL references a bit messy.
- The HL7 standard numbers its fields differently, starting with 1; the element names should probably look more like:
Code: |
(0x01000013):ZOI = (
(0x0300000B):ZOI.1.NumberOfOccurences = '5'
(0x01000013):ZOI.2.TIXTestData = (
(0x0300000B):ZOI.2.1.TIXTestNumber = '100111'
...
) |
|
|
Back to top |
|
 |
wraymore |
Posted: Mon Apr 20, 2009 10:16 am Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
Thanks kimbert, I have switched my message model to TDS. Below are the items that you requested, at least I hope so.
Code: |
Input Message:
ZRL|1|Lab|Facility Name|Address^^City^NC^Zipplus4|phone nbr||Title^LName^FName^^^^degree|||||
ZOI|5|123456^TName1^TStatus1^OName1~234567^TName2^TStatus2^OName2~551697^TName3^TStatus3^OName3~998085^TName4^TStatus4^OName4~X14500^Tname5^TStatus5^OName5~||||
|
Code: |
Message Model:
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" Suppress Absent Element Delimiters="End of Type" Observe Element Length Not Checked
ZRL Min Occurs 1 Max Occurs 1 Tag="ZRL" Data Element Separation="Tagged Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZRL_2_Transmission_Sequence_Number Min Occurs 1 Max Occurs 1 string
ZRL_3_Facility_Mnemonic Min Occurs 1 Max Occurs 1 string
ZRL_4_Facility_Name Min Occurs 1 Max Occurs 1 string
ZRL_5_Facility_Location Min Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZRL_5_1_Facility_Address Min Occurs 1 Max Occurs 1 string
ZRL_5_2_Facility_Other_Designation Min Occurs 1 Max Occurs 1 string
ZRL_5_3_Facility_City Min Occurs 1 Max Occurs 1 string
ZRL_5_4_Facility_State_Province Min Occurs 1 Max Occurs 1 string
ZRL_5_5_Facility_Zip_Postal_Code Min Occurs 1 Max Occurs 1 string
ZRL_6_Facility_Phone_Number Min Occurs 1 Max Occurs 1 string
ZRL_7_Facility_Contact Min Occurs 1 Max Occurs 1 string
ZRL_8_Facility_Director Min Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZRL_8_1_Facility_Director_Title Min Occurs 1 Max Occurs 1 string
ZRL_8_2_Facility_Director_Last_Name Min Occurs 1 Max Occurs 1 string
ZRL_8_3_Facility_Director_First_Name Min Occurs 1 Max Occurs 1 string
ZRL_8_4_Facility_Director_Middle_Initial Min occurs 1 Max Occurs 1 string
ZRL_8_5_Facility_Director_Suffix Min Occurs 1 Max Occurs 1 string
ZRL_8_6_Facility_Director_Prefix Min Occurs 1 Max Occurs 1 string
ZRL_8_7_Facility_Director_Degree Min Occurs 1 Max Occurs 1 string
ZRL_9_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_10_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_11_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_12_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_13_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI Min Occurs 1 Max Occurs 1 Tag="ZOI" Data Element Separation="Tagged Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZOI_2_Number_Of_Occurrences Min Occurs 1 Max Occurs 1 string
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="~" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZOI_3_1_TIX_Test_Number Min Occurs 1 Max Occurs 1 string
ZOI_3_2_TIX_Test_Name Min Occurs 1 Max Occurs 1 string
ZOI_3_3_TIX_Test_Status Min Occurs 1 Max Occurs 1 string
ZOI_3_4_Ordered_Item_Name Occurs 1 Max Occurs 1 string
ZOI_4_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_5_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_6_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_7_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_8_Future_Field Min Occurs 0 Max Occurs 1 string
|
Code: |
Trace Node Output:
(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'LB8SAQG002001'
(0x03000000):MessageType = 'DOC1TDS'
(0x03000000):MessageFormat = 'TDS1'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2009-04-20 16:23:43.400'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'TEST.WELDON.IN.QL'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = 'MQSTR '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d5120514d4d53474441412020202049d9330f200a224a'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'QMMSGDAA '
(0x03000000):UserIdentifier = 'moorew '
(0x03000000):AccountingToken = X'0000000000000000000000000000000000000000000000000000000000000000'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 28
(0x03000000):PutApplName = 'WebSphere MQ Client for Java'
(0x03000000):PutDate = DATE '2009-04-20'
(0x03000000):PutTime = GMTTIME '16:23:43.400'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000021):MRM = (
(0x01000013):ZRL = (
(0x0300000B):ZRL_2_Transmission_Sequence_Number = '1'
(0x0300000B):ZRL_3_Facility_Mnemonic = 'Lab'
(0x0300000B):ZRL_4_Facility_Name = 'Facility Name'
(0x01000013):ZRL_5_Facility_Location = (
(0x0300000B):ZRL_5_1_Facility_Address = 'Address'
(0x0300000B):ZRL_5_3_Facility_City = 'City'
(0x0300000B):ZRL_5_4_Facility_State_Province = 'NC'
(0x0300000B):ZRL_5_5_Facility_Zip_Postal_Code = 'Zipplus4'
)
(0x0300000B):ZRL_6_Facility_Phone_Number = 'phone nbr'
(0x0300000B):ZRL_7_Facility_Contact = ''
(0x01000013):ZRL_8_Facility_Director = (
(0x0300000B):ZRL_8_1_Facility_Director_Title = 'Title'
(0x0300000B):ZRL_8_2_Facility_Director_Last_Name = 'LName'
(0x0300000B):ZRL_8_3_Facility_Director_First_Name = 'FName'
(0x0300000B):ZRL_8_7_Facility_Director_Degree = 'degree'
)
(0x0300000B):ZRL_9_Future_Field = ''
(0x0300000B):ZRL_10_Future_Field = ''
(0x0300000B):ZRL_11_Future_Field = ''
(0x0300000B):ZRL_12_Future_Field = ''
(0x0300000B):ZRL_13_Future_Field = ''
)
(0x01000013):ZOI = (
(0x0300000B):ZOI_2_Number_Of_Occurrences = '5'
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '123456'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName1'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus1'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName1'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '234567'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName2'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus2'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName2'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '551697'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName3'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus3'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName3'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '998085'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName4'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus4'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName4'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = 'X14500'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'Tname5'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus5'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName5'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '
'
)
)
)
)
|
|
|
Back to top |
|
 |
kimbert |
Posted: Mon Apr 20, 2009 11:26 am Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
Hi wraymore,
Thanks - good information there. I cannot give a definite reason for the difference, but I did notice this:
Code: |
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~"... |
In TDS, delimiters always occur *between* elements, and Repeating Element Delimiters always occurs *between* occurrences of the repeating thing. However, your input message looks like this:
Code: |
ZRL|1|Lab|Facility Name|Address^^City^NC^Zipplus4|phone nbr||Title^LName^FName^^^^degree|||||
ZOI|5|
123456^TName1^TStatus1^OName1~
234567^TName2^TStatus2^OName2~
551697^TName3^TStatus3^OName3~
998085^TName4^TStatus4^OName4~
X14500^Tname5^TStatus5^OName5~
|||| |
...with some line breaks added for clarity.
It is possible that the ~ after OName5 may be tripping up the parser. After seeing it, the parser will expect another ZOI_3. Might be worth removing it just to see what happens. |
|
Back to top |
|
 |
wraymore |
Posted: Mon Apr 20, 2009 11:55 am Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
Changed the input message to remove the "~" after the last OName5 and put to the input queue of the message flow.
Code: |
Input Message:
ZRL|1|Lab|Facility Name|Address^^City^NC^Zipplus4|phone nbr||Title^LName^FName^^^^degree|||||
ZOI|5|123456^TName1^TStatus1^OName1~234567^TName2^TStatus2^OName2~551697^TName3^TStatus3^OName3~998085^TName4^TStatus4^OName4~X14500^Tname5^TStatus5^OName5||||
|
However the output was the same
Code: |
From Trace Node:
(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'LB8SAQG002001'
(0x03000000):MessageType = 'DOC1TDS'
(0x03000000):MessageFormat = 'TDS1'
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2009-04-20 19:48:21.340'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'TEST.WELDON.IN.QL'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 273
(0x03000000):CodedCharSetId = 819
(0x03000000):Format = 'MQSTR '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d5120514d4d53474441412020202049d9330f200a224a'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'QMMSGDAA '
(0x03000000):UserIdentifier = 'moorew '
(0x03000000):AccountingToken = X'0000000000000000000000000000000000000000000000000000000000000000'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 28
(0x03000000):PutApplName = 'WebSphere MQ Client for Java'
(0x03000000):PutDate = DATE '2009-04-20'
(0x03000000):PutTime = GMTTIME '19:48:21.340'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x01000021):MRM = (
(0x01000013):ZRL = (
(0x0300000B):ZRL_2_Transmission_Sequence_Number = '1'
(0x0300000B):ZRL_3_Facility_Mnemonic = 'Lab'
(0x0300000B):ZRL_4_Facility_Name = 'Facility Name'
(0x01000013):ZRL_5_Facility_Location = (
(0x0300000B):ZRL_5_1_Facility_Address = 'Address'
(0x0300000B):ZRL_5_3_Facility_City = 'City'
(0x0300000B):ZRL_5_4_Facility_State_Province = 'NC'
(0x0300000B):ZRL_5_5_Facility_Zip_Postal_Code = 'Zipplus4'
)
(0x0300000B):ZRL_6_Facility_Phone_Number = 'phone nbr'
(0x0300000B):ZRL_7_Facility_Contact = ''
(0x01000013):ZRL_8_Facility_Director = (
(0x0300000B):ZRL_8_1_Facility_Director_Title = 'Title'
(0x0300000B):ZRL_8_2_Facility_Director_Last_Name = 'LName'
(0x0300000B):ZRL_8_3_Facility_Director_First_Name = 'FName'
(0x0300000B):ZRL_8_7_Facility_Director_Degree = 'degree'
)
(0x0300000B):ZRL_9_Future_Field = ''
(0x0300000B):ZRL_10_Future_Field = ''
(0x0300000B):ZRL_11_Future_Field = ''
(0x0300000B):ZRL_12_Future_Field = ''
(0x0300000B):ZRL_13_Future_Field = ''
)
(0x01000013):ZOI = (
(0x0300000B):ZOI_2_Number_Of_Occurrences = '5'
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '123456'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName1'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus1'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName1'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '234567'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName2'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus2'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName2'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '551697'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName3'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus3'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName3'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '998085'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'TName4'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus4'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName4'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = 'X14500'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'Tname5'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'TStatus5'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'OName5'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '
'
)
)
)
)
|
|
|
Back to top |
|
 |
kimbert |
Posted: Mon Apr 20, 2009 12:19 pm Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
I think it's time to raise a PMR. It may be something obvious, but if it is, then I can't see it. |
|
Back to top |
|
 |
wraymore |
Posted: Mon Apr 20, 2009 12:49 pm Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
Mr. Kimber, thanks for your help. I will enter a PMR. |
|
Back to top |
|
 |
rekarm01 |
Posted: Wed Apr 22, 2009 1:41 pm Post subject: Re: TDS Question - field with sub fields and repeating |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 1415
|
wraymore wrote: |
Code: |
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" ... |
|
"CR><LF>" looks like a typo.
wraymore wrote: |
Code: |
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="~" Delimiter="^" ... |
|
Group Terminator should be empty. |
|
Back to top |
|
 |
wraymore |
Posted: Thu Apr 23, 2009 5:13 am Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
rekarm01 wrote:
Quote: |
wraymore wrote:
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" ...
"CR><LF>" looks like a typo.
|
Yes, that was a typo, it is actually "<CR><LF>"
rekarm01 wrote:
Quote: |
wraymore wrote:
Code:
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="~" Delimiter="^" ...
Group Terminator should be empty.
|
When I removed the Group Terminator, the following resulted:
Code: |
(0x01000021):MRM = (
(0x01000013):ZRL = (
(0x0300000B):ZRL_2_Transmission_Sequence_Number = '1'
(0x0300000B):ZRL_3_Facility_Mnemonic = 'BN'
(0x0300000B):ZRL_4_Facility_Name = 'LabCorp Burlington'
(0x01000013):ZRL_5_Facility_Location = (
(0x0300000B):ZRL_5_1_Facility_Address = '1447 York Court'
(0x0300000B):ZRL_5_3_Facility_City = 'Burlington'
(0x0300000B):ZRL_5_4_Facility_State_Province = 'NC'
(0x0300000B):ZRL_5_5_Facility_Zip_Postal_Code = '272153361'
)
(0x0300000B):ZRL_6_Facility_Phone_Number = '8007624344'
(0x0300000B):ZRL_7_Facility_Contact = ''
(0x01000013):ZRL_8_Facility_Director = (
(0x0300000B):ZRL_8_1_Facility_Director_Title = 'MD'
(0x0300000B):ZRL_8_2_Facility_Director_Last_Name = 'Hancock'
(0x0300000B):ZRL_8_3_Facility_Director_First_Name = 'William F'
(0x0300000B):ZRL_8_7_Facility_Director_Degree = 'MD'
)
(0x0300000B):ZRL_9_Future_Field = ''
(0x0300000B):ZRL_10_Future_Field = ''
(0x0300000B):ZRL_11_Future_Field = ''
(0x0300000B):ZRL_12_Future_Field = ''
(0x0300000B):ZRL_13_Future_Field = ''
)
(0x01000013):ZOI = (
(0x0300000B):ZOI_2_Number_Of_Occurrences = '5'
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '100111'
(0x0300000B):ZOI_3_2_TIX_Test_Name = 'SPECIM'
(0x0300000B):ZOI_3_3_TIX_Test_Status = 'E'
(0x0300000B):ZOI_3_4_Ordered_Item_Name = 'STATUS REPORT~829574^MONOGR^I^Monogram Trofile~551697^GENOSU^R^GenoSure~998085^VENIPU^S^Venipuncture~X14500^MDP30^S^Oxon Hill,MD 301-567-2819~'
)
(0x01000013):ZOI_3_Ordered_Item_List = (
(0x0300000B):ZOI_3_1_TIX_Test_Number = '
'
)
)
)
|
|
|
Back to top |
|
 |
wraymore |
Posted: Thu Apr 23, 2009 10:33 am Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
PMR has been submitted. Will reply with solution. |
|
Back to top |
|
 |
wraymore |
Posted: Tue Apr 28, 2009 12:13 pm Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
No solution from the PMR (30779 499 000)
Quote: |
From Support:
I took a look at the problem description but it doesn't seem to relate to the product defect.
As you know, we are from product defect support organization. We are not equipped to assist on this matter.
I would like to suggest you to work with IBM Service to get additional help.
You can contact your sales rep to find the contact info or more info.
Regards,
Minsung
|
Will continue trying to figure out how to make this work.
Thanks for all of the help!!  |
|
Back to top |
|
 |
wraymore |
Posted: Thu May 14, 2009 7:44 am Post subject: |
|
|
Centurion
Joined: 16 Aug 2005 Posts: 114 Location: Burlington, NC USA
|
As stated by IBM support it was not a product defect. However they were able to determine why I was having the issue. I had the parent elements defined as Tagged Delimited which was telling the parser that the children would have tags. This was not the case. They instructed me to change the data element separation field to be "All Elements Delimited" and to remove the group terminator form the complex type for the field containing the repeats since it was defined as the Repeating Element Delimiter.
New Message Model:
Code: |
Message Model:
Message Data Element Separation="Tagged Delimited" TagLength="3" GroupTerminator="<CR><LF>" Delimiter="CR><LF>" Suppress Absent Element Delimiters="End of Type" Observe Element Length Not Checked
ZRL Min Occurs 1 Max Occurs 1 Tag="ZRL" Data Element Separation="All Elements Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZRL_2_Transmission_Sequence_Number Min Occurs 1 Max Occurs 1 string
ZRL_3_Facility_Mnemonic Min Occurs 1 Max Occurs 1 string
ZRL_4_Facility_Name Min Occurs 1 Max Occurs 1 string
ZRL_5_Facility_Location Min Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZRL_5_1_Facility_Address Min Occurs 1 Max Occurs 1 string
ZRL_5_2_Facility_Other_Designation Min Occurs 1 Max Occurs 1 string
ZRL_5_3_Facility_City Min Occurs 1 Max Occurs 1 string
ZRL_5_4_Facility_State_Province Min Occurs 1 Max Occurs 1 string
ZRL_5_5_Facility_Zip_Postal_Code Min Occurs 1 Max Occurs 1 string
ZRL_6_Facility_Phone_Number Min Occurs 1 Max Occurs 1 string
ZRL_7_Facility_Contact Min Occurs 1 Max Occurs 1 string
ZRL_8_Facility_Director Min Occurs 1 Max Occurs 1 Data Element Separation="All Elements Delimited" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZRL_8_1_Facility_Director_Title Min Occurs 1 Max Occurs 1 string
ZRL_8_2_Facility_Director_Last_Name Min Occurs 1 Max Occurs 1 string
ZRL_8_3_Facility_Director_First_Name Min Occurs 1 Max Occurs 1 string
ZRL_8_4_Facility_Director_Middle_Initial Min occurs 1 Max Occurs 1 string
ZRL_8_5_Facility_Director_Suffix Min Occurs 1 Max Occurs 1 string
ZRL_8_6_Facility_Director_Prefix Min Occurs 1 Max Occurs 1 string
ZRL_8_7_Facility_Director_Degree Min Occurs 1 Max Occurs 1 string
ZRL_9_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_10_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_11_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_12_Future_Field Min Occurs 0 Max Occurs 1 string
ZRL_13_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI Min Occurs 1 Max Occurs 1 Tag="ZOI" Data Element Separation="All Elements Delimited" Group Terminator="<CR><LF>" Delimiter = "|" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZOI_2_Number_Of_Occurrences Min Occurs 1 Max Occurs 1 string
ZOI_3_Ordered_Item_List Min Occurs 1 Max Occurs -1 Repeating Delimiter="~" Data Element Separation="All Elements Delimited" Group Terminator="" Delimiter="^" Suppress Absent Element Delimiters="End of Type" Observe Element Length Checked
ZOI_3_1_TIX_Test_Number Min Occurs 1 Max Occurs 1 string
ZOI_3_2_TIX_Test_Name Min Occurs 1 Max Occurs 1 string
ZOI_3_3_TIX_Test_Status Min Occurs 1 Max Occurs 1 string
ZOI_3_4_Ordered_Item_Name Occurs 1 Max Occurs 1 string
ZOI_4_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_5_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_6_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_7_Future_Field Min Occurs 0 Max Occurs 1 string
ZOI_8_Future_Field Min Occurs 0 Max Occurs 1 string
|
 |
|
Back to top |
|
 |
Vitor |
Posted: Thu May 14, 2009 7:53 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
Thank you for posting the solution!  _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
|