18 Replies Latest reply: Sep 7, 2010 7:05 PM by Bob Raikes RSS

    Ajax application won't export to excel

      We have an ajax page that has four tables on it. When I try to export any of the table to excel, the popup window pops up like it should, but instead of prompting for "would you like to open or save the file", the page comes up with the "unable to view the webpage" error. the URL of the popup reads "http://qlikview/qvprint/*a bunch of letters".xls. I've also tried to export to a .csv and it fails as well. Does anyone know why this is occuring. It works on some machines but not on others and I'm not sure what setting would be doing this (IE setting, QV setting, security, firewall, etc). thanks.

        • Ajax application won't export to excel

          I'm having a very similar issue. Our issue is with the Internet Explorer browser exporting reports as excel in AJAX. It works fine with the IE Plug-in in Internet Explorer, with Firefox in AJAX, and Crome in AJAX, but not with Internet Explorer in AJAX. We aren't getting the error that you are, which might have something to do with you have the "Web Folders" tab set up on your QVS Console. When we were getting an error, when we tried downloading the file, we changed our URL to https in the "Web Folders" URL box on the QVS Management console so it ran over the secure port. That fixed the error message, but didn't fix the fact that the file wasn't downloading...

          I have a ticket into the support team at QlikTech. They have forwarded my request on to the second level of support. I'll be sure to provide an update if they get a fix for me.

          rob

          • Ajax application won't export to excel

            Thanks alot. I've tried everything I can think of. We tried changing all the IE security settings, the versions of excel, upgrading IE and nothing works. Hopefully they can figure something out.

              • Ajax application won't export to excel
                Philip Doyne

                Hi All,

                Experiencing exactly the same issue with QVS 9.0 SR2 (released on 30Oct). Symptoms exactly as described above but the same things happens for both Print Export and Send to Excel. In my case I only care about the AJAX client - no info about others. I have 9.00 SR1 installed locally on my PC and it works fine on that so it must be something to do with some security setting. I have Windows Server 2008 on the server. It does not seem to be browser - in IE6 I get the standard windows "The page cannot be displayed" in IE7 I get a blank page. I would expect the Send to Excel to bring up the Open/Save dialog and the Print to put the output in HTML in the web page. It seems odd that it s trying to display the XLS in a web page. Any QlikTechers on line to comment. Also have a call in to support.

                 

                Philip

                  • Ajax application won't export to excel
                    moethegreat

                    Same here. I also have a ticket open. Please everyone keep us posted. I get more answers from teh Forum them Support.


                    Good Luck,

                     

                    Moe

                    p.s. I will keep you all posted.

                      • Ajax application won't export to excel

                        I actually got mine working here. I don't know if all of your systems are the same way, but here's what I had to do:

                        Ours is a sharepoint portal that links back to QV. I set up a virtual directory in IIS on our sharepoint server that links back to the printing folder through the server management console. I believe ours is something like "c:\inetpub\wwwroot\Qvprint" on our QV server. I'm assuming if you're not running through a portal you can set up a virtual directory through IIS on the actual QV server that points back to the printing folder just the same. I also changed the URL in the web folder section to be a full URL. I believe the default is just "http://QLIKVIEW/QvPrint. I changed that to http://qlikview.(whateveryoursis).com/QvPrint path. You should be able to see the full path after the domain in the ASP net section of your IIS and it's listed in virutal path. Now I also had to change the security on the QV print directory in IIS to allow anonymous access to let people go through. I had the anonymous access set to our sharepoint admin username/password and that corrected the issue. If you're not going through another box I don't know if you need anonymous or not. If your webpage authenticates back to the server as a specific username you might have to set that username as the anonymous access. Hope this helps everyone else...feel free to post if you have any questions. i'm running 8.5 here so I don't know how this translates to other versions.

                          • Ajax application won't export to excel
                            Philip Doyne

                            Thanks for that - a partial solution for me - I did have Basic Authentication set on the QVPrint virtual folder and after changing it to Anonymous only the Print and Export functions worked but not the Send to Excel Open/Save.

                              • Ajax application won't export to excel
                                arashid

                                Hi,

                                Any solution related to IE "send to Excel" issue? BR, Abu

                                  • Ajax application won't export to excel

                                    My previous post solved the issue from the ajax client here. We've run into a few other minor things on clients machines that could potentially be a client issue instead of a qlikivew issue from an ajax page:

                                    1. Popup blocker cancelling the page since it pops up in a new window

                                    2. Firewall stops the excel page from opening correctly. This is caused by the way ours is set up. The sharepoint page gets through most firewalls just fine and we have in Iframe that goes to the QV page. When ti send it to excel it tries to open a new domain/SSL cert and some firewalls block that from happening.

                                    3. Every once and a while there's a security setting in IE that breaks it. I just reset everything to default in the IE security/advanced settings.

                                    That's about all I know at this point - since we got it up and running on our side I haven't really looked at it too much though. Thanks

                                      • Ajax application won't export to excel
                                        Tom Mandt

                                        Thanks for your post - but I still am having trouble with IE (both 7 and 8) in AJAX mode and opening an excel export.

                                        I have minimized security on both the server and client (even less than the default setting you mentioned above) and what happens when I select the export to excel icon, I get a short hour glass and a pop-up window flashes (too fast to see the full URL) - but it appears to have the right format and the file gets created on the server (and pasting that QV path and file name into the IE url address line does bring up the excel file). So it kind of acts like a pop-up blocker - but they are all shut off on my box.

                                        Any more suggestions?

                                        Thanks

                                      • Ajax application won't export to excel
                                        arashid

                                        Hello,

                                        I have got a solution from QV. It's clearly related with browser and working for me.

                                        Need to do:

                                        In IE (I am using version 8), go to tools->internet options->Internet->custom level->in downloads settings, select Enable.

                                        In Safari, Edit-> uncheck Block Pop-up Windows.

                                         

                                        Cheers.

                                         

                                • Ajax application won't export to excel

                                  I think Your issue may be down to the 2008 server, I have a qvw with Some FileOpen functionality on a macro and it wont run on the server as it cant find a suitable Fileopen Dialog control on the server OS.

                                  Mabe this is a similar issue somehow. Have you got a test box running an older Server OS ?

                                  ColinR

                                   

                                   

                                   

                              • Ajax application won't export to excel
                                Matt Clark

                                My symptoms were a bit different - the popup page only showed up for a fraction of a second in IE7/IE8, but worked in Firefox.

                                I traced the problem down to the prompt that asks if you are sure you wish to open or save the file. Clicking the checkbox fixed the problem for fugure Export-to-Excel operations.

                                Setting a binary value of "0000" for this Windows registry key works:

                                HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}\Excel.Sheet.8

                                I created a file named "ExportToExcelFix.reg" and made it available to my web clients. Running this file fixes the Export-to-Excel problem. Note that I also had to update my IIS Mime Types so that ".reg" files are sent as "application/octet-stream" when distributing this .reg file over the web.

                                Matt Clark

                                • Ajax application won't export to excel

                                  I was having the same problem with my QvPrint Export to Excel (QV9 x64 SR4). The solution that worked for me was to explicitly state the web URL in the QMC at QlikView Server Settings -> Print -> URL. I replaced the server name there with the specific URL that should be used and it worked like a charm.