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