If your CSV is just writing a couple of things you could do the same thing with a Process command to write the data out to the .csv file when you press the button.
Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, November 17, 2008 5:31 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question It's a pretty painful process, but I will attempt to explain. When creating a new record on this form, I have to take GPS coordinates (provided by user), plug them into a mapping program to see where the site is located (predefined territories on the map), then assign it the appropriate number for that territory (1-9). I wanted to create workflow that would create a .CSV file and save it to a specified location, then open the map (which I have linked to the .CSV file) and update. I have it all working except that I have to save the form first; then press the button that fires the workflow. Once it opens I can see what territory it's in and go back and update the ticket. I was hoping to be able to do it before actually saving the form the first time, but it sounds like that might not be feasible. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 17, 2008 5:18 PM To: arslist@ARSLIST.ORG Subject: Re: Active Link Question A report is generally pulled from the database and not from the current transaction that has not yet been committed to the database. Why do you want to pull a report before the transaction is committed anyways? Just curious? You could perhaps 'work around' this by committing the transaction to a temporary table using Direct SQL prior to saving the request and pulling the report off that temporary table. Joe ________________________________ From: "Mayfield, Andy L." <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, November 17, 2008 5:29:13 PM Subject: Active Link Question I know this is probably simple, but my brain is having more problems than usual this afternoon. I want the active link to create a report from information on the current screen. The thing that has me stumped is that I need to do this prior to the record being saved. I'm able to get it to work after the record is submitted using the qualification of 'Request ID' = $Request ID$, but of course that will only work after the record has been saved and I need to be able to do it before saving. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
