Re: Auto-save a rpt file without "people" interaction (U)
Hi Sandra, Try setting the Target Location to 'to-file:' Then, on the Report Information tab: Destination -> 'to-file: ' Operation -> 'Run' The could be hard coded or set to the value of a field that you build in some way. In my app users specify the file path on a field on the form driving the report but the file name is fixed (but with the date appended) so the Destination field is set to 'to-file: $CSVFilePath$/Computer CIs $DateAsCharacter$.csv'. As you can see, I am generating csv files but presume that Crystal reports should be able to be saved in the same way. Cheers Peter > UNCLASSIFIED > > We are using ARS 6.3 patch 21 > Windows Server 2003 > SQL 2000 > Help Desk 5.5 > > > I have an Active Link that runs from a button. > When employed, this is the workflow: > > If Action 1 > Open Window > Window Type: Report > Target Location: New > Qualification: ( 'Status Display' != "Resolved" ) AND ( 'Status Display' > != "Closed" ) > > Report Information: > Report Type: Crystal > Name: Morning Report > Target: File > Operation: Create > Location Reporting Form > > > Works like a charm. > > Can I automate the save to file without a person selecting the "Save to" > properties? > > > Sandra Hennigan > > OSD Enterprise Remedy Administrator > Office # 703-602-2525 x248 > > Apparently, there is nothing that cannot happen today. Mark Twain > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black > Sent: Thursday, April 24, 2008 9:51 AM > To: arslist@ARSLIST.ORG > Subject: Re: Can you export to a csv file from Mid Tier? > > > Brian, > > The Open Window action (for running a Report) requires several inputs: > > 'Window Type' = "Report" > 'Target Location' = "New" or "Current" (your choice) > 'Server Name' > 'Form Name' > 'Form View' ( not sure how this one matters) > > Then you have 4 other tabs of things to fill out for this action: > Qualification, Sort Info, Report Information. > > I was speaking of a filed on the Report Information tab. 'Target :' and > NOT the 'Target Location: ' field in the "header" of the action. But I can > see how my description was not 100% complete. ( Your current value is > likely "File".) > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > On Thu, Apr 24, 2008 at 9:25 AM, Sokol, Brian <[EMAIL PROTECTED]> > wrote: >> Hi Carey, >> >> Thanks. By Target are you referring to the Target Location setting in >> the Open Window settings? I changed that value from New to to-file: >> POSInventory.csv but still get the same result. It defaults to >> Report.rpt. I am hoping I am doing something wrong here that can >> easily be corrected. >> >> Brian >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> >> >> [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black >> Sent: Wednesday, April 23, 2008 11:24 PM >> To: arslist@ARSLIST.ORG >> Subject: Re: Can you export to a csv file from Mid Tier? >> >> Brian, >> >> You can do it... it is just not obvious >> >> You need to supply the "Target" string (in the WindowOpen action) >> like this... >> >> to-file: >> >> No "" is not in the string, but you need a white space >> character there for it to work right. >> >> If you also want to specify the actual file name then the target >> would >> be: >> >> to-file: some.csv >> >> If the file name presented is a *.csv then the report will output to >> csv. If it is *.xml.. then xml >> If it is anything else... then I think you get report (rpt) format. >> >> >> ( I forget where or when I learned this... but I remember it being a >> very obscure (and accurate) source.) >> >> HTH. >> -- >> Carey Matthew Black >> Remedy Skilled Professional (RSP) >> ARS = Action Request System(Remedy) >> >> Love, then teach >> Solution = People + Process + Tools >> Fast, Accurate, Cheap Pick two. >> >> >> On Wed, Apr 23, 2008 at 3:29 PM, Sokol, Brian <[EMAIL PROTECTED]> >> wrote: >> > ** >> > >> > Jason, >> > >> > One last question. I am trying to setup a simple means for a >> manager > to run an export of a query in Remedy. I can now run a >> query, select > Report, select the report, change the output to >> export etc. Too > complicated for this person. I created an AL to run >> a report. Problem > is if you select Destination as File there is no >> where to have Remedy > export the data as a CSV. It always selects >> RPT and there is no way to >> >> > over ride it from the Mid Tier that I can see. In the user tool you >> > can change the file type to CSV before saving and it works. Do you >> > know any way to force this on the Mid Tier? > >> > Brian >> > >> > >> > >> > From: Action Request System discussion list(ARSList) >> > [mailto:[EMAIL PROTECT
Auto-save a rpt file without "people" interaction (U)
UNCLASSIFIED We are using ARS 6.3 patch 21 Windows Server 2003 SQL 2000 Help Desk 5.5 I have an Active Link that runs from a button. When employed, this is the workflow: If Action 1 Open Window Window Type: Report Target Location: New Qualification: ( 'Status Display' != "Resolved" ) AND ( 'Status Display' != "Closed" ) Report Information: Report Type: Crystal Name: Morning Report Target: File Operation: Create Location Reporting Form Works like a charm. Can I automate the save to file without a person selecting the "Save to" properties? Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x248 Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Thursday, April 24, 2008 9:51 AM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? Brian, The Open Window action (for running a Report) requires several inputs: 'Window Type' = "Report" 'Target Location' = "New" or "Current" (your choice) 'Server Name' 'Form Name' 'Form View' ( not sure how this one matters) Then you have 4 other tabs of things to fill out for this action: Qualification, Sort Info, Report Information. I was speaking of a filed on the Report Information tab. 'Target :' and NOT the 'Target Location: ' field in the "header" of the action. But I can see how my description was not 100% complete. ( Your current value is likely "File".) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Thu, Apr 24, 2008 at 9:25 AM, Sokol, Brian <[EMAIL PROTECTED]> wrote: > Hi Carey, > > Thanks. By Target are you referring to the Target Location setting in > the Open Window settings? I changed that value from New to to-file: > POSInventory.csv but still get the same result. It defaults to > Report.rpt. I am hoping I am doing something wrong here that can > easily be corrected. > > Brian > > > -Original Message- > From: Action Request System discussion list(ARSList) > > > [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black > Sent: Wednesday, April 23, 2008 11:24 PM > To: arslist@ARSLIST.ORG > Subject: Re: Can you export to a csv file from Mid Tier? > > Brian, > > You can do it... it is just not obvious > > You need to supply the "Target" string (in the WindowOpen action) > like this... > > to-file: > > No "" is not in the string, but you need a white space > character there for it to work right. > > If you also want to specify the actual file name then the target > would > be: > > to-file: some.csv > > If the file name presented is a *.csv then the report will output to > csv. If it is *.xml.. then xml > If it is anything else... then I think you get report (rpt) format. > > > ( I forget where or when I learned this... but I remember it being a > very obscure (and accurate) source.) > > HTH. > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap Pick two. > > > On Wed, Apr 23, 2008 at 3:29 PM, Sokol, Brian <[EMAIL PROTECTED]> > wrote: > > ** > > > > Jason, > > > > One last question. I am trying to setup a simple means for a > manager > to run an export of a query in Remedy. I can now run a > query, select > Report, select the report, change the output to > export etc. Too > complicated for this person. I created an AL to run > a report. Problem > is if you select Destination as File there is no > where to have Remedy > export the data as a CSV. It always selects > RPT and there is no way to > > > over ride it from the Mid Tier that I can see. In the user tool you > > can change the file type to CSV before saving and it works. Do you > > know any way to force this on the Mid Tier? > > > Brian > > > > > > > > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller > > Sent: Wednesday, April 23, 2008 2:25 PM > > > > > > To: arslist@ARSLIST.ORG > > Subject: Re: Can you export to a csv file from Mid Tier? > > > > > > > > ** That is interesting that support doesn't know about this. For one > > I would think it is a pretty common issue. Anybody who has upgraded > > their pre > > 7 server would experience it (unless a Unix installer uses a different > > > mapping that updates or overwrites). Maybe not many people have > tried > > > exporting to Excel? Second we resolved this ourselves at my last > job > but I am pretty sure that we told support exactly what we did > to fix > it when closing out our ticket. I guess the solution didn't > make it > any further then the incident record (ISS03165279 for > anybody on