We would like to be able to import from a spreadsheet, new items into the Item data table, to create new parts with all the mandatory fields populated. This is because we develop our bids in Excel and only update Baan after we have won the order, and the keying in is time consuming.
Has anyone done it with either an exchange scheme or Baan script?

Not for loading items, but we use Excel a lot for prepping data to loaded into Baan. My preference is to write a API type function server to read a file and insert the data using the Baan sessions. Check out the AFS forum.

We use exchange, but then you have to make sure you get all the supporting tables loaded. Creating exchange schemes is probably no harder than the first option.

Mark

Thanks I'll check it out :rolleyes: