In “Flat File Schema Developers Guide.pdf”, it is stated, page 47 :
4 In the Enter Record Definition Name(s) dialog box, type the name of the record.
Important! This name must match the value of the identifier for each record exactly as it
will appear in the flat file. The name of the record reference does not have to match
the name of the record definition in the flat file dictionary. The name of the record
reference will be matched to the record identifier in the record. The name of the
record definition in the flat file dictionary does not need to match the record identifier
that appears in the flat file.
In Developper I created a FF Schema.
The problem is that it requieres the Record has the name of the Value.
i.e. in the sample here below, if xxxxxxxxxx was fixed, it should be the record name.
DELVRY # DELdateSI PO # Line Qty N Cust PO # [..............][......][........][...][............][.][.][........] xxxxxxxxxx 08032005SI6594402 000100000000001,000N 8731123456 xxxxxxxxxx 09032005SI6630664 000100000000002,000N 1596123456 xxxxxxxxxx 09032005SI6630664 000200000000001,000N 3456123456
- xxxxxxxxxx is a dynamic value representing Delvery Note number.
- xxxxxxxxxx never starts with a common value enabling the use of “Record” Value
Can anyone explain me how am I to create my Schema ?
ScreenShot attached show you what I have done yet.
“Line” indicate the Record. If I would apply what the Guide says, it would mean that each record (actually a line) should start with the string “Line”, i.e. from the example above, I would have :
Line 08032005SI6594402 000100000000001,000N 8731123456 Line 09032005SI6630664 000100000000002,000N 1596123456 Line 09032005SI6630664 000200000000001,000N 3456123456