|
Size: 648
Comment:
|
Size: 779
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = OFFICE CHOICE DATA IMPORT = | |
| Line 3: | Line 4: |
| Stock import: | == Stock import: == |
| Line 5: | Line 6: |
| sql.exe "select code,sup_code,c_code,name,per,sg_code,n_cost,on_h,lpo_date,lm_date,lr_date,price from stock;" > stock.txt | sql.exe "select code,sup_code,c_code,name,per,sg_code,lpo_date,n_cost,lm_date,on_h,lr_date,price from stock;" > stock.txt seperate the dates like that because of the stupid fixed width output and pre 2000 dates |
OFFICE CHOICE DATA IMPORT
Their data is in some sql flat file database and comes with dos apps to extract it with.
Stock import:
To generate the data use this command:
sql.exe "select code,sup_code,c_code,name,per,sg_code,lpo_date,n_cost,lm_date,on_h,lr_date,price from stock;" > stock.txt
seperate the dates like that because of the stupid fixed width output and pre 2000 dates
Inside stock.txt is hopefully data for all those fields in fixed with format. However since this data and programs are from 1991 the dates are all fubared and so stuff for say 26th july 2006 will come out in teh format, 07/26/106, this also frells with the fixed with output so you need to manually adjust the headings to make them align before trying to open it with excel.