cost table data

[alan180274]

Hi ,

I am relatively new to MFg/Pro. I am looking to extract the cost data for our master items. which MFG/Pro table is this data held in i.e. the material cost, burden cost etc ?

also when extracting data from MFG/Pro by writing some data progress scripts, how do i write them so lets me extract as many columns as I want which will all fit in an excel spreadsheet ?

your help would be appreciated

kind regards

alan

 

[vinod_home]

what version of Mfg/pro and what do you need extracted (like column names)

 

[alan180274]

We are on an old version- 74g7. is it possible to export all fields to csv?

 

[vinod_home]

get to the progress editor. Change filename and tablename as per your requirement.

output to "filename.csv".
for each tablename no-lock:
export delimiter "," tablename.
end.
output close.

 

[anandpatwari31]

your table would be sct_det here.

 

[jhdandliai]

the following code may be your need, try it .

output to c:\1.csv.
export delimiter "," "Site" "Item Number" "Material" "Labor" "Burden" "Overhead" "Subcontract".
for each sct_det no-lock:
export delimiter "," sct_site sct_part sct_mtl_tl sct_lbr_tl sct_bdn_tl sct_ovh_tl sct_sub_tl .
end.
output close.