Page 1 of 1

inventory import from UPC existing database

Posted: Fri Sep 23, 2005 10:46 am
by acpr483
Looking for help importing my existing data into DHPOS.
Not looking to start over with each inventory item unless I have to.

Thanks

Scott


Also, what is the structure of the exsting .tbl ??

Stock table file

Posted: Fri Sep 23, 2005 8:39 pm
by Dale Harris
acpr483,

If your current stock data is in an Excel file, or you can get it into one, then you are in luck. If you save it as a comma delimited .CSV file the POS program will be able to import into the stock table. Read this http://keyhut.com/postip6a.htm#export

Also when you unzipped the POS.EXE file and Excel file STOCK TABLE.XLS will have popped out. It is a blank sample Excel file that the POS program can read.

The stock table format is a little more problematical. In the FAQ section of the website there was a long description of the stock table format. But when the person hosting it dropped it, the new FAQ page does not have it. However here is some BASIC code that can be used to access the stock table sort of. Just remember that the first record is an index and does not hold the data for an item. If you need more of an explanation post here. Meanwhile I will try to work on a full description of the .TBL file for the FAQ page.

Type stocktable
descript As String * 24
price As String * 7
category As String * 1
taxtype As String * 1
piecessold As Long '4
valuesold As Long '4
vendorid As String * 1
inventorycount As String * 4
stocknumber As String * 18
cost As Long '4
model As Long '4
pack As Long '4
vendorstock As String * 30
saleprice as Long '4
junk as String * 10
End Type

DIM rec as stocktable
INPUT "Enter full filename", acf$
open acf$ for random shared as #1 len = 120
INPUT "Enter record number to retrieve", xa$
x% = int(xa$)
GET #1, x%, rec
PRINT rec.descript
PRINT int(rec.price) / 100
END