Back to limesurvey.org

Welcome to the LimeSurvey Community Forum

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

Export timestamp with JSON-RPC

  • Marcel2022
  • Marcel2022's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 5 months ago #225028 by Marcel2022
Export timestamp with JSON-RPC was created by Marcel2022
Hi, 
is it possible to export the timestamps of all questions with the JSON-PCR export API?
And if yes, how?

Greetings, Marcel

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 years 5 months ago #225030 by Joffm
Replied by Joffm on topic Export timestamp with JSON-RPC
You have to define all fields you want to export.
These time fields with SGQ-syntax.
Something like
Code:
$surveyResponses = $myJSONRPCClient->export_responses(
    $sessionKey,
    $survey_id,
    'json', // Document type : pdf,csv,xls,doc,json
    null, // Language code : null : default from survey
    'complete', // Stautus complete|incomplete|all
    NULL, // Heading : code|full|abbreviated : question text, default code
    NULL, // answer : short|long , default : long
    1,
    30,
    ['id','token','submitdate','lastpage','interviewtime','159677X490X12345time','159677X487X23123time']
    );

A very rough output here (only timing of groups)
 

Joffm
 
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: DenisChenu, tpartner, BBSR-SR5

Please Log in to join the conversation.

  • Marcel2022
  • Marcel2022's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 5 months ago #225034 by Marcel2022
Replied by Marcel2022 on topic Export timestamp with JSON-RPC
Thanks, Joffm, I will forward your answer to my boss. I hope it solves her problem. Great to get such good and quick answers here on the forum.

Greetings, Marcel

Please Log in to join the conversation.

More
1 week 3 days ago - 1 week 3 days ago #271144 by BBSR-SR5
Replied by BBSR-SR5 on topic Export timestamp with JSON-RPC
I've got a similar issue, but I'd like to automatically download all answer fields. Do I also need to define those?
Code:
['id','token','submitdate','lastpage','interviewtime','q1','q2','q3[1]','159677X490X12345time','159677X487X23123time']

Or is there some way to just define additional fields I want to import?

Or do I need to use "list_questions" first, then build a list from that and then add the fields for timings?
Last edit: 1 week 3 days ago by BBSR-SR5.

Please Log in to join the conversation.

Moderators: tpartner, holch

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source