# Generate Csv file from FlatFile Schema

**URL:** <https://techcommunity.softwareag.com/t/generate-csv-file-from-flatfile-schema/108260>\
**Category:** Forum\
**Tags:** EDI\
**Created:** [November 11, 2003, 2:00am UTC](https://techcommunity.softwareag.com/t/generate-csv-file-from-flatfile-schema/108260 "2003-11-11T02:00:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\
**Post date:** [November 11, 2003, 2:00am UTC](https://techcommunity.softwareag.com/t/generate-csv-file-from-flatfile-schema/108260/1 "2003-11-11T02:00:42Z")

</div>

Hi,

I have a schema with one record defined as “recordWithNoID” containing 18 fields.  
I need to parse this flat file:  
00191893;337753;0811;11/08/03;BRL;+40792,16;-44272,06;+70411,77;+66931,87;841107118; ; ; ; ; ; ; ;00010  
The FlatFile Definition is set:  
RecordParser = delimiter  
record = newline  
fields = ;  
When i test the parser, occur this error: “Found no valid records”  
How can I do to run this??

Thanks

---

<div class="post-metadata">

**Author:** ![sivaram\_kandula](https://avatars.discourse-cdn.com/v4/letter/s/7ba0ec/32.png) [@sivaram\_kandula](https://techcommunity.softwareag.com/u/sivaram_kandula)\
**Post date:** [November 11, 2003, 2:42am UTC](https://techcommunity.softwareag.com/t/generate-csv-file-from-flatfile-schema/108260/2 "2003-11-11T02:42:08Z")

</div>

Hi,  
I believe that you have not created a FlatFileDictionary.  
Create a FlatFileDictionary with the recordname as recordWithNoID.Then create the field definitions and select the Extractor Type for the Field Definition(s) as Nth Position and set the postion of the field in the flat file starting from index 0.

Then create a flat file schema:  
RecordParser = delimiter  
record = newline  
fields = ;

In the Settings tab of the FlatFileSchema select the default record pointing to the FlatFileDictionary created above.

Then you can test your schema by clicking on the Test tab in the FlatFileSchema object and browse the CSV file.

Thanks  
sivaram

---

<div class="post-metadata">

**Author:** ![Guest](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/guest/32/75_2.png) [@Guest](https://techcommunity.softwareag.com/u/Guest)\
**Post date:** [November 12, 2003, 6:36pm UTC](https://techcommunity.softwareag.com/t/generate-csv-file-from-flatfile-schema/108260/3 "2003-11-12T18:36:40Z")

</div>

Thanks for help…It works fine!

---

<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/generate-csv-file-from-flatfile-schema/108260/4 "2021-04-02T15:05:08Z")

</div>