Thanks Carey, Yes I picked the wrong Target field to fill in. In my Admin screen the field to enter the csv file name is actually called Destination and not Target. In any case I changed that field and it works great.
Thanks much, Brian -----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 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=$LANGUAG > > E$&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=$LANGUAG > > E$&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 > > <snip> > > > > > 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 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
