Be wary of this solution....any content within a specific field (, for example) will cause this process to puke.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] santana Sent: Tuesday, March 15, 2011 12:51 PM To: [email protected] Subject: Re: CSV file via workflow 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"
