:confused: hi all
can someone suggest how can i import a flat file using a program script. what i m trying to achieve is that instead of using the Exchange scheme to import the flat through job Management, i want a session should be used which would take the data from the flat file and import the data.

Regards
Gauravjit

Hi,

Importing flat files into Baan is possible.

Just format the flat file in the correct way, and use $BSE/bin/bdbpost6.x to post the file into the desired table. You can first dump the table using bdbpre6.x (use the pipe "|" separator) - this dump file will give you an example of the correct format of the flat file.

Now, you just need to be careful which table(s) you are updating. Sometimes references need updating in other tables (eg. tools tables), and information also needs uploading into these tables also.

So this can be a bit tricky, and in fact probably the reason why the Baan Exchange Modules were developed in the first place.

Let us know what table you want to update and with what information.

Cheers,

James

You can also use the seq.xxx functions to import/export data. The coding for this would be more difficult as you'll have to parse each line in the import file, but I've found these quite useful for specific tasks.

Check Baan's 4GL help for more details...

Neil Pengelly

Hi:

I have use TCL/TK with expect extension. to simulate a keyboard capture (indeed the flat file ASCII) to enter datas in a BaaN Session.

Bien le bonjour
Marcel