Welcome to the LimeSurvey Community Forum

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

Export timestamp with JSON-RPC

Marcel2022
Topic Author
Offline
New Member

More

3 years 6 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
Offline
LimeSurvey Community Team

More

3 years 6 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
Topic Author
Offline
New Member

More

3 years 6 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.

BBSR-SR5
Offline
Senior Member

More

1 month 2 hours ago - 1 month 2 hours 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 month 2 hours 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

Welcome to the LimeSurvey Community Forum

Export timestamp with JSON-RPC

Lime-years ahead

Legal

About Us

Open Source