Updateable Dashboard Help - Job Oper table

Yahoo Archive
1
Nice work... I have a few apps that might prove useful down the road...nice to know.



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Thursday, April 18, 2013 1:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Updateable Dashboard Help - Job Oper table



For posterity, the issue was filling out the Column Mapping - I remapped the ttJobHead/ttJobAsmbl links to use the JobOper fields and voila, good to go.

More specifically, when I brought in JobEntry.UpdateExt it forced the checkbox on ttJobHead, ttJobAsmbl & ttJobOper. I then went to the expression table below and changed the required Company, JobNum & AssemblySeq for the ttJobHead & ttJobAsmbl to point to ttJobOper equivalents and it all broke loose.

Alternatively, the solution might've been to start with a JobOper table ONLY and then bring in JobHead after getting the updateable piece working, but either way it worked!

Hurray!
Ken

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Rob Bucek
Sent: Wednesday, April 17, 2013 7:10 PM
To: 'vantage@yahoogroups.com<mailto:%26%2339%3Bvantage%40yahoogroups.com>'
Subject: [Vantage] RE: Updateable Dashboard Help - Job Oper table

Off the cuff easy thing to try... update the jobhead job released/engineered to false, save, then try changing your joboper fields.. it's a stretch but..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com><mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Wednesday, April 17, 2013 6:29 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updateable Dashboard Help - Job Oper table

I'm trying to create an updateable dashboard for our scheduler to be able to quickly adjust resources (scheduling blocks) on jobs. I've done a few of these and thought I had the process, but this one isn't cooperating....

Here's what I've tried & results

* Use JobEntry.UpdateExt method

o It yelled at me about needing JobHead data, so I brought JobHead data in. Otherwise I get error "no header records found - processing aborting"

o I can update JobHead data, saves no problem

o I can update JobOper data - it says everything is good, but upon refresh the data reverts back - save never occurs

o I'm bringing in required fields JobHead.Company, JobHead.JobNum, JobOper.Company, JobOper.JobNum, JobOper.OprSeq, JobOper.AssemblySeq - as listed by the Data Dictionary Viewer for the Primary Index

* Use JobEntry.ChangeJobOperMachines method

o When doing a trace in job entry this is ran first, but nothing saves, it's like it's a check only. Figured I'd try it anyway.

o Says it runs fine, but again, upon refresh the data reverts back - save never occurs

* I noticed on a trace that the Update method also saves WIMachines (in addition to Machines which is the field name for scheduling blocks) - I brought this in and modified both fields with the same new variable, same results - says all is good, refresh and data reverts back.

* Tried JobOperSearch.UpdateExt - but of course this is a read only method, so I got error "Update of JobOper not allowed."

* Regenerated BPM directive between every change listed above

At this point it seems to me the UpdateExt method is the right one, but it's almost as if I need to run the ChangeJobOperMachines method first and then the UpdateExt - at least this is what happens when you trace it. Any way of doing this? Is there something else simple I'm overlooking? Some other method?

Any suggestions would be greatly appreciated!

Ken

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
I'm trying to create an updateable dashboard for our scheduler to be able to quickly adjust resources (scheduling blocks) on jobs. I've done a few of these and thought I had the process, but this one isn't cooperating....

Here's what I've tried & results


* Use JobEntry.UpdateExt method

o It yelled at me about needing JobHead data, so I brought JobHead data in. Otherwise I get error "no header records found - processing aborting"

o I can update JobHead data, saves no problem

o I can update JobOper data - it says everything is good, but upon refresh the data reverts back - save never occurs

o I'm bringing in required fields JobHead.Company, JobHead.JobNum, JobOper.Company, JobOper.JobNum, JobOper.OprSeq, JobOper.AssemblySeq - as listed by the Data Dictionary Viewer for the Primary Index

* Use JobEntry.ChangeJobOperMachines method

o When doing a trace in job entry this is ran first, but nothing saves, it's like it's a check only. Figured I'd try it anyway.

o Says it runs fine, but again, upon refresh the data reverts back - save never occurs

* I noticed on a trace that the Update method also saves WIMachines (in addition to Machines which is the field name for scheduling blocks) - I brought this in and modified both fields with the same new variable, same results - says all is good, refresh and data reverts back.

* Tried JobOperSearch.UpdateExt - but of course this is a read only method, so I got error "Update of JobOper not allowed."

* Regenerated BPM directive between every change listed above

At this point it seems to me the UpdateExt method is the right one, but it's almost as if I need to run the ChangeJobOperMachines method first and then the UpdateExt - at least this is what happens when you trace it. Any way of doing this? Is there something else simple I'm overlooking? Some other method?

