Thread: RE: [Arsperl-users] Export of the User form
Brought to you by:
jeffmurphy
Menu
▾
▴
arsperl-users
|
From: Mark V. <Mar...@ev...> - 2006-05-09 01:05:48
|
Mitch, I have written a Perl script which runs nightly, via cron. It writes out both a .def file (same as exporting from the Admin tool, thanks to the authors of ars_Export) and an in-house formatted dump file. The =2Edef file can be used to import definitions, via the Admin tool. The in-house dump format is great for searching on. =20 I have an additional Perl script which runs every minute, via cron. It checks the Server Events table, calling the first script whenever a change is made to an active link, active link guide, application, char menu, escalation, filter, filter guide, packing list, schema, or web service. This requires the addition of a check box field on the Server Events table and selecting, in the Admin tool, which objects you'd like to track. =20 I have found these tools immeasurably beneficial because I can go back to a previous version if a mod to an object has caused problems. =20 Although these are written in a Solaris environment, I would presume that Windows has some kind of job scheduler which could run similarly. =20 If you (or anyone else) believes these tools might be beneficial, I'd be more than happy to send them out. =20 HTH, Mark =20 Mark Vaughan Programmer III Direct: +1 303 802 2426 Mobile: +1 303 601 4434 Fax: +1 303 802 1420 mar...@ev... <mailto:mar...@ev...>=20 Evolving Systems, Inc.=20 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 www.evolving.com ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Friday, May 05, 2006 12:56 PM To: ARSPerl Subject: [Arsperl-users] Export of the User form =20 By chance are there any sample scripts available that will create an export (.arx) of the User form?=20 Thanks,=20 Mitch=20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 This e-mail and any attachments may be confidential and/or legally privil= eged. If you have received this e-mail and you are not a named addressee,= please inform Evolving Systems TIS at ti...@ev... and then delete t= he e-mail from your system. If you are not a named addressee you must not= use, disclose, distribute, copy, print or rely on this e-mail. To ensure= regulatory compliance and for the protection of our clients and business= , Evolving Systems may monitor and read e-mails sent to and from its serv= ers. Although Evolving Systems routinely screens for viruses, addressees = should scan this e-mail and any attachments for viruses. Evolving Systems= makes no representation or warranty as to the absence of viruses in this= e-mail or any attachments.=20 Registered Office: 9777 Pyramid Ct Suite 100, Englewood, CO 80112 |
|
From: Lintner, M. <mit...@ci...> - 2006-05-09 14:02:44
|
Mark, =20 I would really be interested in taking a look at your script that creates a def file. I don't get much time to write Perl scripts anymore and have never done anything in the ars_Export area. Note: my servers are HP Unix. =20 Thanks, =20 Mitch =20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 =20 ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Mark Vaughan Sent: Monday, May 08, 2006 9:18 AM To: ars...@ar... Subject: RE: [Arsperl-users] Export of the User form Mitch, I have written a Perl script which runs nightly, via cron. It writes out both a .def file (same as exporting from the Admin tool, thanks to the authors of ars_Export) and an in-house formatted dump file. The .def file can be used to import definitions, via the Admin tool. The in-house dump format is great for searching on. =20 I have an additional Perl script which runs every minute, via cron. It checks the Server Events table, calling the first script whenever a change is made to an active link, active link guide, application, char menu, escalation, filter, filter guide, packing list, schema, or web service. This requires the addition of a check box field on the Server Events table and selecting, in the Admin tool, which objects you'd like to track. =20 I have found these tools immeasurably beneficial because I can go back to a previous version if a mod to an object has caused problems. =20 Although these are written in a Solaris environment, I would presume that Windows has some kind of job scheduler which could run similarly. =20 If you (or anyone else) believes these tools might be beneficial, I'd be more than happy to send them out. =20 HTH, Mark =20 Mark Vaughan Programmer III Direct: +1 303 802 2426 Mobile: +1 303 601 4434 Fax: +1 303 802 1420 mar...@ev... <mailto:mar...@ev...>=20 Evolving Systems, Inc.=20 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 www.evolving.com ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Friday, May 05, 2006 12:56 PM To: ARSPerl Subject: [Arsperl-users] Export of the User form =20 By chance are there any sample scripts available that will create an export (.arx) of the User form?=20 Thanks,=20 Mitch=20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 This e-mail and any attachments may be confidential and/or legally privileged. If you have received this e-mail and you are not a named addressee, please inform Evolving Systems TIS at ti...@ev... and then delete the e-mail from your system. If you are not a named addressee you must not use, disclose, distribute, copy, print or rely on this e-mail. To ensure regulatory compliance and for the protection of our clients and business, Evolving Systems may monitor and read e-mails sent to and from its servers. Although Evolving Systems routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Evolving Systems makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Registered Office: 9777 Pyramid Ct Suite 100, Englewood, CO 80112=20 |
|
From: Heider, S. <sh...@pb...> - 2006-05-09 14:18:12
|
Mark, =20 Could you post it to the list? =20 Thanks. Stephen ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Tuesday, May 09, 2006 9:46 AM To: ars...@ar... Subject: RE: [Arsperl-users] Export of the User form Mark, =20 I would really be interested in taking a look at your script that creates a def file. I don't get much time to write Perl scripts anymore and have never done anything in the ars_Export area. Note: my servers are HP Unix. =20 Thanks, =20 Mitch =20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 =20 ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Mark Vaughan Sent: Monday, May 08, 2006 9:18 AM To: ars...@ar... Subject: RE: [Arsperl-users] Export of the User form Mitch, I have written a Perl script which runs nightly, via cron. It writes out both a .def file (same as exporting from the Admin tool, thanks to the authors of ars_Export) and an in-house formatted dump file. The .def file can be used to import definitions, via the Admin tool. The in-house dump format is great for searching on. =20 I have an additional Perl script which runs every minute, via cron. It checks the Server Events table, calling the first script whenever a change is made to an active link, active link guide, application, char menu, escalation, filter, filter guide, packing list, schema, or web service. This requires the addition of a check box field on the Server Events table and selecting, in the Admin tool, which objects you'd like to track. =20 I have found these tools immeasurably beneficial because I can go back to a previous version if a mod to an object has caused problems. =20 Although these are written in a Solaris environment, I would presume that Windows has some kind of job scheduler which could run similarly. =20 If you (or anyone else) believes these tools might be beneficial, I'd be more than happy to send them out. =20 HTH, Mark =20 Mark Vaughan Programmer III Direct: +1 303 802 2426 Mobile: +1 303 601 4434 Fax: +1 303 802 1420 mar...@ev... <mailto:mar...@ev...>=20 Evolving Systems, Inc.=20 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 www.evolving.com ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Friday, May 05, 2006 12:56 PM To: ARSPerl Subject: [Arsperl-users] Export of the User form =20 By chance are there any sample scripts available that will create an export (.arx) of the User form?=20 Thanks,=20 Mitch=20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 This e-mail and any attachments may be confidential and/or legally privileged. If you have received this e-mail and you are not a named addressee, please inform Evolving Systems TIS at ti...@ev... and then delete the e-mail from your system. If you are not a named addressee you must not use, disclose, distribute, copy, print or rely on this e-mail. To ensure regulatory compliance and for the protection of our clients and business, Evolving Systems may monitor and read e-mails sent to and from its servers. Although Evolving Systems routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Evolving Systems makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Registered Office: 9777 Pyramid Ct Suite 100, Englewood, CO 80112=20 |
|
From: Carey M. B. <bla...@gm...> - 2006-05-09 14:32:33
|
I think there is an example of how to export an check objects into an RCS system too. (In the ARSPerl distribution.) \ARSperl-1.85\example\Dump_Setup.pl Looks like it deals with: @schema @activelink @filter @escalation @menu And even... admin extensions. :) hehe.. do those even still exist in ARS? @admin_ext =3D ars_GetListAdminExtension($c); Here is the header of the script for reference: #!/usr/local/bin/perl # # $Header: /cvsroot/arsperl/ARSperl/example/Dump_Setup.pl,v 1.3 1999/06/14 17:07:39 jcmurphy Exp $ # # EXAMPLE # Dump_Setup.pl [username] [password] [path] # # DESCRIPTION # Log onto the server and export all schemas, filters, etc. # # NOTES # This might require special permission for the username you login as # # AUTHOR # joel murphy # # 03/14/96 # # $Log: Dump_Setup.pl,v $ # Revision 1.3 1999/06/14 17:07:39 jcmurphy # added some login error checking # # Revision 1.2 1998/12/11 15:24:38 jcmurphy # adjustments to GetListSchema for >=3D3.0 systesm # # Revision 1.1 1996/11/21 20:13:50 jcmurphy # Initial revision -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS =3D Action Request System(Remedy) Solution =3D People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 5/9/06, Heider, Stephen <sh...@pb...> wrote: > > Mark, > > Could you post it to the list? > > Thanks. > Stephen > > ________________________________ > > From: ars...@ar... > [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell > Sent: Tuesday, May 09, 2006 9:46 AM > > To: ars...@ar... > Subject: RE: [Arsperl-users] Export of the User form > > > > Mark, > > I would really be interested in taking a look at your script that creates= a > def file. I don't get much time to write Perl scripts anymore and have ne= ver > done anything in the ars_Export area. Note: my servers are HP Unix. > > Thanks, > > Mitch > > > Mitch Lintner > Analyst/Programmer > Remedy Developer > Cingular Wireless > 1125 E Campbell Rd > Richardson, Texas, 75081 > 972-907-6965 > mit...@sw... |
|
From: Retzer, J. C <Jos...@al...> - 2006-05-09 14:47:55
|
Mark, =20 I also would appreciate seeing your Perl script, if it's convenient. Our environment is AIX. =20 Thank you for offering,=20 Joe Retzer=20 ___________________________________________________=20 Joe Retzer=20 jos...@al...=20 Systems Analyst, Allina Hospitals & Clinics=20 Allina Commons at Midtown Exchange=20 2925 Chicago Avenue=20 Minneapolis, MN 55407=20 MR#10611=20 Phone & Fax 612-262-1573=20 ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Tuesday, May 09, 2006 8:46 AM To: ars...@ar... Subject: RE: [Arsperl-users] Export of the User form Mark, =20 I would really be interested in taking a look at your script that creates a def file. I don't get much time to write Perl scripts anymore and have never done anything in the ars_Export area. Note: my servers are HP Unix. =20 Thanks, =20 Mitch =20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 =20 ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Mark Vaughan Sent: Monday, May 08, 2006 9:18 AM To: ars...@ar... Subject: RE: [Arsperl-users] Export of the User form Mitch, I have written a Perl script which runs nightly, via cron. It writes out both a .def file (same as exporting from the Admin tool, thanks to the authors of ars_Export) and an in-house formatted dump file. The .def file can be used to import definitions, via the Admin tool. The in-house dump format is great for searching on. =20 I have an additional Perl script which runs every minute, via cron. It checks the Server Events table, calling the first script whenever a change is made to an active link, active link guide, application, char menu, escalation, filter, filter guide, packing list, schema, or web service. This requires the addition of a check box field on the Server Events table and selecting, in the Admin tool, which objects you'd like to track. =20 I have found these tools immeasurably beneficial because I can go back to a previous version if a mod to an object has caused problems. =20 Although these are written in a Solaris environment, I would presume that Windows has some kind of job scheduler which could run similarly. =20 If you (or anyone else) believes these tools might be beneficial, I'd be more than happy to send them out. =20 HTH, Mark =20 Mark Vaughan Programmer III Direct: +1 303 802 2426 Mobile: +1 303 601 4434 Fax: +1 303 802 1420 mar...@ev... <mailto:mar...@ev...>=20 Evolving Systems, Inc.=20 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 www.evolving.com ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Friday, May 05, 2006 12:56 PM To: ARSPerl Subject: [Arsperl-users] Export of the User form =20 By chance are there any sample scripts available that will create an export (.arx) of the User form?=20 Thanks,=20 Mitch=20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 This e-mail and any attachments may be confidential and/or legally privileged. If you have received this e-mail and you are not a named addressee, please inform Evolving Systems TIS at ti...@ev... and then delete the e-mail from your system. If you are not a named addressee you must not use, disclose, distribute, copy, print or rely on this e-mail. To ensure regulatory compliance and for the protection of our clients and business, Evolving Systems may monitor and read e-mails sent to and from its servers. Although Evolving Systems routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Evolving Systems makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Registered Office: 9777 Pyramid Ct Suite 100, Englewood, CO 80112=20 This message contains information that may be confidential and privileged. = Unless you are the addressee (or authorized to receive for the addressee),= you may not use, copy or disclose to anyone the message or any information= contained in the message. If you have received the message in error, plea= se advise the sender by reply e-mail and delete the message. |
|
From: Galloway, M. J (Mark) <mga...@lu...> - 2006-05-10 21:12:34
|
Mark,
I would be interested as well.
Thanks,
Mark J. Galloway
(630) 224-2101
mga...@lu...
-----Original Message-----
From: ars...@ar... [mailto:ars...@ar...]On Behalf Of Lintner, Mitchell
Sent: Tuesday, May 09, 2006 8:46 AM
To: ars...@ar...
Subject: RE: [Arsperl-users] Export of the User form
Mark,
I would really be interested in taking a look at your script that creates a def file. I don't get much time to write Perl scripts anymore and have never done anything in the ars_Export area. Note: my servers are HP Unix.
Thanks,
Mitch
Mitch Lintner
Analyst/Programmer
Remedy Developer
Cingular Wireless
1125 E Campbell Rd
Richardson, Texas, 75081
972-907-6965
mit...@sw...
_____
From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Mark Vaughan
Sent: Monday, May 08, 2006 9:18 AM
To: ars...@ar...
Subject: RE: [Arsperl-users] Export of the User form
Mitch,
I have written a Perl script which runs nightly, via cron. It writes out both a .def file (same as exporting from the Admin tool, thanks to the authors of ars_Export) and an in-house formatted dump file. The .def file can be used to import definitions, via the Admin tool. The in-house dump format is great for searching on.
I have an additional Perl script which runs every minute, via cron. It checks the Server Events table, calling the first script whenever a change is made to an active link, active link guide, application, char menu, escalation, filter, filter guide, packing list, schema, or web service. This requires the addition of a check box field on the Server Events table and selecting, in the Admin tool, which objects you'd like to track.
I have found these tools immeasurably beneficial because I can go back to a previous version if a mod to an object has caused problems.
Although these are written in a Solaris environment, I would presume that Windows has some kind of job scheduler which could run similarly.
If you (or anyone else) believes these tools might be beneficial, I'd be more than happy to send them out.
HTH,
Mark
Mark Vaughan
Programmer III
Direct: +1 303 802 2426
Mobile: +1 303 601 4434
Fax: +1 303 802 1420
<mailto:mar...@ev...> mar...@ev...
Evolving Systems, Inc.
9777 Pyramid Court, Suite 100, Englewood, CO USA 80112
www.evolving.com
_____
From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell
Sent: Friday, May 05, 2006 12:56 PM
To: ARSPerl
Subject: [Arsperl-users] Export of the User form
By chance are there any sample scripts available that will create an export (.arx) of the User form?
Thanks,
Mitch
Mitch Lintner
Analyst/Programmer
Remedy Developer
Cingular Wireless
1125 E Campbell Rd
Richardson, Texas, 75081
972-907-6965
mit...@sw...
This e-mail and any attachments may be confidential and/or legally privileged. If you have received this e-mail and you are not a named addressee, please inform Evolving Systems TIS at ti...@ev... and then delete the e-mail from your system. If you are not a named addressee you must not use, disclose, distribute, copy, print or rely on this e-mail. To ensure regulatory compliance and for the protection of our clients and business, Evolving Systems may monitor and read e-mails sent to and from its servers. Although Evolving Systems routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Evolving Systems makes no representation or warranty as to the absence of viruses in this e-mail or any attachments.
Registered Office: 9777 Pyramid Ct Suite 100, Englewood, CO 80112
|
|
From: Mark V. <Mar...@ev...> - 2006-05-22 21:42:13
Attachments:
remedyExport.tar.gz
|
All, A whole herd of people asked for this so I thought it'd be easier to send it out and those that do not wish to keep them may delete them. Sorry for the time delay. I've been traveling out of country and had to pull individual subroutines from other pieces of code and validate the whole thing. Attached is a gzipped and tarred file containing three files: remedyExport: The script which actually does the export remedyExportUpdate: The script which compares data in the Server Events table to determine what needs to be saved remedyExport.pm: A Perl module containing needed routines Please note that, in order for remedyExportUpdate to work correctly, a checkbox field, with a default value of unchecked, must be added to the Server Events form. The field ID on line 38 of remedyExportUpdate, currently listed as 600000295, needs to be changed to the field ID of the new field created on the Server Events form. I hope, in the course of moving subroutines around, that I got all of them. Please let me know if I did not and I'll send out a revision to the tarball. If you have any questions, comments, or issues please let me know. Thanks, Mark Mark Vaughan Programmer III Direct: +1 303 802 2426 Mobile: +1 303 601 4434 Fax: +1 303 802 1420 mar...@ev... Evolving Systems, Inc.=20 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 www.evolving.com -----Original Message----- From: Ledford, Keith [mailto:kle...@ta...]=20 Sent: Tuesday, May 09, 2006 6:06 AM To: Mark Vaughan Subject: Re: [Arsperl-users] Export of the User form I would like a copy of these. Please.=20 --=20 Keith Ledford <kle...@ta...>=20 TANDBERG Television 678.812.6361 direct 678.812.6461 fax =20 -----Original Message----- From: ars...@ar... To: ars...@ar... Sent: Mon May 08 10:18:14 2006 Subject: RE: [Arsperl-users] Export of the User form Mitch, I have written a Perl script which runs nightly, via cron. It writes out both a .def file (same as exporting from the Admin tool, thanks to the authors of ars_Export) and an in-house formatted dump file. The .def file can be used to import definitions, via the Admin tool. The in-house dump format is great for searching on. =20 I have an additional Perl script which runs every minute, via cron. It checks the Server Events table, calling the first script whenever a change is made to an active link, active link guide, application, char menu, escalation, filter, filter guide, packing list, schema, or web service. This requires the addition of a check box field on the Server Events table and selecting, in the Admin tool, which objects you'd like to track. =20 I have found these tools immeasurably beneficial because I can go back to a previous version if a mod to an object has caused problems. =20 Although these are written in a Solaris environment, I would presume that Windows has some kind of job scheduler which could run similarly. =20 If you (or anyone else) believes these tools might be beneficial, I'd be more than happy to send them out. =20 HTH, Mark =20 Mark Vaughan Programmer III Direct: +1 303 802 2426 Mobile: +1 303 601 4434 Fax: +1 303 802 1420 mar...@ev... <mailto:mar...@ev...>=20 Evolving Systems, Inc.=20 9777 Pyramid Court, Suite 100, Englewood, CO USA 80112 www.evolving.com ________________________________ From: ars...@ar... [mailto:ars...@ar...] On Behalf Of Lintner, Mitchell Sent: Friday, May 05, 2006 12:56 PM To: ARSPerl Subject: [Arsperl-users] Export of the User form =20 By chance are there any sample scripts available that will create an export (.arx) of the User form?=20 Thanks,=20 Mitch=20 Mitch Lintner=20 Analyst/Programmer=20 Remedy Developer=20 Cingular Wireless=20 1125 E Campbell Rd=20 Richardson, Texas, 75081=20 972-907-6965=20 mit...@sw...=20 This e-mail and any attachments may be confidential and/or legally privileged. If you have received this e-mail and you are not a named addressee, please inform Evolving Systems TIS at ti...@ev... and then delete the e-mail from your system. If you are not a named addressee you must not use, disclose, distribute, copy, print or rely on this e-mail. To ensure regulatory compliance and for the protection of our clients and business, Evolving Systems may monitor and read e-mails sent to and from its servers. Although Evolving Systems routinely screens for viruses, addressees should scan this e-mail and any attachments for viruses. Evolving Systems makes no representation or warranty as to the absence of viruses in this e-mail or any attachments. Registered Office: 9777 Pyramid Ct Suite 100, Englewood, CO 80112 |
Thanks for helping keep SourceForge clean.
X