- Posts: 1128
- Thank you received: 329
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Experiences using LS with Google® drive™ spreadsheets©
- Ben_V
- Topic Author
- Offline
- Platinum Member
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13643
- Thank you received: 2491
Seems very interesting, except the google part. I look for framacalc (ethercalc) system if we can import an XML file.
Maybe update RC to have this XML type can be a good idea ? exportResponse as XML ?
But i think it can be done in a plugin. If i found a ethercalc import XML : i like to do a plugin : export XML . BHere : we need a protection system .....
Denis
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.
- Ben_V
- Topic Author
- Offline
- Platinum Member
- Posts: 1128
- Thank you received: 329
DenisChenu wrote: Seems very interesting, except the google part. I look for framacalc (ethercalc) system if we can import an XML file.
Is it possible to associate scripts with an ethercalc sheet as GG spreadsheets do (=> Aps script ) ?
BTW I paste here for testing purposes, the most simple code to generate a valid XML file listing all templates available in a LS install . Only needs to edit db credentials.
Rows can be displayed in a gg drive spreadsheet using the following formula in a cell:
=IMPORTXML("http://example.org/myxmlfilename.php", "//folder")
myxmlfilename.php
<?php /* * LIST OF AVAILABLE THEMES IN A LS INSTALLATION * - - - - - - - - - - - - - - - - - - - - - - - - - - - * GGsheet formula (have to be pasted in a cell): * =IMPORTXML("http://example.org/myxmlfilename.php", "//folder") */ header('Content-type: application/xml; charset=utf-8'); header ('X-Robots-Tag: none', true); print "<?xml version='1.0' encoding='utf-8'?>"; print "<answers>"; // Fetch database credentials (better outside web www root directory) $dblocation = ' '; $dbname = ' '; $dbuser = ' '; $dbpwd = ' '; // Create connection $conn = new mysqli($dblocation, $dbuser, $dbpwd, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT `folder` FROM `lime_templates`"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { print "<item>\n"; print "<folder>".$row["folder"]."</folder>\n"; print "</item>\n"; } } else { print "big error"; } $conn->close(); print "</answers>"; ?>
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13643
- Thank you received: 2491
Don't knwo actually, asking on frmasoft forumBen_V wrote: ...
Is it possible to associate scripts with an ethercalc sheet as GG spreadsheets do (=> Aps script ) ?
...
Denis
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.
- Ben_V
- Topic Author
- Offline
- Platinum Member
- Posts: 1128
- Thank you received: 329
For whom is interested, more info is available hereBen_V wrote: For example in USA, GG drive is not considered HIPAA compliant out of the box;
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- Ben_V
- Topic Author
- Offline
- Platinum Member
- Posts: 1128
- Thank you received: 329
DenisChenu wrote: I look for framacalc (ethercalc) system if we can import an XML file.
FYI, after reading this stackoverflow post , this sounds yet feasible with recent Excel versions.... maybe only Office 365, I don't know.
I can't test right now, because I've no recent Excel release installed, but if someone wants to put the hands into this, there are lots of xml valid files waiting for testing at xmlfiles.com .
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- DenisChenu
- Offline
- LimeSurvey Community Team
- Posts: 13643
- Thank you received: 2491
Else : another tool to considerate : docs.datawrapper.de/automatic-data-upload/
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.
- Qsgt
- Offline
- New Member
- Posts: 19
- Thank you received: 0
1. Is it possible to define which column a response goes into i.e. is it possible to skip some columns when importing responses so as to have field that utilise a gg formula in the same row as the reposes?
2. Is making the gg sheet publicly viewable as a published html document the only way to have it update or will it still update if I have a private document that I just chare with the necessary people?
Thanks,
qsgt
- Ben_V
- Topic Author
- Offline
- Platinum Member
- Posts: 1128
- Thank you received: 329
1) yes (it's the standard method)
2) no (you can share the original sheet with only some persons, with or without rights to edit the document)
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
- Qsgt
- Offline
- New Member
- Posts: 19
- Thank you received: 0
1. I'm relatively new to XML where would I go to find the standard method?
2. So, if I share the sheet like I would a regular Google Document, it will still update?
3. New Question, is it possible to only export a response to the sheet if there is a value in the response? If so, where do I go to find out how?
Thanks for the help,
qsgt
- Mazi
- Offline
- Official LimeSurvey Partner
Note that for sending emails to a predefined address if question X was answered "Y" is something that can easily be done from within Limesurvey. That's nothing I'd recommend to use the Google service for.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
- Ben_V
- Topic Author
- Offline
- Platinum Member
- Posts: 1128
- Thank you received: 329
(re)read this blog entry from the begining; there are some links to the manual describing the whole process and other pieces of code.qsgt wrote: 1. I'm relatively new to XML where would I go to find the standard method?
Yes of course. My experience is that all documents update at least 2 or 3 times hourly.qsgt wrote: 2. So, if I share the sheet like I would a regular Google Document, it will still update?
Sorry. I don't understand fully the question, but remember that sheets content is linked to the query presented in your xml file... For example if you query included a statement like "where submitdate is not null", incomplete records won't be returned.qsgt wrote: 3. ...is it possible to only export a response to the sheet if there is a value in the response?
....
Yes... but for more advanced needs, it's hard to imagine easier and more complete possibilities than those managed with apps script.Mazi wrote: Note that for sending emails to a predefined address if question X was answered "Y" is something that can easily be done from within Limesurvey
For example it's quiet easy to handle:
- Automating a Help Desk Workflow
- blacklists of email addresses or domains (eg. yopmail.com).
- Delayed emails for example x days or months after submission.
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)