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 ______________________________________________________________________ _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ -- 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"