|
We use triggers as if they are going out of style. Initially - we eliminated numerous modified mapics source code by converting specialized update program routines to triggers based on file CRUD events. Then it provided us with real-time updates to our custom files so there is no need to run additional batch events to keep custom files in synch with Mapics. And in browser, we use the triggers to condition special editing and updates from our specifically designed integrator objects to create the required updates to Mapics files, reducing the amount of input users need to perform. Triggers are nothing more than a powerful database tool that helps us realize many needs. Seeing as a data base event causes the trigger to kick off, you can expect for additional processes to occur whenever the trigger kicks off, so watch our for jobs that perform numerous updates to a file. (Ie.. ITMRVB updates during full cost roll up) Our job took over twice as long to run when we added our own trigger over the ITMRVB file, because every update forced a trigger event to process. So we changed our trigger programs execution to monitor data areas and if the data area has a value of "NOTRIGGER", it then bypasses the execution of the trigger. Other gotcha is duplicating file objects with triggers from live to test environment. The trigger can and will process your test event into live files if access path within trigger object is still mapped to live data. Make sure that you remove trigger from test and re-apply. Last but not least. I feel your pain if you're a 24/7 operation. So look at using a central program that can be attached to file, but calls a second program that controls your data event. This will allow for changes to trigger file process in the event of emergencies. Any feed back would be great. c -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of mapics-l-request@xxxxxxxxxxxx Sent: Thursday, March 01, 2007 7:05 PM To: mapics-l@xxxxxxxxxxxx Subject: MAPICS-L Digest, Vol 5, Issue 35 Send MAPICS-L mailing list submissions to mapics-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request@xxxxxxxxxxxx You can reach the person managing the list at mapics-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Re: Updating PO Item and Release files (ARojas@xxxxxxxxxxxxxxxxxxx) 2. Re: Updating PO Item and Release files (Sansi, Jim) 3. Re: Updating PO Item and Release files (Oney, Vince (Unison)) 4. Requisition date for 04/19/2007 (Peter Vidal) 5. Re: MAPICS-L Digest, Vol 5, Issue 34 - Time phased inventory cost changes (cvela@xxxxxxxxxx) ---------------------------------------------------------------------- message: 1 date: Thu, 1 Mar 2007 10:07:05 -0800 from: ARojas@xxxxxxxxxxxxxxxxxxx subject: Re: [MAPICS-L] Updating PO Item and Release files I have three 'user triggers' on my system: - Over IMHIST when a new RP transaction is *inserted to produce a 'receiving document' - Using Browser (Integrator) trigger over a custom file - Over TEMGEN --> required by FRx Same as Dave, I try to avoid the use of Triggers as much as possible. Antonio Rojas IT Manager - Senior Aerospace, SSP (818) 260-2218 DaleGindlesperger@xxxxxxxxxxx Sent by: mapics-l-bounces@xxxxxxxxxxxx 03/01/2007 09:09 AM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> cc Subject Re: [MAPICS-L] Updating PO Item and Release files Group.... I know all the advantages of triggers - they have been explained to me over and over. But I keep being burned on them with things like Eric mentioned, and others (difficulty in adding or maintaining them in a 24/7 environment). Am I being too conservative in my outlook in that I make every effort to avoid using them, and instead run periodic jobs (nightly seems to be adequate usually) to examine all the files and take any necessary actions? I'd appreciate a brief set of responses as to how many of us are using triggers, just a personal survey, if I may. 1) Can't live without triggers - they put sliced bread with butter to shame! 2) Use them, they are OK, the pain is pretty well worth it 3) Triggers? What are they? So I don't bury the thread on this, please reply to my direct address. This is totally unofficial, I'm just scratching a curiosity bone.... Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 dgindles@xxxxxxxxxxx "Eric Wolf" <eric_a_wolf@hotm ail.com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject Re: [MAPICS-L] Updating PO Item and 03/01/2007 11:52 Release files AM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 2 date: Thu, 1 Mar 2007 10:18:59 -0800 from: "Sansi, Jim" <jsansi@xxxxxxxxxxx> subject: Re: [MAPICS-L] Updating PO Item and Release files 3) Triggers? Ok, I know what triggers are... We just haven't needed or used them so far to date. -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of DaleGindlesperger@xxxxxxxxxxx Sent: Thursday, March 01, 2007 9:10 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] Updating PO Item and Release files Group.... I know all the advantages of triggers - they have been explained to me over and over. But I keep being burned on them with things like Eric mentioned, and others (difficulty in adding or maintaining them in a 24/7 environment). Am I being too conservative in my outlook in that I make every effort to avoid using them, and instead run periodic jobs (nightly seems to be adequate usually) to examine all the files and take any necessary actions? I'd appreciate a brief set of responses as to how many of us are using triggers, just a personal survey, if I may. 1) Can't live without triggers - they put sliced bread with butter to shame! 2) Use them, they are OK, the pain is pretty well worth it 3) Triggers? What are they? So I don't bury the thread on this, please reply to my direct address. This is totally unofficial, I'm just scratching a curiosity bone.... Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 dgindles@xxxxxxxxxxx "Eric Wolf" <eric_a_wolf@hotm ail.com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject Re: [MAPICS-L] Updating PO Item and 03/01/2007 11:52 Release files AM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 3 date: Thu, 1 Mar 2007 13:34:55 -0500 from: "Oney, Vince \(Unison\)" <Vince.Oney@xxxxxxxxxxxxxxxxxxxx> subject: Re: [MAPICS-L] Updating PO Item and Release files 1) We use a lot of triggers and can't do without but be careful they do affect system performance. Vince -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Sansi, Jim Sent: Thursday, March 01, 2007 1:19 PM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] Updating PO Item and Release files 3) Triggers? Ok, I know what triggers are... We just haven't needed or used them so far to date. -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of DaleGindlesperger@xxxxxxxxxxx Sent: Thursday, March 01, 2007 9:10 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] Updating PO Item and Release files Group.... I know all the advantages of triggers - they have been explained to me over and over. But I keep being burned on them with things like Eric mentioned, and others (difficulty in adding or maintaining them in a 24/7 environment). Am I being too conservative in my outlook in that I make every effort to avoid using them, and instead run periodic jobs (nightly seems to be adequate usually) to examine all the files and take any necessary actions? I'd appreciate a brief set of responses as to how many of us are using triggers, just a personal survey, if I may. 1) Can't live without triggers - they put sliced bread with butter to shame! 2) Use them, they are OK, the pain is pretty well worth it 3) Triggers? What are they? So I don't bury the thread on this, please reply to my direct address. This is totally unofficial, I'm just scratching a curiosity bone.... Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 dgindles@xxxxxxxxxxx "Eric Wolf" <eric_a_wolf@hotm ail.com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject Re: [MAPICS-L] Updating PO Item and 03/01/2007 11:52 Release files AM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 4 date: Thu, 1 Mar 2007 14:12:06 -0500 from: Peter Vidal <Peter_Vidal@xxxxxxxx> subject: [MAPICS-L] Requisition date for 04/19/2007 Hi list: Excuse my ignorance but: why I have a requisition date of 04/19/2007? What will cause this to happen? Thanks! Peter Vidal PALL Corporation / SR Programmer Analyst, IT Development Group 10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111 http://www.pall.com "Labor to keep alive in your heart that little spark of celestial fire - Conscience." George Washington ------------------------------ message: 5 date: Thu, 1 Mar 2007 19:05:06 -0500 from: <cvela@xxxxxxxxxx> subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 34 - Time phased inventory cost changes Good day Roger B. Have you considered loading data into the Vendor/Item contract master? As for inventory evaluation - depending on how you track variances, there may be no need to update your standard cost. If data comes from vendor in a text or excel data file, I can surely help you out in creating an import to your system i. Let me know -----Original Message----- From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of mapics-l-request@xxxxxxxxxxxx Sent: Thursday, March 01, 2007 1:00 PM To: mapics-l@xxxxxxxxxxxx Subject: MAPICS-L Digest, Vol 5, Issue 34 Send MAPICS-L mailing list submissions to mapics-l@xxxxxxxxxxxx To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request@xxxxxxxxxxxx You can reach the person managing the list at mapics-l-owner@xxxxxxxxxxxx When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Updating PO Item and Release files (David Williams) 2. Time phased inventory cost changes (Roger.Blocher@xxxxxxxxxxxxxxxxxxx) 3. Re: Time phased inventory cost changes (RArnold@xxxxxxxxxxxxxx) 4. Guidelines for MAPICS-L mailing list (mailman@xxxxxxxxxxxx) 5. Re: Updating PO Item and Release files (sjones@xxxxxxxxxxxxxx) 6. Re: Updating PO Item and Release files (David Williams) 7. Re: Updating PO Item and Release files (Eric Wolf) 8. Re: Updating PO Item and Release files (DaleGindlesperger@xxxxxxxxxxx) ---------------------------------------------------------------------- message: 1 date: Wed, 28 Feb 2007 13:05:56 -0800 (PST) from: David Williams <jdwill5@xxxxxxxxx> subject: [MAPICS-L] Updating PO Item and Release files I want to update the Poitem and poblkt files when the item revision this level cost is changed on a purchased part through the browser. I am at Rel 6. I think I would like to use a DB2 trigger in that I can tell when the filed (column) that has the this level cost is changed. Has anyone had experience using triggers against the MAPICS database? Any sample code available? Any assistance would be appreciated. ____________________________________________________________________________ ________ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 ------------------------------ message: 2 date: Wed, 28 Feb 2007 17:23:26 -0500 from: Roger.Blocher@xxxxxxxxxxxxxxxxxxx subject: [MAPICS-L] Time phased inventory cost changes How are other MAPICS users addressing the need for keeping up with vendor cost changes in a proactive manner? Can you point me to a package/solution that will provide us an option to pre-load future cost changes with an effective date? (We have both one-at-a-time changes as well as mass loads for 2000 item cost changes from a single vendor.) Also, we need to take into account the impact on inventory and new purchase orders. Ideally we would start buying under a new price in advance of updating the inventory cost. (This may be asking too much!) The possiblity of loading the purchase price field in advance of loading the unit cost default and the current cost fields. Thoughts? Suggestions? THANKS Roger Blocher TECH International I.S. Manager 740.966.8009 740.966.8090 (fax) ------------------------------ message: 3 date: Wed, 28 Feb 2007 22:17:02 -0500 from: RArnold@xxxxxxxxxxxxxx subject: Re: [MAPICS-L] Time phased inventory cost changes We may have something that may do what you need. We created a screen that allows our purchasing group to enter an item, price and effective date. We then take the current effective price to the item master for repricing. We do this in a scheduled job after midnight. This gives us the ability to track pricing changes by user as well as set price changes in the future. It would be easy to mass load the file from a data transfer. If you're updating the costs, then it should be an fairly easy change... If you think this may help, let me know, we'll shoot you the source. Thanks, Bob Arnold MIS Manager H-P Products, Inc. 330-875-5556 ------------------------------ message: 4 date: Thu, 1 Mar 2007 06:30:25 -0600 from: mailman@xxxxxxxxxxxx subject: [MAPICS-L] Guidelines for MAPICS-L mailing list Monthly posting of the guidelines for participation in the MAPICS Mailing List. Keep to the subject. The topic of the list is MAPICS (Manufacturing, Accounting and Production Inventory Control System), the ERP software package originally developed by IBM and now sold by Infor Global Solutions. Any discussion related to MAPICS in particular or ERP systems in general is acceptable. Discussion of unrelated topics will be actively discouraged. When quoting messages, do not quote the entire message. Just quote the parts that are needed to make the appropriate references. Flames are absolutely prohibited. If you disagree with someone, feel free to argue the facts, but no personal attacks will be tolerated. The official language of the MAPICS Mailing List is English. Do not post personal messages. Please use direct E-Mail. This list is international in scope and personal messages just end up costing money. Job and/or employment messages are forbidden. Please use the various jobs oriented conferences, such as midrange-jobs@xxxxxxxxxxxxx Advertising products, repeated postings, etc, are strictly prohibited. Also, if you have a solution that will specifically help another participant, feel free to tell that person. And finally, if you are a vendor, please identify yourself as such... do not try to pass yourself off as a user of your own products (even if you are). By posting to this mailing list, you are granting MIDRANGE dot COM and David Gibbs (david@xxxxxxxxxxxx) non-exclusive, unlimited, rights to republish its contents. This list IS copyrighted as a compilation. Republication of this mailing list, for anything other than personal use, without the explicit permission of the list owner is a violation of U.S. Copyright Law and will be dealt with as such. Collecting or "Mining" of email address from this forum, or any related web archive, is strictly and explicitly prohibited (not to mention that it is extraordinarily unprofessional). Violation of the above guidelines will be determined by the moderator and will result in the offending party either a) being forced to run Application Recovery Procedures for MAPICS I on a System/34 with worn out diskettes and impatient, cranky users, or b) permanent disconnection from the conference (you decide which is worse). To subscribe, unsubscribe, or change mailing list options, please vist http://lists.midrange.com/mailman/listinfo/MAPICS-L If you have questions or comments about these guidelines, please feel free to contact the moderator, Dave Shaw, via internet e-mail at mapics-l-owner@xxxxxxxxxxxxx MIDRANGE dot COM is a non-commercial organization and is not connected with any corporation, periodical, or commercial enterprise. For more information, send Internet E-Mail to INFO@xxxxxxxxxxxxx MIDRANGE dot COM and midrange.com, the owners and operators of this list are in no way associated with Infor Global Solutions, International Business Machines (IBM), "Midrange Computing" magazine, or "Midrange Systems" magazine. The opinions expressed here are strictly those of their authors, and in no way reflect the opinions or statements of direction of the aforementioned companies. ------------------------------ message: 5 date: Thu, 1 Mar 2007 07:47:06 -0500 from: sjones@xxxxxxxxxxxxxx subject: Re: [MAPICS-L] Updating PO Item and Release files We have a trigger on the itembl file. I used this template to setup our trigger, http://www.pbhall.us/trigger.html The hardest part of the trigger program is you must gain exclusive access to the file in order to add the trigger. David Williams <jdwill5@xxxxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 02/28/2007 04:13 PM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To mapics-l@xxxxxxxxxxxx cc Subject [MAPICS-L] Updating PO Item and Release files I want to update the Poitem and poblkt files when the item revision this level cost is changed on a purchased part through the browser. I am at Rel 6. I think I would like to use a DB2 trigger in that I can tell when the filed (column) that has the this level cost is changed. Has anyone had experience using triggers against the MAPICS database? Any sample code available? Any assistance would be appreciated. ____________________________________________________________________________ ________ Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 6 date: Thu, 1 Mar 2007 05:15:29 -0800 (PST) from: David Williams <jdwill5@xxxxxxxxx> subject: Re: [MAPICS-L] Updating PO Item and Release files Thanks for the information. --- sjones@xxxxxxxxxxxxxx wrote:
We have a trigger on the itembl file. I used this template to setup our trigger, http://www.pbhall.us/trigger.html The hardest part of the trigger program is you must gain exclusive access to the file in order to add the trigger. David Williams <jdwill5@xxxxxxxxx> Sent by: mapics-l-bounces@xxxxxxxxxxxx 02/28/2007 04:13 PM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To mapics-l@xxxxxxxxxxxx cc Subject [MAPICS-L] Updating PO Item and Release files I want to update the Poitem and poblkt files when the item revision this level cost is changed on a purchased part through the browser. I am at Rel 6. I think I would like to use a DB2 trigger in that I can tell when the filed (column) that has the this level cost is changed. Has anyone had experience using triggers against the MAPICS database? Any sample code available? Any assistance would be appreciated.
____________________________________________________________________________ ________
Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games. http://videogames.yahoo.com/platform?platform=120121 _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.
____________________________________________________________________________ ________ It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. http://tools.search.yahoo.com/toolbar/features/mail/ ------------------------------ message: 7 date: Thu, 01 Mar 2007 08:52:35 -0800 from: "Eric Wolf" <eric_a_wolf@xxxxxxxxxxx> subject: Re: [MAPICS-L] Updating PO Item and Release files Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms ------------------------------ message: 8 date: Thu, 1 Mar 2007 12:09:54 -0500 from: DaleGindlesperger@xxxxxxxxxxx subject: Re: [MAPICS-L] Updating PO Item and Release files Group.... I know all the advantages of triggers - they have been explained to me over and over. But I keep being burned on them with things like Eric mentioned, and others (difficulty in adding or maintaining them in a 24/7 environment). Am I being too conservative in my outlook in that I make every effort to avoid using them, and instead run periodic jobs (nightly seems to be adequate usually) to examine all the files and take any necessary actions? I'd appreciate a brief set of responses as to how many of us are using triggers, just a personal survey, if I may. 1) Can't live without triggers - they put sliced bread with butter to shame! 2) Use them, they are OK, the pain is pretty well worth it 3) Triggers? What are they? So I don't bury the thread on this, please reply to my direct address. This is totally unofficial, I'm just scratching a curiosity bone.... Dale Gindlesperger IT Manager/Special Projects Leader Fleetwood Folding Trailers, Inc. 258 Beacon Street Somerset, PA 15501 dgindles@xxxxxxxxxxx "Eric Wolf" <eric_a_wolf@hotm ail.com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject Re: [MAPICS-L] Updating PO Item and 03/01/2007 11:52 Release files AM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> Besides having to gain full access to the file, you may want to add the trigger using the MAPICS CAS option. Even though ITEMBL does not have any current triggers on it in XA R6 (PCM 7412), if they add one and you have yours outside of XA, whenever MAPICS runs the command to remove the triggers, yours will be removed, too. Then when MAPICS runs the command to add back the triggers, yours will not be added back since it will not be contained in the TRGMST file. I ran into this problem at one client and it took a while to figure out how it was getting removed. Eric > > > We have a trigger on the itembl file. I used this > > template to setup our > > trigger, http://www.pbhall.us/trigger.html > > > > The hardest part of the trigger program is you must > > gain exclusive access > > to the file in order to add the trigger. ---------------------------------------------------------------------- Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. End of MAPICS-L Digest, Vol 5, Issue 34 *************************************** ------------------------------ _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. End of MAPICS-L Digest, Vol 5, Issue 35 ***************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
