Experienced ERP consultant wanted for $10/hour!! :eek:
Join a fast-growing software company that specializes in the development, sales and support of Advanced Planning and Scheduling (APS) software.
- Work with businesses to identify their needs and model their factories in our software.
-...
I'm trying to import a csv file that has formulas. Instead of importing the values, Progress imports the formulas literally. Is there a simple way around this?
example:
the csv file has a cell equal to "=1+1". I need to import this cell as "2", not "=1+1".
Thanks
Run this code as an example. You should not see any blank lines in your form.
def var cmmt like cd_cmmt.
def var i as integer.
def var k as integer.
for each cd_det no-lock:
cmmt = "".
k = 1.
do i = 1 to 15:
if cd_cmmt[i] ne "" then
assign cmmt[k] = cd_cmmt[i]
k = k + 1.
end...
For those still stuck in ChUI, you can still output to a spreadsheet (not CSV) with all the bells and whistles like formatting, sorting, subtotals, filters, comments etc. You basically output to an XML file and open it with Excel. See the attachment for a simplied example.
You can get as...
def var cmmt like cd_cmmt.
form
cmmt[1]
cmmt[2]
cmmt[3]
... etc
when assigning cmmt only assign it if cd_cmmt is not blank:
k = 1.
do i = 1 to 15:
if cd_cmmt[i] ne "" then
assign cmmt[k] = cd_cmmt[i]
k = k + 1.
end.
Try this wrapper around 23.1, 23.2 or 23.3. You will still need to set the order policy to LFL for all parts involved.
{mfdeclre.i}
def var nbr like so_nbr.
on find of mrp_det
do:
if mrp_dataset = "sod_det" then nbr = mrp_nbr.
end.
on write of wo_mstr
do:
wo_so_job = nbr.
end.
{gprun.i...
I don't believe there is any way to have MRP link a WO to an SO. If you want to customize it to do so, I would recommending setting the order policy (pt_ord_pol/ptp_ord_pol) to LFL... this will generated WO's for the same quantity as the sod open qty. After the MRP generates the planned orders...
I wrote a quick query that will generate a list of all programs that are called from a parent program. I wrote it in a QAD environment. Minor tweaks needed for non QAD.
I can subtotal a single column but am having problems subtotaling for multiple columns.
chexcel:selection:subtotal(2,xlsum,xxx,,,).
I want to put the equivalent of array(5,6,7) in place of xxx. How do I do this in Progress??
Thank you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.