One other way would be to utilize the notify action (using one of the Other codes that creates a file on the server).
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jarl Grøneng Sent: Wednesday, March 16, 2011 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: CSV file via workflow Agree on that, using this approach on *nix can give you a lot of troubles...(not sure about windoze) --- J 2011/3/16 John Sundberg <john.sundb...@kineticdata.com>: > ** > Danger Will Robinson, Danger!!! > > In general - I would not put anything onto the commandline -- that you > didn't purposefully put there. > > Obviously you know your situation better than I do -- and it could be OK -- > but -- just in case -- I thought I would at least -- toss you an alert. > Have fun, > > > -John > On Mar 15, 2011, at 5:28 PM, Mike Ilmer wrote: > ** > Thanks to all! > > I'm really like the Kimberly's solution. > > No Reports, no external applications required. > > I've setup the filter guide to do the table walk on the server, setup the > escalator to run at certain time and it works like a charm! > > Thanks to everyone for ideas. > > Mike > > ________________________________ > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Rune Sorlid > Sent: Tuesday, March 15, 2011 3:09 PM > To: arslist@ARSLIST.ORG > Subject: Re: CSV file via workflow > > ** > Hi > > The standard Active Link Open Window action(Report) and use a standard > remedy report, and specify in a field "where" to send the report( to-file: > c:\temp\filename.csv) > > /Rune Sorlid > > > 2011/3/15 kimberly.sant...@oracle.com santana <kimberly.sant...@oracle.com> >> >> I love it. it works awesome. we even go as far adding that file as an >> attachment to the ticket. >> >> One thing I forgot to warn about is make sure you use >> to append to the >> existing file. (> will overwrite) >> >> cmd /c echo $bl tmp bl file text$>>"c:\Filename.csv" >> >> >> Good Luck >> >> Kimberly Santana >> SR Programmer Analyst >> Oracle >> >> >> >> On 3/15/2011 2:40 PM, Mike Ilmer wrote: >>> >>> Thank you, Kimberly, it is quite interesting solution. >>> >>> Regards, >>> Mike >>> >>> -----Original Message----- >>> From: kimberly.sant...@oracle.com santana >>> [mailto:kimberly.sant...@oracle.com] >>> Sent: Tuesday, March 15, 2011 2:16 PM >>> To: arslist@ARSLIST.ORG >>> Cc: Ilmer, Mike >>> Subject: Re: CSV file via workflow >>> >>> Mike >>> I create a csv file using Active Link Run Process. In my example I >>> create the file then I loop through a table to append values to the >>> file. >>> >>> First step - set a temp field with values needed for column headings >>> (row 1 in the csv file) >>> example: set 'bl tmp bl file text' = "Sequence,Method,RelPath and >>> FileName,DB_Prefix" >>> >>> >>> Next - use a run process to create the .csv file (client side) >>> example: cmd /c echo $bl tmp bl file text$>"c:\Filename.csv" >>> (notice you can pass the above field value to the .csv file) >>> >>> Finally >>> I use an al guide and loop a table >>> >>> 1. : set a temp field with values from the table and commas >>> example: set 'bl tmp bl file text' = (((($col_bl_segment$ >>> + ",") + $col_bl_method$) + ",") + $col_bl_filename$) + " ,") >>> +........ >>> >>> 2. - use a run process to append the existing csv file >>> >>> loop the table till there are no more entries >>> >>> >>> I hope this makes some sense. Feel free to contact me direct if this is >>> unclear >>> >>> Kimberly Santana >>> SR Programmer Analyst >>> Oracle >>> >>> >>> >>> >>> >>> On 3/15/2011 1:34 PM, Mike Ilmer wrote: >>>> >>>> Hi List. >>>> >>>> Do you know if it is possible to generate the .CSV file with the data >>>> from the remedy form using the only remedy workflow (like filters or >>>> escalator). >>>> >>>> I know that I can do this using C, java, Perl, etc. >>>> However may be someone has an idea how (automatically) extract data >>>> and store it in the .csv file without using an external application. >>>> >>>> Regards, >>>> Mike >>>> > -- > John Sundberg > > Kinetic Data, Inc. > "Building a Better Service Experience" > Recipient of: > WWRUG10 Best Customer Service/Support Award > WWRUG09 Innovator of the Year Award > > john.sundb...@kineticdata.com > 651.556.0930 I www.kineticdata.com > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
