- Posts: 19
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Export Answers/Responses as .sql
- nali
- Topic Author
- Offline
- New Member
Less
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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
9 years 6 months ago #112602
by DenisChenu
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.
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)
- 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.
- nali
- Topic Author
- Offline
- New Member
Less
More
- Posts: 19
- Thank you received: 0
9 years 6 months ago #112604
by nali
Replied by nali on topic Export Answers/Responses as .sql
Where can I activate those?
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
9 years 6 months ago #112608
by DenisChenu
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.
Replied by DenisChenu on topic Export Answers/Responses as .sql
In plugin management via admin part. The last icon on the first menu.nali wrote: Where can I activate those?
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.
- nali
- Topic Author
- Offline
- New Member
Less
More
- Posts: 19
- Thank you received: 0
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
9 years 6 months ago #112621
by DenisChenu
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.
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.
- ConradNg
- Offline
- New Member
Less
More
- Posts: 14
- Thank you received: 0
6 years 11 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
I am curious if there will be any development on this export function as SQL?
Kind Regards,
Conrad
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
6 years 11 months ago #153214
by DenisChenu
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.
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
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11758
- Thank you received: 2753
6 years 11 months ago #153216
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
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.