Welcome to the LimeSurvey Community Forum

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

Query the hosted LimeSurvey sql database

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 1 month ago #194015 by Joffm
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

Volunteers are not paid.
Not because they are worthless, but because they are priceless
The topic has been locked.
  • christianlangkamp
  • christianlangkamp's Avatar
  • Offline
  • Junior Member
  • Junior Member
More
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...
The topic has been locked.
More
4 years 1 month ago #194037 by jelo
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/

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
  • christianlangkamp's Avatar
  • Offline
  • Junior Member
  • Junior Member
More
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
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose