# Create FF Schema with no Record available from FF

**URL:** <https://techcommunity.softwareag.com/t/create-ff-schema-with-no-record-available-from-ff/108484>\
**Category:** Forum\
**Tags:** EDI\
**Created:** [June 23, 2005, 2:44pm UTC](https://techcommunity.softwareag.com/t/create-ff-schema-with-no-record-available-from-ff/108484 "2005-06-23T14:44:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rangoon](https://avatars.discourse-cdn.com/v4/letter/r/77aa72/32.png) [@rangoon](https://techcommunity.softwareag.com/u/rangoon)\
**Post date:** [June 23, 2005, 2:44pm UTC](https://techcommunity.softwareag.com/t/create-ff-schema-with-no-record-available-from-ff/108484/1 "2005-06-23T14:44:16Z")

</div>

Hello,

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
```

note :

- 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
```

Thanks ![](http://www.wmusers.com/wmusers/messages/117/50237.gif)

---

<div class="post-metadata">

**Author:** ![rangoon](https://avatars.discourse-cdn.com/v4/letter/r/77aa72/32.png) [@rangoon](https://techcommunity.softwareag.com/u/rangoon)\
**Post date:** [June 23, 2005, 3:25pm UTC](https://techcommunity.softwareag.com/t/create-ff-schema-with-no-record-available-from-ff/108484/2 "2005-06-23T15:25:35Z")

</div>

OK, I found the solution.

For those having this question (and for myself later on), here it is.

Actually, if WM can not match your flat file against the Schema you have defined, it will look if you have set a “Schema Properties / Default Record / Dictionnary” value.

## A “Default Value” (explained page 43 in “Flat File Schema Developers Guide.pdf”) is a dictionnary that will define you flat file as is should be. In My case, I just recreated a Dictionnary in wich I added a “Record Definition” that exactly reflects what I already did for the Schema (see screen shot in my previous post). Then I followed the procedure stated page 43 in the Guide :

## 2 Under Default Record, configure the following properties: To specify properties for the flat file schema Property Description Set Optional - Under Value, click Set to select the default record for this flat file schema from a flat file dictionary. This record is used to parse an undefined data record when the convertToValues service fails to find a match between the flat file and the flat file schema. If the default record is specified when creating the flat file schema, any record that cannot be recognized will be parsed using this default record. If a default record is not selected, the record will be treated as undefined data. If the Undefined Data property is set to False and the validate variable of the convertToValues service is set to true, convertToValues will generate errors when it encounters undefined data. For more information about the Undefined Data property, see page 44.

C U

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:05pm UTC](https://techcommunity.softwareag.com/t/create-ff-schema-with-no-record-available-from-ff/108484/3 "2021-04-02T15:05:15Z")

</div>


