Hi ALL,

we have one customer going to start wih LN ,so we want to import item data from ASCII file .As you know ,in BAAN 4 there ware 2 tables to import so was more easy ..now there are many tables related to item to import ,is there any easy way of importing item data in Ln?

Still through exchange scheme, remember to turn on the "DAL".

You can set the item defaults data first. If you do so, once you import the data into item general data (tcibd001), all other tables are filled in automatically.

Thanks for your info \what does it mean to turn on DAL _SORRY NO EXPERINCE on Ln

Still through exchange scheme, remember to turn on the "DAL".

You can set the item defaults data first. If you do so, once you import the data into item general data (tcibd001), all other tables are filled in automatically.

turn on the "DAL" means

in session "Tables Relations(Import)", check the field "Import via DAL".

Yeah, DAL is a good tools to validate data when import data in baan system.

we created import scheme with DAL check ,dont know why but system makes problem on project field which should be empty ..any idea?

You are not dealing with a technical problem here. This is purely functional data mapping now.

Are you importing standard or customized items from BAAN IV?
In LN the item field is split into two segments: a project segment and an item segment. In this way all items (standard and customized) can be stored in one table (tcibd001) and the same table. In BAAN IV they were two separate tables.
However, the first eight positions in the "Item" field in tcibd001 have been reserved for the project segment and after that the item segment will start.

What else are you trying to convert from IV to LN?

When we had to port large amount of item data from BaanIV to BaanERP, we:
set the Item Default Data for all target item group
created the General Item Data in spreadsheet program & saved it in flat text format
created an API-powered script that reads the text file and fill in the fields in General Item Data session
Just another alternative for you to consider :)

Rgds,
Paul

Hi,

How about Infor Migration Tool.. Is it worth to go for?

Regards

skbn

Migration tool only make sense when you want to port all the existing transaction data to Ln. If you only want to port static data and opening balance, migration tool is not necessary.