Jump to content


Photo

Importing of data


  • Please log in to reply
No replies to this topic

#1 sblair

sblair

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 24 January 2008 - 08:51 AM

I need to import our Inventory, Bin, Customer and Suppliers data into MOM using dbuwin. Here is who I think it can be done.
I have exported the following tables in order to help me format our data: stock.dbf, bin.dbf, inventor.dbf, suppliers.dbf cust.dbf.

I'm probably going to import the stock information using the Import/Export module. I will be importing the Distrib and Diststock fields.

I believe that I can append the Supplier information into the directly in to the suppliers.dbf table without any trouble. With this import I believe Distrib fild from the stock.dbf must match the Code field in the suppliers.dbf. Am I correct?

With customers I think can be imported directly into the dbf if I'm not tacking any history with me. It also looks like customers can be imported via the import/export module?

When importing bin numbers would I have to create a relationship with the the BIN_ID field in the Inventor.dbf table and the BIN_ID in the bin Bin.dbf table. Also what is the purpose of the bin field in stock.dbf? I have set up some test items with test bins and that field is not populated. Also what exactly dose the inventor.dbf table do?




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users