Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Export Answers/Responses as .sql

More
9 years 6 months ago - 9 years 6 months ago #112579 by nali
Export Answers/Responses as .sql was created by nali
Hello there

I would like to find out, if I can export my responses/answers as an sql? SO it'll be easier for us to just import them into our FileMaker database.

(I have notice that only when you are backing up the entire database, that's when it is in .sql, but if I want to export my answers it gives me options of only: CSV, EXCEL, WORD, HTML & PDF)

SOS :S
Last edit: 9 years 6 months ago by nali. Reason: error
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 6 months ago #112602 by DenisChenu
Replied by DenisChenu on topic Export Answers/Responses as .sql
You can activate plugin :
- STATA Export
- SPSS
- R

This is not SQL, but more done for survey.

You can construct a SQL export if needed (look at SPSS for example)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
More
9 years 6 months ago #112604 by nali
Replied by nali on topic Export Answers/Responses as .sql
Where can I activate those? :unsure:
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 6 months ago #112608 by DenisChenu
Replied by DenisChenu on topic Export Answers/Responses as .sql

nali wrote: Where can I activate those? :unsure:

In plugin management via admin part. The last icon on the first menu.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: nali
The topic has been locked.
More
9 years 6 months ago #112612 by nali
Replied by nali on topic Export Answers/Responses as .sql
I activated the STATA Export & R, but there wasn't - SPSS (see attached
).
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 6 months ago #112621 by DenisChenu
Replied by DenisChenu on topic Export Answers/Responses as .sql

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: nali
The topic has been locked.
More
6 years 10 months ago #153212 by ConradNg
Replied by ConradNg on topic Export Answers/Responses as .sql
Hi Denis,

I am curious if there will be any development on this export function as SQL?

Kind Regards,
Conrad
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 10 months ago #153214 by DenisChenu
Replied by DenisChenu on topic Export Answers/Responses as .sql
I never say i make such export, and nobody ask me a new export.

extensions.sondages.pro/about/contact

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 10 months ago #153216 by holch
Replied by holch on topic Export Answers/Responses as .sql
I am not an expert, but as the results of a survey are usually stored in one database, how hard can it be to use something like PHPmyAdmin, search for the correct database and export it manually?

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The following user(s) said Thank You: DenisChenu, ConradNg
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose