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:[email protected]] On Behalf Of Rune Sorlid Sent: Tuesday, March 15, 2011 3:09 PM To: [email protected] 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 [email protected] santana <[email protected]> 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: [email protected] santana [mailto:[email protected]] Sent: Tuesday, March 15, 2011 2:16 PM To: [email protected] 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 <http://www.arslist.org/> attend wwrug11 www.wwrug.com <http://www.wwrug.com/> ARSList: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> attend wwrug11 www.wwrug.com <http://www.wwrug.com/> ARSList: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> attend wwrug11 www.wwrug.com <http://www.wwrug.com/> ARSList: "Where the Answers Are" _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"
