Error: Bad Zip File

[#1]

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!

[ashfaq_haseeb]

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

[#3]

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

[sudeepkm]

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

[jaimeaguilar]

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

[Anonymous]

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.

[#7]

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?

[#8 · Accepted solution]

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.