9.05.702 Progress DB - Updating JobOper.Number02 field for all r

Yeah I will suggest maybe to apply a set of criteria that you can control manually perhaps even adding a checkbox to an screen customization so you can checked it and save to fire your mass update BPM, once that is done you take the criteria of that checkbox out of your BPM conditions and you update your code so it only updates new records once more. 
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner
Kind Regards,
Sergio P.

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...




On Friday, March 27, 2015 10:19 AM, "'Winter, Patrick' pjw@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-659658702yiv4450247403ygrp-text">
  
  
  <div>
Sergio,
 
Thanks
I will try this, but I’m going to have it only trigger off a particular job so it doesn’t get executed multiple times and hog down the system.
 
Patrick Winter
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 27, 2015 09:53
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 9.05.702 Progress DB - Updating JobOper.Number02 field for all records.
 
 
You could modify your BPM so it goes back and updates all records in your DB, then execute your BPM by simply doing the actions you need to do to execute it right now, once thats done go back to the BPM and modify it once more so it doesnt update historic data anymore. Makes sense? That sounded like a puzzle but it does work!
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner
Kind Regards,
Sergio P.
 
Mayan Technologies USA, Inc.
(858) 900.1555
 
 
 
On Thursday, March 26, 2015 9:06 AM, "'Winter, Patrick' pjw@... [vantage]" <vantage@yahoogroups.com> wrote:
 
 
All,
 
I there a way without DMT to write a script to pass the JobOper.Number02 table and populate the JobOper.Number02 field with an Actual Pieces Per Hour calculation.
Would be like a Conversion Program.
Can you do this thru “Data Conversion & Translation Utility” / “Run Progress Editor”
 
Another though would be to just touch the records somehow and let the Data Directive update them.
 
My Data Directive on JobOper works great going forward, now I just want to update old records that are complete.
 
find first ttJobOper where ttJobOper.RowMod = 'U' no-lock.
IF ttJobOper.QtyCompleted > 0 and ttJobOper.ActProdHours > 0 and ttJobOper.StdFormat = 'PH'
then ttJobOper.Number02 =  (ttJobOper.QtyCompleted / ttJobOper.ActProdHours).
 
Patrick Winter
 
 
 

  Â­Â­  
 

  Â­Â­  
</div>
 


