phpMyAdmin / Bugs / #3007 (OK 3.3.3) Excel 97-2003 export omits data

Björn Wiberg - 2010-03-22

SQL dump of table "rum"

rum.sql

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-03-22

XLS export of table "rum"

rum.xls

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-03-31

Exported Excel 97-2003 file, of the database you provided, opens without a problem.

Might this be related to bug #2973277 (Excel 97-2003 exports and include path) you reported?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-03-31

status: open --> open-works-for-me
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-03-31

status: open-works-for-me --> pending-works-for-me
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-03-31

assigned_to: nobody --> ruleant
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-06

I believe not, as the problem occurs despite the fix in bug #2973277.

Have you tried this with PHP 5.2.13?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-06

status: pending-works-for-me --> open-works-for-me
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-06

assigned_to: ruleant --> nobody
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-06

I tested it with PHP 5.2.6, but I don't have 5.2.13 available at the moment, so I can't test it right now.

I think you mean the fix for bug #2973280. Bug #2973277 was closed after you said it was due to a bug in PHP.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

Problem occurs on 5.2.13 with fix for bug #2973280 applied and with correct include path being set (administratively and manually) as per bug #2973277.

I'll try with PHP 5.2.12 to see if PHP 5.2.13 is causing the problem. I'll get back to you with results soon.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

Tried phpMyAdmin 3.3.1 with PHP 5.2.12, same problem as phpMyAdmin 3.3.1 with PHP 5.2.13 (Excel complains about some content being impossible to read and offers to repair -- and it appears that it doesn't like the workbook name).

I'll investigate this further and will get back to you as soon as possible.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

Problem also present in phpMyAdmin 3.3.0 (PHP 5.2.13).

As a sidenote, phpMyAdmin 3.3.0 also needs the fix for bug #2973280, which I applied before testing.

I'll investigate this further and will get back to you as soon as
possible.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

Verified OK with phpMyAdmin 3.2.5 (PHP 5.2.13) and Microsoft Excel 2000 export.
It appears that something must have broken in the newer Excel (97-2003) export as of phpMyAdmin 3.3.0 and up.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

The source of the problems appears to be the IBM AIX iconv().

Many of the iconv() calls performed by PHPExcel simply do not work with the IBM AIX version of iconv().
I noticed problems with character counting, garbled characters and lost column names when enabling/disabling different iconv() calls in libraries/PHPExcel/PHPExcel/String.php.

The work-around is to make PHPExcel NOT use iconv() iff all these criteria are met:

* PHP is running on operating system "AIX"
* The iconv implementation is reported as "unknown"
* The iconv version is reported as "unknown"

...as using the IBM AIX iconv() will not work.

Attaching a simple patch for this. Will try to push it upstream to the PHPExcel developers, too.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

libraries/PHPExcel/PHPExcel/Shared/String.php patch to disable IBM AIX iconv() (only)

String.php.diff

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

This of course applies to phpMyAdmin 3.3.0 as well as the new PHPExcel code was introduced in 3.3.0.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-07

Logged upstream (PHPExcel) as: http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=12538

But unsure when/if this will be adressed in PHPExcel, and when phpMyAdmin will fetch a "fixed" version from upstream?

Perhaps the patch could be applied in phpMyAdmin for now, and the next time PHPExcel is fetched from upstream, the fix will hopefully be in it already?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Björn Wiberg - 2010-04-08

It appears the patch has been accepted and should be included in the next release of PHPExcel (1.7.3?):

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=12538

Please schedule a download of the new version for integration with phpMyAdmin as soon as it becomes available.

Thanks in advance!

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-08

Thanks for debugging. We'll keep an eye open for a future release of PHPExcel

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-08

assigned_to: nobody --> ruleant

status: open-works-for-me --> open-accepted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-09

For future reference:
* libraries/PHPExcel/ is at version 1.7.0
except:
libraries/PHPExcel/PHPExcel/Shared/Escher (included in PHPExcel 1.6.7)
libraries/PHPExcel/PHPExcel/Shared/JAMA (included in PHPExcel 1.6.7)

libraries/PHPExcel/PHPExcel/Shared/PDF (not present)
libraries/PHPExcel/PHPExcel/Shared/JAMA/docs (not present)
libraries/PHPExcel/PHPExcel/Shared/JAMA/examples (not present)
libraries/PHPExcel/PHPExcel/Shared/JAMA/tests (not present)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-12

This bug was fixed in repository and will be part of a future release; thanks for reporting.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-12

summary: Excel 97-2003 export omits data --> (OK 3.3.3) Excel 97-2003 export omits data

priority: 5 --> 1

status: open-accepted --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Dieter Adriaenssens - 2010-04-12

I tested the fix (PHP 5.2.6, i386, linux) : export/import of Excel 97-2003 still works.
Couldn't test on IBM AIX. Please test this when version 3.3.3 is released.

We plan on upgrading the PHPExcel library in a future phpMyAdmin release (3.4 >), once your patch is included in a PHPExcel release.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(OK 3.3.3) Excel 97-2003 export omits data

A software tool to bring MySQL to the Web

Group

Searches

Help

#3007 (OK 3.3.3) Excel 97-2003 export omits data

Discussion