Is any one out there using Office integration with Baan IV c4? We are toying with the idea of pushing some data into baan finance from spreadsheets. Would appreciate word of wisdom from other members.

Hi,

we've created a device in Baan called Excel.
Device type is rewrite file.
4gl program is ttstpconv
argument is ASCII:excel
path is excel.txt

We're on Unix so the only way this is working is if the user is using the GUI interface of Baan.

PB

Dear mrinmoygupta,

as I understand, you want to import data from an external file (e.g. csv or txt) into finance tables e.g. in the FBS Modul (Finance Budgeting and Simulation e.g. tffbs101).

You can use the BaaN IV Utilities Exchange Schemes.

You define an Exchange Scheme, field relation ascii file to table fields.

You can also program some code within the conditions e.g. to modify values before importing them depending on some data within BaaN IV tables.

Exchange Scheme is a full GUI Interface with logging functionality (inserted, updated, rejected) with detailed error information like relation does not exist e.g. account in import file does not exist in general ledger.

Regards,

Kozure

Or you can install the Office Integration tool from Infor which allows you to push data from Excel to Baan directly without having to use Exchange.