Flat File Schema validation error

, ,
1

Hello all,
I’m getting the following error when iam trying to validate a Flatfile using the FlatFile Schema.

Could not run ‘newFFschema’.
com.wm.ff.parser.ParseException: [FFP.0012.0004] Found no valid records.

My FlatFile is as follows:
12345,Pant,500,Sudheer,9395510415
34567,Shirt,600,Amrutha,7702720090
45678,UnderW,700,Srinadh,9533492964

I have used NthField extractor and Delimiter(,) for filed and (newline) for record.
Record named as ‘ORDER’
and File named as ‘Flatfile_ORDER’ with no extension and also tried with ‘.txt’ extension

Plz… Just resolve with this issue.

Thanks in advance

2

Hey,

While creating Schema have you set ff Dict where you defined your fileds???

Once you do it… create a docType and provide it in convertTo Value …

–Shaik

3

It means that the line of your files should begin with ‘ORDER’:

ORDER12345,Pant,500,Sudheer,9395510415
ORDER34567,Shirt,600,Amrutha,7702720090
ORDER45678,UnderW,700,Srinadh,9533492964

The begining of your lines must start with the record’s name…

But without modifying your file, you can convert your file by modifying your schema with the “Default Record” property of your schema, but you need to define a dictionnary first.

4

Really very very thanks to “arnaud”. It is working for me.
I have broken my head for many days.
Thank you very much

5

Hi Adhitya,

can you please tell me how to create a default record in FF dictionary and how to use it in FF Schema?

Regards,
raja

6

Issue resolved.

Thanks,
Raja