Link LimeSurvey with an external SQL-database

More
2 months 1 week ago #174693 by svennic
svennic created the topic: Link LimeSurvey with an external SQL-database
Hi guys,

we have a SQL-database and our plan is to use LimeSurvey to gather specific data about our customers (which are in our SQL-database). The gathering-process is done by our employees and mainly by phone or via mail. Now we want to connect our database with LimeSurvey to have the possibility to search and select in dropdown menus (the database contains at least 5000 customers) and therefore link gathered data to individual customers.

Is this possible by any means?

Best regards

Please Log in or Create an account to join the conversation.

More
2 months 1 week ago #174696 by DenisChenu
DenisChenu replied the topic: Link LimeSurvey with an external SQL-database
By plugin:

See gitlab.com/SondagesPro/QuestionSettingsType/cpVille for an usage of a DB for autocomplete in a multiple short text question
And gitlab.com/Shnoulle-LimeSurvey-plugin/Au.../AuthWPbyDB.php#L227 to add an external DB connexion on another database

Else : you can use directly an javascript solution calling via ajax a php file on your own.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!