Welcome, Guest
Username: Password: Remember me

TOPIC: Export Data to Excel

Export Data to Excel 4 years 5 months ago #44642

  • chinglnc
  • chinglnc's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 29
  • Karma: 0
Hello

I can't seem to export the data properly anymore.

Although I'm still able to export the data, but it has become an unrecognised format for Excel.

I have tried both mac and windows, new and old versions of excel, but none of them work. Though everything was fine last week.

Microsoft Word, CSV still working fine, just excel.

Anyone has the same problem as me?
The administrator has disabled public write access.

Re:Export Data to Excel 4 years 3 months ago #46913

  • freakingid
  • freakingid's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
I've had the problem also with Microsoft Word. The document is created, but it contains some PHP error codes instead of DOC-data.
The administrator has disabled public write access.

Re:Export Data to Excel 4 years 3 months ago #46944

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6551
  • Thank you received: 868
  • Karma: 257
Hello,

What version of LS did you use ?
Have you a debug=0 on your config.php ?

Can you copy/paste the php error code ?
The administrator has disabled public write access.

Re:Export Data to Excel 4 years 3 months ago #46976

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5423
  • Thank you received: 307
  • Karma: 252
@chingInc, there must ahve been some changes to your system, it can't have changed magically. Did you perform an update?

@freakingid: This problem should be solved meanwhile. limesurvey.svn.sourceforge.net/viewvc/li...vision&revision=9050

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re:Export Data to Excel 3 years 11 months ago #53810

  • ChacoKevy
  • ChacoKevy's Avatar
  • OFFLINE
  • Junior Lime
  • Posts: 20
  • Karma: 1
What version of LS did you use ?
Have you a debug=0 on your config.php ?

Can you copy/paste the php error code ?


I believe I ran into this same error, yet I'm still trying to trace my steps to see what I may have done.
LS 1.90+
The dialog box when you try to open the export says the file format is unrecognizable, but then as a bullet point says click "OK" if you would like to see the text in the file. On Doing that, here is that line I see in excel.

:SELECT * FROM lime_answers WHERE qid=39 AND language='en' AND code = ?

The changes to the configuration I've been making have been 1) along the lines of template editing to remove the placeholders in the welcome screen, and 2) Using Jason's suggestion to remove the "No answer" selection using the $shownoanswer = 0; line. (It didn't work, so I have since removed the line)

Will let you know when I figure something out.
-Kevy
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.160 seconds
Donation Image