|
Size: 654
Comment:
|
Size: 1167
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: | Note: there's crap at the end of the sql output which you should remove also. |
| Line 5: | Line 6: |
| == Stock import: == | |
| Line 9: | Line 11: |
| now because this program is from 1991 the date format totally screws up with 2000+ dates and needs to be fixed because it it frells the fixed width formatting and I noticed dates and data would be chopped off when importing to excel, anyways this simple command fixes dates in teh format of mm/dd/'''1'''yy to become mm/dd/yy | |
| Line 10: | Line 13: |
| 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. | cat stock.txt | sed 's/\([0-9][0-9]\/[0-9][0-9]\/\)1\([0-9][0-9]\)/\1\2/g' > stockdatefixed.txt You shouldn't need to fix up the alignment after that but check it anyways before importing into excel. == Debitor import: == sql.exe "select code,name,add1,add2,sub_state,state,pcode,d_name,d_add1,d_add2,d_sub_state,d_state,d_pcode,phone1,phone2,fax,car,email,contact,abn,cr_limit,d_specialinst,statement,date_lpaid,date_linv from debtors;" |
OFFICE CHOICE DATA IMPORT
Their data is in some sql flat file database and comes with dos apps to extract it with.
Note: there's crap at the end of the sql output which you should remove also.
Stock import:
To generate the data use this command:
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
now because this program is from 1991 the date format totally screws up with 2000+ dates and needs to be fixed because it it frells the fixed width formatting and I noticed dates and data would be chopped off when importing to excel, anyways this simple command fixes dates in teh format of mm/dd/1yy to become mm/dd/yy
cat stock.txt | sed 's/\([0-9][0-9]\/[0-9][0-9]\/\)1\([0-9][0-9]\)/\1\2/g' > stockdatefixed.txt
You shouldn't need to fix up the alignment after that but check it anyways before importing into excel.
Debitor import:
sql.exe "select code,name,add1,add2,sub_state,state,pcode,d_name,d_add1,d_add2,d_sub_state,d_state,d_pcode,phone1,phone2,fax,car,email,contact,abn,cr_limit,d_specialinst,statement,date_lpaid,date_linv from debtors;"