PDA

View Full Version : Freq. Flyer Activity Export Bug

paulfanner
April 17th, 2008, 08:35 AM
The Export to Excel button in the Frequent Flyer Activity dialog creates a file that is not recognized by Excel.
michael
April 17th, 2008, 09:00 AM
I just tried this and the .csv opened perfectly.
paulfanner
April 17th, 2008, 09:40 AM
Well it doesn't work for me. I am using Excel 2003 and I get the attached error message when I try to export this data. Having looked at the created file I note that it is separated with semi colons, not commas. I also attach the file created.
4529

4530
michael
April 17th, 2008, 09:54 AM
Strange. Try manually placing the .csv extension text in the file name before saving.
paulfanner
April 17th, 2008, 10:48 AM
I have tried this, but it doesn't make any difference (the file already had a .csv file name).
FunnyComputerGu
April 17th, 2008, 01:41 PM
I have replicated the error and know why it is being caused.

When you select a Frequent Flyer account on the Desktop version and go to the activity tab there is an option to export to excel.

When the file gets exported it is saved as a CSV (comma seperated values) file, but if you open the file in Notepad the values are all seperated by semi-colons ( ; ) and that's why Excel is not recognizing the file.