- Posts: 12790
- Thank you received: 3940
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Query the hosted LimeSurvey sql database
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
4 years 1 month ago #194015
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Query the hosted LimeSurvey sql database
I am not really sure what christianlangkamp talked about.
He asked in two old threads, this one about a LS hosted installation and the other one about direct querying the database (how to query to replace SGQA codes with question codes).
But he didn't mention where his installation is hosted.
So I answered to more or less both questions in one answer.
Joffm
He asked in two old threads, this one about a LS hosted installation and the other one about direct querying the database (how to query to replace SGQA codes with question codes).
But he didn't mention where his installation is hosted.
So I answered to more or less both questions in one answer.
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
- christianlangkamp
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
4 years 1 month ago #194018
by christianlangkamp
Replied by christianlangkamp on topic Query the hosted LimeSurvey sql database
I am in the hosted Limesurvey one. The commercial package so to speak.
At the moment once a week I go in and download a CSV. That is OK for now, but a bit of a nuisance.
But it would be so much more convenient to be able to just use a SQL Query node in KNIME or so and just click the update button...
At the moment once a week I go in and download a CSV. That is OK for now, but a bit of a nuisance.
But it would be so much more convenient to be able to just use a SQL Query node in KNIME or so and just click the update button...
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
4 years 1 month ago #194037
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Query the hosted LimeSurvey sql database
The RemoteControl API is the way to go at the moment.
1. In the long run: KNIME extension for LimeSurvey
2. Shortcut: Check interfaces of other languages, which might already have a toolchain into KNIME.
LimeSurvey via R: LimeR: github.com/cloudyr/limer
LimeSurvey via Python: Limepy : pypi.org/project/limepy/
1. In the long run: KNIME extension for LimeSurvey
2. Shortcut: Check interfaces of other languages, which might already have a toolchain into KNIME.
LimeSurvey via R: LimeR: github.com/cloudyr/limer
LimeSurvey via Python: Limepy : pypi.org/project/limepy/
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: christianlangkamp
The topic has been locked.
- christianlangkamp
- Offline
- Junior Member
Less
More
- Posts: 32
- Thank you received: 0
4 years 1 month ago #194042
by christianlangkamp
Replied by christianlangkamp on topic Query the hosted LimeSurvey sql database
Hi Jelo
This is great - thanks for pointing to this. R and Python might be enough, though a KNIME node (maybe even using one of those packages) might be even better.
I will put it onto the KNIME Forum.
Thanks
This is great - thanks for pointing to this. R and Python might be enough, though a KNIME node (maybe even using one of those packages) might be even better.
I will put it onto the KNIME Forum.
Thanks
The topic has been locked.