baantl
11th July 2008, 09:51
hi all expert
How to use exchange scheme from 1 csv file import into 3 tables? table is tfgld213, tfgld214, tfgld215 and the table can diffenciat at B = Batch, H = Header, L = line. will highly appreaciate to all .
eg : the indentify field is idno, all 3 table have the same field
B|..... go to table tfgld213
H|..... go to table tfgld214
L|..... go to table tfgld215

how to write the condition in the exchange scheme?

Felipe_Saavedra
11th July 2008, 14:35
Attached you will find a document about a standard exchange import to loas the tables you are talking about it is called JVIMPRT.

Sorry my notes are in Spanish but you could follow the samples, since they are screen shots.

I have also an application to integrate external Excel® csv files with Baan Finance, email me if you need more info.

Felipe Saavedra

baantl
12th July 2008, 03:54
Hi Felipe Saavedra
Thank for you attactment. I already get the idea and done it.