ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Import Inventory with "Entered Date"
http://www.istechforum.com/YaBB.pl?num=1270741706

Message started by daletone on 04/08/10 at 08:48:26

Title: Import Inventory with "Entered Date"
Post by daletone on 04/08/10 at 08:48:26

We are trying to import our inventory items from another program into DBA, while still retaining data which is important to us such as initial product entry date (not import date) and entered user.

It is my understanding that this information is stored in 2 fields in the inventory table: PROD_VEND[9] and PROD_VNAM[9]. The problem is DE-B does not allow those fields for import.

Does anyone have a way to import inventory items while assigning an "entered date" in PROD_VEND[9] and the associated history data in PROD_VNAM[9]?

Alternatively, does anyone have a BETTER way of getting this information into DBA?

Title: Re: Import Inventory with "Entered Date"
Post by dameng on 04/08/10 at 09:37:20

yes, it can be done thru an ODBC connection and using a SQL manager.

I'd suggest using the DE-B import for al the data that you can import, so that way the program can update all required fields as well as perform proper error checking. after those steps are completed, then use an external SQL manager to import and relate your extra data you desire.

Title: Re: Import Inventory with "Entered Date"
Post by daletone on 04/09/10 at 07:02:44

Thanks Dave. We will try this method of SQL manager. Appreciate the suggestions, this will hopefully save us some time and frustration.