Hi Brian, I have never tried that before today. I am trying a few things on our test server. I'll let you know what I find.
Jason On Wed, Apr 23, 2008 at 12: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 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=$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTRY=$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=$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTRY=$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 > > > > > > __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___ > __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"