View Issue Details

IDProjectCategoryView StatusLast Update
0015526phpList 3 applicationSubscriber Exportpublic03-05-11 16:50
Reporterhovel Assigned To 
Status resolvedResolutionfixed 
Product Version2.10.12 
Target Version2.10.XFixed in Version2.10.14 
Summary0015526: SYLK file not valid...
DescriptionAn exported user list containing the ID column cannot be opened in Excel.
Excel gives error: "SYLK: File format is not valid"


I do not understand the decision "won't fix" for the above issue. One goes through the effort of adding a note to the documentation while it is just as easy to correct the code.

The best way, in my opinion, to solve this is to change the string "ID" to "Id" in file \admin\structure.php. At list on line 29, or better still for all occurances in the file. (Change all case sensitive).

Not correcting such a problem is not an option!
TagsNo tags attached.


related to 0004677 closed SYLK file not valid... 



22-08-10 17:05

manager   ~0051072

Related forum treads:


29-04-11 22:09

administrator   ~0051243

I don't have excel, so it's a bit hard to test, but are you saying that your suggested fix of changing ID to id solves it?

I use open office, which has no problem opening the phpList exports.

If you can confirm that the lowercase fixes it, then I'd be happy to eg force all column headings lowerkey in the export, or maybe just the ID one. I wouldn't want to do this in the structure.php file, as that is used all over and might break something else


30-04-11 19:24

reporter   ~0051255

I hereby confirm that the lowercase fixes the problem.

See also the Microsoft kb

p.s. I also use but my custommer does not.


03-05-11 16:50

administrator   ~0051257