Hello everyone,
I would be super grateful if someone could help me set up an importxml connection from Google Sheets to Limesurvey.
More specifically, this is what I would like to achieve:
I personally use to read directly ( using "IMPORTXML" function) some data collected with LS in a GG spreadsheet. Its very easy; No required use neither of LS nor GG APIs. Note that new survey responses are not exactly transmited in real-time, because there is usually a 15 to 30 minutes delay with the spreadsheet update, but it's ok
.
Some interessant features are:
I am trying to follow this manual.
I suppose this is what I need to do:
- Create the php.file:
Is the dblocation https://mylimesurveysite.com/admin/index.php?
What is the dbname?
dbuser and dbpwd are the LimeSurvey user credentials?
(No questions about sid :-)).
-
Save it at http://mylimesurveysite.com/test.php
Here is where I run into difficulties since we run LS on Cloudron.
-
Paste the following formula in Google Sheets:
=IMPORTXML("http://mylimesurveysite.com/test.php?refresh=&GoogleClock()", "//mytaglabel")
Can you help me figure out how to use it?
It would be awesome to get it to work.
Thanks!