Hello All;

Trying to setup the exchange scheme jvimprt on my new 4c4 box.

Unfortunately, when we loaded the 4c4 box with our 3.1 data, it blew away the "default" exchange scheme.

Baan support provided documentation on setting this up, but theres several revisions of it referencing different tables (ie tfgld213 vs. tfgld936), and there's nothing thorough (ie detailing the condition scripts, etc).

I was hoping someone could shed some light on this exchange scheme.

I'm hoping someone here has this working correctly and could provide some decent setup documentation.

Thanks in advance!

Does anyone have an ODBC Excel Spreadsheet they've designed to load tables ttfgld213-ttfgld215 directly?

I imagine this would be easier from the end users perspective.

Here's the conditions text anyway. I have only the powerpoint on generating the schemes, same as you probably have. This refers to Baan solution # 150963


Condition: BATCHHDR
*********

table ttfgld213

extern string batcherr(1)

if rec.id = "B" then
batcherr = "n"
select tfgld213.*
from tfgld213
where tfgld213.idno = :idno
selectdo
if tfgld213.imst = tfgld.imst.l.error then
tfgld213.imst = tfgld.imst.l.free
return(true)
else
batcherr = "y"
return(false)
endif
endselect
return(true)
else
return(false)
endif

Condition: DOCHDR
*********

extern string batcherr(1)

if rec.id = "H" then
if batcherr = "n" then
return(true)
else
return(false)
endif
else
return(false)
endif

Condition: DOCLINE
**********

extern string batcherr(1)

if rec.id = "L" then
if batcherr = "n" then
return(true)
else
return(false)
endif
else
return(false)
endif

Here is the solution that is use:
copy the file below ending in .txt and make a DLL in Baan called tfgldolejvimp.

Then use the excel spreadsheet to upload it into Baan using OLE. When you press the baan icon inside the spreadsheet it will call you default BW to login.

This solution writes directly into the tfgld102. I've been using it for 5 or so years and it works great.

D'oh!

I guess I should've explained why I wanted to access via the ODBC directly - we're migrating from Triton and to minimize impact within our user community, we're going (staying) in ascii mode.

Thanks lbencic and mac_nt3333;

Update:

I was able to get the jvimprt scheme to compile and it's finally reading the files into tables tfgld213, tfgld214 and tfgld215.

I'd still like to look at implementing some kind of connector to populate these tables directly however, mainly for management purposes...

If anyone needs the screenshots of the everything I did to get the exchange scheme jvimprt finally working, please let me know...

please if any one have baaniv documentation standard or cables plz attach and send on
m.shehata@ibcmea.com
thanks everybody in advance !!!!!!

I'm starting the setup of JVimport, I was able to configure the Exchange scheme but was wondering if anyone had a sample import file (need format).

Thanks