Welcome to the LimeSurvey Community Forum

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

What attributes to fetch with list_participants?

  • tammo
  • tammo's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 11 months ago - 6 years 11 months ago #151159 by tammo
I am using R to get data about the participants from the token table.

I use list_participants and I looked up the documentation at:


api.limesurvey.org/classes/remotecontrol...od_list_participants


But I want more than just the tid, token, firstname and lastname.

Frans Marcelissen helped me out, using older knowledge. So now I use:

all_attributes<- c('id',
'completed',
'participant_id',
'language string',
'usesleft',
'firstname',
'lastname',
'email',
'blacklisted',
'validfrom',
'sent',
'validuntil',
'remindersent',
'mpid',
'emailstatus',
'remindercount',
paste0('attribute_',1:100)
)

survey_tokens<-call_limer("list_participants", list(survey_list$sid,0,999999,F, all_attributes))

But what come to mind: how do I know if I retrieve all information that I need? Is there a way of showing all attributes that can be retrieved?


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Last edit: 6 years 11 months ago by tammo. Reason: Wrong API call named in title
The topic has been locked.
More
6 years 11 months ago #151176 by Ben_V
Hi Tammo,

attributes = columns in your lime_tokens_1234 table , no?



www.limesurvey.org/community/forums/news...0920-released/147867

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)
Attachments:
The topic has been locked.
More
6 years 11 months ago #151177 by jelo
I remember a thread around getting more attributes than the default one.
www.limesurvey.org/de/foren/can-i-do-thi...rol-api,-python-glue
Not convinced that it can help in your situation.
Which LimeSurvey version is used?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • tammo
  • tammo's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 11 months ago #151181 by tammo
I am using the most recent version that is available via ComfortUpdate. Currently: Version 2.64.0+170307


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • tammo
  • tammo's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 11 months ago #151183 by tammo
Thanks, I will experiment..

Tammo


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 11 months ago #151184 by holch
170307 is not the most recent version available with Comfort Update. ;-)

I updated a few days ago to Version 2.64.1+170310, just as information. Maybe you need to set/change the intervall of your comfort update. Luckily we don't have daily or twice per day updates anymore... ;-)

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

The topic has been locked.
  • tammo
  • tammo's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 11 months ago #151185 by tammo
Haha, just last week my year of comfort updates ended, I now have to buy a new one again. I guess I did not notice that...

I will update!

Thanks, Holch (and jelo, and Ben_V!)

Tammo


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
More
6 years 11 months ago #151188 by jelo

tammo wrote: I am using the most recent version that is available via ComfortUpdate. Currently: Version 2.64.0+170307

Most recent??? I got Version 2.64.1+170310 via Comfortupdate.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • tammo
  • tammo's Avatar Topic Author
  • Offline
  • Official LimeSurvey Partner
  • Official LimeSurvey Partner
More
6 years 11 months ago #151189 by tammo
You are right. I just ran out of "ComfortUpdate" resources, my year ran until some days ago.. I will renew.

Thanks,

Tammo


Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose