Welcome to the LimeSurvey Community Forum

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

CSV file automatic import

  • tesnime_haouach
  • tesnime_haouach's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 day 2 hours ago #271147 by tesnime_haouach
CSV file automatic import was created by tesnime_haouach
Hello,Is it possible to import a CSV file automatically uploaded by another tool into the LimeSurvey database to automate the sending of a daily survey?

Thank you!

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 day 1 hour ago #271149 by Joffm
Replied by Joffm on topic CSV file automatic import
What is the content of this csv file?

And why didn't you answer the questions at the beginning?

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • tesnime_haouach
  • tesnime_haouach's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 day 1 hour ago #271150 by tesnime_haouach
Replied by tesnime_haouach on topic CSV file automatic import
The CSV file contains information about survey participants—specifically, users who have had an incident resolved. Since new incidents are typically resolved each day, we would like LimeSurvey to automatically send out a survey to these users by importing the CSV file automatically on a daily basis.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
21 hours 14 minutes ago #271151 by Joffm
Replied by Joffm on topic CSV file automatic import
Ah, you talk about participants.

I see two solutions.
1. Use the API
[url] www.limesurvey.org/manual/RemoteControl_2_API [/url]
and
[url] api.limesurvey.org/classes/remotecontrol-handle.html [/url]

with the functions
add_participants()
and
invite_participants()

Create a script in your preferred programming language
  • parse the csv file
And for each row
  • add the participant
  • invite the participant

2. Use direct access to the database.
Add the new participants to table "lime_token:[surveyID]"
Invite the participants with some mailmerge add-on of a mail programm  (like "Mail Merge" in Thunderbird)

But you still did not answer the initial questions about your version, about the hosting (own server, SaaS, or ...)

Joffm
 

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose