Welcome to the LimeSurvey Community Forum

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

Link LimeSurvey with an external SQL-database

  • svennic
  • svennic's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 6 months ago #174693 by svennic
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
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 6 months ago #174696 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose