topic Re: Error: Bad Zip File in QlikView

Error: Bad Zip File

Thu, 10 Jul 2014 15:02:42 GMT

Hello,

When I load my script, I have a "bad zip file" error. Is there a typical reason for this kind of error? My script seems to work even with the error... but I would like to solve it anyway.

I load three different kinds of files with a loop and I have the error message at the beginning of each loop.

Thank you for your help!

Re: Error: Bad Zip File

alexandros17 — Thu, 10 Jul 2014 15:03:58 GMT

Because one of your files is cripted (rar or zip or something else) and cannot be read

Re: Error: Bad Zip File

jaimeaguilar — Thu, 10 Jul 2014 15:37:56 GMT

Hi,

Are you getting this error message?

if yes, then it is happens because you're trying to load a file extension with wrong syntax. For example trying to load a xlsx with the syntax of a xls file will cause this error. Just double check that you're loading your data with the correct syntax,

regads

Re: Error: Bad Zip File

Mon, 14 Jul 2014 10:03:43 GMT

This is the error message I get:

All the files I load are "xlsx" and the syntax for loading them is also "xlsx"... I don't think they are cripted but how can I control that?

Re: Error: Bad Zip File

ashfaq_haseeb — Mon, 14 Jul 2014 10:07:57 GMT

Is your sheet password protected?

Regards

ASHFAQ

Re: Error: Bad Zip File

amit_saini — Mon, 14 Jul 2014 10:08:33 GMT

Hi Anne,

It may be possibility that source sheet is corrupted if not than in document properties enable generate log file (in general file). While reloading a log file is create which can be helpful to spot the defective excel file. Along with the error description.

Thanks,

Re: Error: Bad Zip File

Mon, 14 Jul 2014 12:44:09 GMT

No it isn't. How do I know if the source sheet is corrupted? I created a log file but it doesn't help me more...

Re: Error: Bad Zip File

ashfaq_haseeb — Mon, 14 Jul 2014 12:51:46 GMT

Can you try by replacing it with another excel file.

try by copying content from old xl to new xl.

Regards

ASHFAQ

Re: Error: Bad Zip File

sudeepkm — Mon, 14 Jul 2014 12:53:10 GMT

maybe one of your source files are xls (97 - 2003 format) file but the extension just changed to xlsx. can you please save all your source files as xlsx and try to load.

Re: Error: Bad Zip File

Mon, 14 Jul 2014 13:30:34 GMT

I juste did this, as you suggested, and it still doesn't work... I saved all files as xslx...

Thank you everybody for your help and your answer... I hope we can find the solution!

Re: Error: Bad Zip File

ashfaq_haseeb — Mon, 14 Jul 2014 13:35:12 GMT

Hi,

Did you try by transferring content from 1 file to anther?

Can you try to load by placing exit script; function after every table one by one.

May be the error is somewhere else then we are checking?

Enable document log even.

let us know if that helped.

Regards

ASHFAQ

Re: Error: Bad Zip File

Mon, 14 Jul 2014 14:18:43 GMT

Yes I try by transferring content from one file to another but I still have the error message.

What is the exit script function? I can't write it after each table I load because I'm using a loop. Do you mean I have to rewrite my script without the loop?

Tanks

Re: Error: Bad Zip File

sudeepkm — Mon, 14 Jul 2014 14:27:03 GMT

can you please share one of your files? you can scramble the data in the xls or reduce rows before sending.

Re: Error: Bad Zip File

jaimeaguilar — Mon, 14 Jul 2014 17:34:17 GMT

Have you tried generating again the script with the wizard (with the button called "Table Files")?

after regenerating that block of script you'll just need to enclose it with loop part you're using to fetch multiple files. If you're sure all the files are xlsx, then I suppose the error is in some part of the script syntax,

regards

Re: Error: Bad Zip File

Anonymous — Mon, 14 Jul 2014 19:44:34 GMT

This issue I faced when my script was set to read xls 2010 file but spreadsheet in next run was saved in 97-2003 format.

Re: Error: Bad Zip File

Thu, 17 Jul 2014 07:31:40 GMT

I found a little mistake: I loaded "sheet1" but in my files it was "Feuil1" because in french. I've changed that and I still have the same error message...

I tried to generate the script again with the wizard. Here is a part of my script:

for each fichier_courant2 in filelist ($(srcdir)&'*QRY.xlsx')

PDP2:

LOAD [Code Direction],

Direction,

[Code Service],

Service,

[Code Sous-service],

[Sous-service],

[Date sélective],

[N° poste],

[N° poste interne],

[Intitulé du poste],

[Statut poste],

[Origine: Type],

[Origine: Valeur],

[Cd empl.],

[Intitulé emploi],

[ETP alloué]

FROM

$(fichier_courant2)

(ooxml, embedded labels, header is 1 lines, table is Feuil1)

Where not Match ([Code Direction],'D0033') and not Match ([Statut poste],'Proposé');

Next;

How can I share one of my xlsx files?

Re: Error: Bad Zip File

Thu, 17 Jul 2014 15:01:45 GMT

Hi everybody, I found the error. The files came automatically from a program generating excel files and for this reason there was some special format which weren't recognised I think... I had to copy paste the values in a new excel file. Now it works. Thank you for your help.