Any suggestions would be greatly appreciated!

Ken


[Non-text portions of this message have been removed]
3
Off the cuff easy thing to try... update the jobhead job released/engineered to false, save, then try changing your joboper fields.. it's a stretch but..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Williams
Sent: Wednesday, April 17, 2013 6:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Updateable Dashboard Help - Job Oper table



I'm trying to create an updateable dashboard for our scheduler to be able to quickly adjust resources (scheduling blocks) on jobs. I've done a few of these and thought I had the process, but this one isn't cooperating....

Here's what I've tried & results

* Use JobEntry.UpdateExt method

o It yelled at me about needing JobHead data, so I brought JobHead data in. Otherwise I get error "no header records found - processing aborting"

o I can update JobHead data, saves no problem

o I can update JobOper data - it says everything is good, but upon refresh the data reverts back - save never occurs

o I'm bringing in required fields JobHead.Company, JobHead.JobNum, JobOper.Company, JobOper.JobNum, JobOper.OprSeq, JobOper.AssemblySeq - as listed by the Data Dictionary Viewer for the Primary Index

* Use JobEntry.ChangeJobOperMachines method

o When doing a trace in job entry this is ran first, but nothing saves, it's like it's a check only. Figured I'd try it anyway.

o Says it runs fine, but again, upon refresh the data reverts back - save never occurs

* I noticed on a trace that the Update method also saves WIMachines (in addition to Machines which is the field name for scheduling blocks) - I brought this in and modified both fields with the same new variable, same results - says all is good, refresh and data reverts back.

* Tried JobOperSearch.UpdateExt - but of course this is a read only method, so I got error "Update of JobOper not allowed."

* Regenerated BPM directive between every change listed above

At this point it seems to me the UpdateExt method is the right one, but it's almost as if I need to run the ChangeJobOperMachines method first and then the UpdateExt - at least this is what happens when you trace it. Any way of doing this? Is there something else simple I'm overlooking? Some other method?

Any suggestions would be greatly appreciated!

Ken

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
4
For posterity, the issue was filling out the Column Mapping - I remapped the ttJobHead/ttJobAsmbl links to use the JobOper fields and voila, good to go.

More specifically, when I brought in JobEntry.UpdateExt it forced the checkbox on ttJobHead, ttJobAsmbl & ttJobOper. I then went to the expression table below and changed the required Company, JobNum & AssemblySeq for the ttJobHead & ttJobAsmbl to point to ttJobOper equivalents and it all broke loose.

Alternatively, the solution might've been to start with a JobOper table ONLY and then bring in JobHead after getting the updateable piece working, but either way it worked!

Hurray!
Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Wednesday, April 17, 2013 7:10 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: Updateable Dashboard Help - Job Oper table



Off the cuff easy thing to try... update the jobhead job released/engineered to false, save, then try changing your joboper fields.. it's a stretch but..

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ken Williams
Sent: Wednesday, April 17, 2013 6:29 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Updateable Dashboard Help - Job Oper table

I'm trying to create an updateable dashboard for our scheduler to be able to quickly adjust resources (scheduling blocks) on jobs. I've done a few of these and thought I had the process, but this one isn't cooperating....

Here's what I've tried & results

* Use JobEntry.UpdateExt method

o It yelled at me about needing JobHead data, so I brought JobHead data in. Otherwise I get error "no header records found - processing aborting"

o I can update JobHead data, saves no problem

o I can update JobOper data - it says everything is good, but upon refresh the data reverts back - save never occurs

o I'm bringing in required fields JobHead.Company, JobHead.JobNum, JobOper.Company, JobOper.JobNum, JobOper.OprSeq, JobOper.AssemblySeq - as listed by the Data Dictionary Viewer for the Primary Index

* Use JobEntry.ChangeJobOperMachines method

o When doing a trace in job entry this is ran first, but nothing saves, it's like it's a check only. Figured I'd try it anyway.

o Says it runs fine, but again, upon refresh the data reverts back - save never occurs

* I noticed on a trace that the Update method also saves WIMachines (in addition to Machines which is the field name for scheduling blocks) - I brought this in and modified both fields with the same new variable, same results - says all is good, refresh and data reverts back.

* Tried JobOperSearch.UpdateExt - but of course this is a read only method, so I got error "Update of JobOper not allowed."

* Regenerated BPM directive between every change listed above

At this point it seems to me the UpdateExt method is the right one, but it's almost as if I need to run the ChangeJobOperMachines method first and then the UpdateExt - at least this is what happens when you trace it. Any way of doing this? Is there something else simple I'm overlooking? Some other method?

Any suggestions would be greatly appreciated!

Ken

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]