Using WmFlatFile to parse delimited records with no ID

Greetings All,

This is probably an FAQ, but I can’t find references to the topic easily it seems.

We have a flat file of delimited records with no record identifiers. I am looking or pointers on how to use WmFlatFile to parse this sort of data.

I have seen reference to property, but I can’t find any evidence of the existence of this anywhere despite looking hard. Also, I cannot for the life of me find the property and so on.

The point is that I don’t know how to set up the flat file schema to deal with this simple case.

I imagine this is a very frequently encountered task. The standard documentation does not seem helpful in this area. Anybody with more experience than me able to set us straight?

Using IS 6.5.

Thanks in advance for any assistance.

cheerio
Andrew

http://www.wmusers.com/wmusers/messages/117/12282.shtml

Yes, you won’t find the mention of recordWithNoId in any of the Flat File Adapter documentation but it is mentioned in the EDI BIS Reference doc and is discussed very often on wMUsers.

Hi,

The steps getiing data from flat file

  1. open the flatfile

  2. read the record upto what you mentioned special charactor

  3. prepare Doc type which you need get from flat fine or which u need store in database table

  4. Specify in doc each feild wt is starting postion wt is ending position

  5. insert the database up to end of the record