Cloudron Forum

Thank you, @msbt
I don't think Cloudron users can use this fix?

---

Title: Elgg - a powerful open source social networking engine

---

• Main Page: https://elgg.org/

• Git: https://github.com/Elgg/Elgg

• Licence: GNU General Public License (GPL) Version 2 and the Massachusetts Institute of Technology (MIT-X11) License.

• Docker: no official one; not sure if still maintained: https://github.com/jumbojett/docker-elgg-dev and https://github.com/jumbojett/docker-elgg-dev

• • Demo: https://elgg.org/showcase

---

Summary: Elgg is an award-winning open source social networking engine that provides a robust framework on which to build all kinds of social environments, from a campus wide social network for your university, school or college or an internal collaborative platform for your organization through to a brand-building communications tool for your company and its clients.

---

Notes: We are a non-profit active in education project. We would like to build a teacher network for our different projects to make the project work have a more sustainable impact on education.

---

Alternative to / Libhunt link: e.g. https://www.libhunt.com/r/Elgg

Features:
Well-documented core API that allows developers to kick start their new project with a simple learning curve
Composer is the package manager of choice that greatly simplifes installation and maintenance of Elgg core and plugins
Flexible system of hooks and events that allows plugins to extend and modify most aspects of application's functionality and behavior
Extendable system of views that allows plugins to collaborate on application's presentation layer and built out complex custom themes
Cacheable system of static assets that allows themes and plugins to serve images, stylesheets, fonts and scripts bypassing the engine
User authentication is powered by pluggable auth modules, which allow applications to implement custom authentication protocols
Security is ensured by built-in anti CSRF validation, strict XSS filters, HMAC signatures, latest cryptographic approaches to password hashing
Client-side API powered by asynchronous JavaScript modules via RequireJS and a build-in Ajax service for easy communication with the server
Flexible entity system that allows applications to prototype new types of content and user interactions
Opinionated data model with a consolidated API layer that allows the developers to easily interface with the database
Access control system that allows applications to build granular content access policies, as well as create private networks and intranets
Groups - out of the box support for user groups
File storage powered by flexible API that allows plugins to store user-generated files and serve/stream them without booting the engine
Notifications service that allows applications to subscribe users to on-site and email notifications and implement integrations with other their-party services
RPC web services that can be used for complex integrations with external applications and mobile clients
Internationalization and localization of Elgg applications is simple and can be integrated with third-party services such as Transifex
Elgg community that can help with any arising issues and hosts a repository of 1000+ open source plugins

Hi everyone,

An IT dummy (me) uses Cloudron installed on a VPS hosted by Contabo. My domain and website are managed through Webgo, where I can configure DNS settings but don’t have file system access.

I’d like to run some simple Python scripts (e.g. to handle URL redirects dynamically). What is the easiest way to host and run custom Python scripts within the Cloudron environment, given this setup?

Thanks,

Mary

It looks like it has a lot of potential to become a true Clockify alternative (still some way to go).

The QR code tool does not support embedded logos.
Mini-qr + code management to later change the destination address would be a dream come true.

---

• Title: Phraseanet - Digital Asset Management

---

• Main Page: https://www.phraseanet.com/
• Git: https://github.com/alchemy-fr/Phraseanet
• Licence: GPL-v3
• Docker: Yes -> https://hub.docker.com/u/alchemyfr
• Screenshots: https://www.phraseanet.com/en/community/captures-decran/

---

• Summary: Phraseanet is an Open Source Digital Asset Management solution dedicated to professionals who need a complete system to manage, publish and share their digital media resources (pictures, videos, audio, PDF, Office documents…).

---

• Notes: As a non-profit organisation, we are managing a growing collection of images that we have either created, purchased, or received under a usage licence. Some of these licences limit usage to specific projects. Up to now, we have relied on Excel to keep track of the images, but a digital asset management system (DAM) would be far more convenient.

At present, there is no DAM available on Cloudron. Adding one would be an excellent step towards supporting the needs of organisations managing visual content with today's licensing and intellectual property requirements.

@girish said in pretix - Ticketing software that cares about your event—all the way:

An initial package is ready - https://git.cloudron.io/packages/pretix-app . Hopefully, we can get it out coming week.

A M A Z I N G

@nebulon
Are there any plans to make Grist availalble?

Hello everyone,
FYI: We ended up using https://www.encuesta.biz/producto/limesurvey-plugin-google-sheets-connector/.
The guys are super responsive and very supportive.
It works like a charm.

Hi @joseph,
Google Sheets (Google version of MS Excel) does in fact support connecting via ssh tunnel and we can get it done.
But I still don't know how to adapt the variables in the script.

This is the description in the LimeSurvey Manual:

Import & show data into a Google Drive Spreadsheet
Tested with: LS >= 2.05

You can import any data (e.g. list of surveys or users, selected answers) stored in your limesurvey database using the "IMPORTXML" function.

