FlatFile Schema for a file that contains many files

, ,
1

Hi,
I’m having trouble defining a FF Schema for a file that has the following structure:

Multiple occurences of the following in the same one file:
Header - [Identifier: 0, Max Occurs: 1]
Detail - [Identifier: 2, Max Occurs: Unlimited]
Trailer - [Identifier: 7, Max Occurs: 1]

So, in other words, the file contains a DocumentList of:

Beginning of File
1 Header/Multiple Details/1 Trailer;
Another Header/Multiple Details/Another Trailer;
Another Header/Multiple Details/Another Trailer;
Another Header/Multiple Details/Another Trailer;
Another Header/Multiple Details/Another Trailer;
End of File

Does anyone know how to define the schema to reflect this ?? I’ve been trying for a couple of days now with no luck.

Any help is appreciated.
Cheers,
David

2

When you are creating record definitions in flatfile schema/Dictonary set property maximum reapeat to unlimited for detail record

3

Hi Sai,
That’s the easy part. I don’t think you read my original post correctly… Please take note of the "Beginning of File" and "End of File" positions in the example below…

Beginning of File ← This indicates the top of the flat file
[1 Header record/Multiple Detail records/1 Trailer record]
[1 Header record/Multiple Detail records/1 Trailer record]
[1 Header record/Multiple Detail records/1 Trailer record]
[1 Header record/Multiple Detail records/1 Trailer record]
[1 Header record/Multiple Detail records/1 Trailer record]
End of File ← This indicates that there are no more records in the file…

David

4

Hi,
I think there might be some confusion about the structure of the files that I am working with. There are three different record types in the file (0 - Header RecType, 2 - Detail RecType & 7- Trailer RecType)

The following is an actual file with pertinent data replaced

0 01XXX xxxxxxxxxxxxxxxxxxxxxx 072907 123456999-999999999 2999-999999999 6130000082063DataName Xxx Xxx Ssss XXX 111-222333444555More Data 7999-999 000008206300000000000000082063 000001 0 01XXX xxxxxxxxxxxxxxxxxxxxxx 180342 123456999-999999999 2999-999999999 6130000258258DataName Xxx Xxx Ccc XXX 111-222333444555More Data 2999-999999999 6130002407620DataName Xxx Xxx Ccc XXX 111-222333444555More Data 7999-999 000266587800000000000002665878 000002 0 01XXX xxxxxxxxxxxxxxxxxxxxxx 180343 123456999-999999999 2999-999999999 6130000301148DataName Xxx Xxx SAaa XXX 111-222333444555More Data 2999-999999999 5130000117711DataName Xxx Xxx SAaa XXX 111-222333444555More Data 2999-999999999 6130000236489DataName Xxx Xxx SAaa XXX 111-222333444555More Data 7999-999 000065534800000000000000655348 000003 0 01XXX xxxxxxxxxxxxxxxxxxxxxx 180344 123456999-999999999 2999-999999999 6130000273069DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 6130000358317DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 6130000304706DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 6130000295708DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 3130000641029DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 6130001272117DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 6130000264446DataName Xxx Xxx TNzz XXX 111-222333444555More Data 2999-999999999 6130001035613DataName Xxx Xxx TNzz XXX 111-222333444555More Data 7999-999 000444500500000000000004445005 000008 0 01XXX xxxxxxxxxxxxxxxxxxxxxx 180345 123456999-999999999 7999-999 000000000000000000000000000000 000000 0 01XXX xxxxxxxxxxxxxxxxxxxxxx 379798 123456999-999999999 7999-999 000000000000000000000000000000 000000 0 01XXX xxxxxxxxxxxxxxxxxxxxxx 379847 123456999-999999999 7999-999 000000000000000000000000000000 000000
5

So what is the issue here are you unable to create a FFSchema or parsing for this format?

What you have given is the record structure in the same hierarchy?

0 (max repeat unlimited for the header)
–>2 (max repeat unlimited)
–>7 (Trailer max repeat is RM

HTH,
RMG

6

David,

Yes what RMG has given correct parse. even if you find difficult with parsing data.check schema definition Ordered property shold set to true

7

Tricky data structure for a flatfile…
As Sai suggested, set the Ordered property to ‘true’. Let us know your findings.

-Senthil

8

Hi,
I’m confused. I know I tried that previously and it didn’t work properly. I’ve tried it again and it now works… I must of have not had one of the flags set correctly before…

 Thanks guys.

Cheers,
David

9

Step by step flat file parsing, creating a Dictionary, Schema…

http://idnxchange.com/webmethods-blogs/step-by-step-flat-file-parsing-in-webmethods-82.html