- Posts: 962
- Thank you received: 216
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
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
6 years 11 months ago - 6 years 11 months ago #151159
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
What attributes to fetch with list_participants? was created 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?
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.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1223
- Thank you received: 351
6 years 11 months ago #151176
by Ben_V
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)
Replied by Ben_V on topic What attributes to fetch with list_participants?
Hi Tammo,
attributes = columns in your lime_tokens_1234 table , no?
www.limesurvey.org/community/forums/news...0920-released/147867
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
6 years 11 months ago #151177
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic What attributes to fetch with list_participants?
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?
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
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
6 years 11 months ago #151181
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic What attributes to fetch with list_participants?
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
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
6 years 11 months ago #151183
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic What attributes to fetch with list_participants?
Thanks, I will experiment..
Tammo
Tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11746
- Thank you received: 2750
6 years 11 months ago #151184
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic What attributes to fetch with list_participants?
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 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
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
6 years 11 months ago #151185
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic What attributes to fetch with list_participants?
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
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
6 years 11 months ago #151188
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic What attributes to fetch with list_participants?
Most recent??? I got Version 2.64.1+170310 via Comfortupdate.tammo wrote: I am using the most recent version that is available via ComfortUpdate. Currently: Version 2.64.0+170307
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- tammo
- Topic Author
- Offline
- Official LimeSurvey Partner
Less
More
- Posts: 962
- Thank you received: 216
6 years 11 months ago #151189
by tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
Replied by tammo on topic What attributes to fetch with list_participants?
You are right. I just ran out of "ComfortUpdate" resources, my year ran until some days ago.. I will renew.
Thanks,
Tammo
Thanks,
Tammo
Tammo ter Hark at Respondage
For Limesurvey reporting, education and customized themes
respondage.nl
The topic has been locked.