Create a XML file to structure and print needed data (you should access it at http://mysite.com/myxml.php )
In your spreadsheet use the following format (pasting in a cell):

=IMPORTXML("http://mysite.com/myxml.php?refresh=&GoogleClock()", "//mytaglabel")

To protect your XML file(s) from direct access you can put them in a dedicated folder and use a .htacess file to limit the access exclusively to Google Apps web crawlers filtered by ip ranges

order allow, deny
deny from all
# allow from your_ip
allow from 66.249.64.0/19 # Used by User-Agents 'apps-spreadsheets' & 'Feedfetcher-Google'
allow from 66.249.80.0/20 # Used by User-Agents 'apps-spreadsheets' & 'Feedfetcher-Google'
allow from 64.233.160.0/19 # Used by  'GoogleApps' UA
# Uncomment if necessary following ther IP ranges commonly used by Google INC.
# allow from 46.108.0.0/18 64.18.0.0/20 66.249.80.0/20 72.14.192.0/18 74.125.0.0/16 173.194.0.0/16 207.126.144.0/20 209.85.128.0/17 216.239.32.0/19

PHP (XML output) file sample.

The following php file will generate an XML view printing ID, STARTDATE and STARTLANGUAGE values of a survey.

<?php

/*
 - This php file will generate an XML file showing ID, STARTDATE and STARTLANGUAGE values of a survey.
 - Please edit variables for db credentials and survey id ($sid)
*/
    header('Content-type: application/xml; charset=utf-8');
    header ('X-Robots-Tag: none', true);

// Fetch database credentials (much better outside the wwww root directory)
// ************************
    $dblocation =   ' ';
    $dbname =  ' ';
    $dbuser =    '  ';
    $dbpwd =   ' ';
// ************************

// Create db connection
    $conn = new mysqli($dblocation, $dbuser, $dbpwd, $dbname);
// Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 


// Start XML output

    echo "<?xml version='1.0' encoding='utf-8'?>"; 
    echo "<answers>";

// Define survey ID
// ************************
    $sid = "1234";
// ************************

    $sql = "SELECT id, startdate, startlanguage FROM lime_survey_".$sid." ORDER BY 'id' LIMIT 100";
//  $sql = "SELECT 1234X56X789, id, startdate, startlanguage FROM lime_survey_".$sid." ORDER BY 'id' LIMIT 100";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {

    echo "<item>\n";
    echo "<id>".$row["id"]."</id>\n";  
    echo "<startdate>".$row["startdate"]."</startdate>\n";
    echo "<startlanguage>".$row["startlanguage"]."</startlanguage>\n";
//  echo "<anylabel>".$row["1234X56X789"]."</anylabel>\n";
    echo "</item>\n";
    }
    } else {
        echo "something is happening here but you don't know what it is";
    }

    echo "</answers>";

// Close db connection
    $conn->close();

?>

@nebulon: Any updates if pretix is on your radar (or even roadmap)?

@marcusquinn Thanks for the tip. Not sure it is GDPR-compatible. There are other alternatives, but Pretix is our favourite.

@imc67 said in pretix - Ticketing software that cares about your event—all the way:

It's a pity that after more than 6 years on the Wishlist, high ranked, one of the best and complete Open Source Event Ticketing software, while there is no single equivalent in the App Store ... it's still not available

Hi, Google Sheets, yes.
This description makes it sound really easy.
But... dblocation, dbname, dbuser, dbpwd.
Nextcloud is not an option at this time unfortunately.
I will find out if Google Sheets supports connecting vis ssh tunnel.
Thanks for your comments and help!

Unfortunately, I am still failing to connect Sheets to LimeSurvey.

$dblocation = CLOUDRON_MYSQL_URL ?
$dbname = CLOUDRON_MYSQL_DATABASE ?
$dbuser = CLOUDRON_MYSQL_USERNAME ?
$dbpwd = CLOUDRON_MYSQL_PASSWORD ?

CLOUDRON_MYSQL_DATABASE and CLOUDRON_MYSQL_USERNAME
have identical values.

CLOUDRON_MYSQL_URL starts with "mysql://..."
Not sure how to translate this into a URL.

Thank you, @nebulon!!!

I believe I am one step closer to what I need. If I manage to locate the LimeSurvey config.php, I will know dblocation, dbname, dbuser and dbpwd. It should be easy from there.

In self-hosted LimeSurvey environments, it seems to be located here:
[limesurvey_installation]/application/config/config.php.

The question now is where is the LimeSurvey config.php stored on Cloudron?

Unfortunately, config.json does not seem to provide the answer.

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:

• updated reports without LS admin login (for people who know the url)
• very large library of powerful functions, well documented for calculation, charts, terrific mailing, etc.
• possibility to build reports merging several surveys
  (https://forums.limesurvey.org/forum/can-i-do-this-with-limesurvey/103747-experiences-using-ls-with-google-drive-spreadsheets#132260)

---

I am trying to follow this manual.

I suppose this is what I need to do:

1. 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 :-)).

2. Save it at http://mylimesurveysite.com/test.php
   Here is where I run into difficulties since we run LS on Cloudron.

3. 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!

Since we are not in a particular hurry and Cloudron is just super comfortable to use, I guess we'll wait and see.

@scooke
The quote is from @andirahmat.

I represent a non-profit. We would like to start our own journal to quickly publish results from (our) European education projects.