<div class="ygrps-yiv-659658702yiv4450247403yqt1158044707" id="ygrps-yiv-659658702yiv4450247403yqt44120"><div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403 -- #ygrps-yiv-659658702yiv4450247403ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mkp #ygrps-yiv-659658702yiv4450247403hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mkp #ygrps-yiv-659658702yiv4450247403ads {
margin-bottom:10px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mkp .ygrps-yiv-659658702yiv4450247403ad {
padding:0 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mkp .ygrps-yiv-659658702yiv4450247403ad p {
margin:0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mkp .ygrps-yiv-659658702yiv4450247403ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-sponsor #ygrps-yiv-659658702yiv4450247403ygrp-lc {
font-family:Arial;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-sponsor #ygrps-yiv-659658702yiv4450247403ygrp-lc #ygrps-yiv-659658702yiv4450247403hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-sponsor #ygrps-yiv-659658702yiv4450247403ygrp-lc .ygrps-yiv-659658702yiv4450247403ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403activity span {
font-weight:700;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403activity span span {
color:#ff7900;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403activity span .ygrps-yiv-659658702yiv4450247403underline {
text-decoration:underline;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403attach div a {
text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403attach img {
border:none;padding-right:5px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403attach label a {
text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403bold a {
text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 dd.ygrps-yiv-659658702yiv4450247403last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 dd.ygrps-yiv-659658702yiv4450247403last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 dd.ygrps-yiv-659658702yiv4450247403last p span.ygrps-yiv-659658702yiv4450247403yshortcuts {
margin-right:0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403attach-table div div a {
text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403attach-table {
width:400px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403file-title a, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403file-title a:active, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403file-title a:hover, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403file-title a:visited {
text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403photo-title a, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403photo-title a:active, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403photo-title a:hover, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div.ygrps-yiv-659658702yiv4450247403photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 div#ygrps-yiv-659658702yiv4450247403ygrp-mlmsg #ygrps-yiv-659658702yiv4450247403ygrp-msg p a span.ygrps-yiv-659658702yiv4450247403yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403green {
color:#628c2a;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 o {
font-size:0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403photos div {
float:left;width:72px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403reco-category {
font-size:77%;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403reco-desc {
font-size:77%;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 .ygrps-yiv-659658702yiv4450247403replbq {
margin:4px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mlmsg select, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 input, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mlmsg pre, #ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 code {
font:115% monospace;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-mlmsg #ygrps-yiv-659658702yiv4450247403logo {
padding-bottom:10px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-msg p#ygrps-yiv-659658702yiv4450247403attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-reco #ygrps-yiv-659658702yiv4450247403reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-sponsor #ygrps-yiv-659658702yiv4450247403ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-sponsor #ygrps-yiv-659658702yiv4450247403ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-sponsor #ygrps-yiv-659658702yiv4450247403ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-text {
font-family:Georgia;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-text tt {
font-size:120%;}

#ygrps-yiv-659658702 #ygrps-yiv-659658702yiv4450247403 #ygrps-yiv-659658702yiv4450247403ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-659658702



All,
 
I there a way without DMT to write a script to pass the JobOper.Number02 table and populate the JobOper.Number02 field with an Actual Pieces Per Hour calculation.
Would be like a Conversion Program.
Can you do this thru “Data Conversion & Translation Utility” / “Run Progress Editor”
 
Another though would be to just touch the records somehow and let the Data Directive update them.
 
My Data Directive on JobOper works great going forward, now I just want to update old records that are complete.
 
find first ttJobOper where ttJobOper.RowMod = 'U' no-lock.
IF ttJobOper.QtyCompleted > 0 and ttJobOper.ActProdHours > 0 and ttJobOper.StdFormat = 'PH'
then ttJobOper.Number02 =  (ttJobOper.QtyCompleted / ttJobOper.ActProdHours).
 
Patrick Winter
 
 
 

  ­­  
You could modify your BPM so it goes back and updates all records in your DB, then execute your BPM by simply doing the actions you need to do to execute it right now, once thats done go back to the BPM and modify it once more so it doesnt update historic data anymore. Makes sense? That sounded like a puzzle but it does work!
 
Kind Regards,
Sergio P. 
CTO, Sr. Partner
Kind Regards,
Sergio P.

Mayan Technologies USA, Inc.
(858) 900.1555
sprieto@...




On Thursday, March 26, 2015 9:06 AM, "'Winter, Patrick' pjw@... [vantage]" <vantage@yahoogroups.com> wrote:


 
<div id="ygrps-yiv-152441976yiv7408570088ygrp-text">
  
  
  <div>


All,

 
I there a way without DMT to write a script to pass the JobOper.Number02 table and populate the JobOper.Number02 field with an Actual Pieces Per Hour calculation.
Would be like a Conversion Program.
Can you do this thru “Data Conversion & Translation Utility” / “Run Progress Editor”
 
Another though would be to just touch the records somehow and let the Data Directive update them.
 
My Data Directive on JobOper works great going forward, now I just want to update old records that are complete.
 
find first ttJobOper where ttJobOper.RowMod = 'U' no-lock.
IF ttJobOper.QtyCompleted > 0 and ttJobOper.ActProdHours > 0 and ttJobOper.StdFormat = 'PH'
then ttJobOper.Number02 =  (ttJobOper.QtyCompleted / ttJobOper.ActProdHours).
 
Patrick Winter
 
 
 


  Â­Â­  

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088 -- #ygrps-yiv-152441976yiv7408570088ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mkp #ygrps-yiv-152441976yiv7408570088hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mkp #ygrps-yiv-152441976yiv7408570088ads {
margin-bottom:10px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mkp .ygrps-yiv-152441976yiv7408570088ad {
padding:0 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mkp .ygrps-yiv-152441976yiv7408570088ad p {
margin:0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mkp .ygrps-yiv-152441976yiv7408570088ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-sponsor #ygrps-yiv-152441976yiv7408570088ygrp-lc {
font-family:Arial;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-sponsor #ygrps-yiv-152441976yiv7408570088ygrp-lc #ygrps-yiv-152441976yiv7408570088hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-sponsor #ygrps-yiv-152441976yiv7408570088ygrp-lc .ygrps-yiv-152441976yiv7408570088ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088activity span {
font-weight:700;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088activity span span {
color:#ff7900;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088activity span .ygrps-yiv-152441976yiv7408570088underline {
text-decoration:underline;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088attach div a {
text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088attach img {
border:none;padding-right:5px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088attach label a {
text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088bold a {
text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 dd.ygrps-yiv-152441976yiv7408570088last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 dd.ygrps-yiv-152441976yiv7408570088last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 dd.ygrps-yiv-152441976yiv7408570088last p span.ygrps-yiv-152441976yiv7408570088yshortcuts {
margin-right:0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088attach-table div div a {
text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088attach-table {
width:400px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088file-title a, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088file-title a:active, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088file-title a:hover, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088file-title a:visited {
text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088photo-title a, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088photo-title a:active, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088photo-title a:hover, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div.ygrps-yiv-152441976yiv7408570088photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 div#ygrps-yiv-152441976yiv7408570088ygrp-mlmsg #ygrps-yiv-152441976yiv7408570088ygrp-msg p a span.ygrps-yiv-152441976yiv7408570088yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088green {
color:#628c2a;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 o {
font-size:0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088photos div {
float:left;width:72px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088reco-category {
font-size:77%;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088reco-desc {
font-size:77%;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 .ygrps-yiv-152441976yiv7408570088replbq {
margin:4px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mlmsg select, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 input, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mlmsg pre, #ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 code {
font:115% monospace;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-mlmsg #ygrps-yiv-152441976yiv7408570088logo {
padding-bottom:10px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-msg p#ygrps-yiv-152441976yiv7408570088attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-reco #ygrps-yiv-152441976yiv7408570088reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-sponsor #ygrps-yiv-152441976yiv7408570088ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-sponsor #ygrps-yiv-152441976yiv7408570088ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-sponsor #ygrps-yiv-152441976yiv7408570088ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-text {
font-family:Georgia;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-text tt {
font-size:120%;}

#ygrps-yiv-152441976 #ygrps-yiv-152441976yiv7408570088 #ygrps-yiv-152441976yiv7408570088ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-152441976



Sergio,

 

Thanks

I will try this, but I’m going to have it only trigger off a particular job so it doesn’t get executed multiple times and hog down the system.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, March 27, 2015 09:53
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 9.05.702 Progress DB - Updating JobOper.Number02 field for all records.

 

 

You could modify your BPM so it goes back and updates all records in your DB, then execute your BPM by simply doing the actions you need to do to execute it right now, once thats done go back to the BPM and modify it once more so it doesnt update historic data anymore. Makes sense? That sounded like a puzzle but it does work!

 

Kind Regards,

Sergio P. 

CTO, Sr. Partner

Kind Regards,

Sergio P.

 

Mayan Technologies USA, Inc.

(858) 900.1555

 

 

 

On Thursday, March 26, 2015 9:06 AM, "'Winter, Patrick' pjw@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

All,

 

I there a way without DMT to write a script to pass the JobOper.Number02 table and populate the JobOper.Number02 field with an Actual Pieces Per Hour calculation.

Would be like a Conversion Program.

Can you do this thru “Data Conversion & Translation Utility” / “Run Progress Editor”

 

Another though would be to just touch the records somehow and let the Data Directive update them.

 

My Data Directive on JobOper works great going forward, now I just want to update old records that are complete.

 

find first ttJobOper where ttJobOper.RowMod = 'U' no-lock.

IF ttJobOper.QtyCompleted > 0 and ttJobOper.ActProdHours > 0 and ttJobOper.StdFormat = 'PH'

then ttJobOper.Number02 =  (ttJobOper.QtyCompleted / ttJobOper.ActProdHours).

 

Patrick Winter

 

 

 


  Â­Â­  

 


  ­­