What would be the best way to have workflow periodically export a CSV
file? I tried using an Escalation that did a Run Process of the
runmacro.exe (plus the appropriate arguments) using a macro I created
that queried a form and exported to a CSV file. The escalation runs but
there is no output. If look at the Process Tab of the Task Manager in
Windows, I can see the runmacro.exe process quickly appear then
disappear. If I run the runmacro.exe command through the command line
the CSV file is created.



Chris Puente

Enterprise SOCHelp Support

COM (813) 828- 3017

DSN 299-3017







UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Hi Chris

Make sure that the local account that run macro is using has permission to the directory that it is exporting to. I have had a similar experience and in the end it was permissions to the directory.

Cheers

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Puente Christopher J. Team EITC
Sent: 30 December 2004 14:42
To: arslist@ARSLIST.ORG
Subject: Exporting a CSV file using Workflow


**

What would be the best way to have workflow periodically export a CSV file? I tried using an Escalation that did a Run Process of the runmacro.exe (plus the appropriate arguments) using a macro I created that queried a form and exported to a CSV file. The escalation runs but there is no output. If look at the Process Tab of the Task Manager in Windows, I can see the runmacro.exe process quickly appear then disappear. If I run the runmacro.exe command through the command line the CSV file is created.



Chris Puente

Enterprise SOCHelp Support

COM (813) 828- 3017

DSN 299-3017





This posting was submitted via the Web interface



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Chris,
That is the "most standard" way to do the task. The only other
suggestion is to write a Remedy API program to get the job done. (But
that requires code work that will never end. :)

If the Escalation is not working... turn on Escalation logs and see
what is really going on. (maybe filter logs too. Depends on how you
have things set up.)

Ideas things to think about....

The Remedy servers is running as what user? does it have access to
write the CSV file to the location your Escalation is trying to put
it?

Watch the user.log file to see if the macro actually logs in to the
server and gets authenticated when the Escalation runs.

If you really get desperate... turn on SQL/API logs to see what the
Macro is doing after authentication. But check the other stuff first.
:)

HTH.

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.

http://www.fellowshipchurch.com


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)