Error #2032 Xcelsius Xml Data
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Xcelsius XML Data connection using .aspx page Error #2032 up vote 0 down vote favorite Because of my version of Xcelsius I'm limited to 2 web service connections so I tried using XML Data connection and aspx page to bring data from database to Xcelsius. I have an ASPX page that outputs an xml file with the format
on April 26, 2008 | 43 Comments Accessing data in Xcelsius is pretty easy. You can have static data loaded from Excel, or dynamic data loaded through Web Services, Excel XML Maps, QaaWS (Query as a Web Service), Crystal Reports, Web Intelligence Reports or queries using Live Office. There are however only a few ways to export data from Xcelsius. Either we could use Flash variables or use the XML Data Button to export data out of the compiled .swf file. Here I present a simple method to export data from an Xcelsius .swf to http://stackoverflow.com/questions/9810680/xcelsius-xml-data-connection-using-aspx-page-error-2032 a csv/Excel file. This method utilizes the XML Data Button's capability to send and receive XML data. The source code is provided at the end of this post as a download. Copy the code from the PDF and save as export2csv.aspx on the web server. Note that this is an ASP.Net (.aspx extension) file, which works with an IIS Web Server. If you wish to use https://biguru.wordpress.com/2008/04/26/export-data-out-of-your-xcelsius-dashboards/ this code, please remember to change the links to point to your webserver and the appropriate directories. For being able to write the exported data to a directory, you may need to grant Write access to the IUSR_ account to allow anonymous access. After you've placed the export2csv.aspx file on your webserver, perform the following steps in your XLF file. 1. Add an XML data button [ Xcelsius 4.5 ]/Connection Refresh button [ Xcelsius 2008 ] and check the "Enable Send" box. Make sure that in the MIME Type dropdown, "application/x-www-form-urlencoded" is selected. 2. Type out the URL of the export2csv.aspx file in the XML Data URL and add the ranges of data that you need to export. The screenshot above shows 2 ranges being exported. 3. Check the "Enable Load" box and add a single cell range (Sheet1!$J$1 in the example) to receive the URL of the CSV file that will be returned by the export2csv.aspx file. Note that the XML variable name returned by the export2csv.aspx is exportdataurl, so you need to name the range the same. If you wish to change the name, you'll need to update the same in t
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. Regarding Error #2032 Goto page 1, 2Next Search this topic...|Search Xcelsius - Crystal Dashboard Design...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All http://www.forumtopics.com/busobj/viewtopic.php?p=612678 Forums) Unanswered Posts Register or Login to Post Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design Author Message rajani_jaganSenior MemberJoined: 23 Jan 2008Posts: 77Location: Chennai Posted: Tue Jan 20, 2009 1:36 amPost subject: Regarding Error #2032 Hi All I created a dashboard by using Crystal Xcelsius and Web Service. This Web Service is having three methods and the output of the first method is Input to the second method error #2032 and the Output of the second method is Input to the third method. I used three Web Service Connections and three Connection Refresh Buttons and I used the option called "When Cell Updates". When I am using When Cell Updates field for the first connection refresh button there is no error and when I am using for third connection refresh button it is giving error # 2032. After clicking on OK Button the dashboard is error #2032 xcelsius working fine. If I remove the When cell updates field then there is no error. But the data is not coming properly. I am attaching the XLF file for reference. Please check and tell me is there any solution for this. Thanks in advance Rajani Back to top titlolaPrincipal MemberJoined: 10 Jan 2007Posts: 205Location: France Posted: Tue Jan 20, 2009 3:19 amPost subject: Re: Regarding Error #2032 Hi, I have created a dashboard with a WebService too. I frequently get error 2032, but it seems this error is something like a default error. I get it in Xcelsius each time there is an error in the code of my WebService. The solution is probably in your WebService and not in Xcelsius... Hope it helps Back to top mandavasriharibabuForum MemberJoined: 07 Jan 2009Posts: 19 Posted: Tue Jan 20, 2009 5:01 amPost subject: Re: Regarding Error #2032 Hi, The Error #2032 your getting is due to the Flash player security. To remove this this error you need one crossdomain Xml file in the root directory which actually provides a lot more control over who has access to your data from a SWF. The cross domain policy is attached as crossdomain.xml. In the XML file, it is used a wildcard (*). This allows a SWF located on any machine to access your data s