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