arsperl-users

[Arsperl-users] Export of the User form

[Lintner, M. <mit...@ci...>]

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...

Re: [Arsperl-users] Export of the User form

[Carey M. B. <bla...@gm...>]

Mitchell,

To my knowledge the ARX format is not really "openly" defined by
Remedy. It is considered an internal format that they can (and have)
changed from time to time.

I would actually suggest a different approach to this problem. Perl
can be an excellent way to manage "administrative" tasks on any
system. (Unix or Windows) That and the fact that Remedy publishes a
client that can export data at the command line (arcopy/runmacro) that
they will (very likely) be maintaining for you well into the future.
Well, I am not sure why you would want to write something that is
already written by the vendor.

Ref: AdvancedGuide-630.pdf page: 566 "Using the Remedy User command
line interface".


FWIW: I have put together a Perl script that loops over the lists of
forms for a server and backs up all of our data every night. (149
schemas, ~2.5 Million rows, in about 3.5 hours, Yea.. not RDMBS fast,
but it works. Our hourly incremental only take about 5 minutes to run
at the end of the day and catch between 10-15K records. :)


Oh... and one other thing... the ARS Perl function that returns the
list of forms for the server... appears to be broke in some way. (At
least I could not get it to work. I ended up resorting to using the
Java driver to build some text files of the forms by type. Join, View,
Vendor, All and then using Perl to add/subtract those lists and
finally subtract a manual list and add a manual list so that we have
the last say in what is or is not backed up. :)

HTH.

--
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/5/06, Lintner, Mitchell <mit...@ci...> wrote:
>
>
> By chance are there any sample scripts available that will create an expo=
rt
> (.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...

Re: [Arsperl-users] Export of the User form

[Misi M. <mi...@rr...>]

Hi!

The ARX-format is not hard to create, it is quite obvious if you do a tes=
t
export of various data types from Remedy User. To my knowledge, it has no=
t
changed other than addition of new data types over the years.

The problem with the User-form is that remedy encrypts the password insid=
e
of Remedy User and Run Macro. This prevents the moving of the password
data to/from ARX-files with ARSPerl or any other API-program NOT created
by Remedy.

They have failed to give me a good reason for this behaviour...

You can not even do a ARGetEntry() from one server and then a
ARMergeEntry() to another. The password will get corrupted.

        Best Regards - Misi, RRR AB, http://www.rrr.se

> Mitchell,
>
> To my knowledge the ARX format is not really "openly" defined by
> Remedy. It is considered an internal format that they can (and have)
> changed from time to time.
>
> I would actually suggest a different approach to this problem. Perl
> can be an excellent way to manage "administrative" tasks on any
> system. (Unix or Windows) That and the fact that Remedy publishes a
> client that can export data at the command line (arcopy/runmacro) that
> they will (very likely) be maintaining for you well into the future.
> Well, I am not sure why you would want to write something that is
> already written by the vendor.
>
> Ref: AdvancedGuide-630.pdf page: 566 "Using the Remedy User command
> line interface".
>
>
> FWIW: I have put together a Perl script that loops over the lists of
> forms for a server and backs up all of our data every night. (149
> schemas, ~2.5 Million rows, in about 3.5 hours, Yea.. not RDMBS fast,
> but it works. Our hourly incremental only take about 5 minutes to run
> at the end of the day and catch between 10-15K records. :)
>
>
> Oh... and one other thing... the ARS Perl function that returns the
> list of forms for the server... appears to be broke in some way. (At
> least I could not get it to work. I ended up resorting to using the
> Java driver to build some text files of the forms by type. Join, View,
> Vendor, All and then using Perl to add/subtract those lists and
> finally subtract a manual list and add a manual list so that we have
> the last say in what is or is not backed up. :)
>
> HTH.
>
> --
> 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/5/06, Lintner, Mitchell <mit...@ci...> wrote:
>>
>>
>> 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...
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, securit=
y?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geron=
imo
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=120709&bid&3057&dat=12164=
2
> _______________________________________________
> Arsperl-users mailing list
> Ars...@ar...
> https://lists.sourceforge.net/lists/listinfo/arsperl-users
>