Re: Can you export to a csv file from Mid Tier?
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: 001 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
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: 001 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
Re: Can you export to a csv file from Mid Tier?
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: 001 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
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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can you export to a csv file from Mid Tier?
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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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: 001 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Re: Can you export to a csv file from Mid Tier?
Hi Jason, That did it. Thanks, 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: 001 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
Re: Can you export to a csv file from Mid Tier?
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: 001 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
Re: Can you export to a csv file from Mid Tier?
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: 001 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
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: 001 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 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
Re: Can you export to a csv file from Mid Tier?
Hi Lisa, My settings are all the same except I have the report format set to Column. I need this setting in order to open the export in Excel. This should not matter. I tested it with the user tool and it works OK. Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, April 18, 2008 4:53 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** What kind of report is it? Is it just a really simple report (with x number of fields) or does it to a count or sum anywhere? On one of my reports (on the ReportCreator page) here is what I have: Report Name: (any name you want) Server Name: (my server name) Form Name: Contract (for example) Report Format: Record Locale: (I have this blank) Report Set: this is a required field, you can put anything you want in here. Field Tab - all the fields that I want to show on the report Sorting Tab - I did not choose anything on this tab, everything is blank Statistics - I did not choose anything on this tab, everything is blank Page Setup - I did not make any changes to this tab, I just took the default settings Qualification - did not add anything to this Description - I have a description Permissions - Public Administration - whatever the defaults are (make sure it is set to Active) Close the ReportCreator form, hightlight the report you want to run and make sure these settings are set: Destination: file Override Query in Report? (depends on what you want, but I set my to No) Report Format: CSV Character Encoding: useserver. Is anything different? Are you able to run it from the user tool? Just go to the ReportSelection form and try to run it from there and see what happens. Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hi Lisa, I tried that same result. Perhaps I am doing something wrong. I have an AR System type report. I clicked on the Report button in my browser query window, selected the report and chose destination file, format CSV. The report will preview on screen OK if I select screen as the destination. It will not let me save it to a file. Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, April 18, 2008 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Make sure your report hasPublic permissions and Character Encoding is useserver Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 11:34 AM 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can you export to a csv file from Mid Tier?
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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can you export to a csv file from Mid Tier?
Make sure your report hasPublic permissions and Character Encoding is useserver Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 11:34 AM 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can you export to a csv file from Mid Tier?
Hello Brian, After you run the report and get the report on the screen, click the button highlighted in the snapshot below. Once you click there, it will show a dialog which will let you select the format to export to and the necessary settings for that export. Try this and let me know. Thanks Regards, Abhijit Oak From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 9:04 PM 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___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Outlook.jpg
Re: Can you export to a csv file from Mid Tier?
What screen is that? Are you using the Mid Tier? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Friday, April 18, 2008 12:02 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hello Brian, After you run the report and get the report on the screen, click the button highlighted in the snapshot below. Once you click there, it will show a dialog which will let you select the format to export to and the necessary settings for that export. Try this and let me know. Thanks Regards, Abhijit Oak From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 9:04 PM 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___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __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 Outlook.jpg
Re: Can you export to a csv file from Mid Tier?
Hi Lisa, I tried that same result. Perhaps I am doing something wrong. I have an AR System type report. I clicked on the Report button in my browser query window, selected the report and chose destination file, format CSV. The report will preview on screen OK if I select screen as the destination. It will not let me save it to a file. Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, April 18, 2008 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Make sure your report hasPublic permissions and Character Encoding is useserver Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 11:34 AM 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can you export to a csv file from Mid Tier?
Hello Dylan, Sorry, my mistake. I read from the mail that you have sent to Lisa that you are using AR Reports. The print screen that I have sent to you is from a report developed using Crystal Reports. In that case, my suggestion may not work. Thanks Regards, Abhijit Oak From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 10:02 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** What screen is that? Are you using the Mid Tier? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Friday, April 18, 2008 12:02 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hello Brian, After you run the report and get the report on the screen, click the button highlighted in the snapshot below. Once you click there, it will show a dialog which will let you select the format to export to and the necessary settings for that export. Try this and let me know. Thanks Regards, Abhijit Oak From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 9:04 PM 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___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are Outlook.jpg
Re: Can you export to a csv file from Mid Tier?
No that will not work. I am simply trying to save a csv file from an AR report from Mid Tier. Here is the error. Anyone know what is wrong? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Friday, April 18, 2008 12:43 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hello Dylan, Sorry, my mistake. I read from the mail that you have sent to Lisa that you are using AR Reports. The print screen that I have sent to you is from a report developed using Crystal Reports. In that case, my suggestion may not work. Thanks Regards, Abhijit Oak From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 10:02 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** What screen is that? Are you using the Mid Tier? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abhijit Oak Sent: Friday, April 18, 2008 12:02 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hello Brian, After you run the report and get the report on the screen, click the button highlighted in the snapshot below. Once you click there, it will show a dialog which will let you select the format to export to and the necessary settings for that export. Try this and let me know. Thanks Regards, Abhijit Oak From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 9:04 PM 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___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __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 Outlook.jpgOutlook.jpg
Re: Can you export to a csv file from Mid Tier?
What kind of report is it? Is it just a really simple report (with x number of fields) or does it to a count or sum anywhere? On one of my reports (on the ReportCreator page) here is what I have: Report Name: (any name you want) Server Name: (my server name) Form Name: Contract (for example) Report Format: Record Locale: (I have this blank) Report Set: this is a required field, you can put anything you want in here. Field Tab - all the fields that I want to show on the report Sorting Tab - I did not choose anything on this tab, everything is blank Statistics - I did not choose anything on this tab, everything is blank Page Setup - I did not make any changes to this tab, I just took the default settings Qualification - did not add anything to this Description - I have a description Permissions - Public Administration - whatever the defaults are (make sure it is set to Active) Close the ReportCreator form, hightlight the report you want to run and make sure these settings are set: Destination: file Override Query in Report? (depends on what you want, but I set my to No) Report Format: CSV Character Encoding: useserver. Is anything different? Are you able to run it from the user tool? Just go to the ReportSelection form and try to run it from there and see what happens. Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 12:36 PM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Hi Lisa, I tried that same result. Perhaps I am doing something wrong. I have an AR System type report. I clicked on the Report button in my browser query window, selected the report and chose destination file, format CSV. The report will preview on screen OK if I select screen as the destination. It will not let me save it to a file. Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, April 18, 2008 11:55 AM To: arslist@ARSLIST.ORG Subject: Re: Can you export to a csv file from Mid Tier? ** Make sure your report hasPublic permissions and Character Encoding is useserver Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, April 18, 2008 11:34 AM 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are