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 ID: 000000000000001 for AR System report type. Changed Run Command value From: /servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR=$ RPTQOVR$&S=$RPTSVR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=$RPT APP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTR Y=$COUNTRY$&enc=$RPTENC$ To: /servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR=$ RPTQOVR$&S=$RPTSVR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=$RPT APP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTR Y=$COUNTRY$&enc=$RPTENC$&DT=$RPTDEST$&CS=$RPTCHARSET$ Let me know if this works for you. Jason On Wed, Apr 23, 2008 at 6:36 AM, Sokol, Brian <[EMAIL PROTECTED]> wrote: ** Thanks Jason, Yes it is an upgraded server. I opened a tkt with BMC support but they were clueless. They kept insisting it was a problem with my report (even though I get the same error on all reports). It is getting more and more difficult to prove there is a bug. Please let me know if you come up with a solution. Brian ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Wednesday, April 23, 2008 4:12 AM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hi Brian, sorry I am late to the party. Sounds like a pre 7 server that was upgraded to 7.x. I have seen this before and actually need to fixed at my new job. What I have seen happen is the Report Type record for "AR System" does not import (.arx file) during the upgrade because the record already exists and the mapping is set to reject duplicate records. In version 7 there was a little bit more "magic" added to the Run Command field (if I remember correctly) to handle exporting to csv which wasn't available before. I have been meaning to find the specifics since we have the same problem currently. I will post the fix once I find it (hopefully tomorrow, or today (1am according to my laptop)). Jason On Tue, Apr 22, 2008 at 6:31 AM, Sokol, Brian <[EMAIL PROTECTED]> wrote: ** It is a tiny report. There is nothing wrong with it. I can print it or preview it. I can also export it using the user tool. Just will not work on MidTier. Brian ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steve Brown Sent: Sunday, April 20, 2008 6:29 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Try preview report. How big is the file. If successful then problem with lies with the export,( destination, permissions) if unsuccessful problem lies with report, check parameter settings, another report, create small temp report preview that, as a start Steve Brown System Management Consulting p 03 9781009 m 021 48 22 66 e [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Saturday, 19 April 2008 3:34 a.m. To: arslist@ARSLIST.ORG Subject: Can you export to a csv file from Mid Tier? ** I thought this was now possible? I am on ver 7.1. I have a report for the form I am using. In the Report window I selected Destination File and Report Format CSV. When I click Run a get a window to name the file. That all works up to that point. When I click Ok after naming the file I get an error: Report Error Failed To Perform Action Am I doing something wrong here? Brian Sokol Manager, Desktop Services Scholastic Inc. 557 Broadway NY, NY 10012 (212) 343-6494 http://www.Scholastic.com <http://www.Scholastic.com> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
