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

Excel 2007 File on FTP

Hi All,

I have been using Text file / CSV File / XLS file on the FTP Location as a data source for my Qlikview applications. Recently i am getting XLSX Files as the data source. QlikView is not able to identify them as ooxml format by default. Even if i change the code manually to read from the FTP File, QV gives a error as SCRIPT ERROR and does not give any information regarding the same.

If any of you have a solution, please do share with me.

Regards,

Sriram N

5 Replies
jacekvsp
Contributor III
Contributor III

I have the same problem. Any ideas?

parpatra
Partner - Contributor III
Partner - Contributor III

Has anyone found a solution to this? The xlsx files does show anything while reading from FTP location.

Not applicable
Author

You have problems only with xlsx files or with other files too?

eg. txt or csv reading is OK?

Not applicable
Author

Seeing the same thing with xlsx files only.  csv and xls works fine.

Testing on QV 9 SR3 and QV10 SR1.  Problem is the same in both.  ftp sees file, but doesn't do preview and can't load data.

strange...

Not applicable
Author

The .docx and .xmlx are actually ZIP files with loads of XML and other files inside.

Something (maybe your server) detects that the files are ZIPs and marks them as such (using Content-Type header), what makes your browser interpret them as ZIP, despite them not having the .zip extension.