The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: How can I export survey responses directly from SQLserver?

How can I export survey responses directly from SQLserver? 2 months 2 days ago #93961

  • ldhf5237
  • ldhf5237's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
:(
As we know data extraction from Lime Survey is limited. Now I got a requirement from business users to export data from SQLServer directly by running a SQL code. But when I queried in database I found some languages are stored as strange codes in database. How could I export the responses correctly without strange codes?

Many thanks in advance.
The administrator has disabled public write access.

How can I export survey responses directly from SQLserver? 2 months 1 day ago #93966

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5116
  • Thank you received: 260
  • Karma: 240
You are not the only one having tried to export data directly via an SQL statement and so far no one has succeeded to do so.
There are several reasons for this, e.g. Limesurvey stores answer codes instead of the full text answers to deal with multi-lingual surveys and thus several sub-queries are needed to get in all in line.
You definitely need a PHP script to do the export the data (and write it into another DB).

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.
The following user(s) said Thank You: ldhf5237
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.226 seconds
Donation Image