I have a problem, i have a xsd with multiple records, the structure of flat file is:
MSH
NTE [0 to unbound]
PID
{
ORC
TQ1
OBR
OBX [0 to unbound]
} [0 to unbound]
I put a secuence in a structure delimited by {} but i dont know to do the NTE and OBX sequence because if i put unbount NTE all headers bellow are NTE and if i put in OBX the same.
I dont know how to do the structure.
Anyone can help me?
The easiest way to create flat file schema, is you create the flat file that you need (.txt) and import in Biztalk with wizard.
The key to structured flat files is using Tag Identifiers. A character sequence that the parser can use to identify a record type so that it knows when it has finished with a recurring set of records.
Can you post a short example of your flat file?
MSH|aaaa|bbbb|cccc|dddd|eeee|ffff|gggg
NTE|aaaa|bb|ccc
NTE|aaaa|bb|cccc (0 to unbound)
PID|sdasd|fasdas|sdfsdf|ferer|dfsers|fsersd|dsfsres|sdfser|sdfetq|adee|fsaerr
ORC|fisrt|time|dfaswr|asd
TQ1|asdaa|asda|free|
OBR|ada|aa|eedd|zzzz|xxxx|rrfra
OBX|aaa|bbbb|ccc
OBX|aaa|bbb|cccc
OBX|afrrr|fffee||
ORC|second|time|dfaswr|asd
ORC|third|time|dfaswr|asd
OBX|sea|sra|ffrtg
this is an example of my flat file
Here is a sample schema show the basic structure:http://cid-4e9c10425c5f8e8f.skydrive.live.com/self.aspx/Public/StructuredFlatFile.zip
Thanks, I solve the problem with Tag Identifier but if the node NTE or TQ1 (the two nodes with min Occurs = 0) not appear in the flat file throw an error:
Error
Source: Flat file disassembler
Message: An error occurred when parsing the incoming document: "Unexpected data found while looking for:
'TQ1'
'ORC'
The current definition being parsed is HL7_OML_O21. The stream offset where the error occured is 961. The line number where t
he error occured is 14. The column where the error occured is 0.".
HRESULT: c0c0146a
Any idea?
I solve the problem with a choice and sequence combination. I put the solution for other users with the same problem.