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: file path and name' Operation - 'Run' The file and path name 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:space No space 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
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:space No space 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 the inside who may want to look it up). We just fixed it on our server here. Here is what we did: Updated configuration record Request