Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Why is export function defaulting automatically to CSV

Hey guys,

I have an issue when trying to export a QV table from the server. On my development environment, when I right click on the table and select the Export.. function, I get the usual Windows dialog box which lets me select the file type and destination, which is what I want. When I try the same thing on the production server to the same table, it automatically starts to export to a CSV file, which I don't have a problem with but it saves it to the server, and opens up a separate browser window. I need to get the dialog box to choose a local destination. Is there an option what should be changed in the adminitration area of the server?

5 Replies
Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

Have you tried the Broser Download options? You can set it up to automatically donwload to a specific location or let you choose destination for every download.

Not applicable
Author

Emmanuelle,

I am using IE 9 to access the QV server. Where do I find the Browser Download options? Would that happen to be in Security Settings? All I see there is Downloads:  Enabled.

Giuseppe_Novello

What version of windows office are you using? Are you using IE plug-in client or Ajax client?

Not the following:

The Microsoft Excel 97-2003 file format XLS, only supports sheets with maximum of  65 536 rows and 256 columns.

For this reason QlikView can not export data larger than the above limit to XLS files, as can been seen in Microsoft's specifications below: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

Tables larger than the XLS limitation will be exported to Excel as comma separated (.CSV) text files instead, to get around the file format limitation.


Now you need to implement a Easter egg to increment the mount of rows to xls format, but this will only work for Ajax client.

1- Stop Qlikview server service

2- GO to QVS settings.ini ( C:\ProgramData\QlikTech\QlikViewServer\settings.ini)

3- below "[settings 7]" add RowLimitForCsvInsteadOfXls= <number> ( I use for <number> " 1000000")

4- Save the file

5- Start Qlikview server service again

6- Export and it should export to .xls file.

Giuseppe Novello
Principal Technical Support Engineer @ Qlik
Not applicable
Author

Giuseppe,

I am using Office 2010. Thats the reason I was trying to export to a CSV in the first place, because I was trying to export 129k rows with the "Send to Excel" option, and it automatically opened up another browser window with the data in CSV format. Then I tried the "Export.." option and again it automatically opened up the CSV in a browser window. Neither option is letting me save the file locally in my machine. The only workaround to that is opening up Excel and importing the data from the url the server generated when it created the csv. The instructions you gave me above should be done by the server administrator right? Because I don't have access to the server directly, so I would have to send a request to them.

Emmanuelle__Bustos
Partner - Specialist
Partner - Specialist

129K rows....

Then what Giuseppe advised might be the solution, and yes that's an QV Server administrator task.