HI guys,
I have created a schema which would parse a file with each record being of 1304 characters. In addition to fixed length, they are line delimited as well.
Now, the characters/fields inside each record can be identified with only thier positions.
i have created the schema in which i have selected fixed length as type of record. I have left all other options in the Flat file Defination window as empty.( i am using webMethods 7.x developer).
Coming to flat File structure window, i have created each of those fields with extractor being the position.(1-3,3-6…etc).
But when i try to run the schema or use the converttoValues, it eventually errors out saying “No valid records found”…
I have tried to use Delimted instead of fixed lenght…but same problem…
Basically,
Its a text file with .txt extension.
please see attached txt file for details.
Its fields are basically position based and i have created schema according to it.
But no matter what i am unable to get rid of this errror “No valid Records found”. myname.txt (1.28 KB)
HI RMG,
Thanks for your help,
Basically i have created a schema in which i have defined a record name.
Under the record, i have defined fields based on Positions.
For example , field 1 starts from 0-3, field 2 from 3-4 etc.
You have to define the record name as “recordWithNoID” (maxRepeat=1 or ulimited) and beneath this create the FieldDefinitions and try it…When i looked at your data there is no record identifier exist,so recordWithNoID is the option to parse the file correctly.
RMG,
Thanks again,
I did what you said , and it still gives the error…
I have attached the schema in the package.
If you could look at it and point out what is amiss , i would be reaalllly grateful dummyPackage.zip (5.29 KB)
When i use your schema in your dummyPackage.zip, also have the same issue“Found no valid records”. I try to fix it and find the way to fix it.
There are two things you got to do:
create a flat file dictionary.
2.To set the default record, open the flat file schema and click on the tab of the schema so that you see the properties for the entire schema. You will see a property called ‘Default Record’. You will need to click the Set… button under the Value column and then choose the corresponding record in your dictionary. dummyPackage.zip (11.3 KB)
Hi
Can anybody explain me why such a case works perfectly fine with a FF dictionary reference in the schema,but when we r creating a schema in a regular way without referring to the dictionary its throwing this error…
Recently I created a tab delimited FF schema having only 3 fields…my PL asked me not to use dictionary for such a small schema ,but it didn’t work without the FF dict reference(was throwing this error)…So I again created a new FF schema with FF dict reference…
FFSchema should work independently with out Dictionary also…
Not sure why you are getting the error.
May be your schema not matching exactly per the file sample you are testing against? And obviously flatfile:convertToValues parsing (data issue or delimiters or other simple reasons) could cause that error.So you should debug and run sample file with it:
