I would like to get recommendations in uploading data into Item Master; BOM; and Supplier Master Data. Thank you.

best bet is AFS application function servers, do a search on the board there are plenty of examples.

Thanks, Darren. I'll check it out.

Is there a simpler way to upload data of Item Master; BOM; and Supplier Master Data other than AFS if the data to be uploaded coming from our customer using IVc4 as well? Thank you.

If you know all the tables which needs to be updated, then you can go in for exchange schemes else as said earlier AFS is best bet. Altough it looks scary, the more u get use to it , more simpler it becomes.

Hi,

If the uploaded data is comming from Baan you might try to use "Create Sequential Dump of table" (ttaad4226m000) to export the data from your customer & "Create Table from Sequential Dump" (ttaad4227m000) to import the date into your Baan. I didn't use them my self before so it will be good if you read the help first and try some tests...

I hope it helps,

- George

M2,

You have not specified your DB name. You can take DB utilities help.

To extend George's statement, You can add your data in .s file without touching to first line and run Create Table.. in Append mode.

regards,

-Suhas

Hi,

You can try dataload. It's very easy to use.
You can download it from dataload.net and it's a free software :)

All you have to do is simulate the data that you want to input in the session,
e.g: you have to click new, input the data, press tab, input the data, press tab, save.

All this steps you have to simulate it in the dataload, just type NEW for new and type TAB for tab process. You can change the command in the dataload.

And when you done, choose the window(baan session) and then click "send data to form"

Enjoy....

Regards,
Agoes

hi,

You need to check if your client too has same table definition before using the Create Table from Seq. Dump option.

Moreover, for Item Master the affected tables are tiitm001 & tiitm100.
For Supplier master the only table affected is tccom020.

regards,

I think that best way is AFS. Other methods have risk for your system. In others you should known data structure of tables. You should examine related tables that concern with main tables. That's why best way is AFS.
Lastly , you should do these operations in TEST COMPANY.

Good luck !