still the problem of the backup in excel

[jack19]

Hi to all,
I a strange thing happens on backup to excel in the localhost works fine, but on the web server returns a blank Excel file.
Any idea?

[GreyHead]

Hi jack19,

Could be a permissions problem, could be a server timeout.

Try setting your site error reporting temporarily to Maximum and see if you get any error mesages (they may appear inside the Excel file).

Bob

[jack19]

Try setting your site error reporting temporarily to Maximum and see if you get any error mesages (they may appear inside the Excel file).

Bob

Hi Bob,
I try, but no error messages appear.I use Excel 2007 and displays the dialog box that warns you that the file format is different than that specified by the file.

[GreyHead]

Hi jack19,

Hmm - very hard to say much more. By all means PM or email me the url and a SuperAdmin login and I'll take a quick look.

Bob

[yvet]

Hi Bob and Jacky,

After reading and trying this and this tread, I'm also having the same problems Jacky is describing.

Hope you find some solution. Thanks.

Yvet

[GreyHead]

Hi Yvet,

What are the character code settings for your database tables? Are they set to UTF-8 or something else?

Bob

[yvet]

Hi Bob,

It is:

MySQL Karakterset: UTF-8 Unicode (utf8)
MySQL verbindingscollatie: Collatie utf8_unicode_ci

So that can't be the problem?

Yvet

[GreyHead]

Hi Yvet,

Would you be kind enough to take a MySQL dump of your database table and email it to the address in my sig below. Then I'll see if I can replicate the problem.

Bob

[yvet]

Hi Bob,

Ofcourse I will and did already! Thank you for the help. Hopefully, you can see what is wrong.

Yvet

[GreyHead]

Hi Yvet,

Just to report progress - or lack of it.

At the moment I'm baffled. I can export all of data in chunks so there is nothing wrong with that. But if I export more than about 8 rows or about 20 columns then the data is corrupt

I've tried various combinations of rows and columns and saving the the file before downloading all so far to no effect .

I'll keep thinking about it and hope that I have a bright idea.

Bob