Accessing Paradata fields
Posted: February 8th, 2022, 8:09 am
Hi folks,
Just as a background, I already tried several times to work with paradata, but I always throw the towel when it comes to the query part of it, mainly because my lack of experience with SQL.
But this time I really want to tackle this subject, and my question now is:
Where can I find information for all the fields that the cslog contains?
I see the examples in the PARADATA help sheet mentioning fields such as
operatorid_info
session_info
event_start.time
sesssion_event_end
etc
Where do they come from?
Do you have any other examples of reading a paradata file?
I took a look at the paradataViewer tool, and it seems very interesting, but besides that, I need to really get data for every interviewer/variable timing. For example, I want to have an array containing an entry for each operator id, case_id, variable_id, time_Start and time_end.
So, by using this array, I would be able to have averages of the time consumed by each field and/or each operator.
For example, operators taking too fie times for such a variable might mean that s/he is not even reading the question to the interviewer, since the registered time in the paradata is shorter than the time to read the question.
My other interest in the paradata is related to the gps function.
Now we are dealing with those issues by hand, inside the cspro program, collecting the gps and the time for each question, which is not the best solution.
That is, we really need to move forward into using the paradata as it should be. I´m not sure that other users like us "abandoned" the paradata, or indeed how many users are dealing with the subject.
Best
Ari
Just as a background, I already tried several times to work with paradata, but I always throw the towel when it comes to the query part of it, mainly because my lack of experience with SQL.
But this time I really want to tackle this subject, and my question now is:
Where can I find information for all the fields that the cslog contains?
I see the examples in the PARADATA help sheet mentioning fields such as
operatorid_info
session_info
event_start.time
sesssion_event_end
etc
Where do they come from?
Do you have any other examples of reading a paradata file?
I took a look at the paradataViewer tool, and it seems very interesting, but besides that, I need to really get data for every interviewer/variable timing. For example, I want to have an array containing an entry for each operator id, case_id, variable_id, time_Start and time_end.
So, by using this array, I would be able to have averages of the time consumed by each field and/or each operator.
For example, operators taking too fie times for such a variable might mean that s/he is not even reading the question to the interviewer, since the registered time in the paradata is shorter than the time to read the question.
My other interest in the paradata is related to the gps function.
Now we are dealing with those issues by hand, inside the cspro program, collecting the gps and the time for each question, which is not the best solution.
That is, we really need to move forward into using the paradata as it should be. I´m not sure that other users like us "abandoned" the paradata, or indeed how many users are dealing with the subject.
Best
Ari