Error when trying to export to excel

[Former Member]

I have been having a problem with some of the dashboards I have been creating that export data to a csv file. I used the process described here: http://biguru.wordpress.com/2008/04/26/export-data-out-of-your-xcelsius-dashboards/. When I trigger the XML connection it gives me an Error #2032. I have done research on this error as I have seen it before and usually the solution has something to do with a crossdomain.xml file. However, I don't think this is a fix for my problem. The reason I believe this is because I have successfully created dashboards that implement this export method before. In fact I have .swf files and .xlf files that continue to function properly. It's just new dashboards that I create where I see this error. Seeing as both the functioning and non-functioning files exist in the same directory and on the same server, it's hard for me to believe the error is a result of a crossdomain policy. Any ideas on what might be the problem?

[Former Member]

Hi,

I think you don't have a direct solution for exporting data from excel,

You can try using the following add-on component ,in which supports both flex2

and fllex 4 version ,which you can use the current data lively to excel and also to csv formats...

http://www.visualbis.com/products/export-to-excel/

Thanks & Regards

Vignesh VL

[Former Member]

Hi Vignesh,

it is a direct solution, but will not work in the older versions of Xcelsius (which requires flex 2). However, the solution is for free and can be used with the version of Dashboards 4.0 SP3 or higher.

Ivo

[Former Member]

Just download the free Data Export addon from http://www.just-bi.nl (in articles). No need for jsp's or aspx files anymore.

[Former Member]

But doesn't this only work for the latest SAP Dashboard 4.0?  How about for those with just Xcelsius Engage 2008?  I'm thinking that's why everyone is discussing the XML output option

• http://biguru.wordpress.com/2008/04/26/export-data-out-of-your-xcelsius-dashboards/
• http://myxcelsius.com/2009/07/06/customize-your-xcelsius-dashboard-with-the-export2excel-solution-fr...

[Former Member]

Hi Jacob,

We are facing the same error while using Export2Excel tool. We have followed the prcedure as mentiond in http://myxcelsius.com/2009/07/06/customize-your-xcelsius-dashboard-with-the-export2excel-solution-fr...

but still we are not able to resolve the issue.

Regards

Sushant

[Former Member]

I have found that I am able to open a connection to a .xml file with the XML connection even in new dashboards. The error seems to pop up when I set the XML Data URL to the .aspx file that the export method calls for. Still is a mystery to me why I was able to reference this file in previous dashboards without encountering the error though.

[Former Member]

Argh this was so frustrating but I finally figured out the problem and it had nothing to do with what I thought it might be. Turns out it was a problem with the name of the file I was trying to create. Because I was generating the names dynamically, the old dashboards were producing names that were acceptable to a Windows environment while the new dashboards were not (I was using ">" in the file name). Guess the most important thing I learned from this was that Error #2032 is a very generic error and could mean a whole bunch of different things.