I’ve noticed after updating our local Survey Solutions to the latest version (19.05.3) that our Postgres database structure was updated as well.
I’ve also noticed that two tables from the readside schema (‘interviews’ & ‘interviews_id’) has been removed. I figured that the id field from the interviews_id table has been incorporated into the interviewsummaries table (correct me if I’m wrong), but I can’t figure out what happened to the interviews table data?
Could you kindly share where you have moved the interviews table data to?
That is the first time that I’m here and I’d like to ask about the data location.
I’m testing your solution on our own Windows server. I don’t find any table of interviews and in this post I understand that those tables are removed.
I read the content of the link in the reply to this question and I understand that data are not directly accessible with any client soft. But I’m still asking where are exactly the data? Are they on our server in a specific file? If it’s the case would you tell us where to locate this file also if we can’t open it. Or is there any other way!?
Survey Solutions posts the data to a Postgresql DB server, which could be the same server as the web server or a different server, as determined by the connection string. On the Postgresql server the data is stored as per Postgresql documentation:
What do you want to do with it if you can’t open in?
The aim is to know how we can make dependant processing between table of data and other tables (in the same or other) database.
We want to experiment writting triggers on data table that can do automatically some operations (like updates, inserts) on other tables (or may be upadte automatically fields of the same table) accordingly to some answers.
So, in the schema of Postgresql we can’t locate the data table.
There is screenshot of tables where anything is found concerning 2 test inserted rows visibles either for different users in the browser (hq, supervisor, interviewer):
Can you tell us which table exactly in postgreSql db contains the data ?
To use data collected with Survey Solutions jointly with a a different database, first, export the data from Survey Solutions, then import it to the second system, where the other data resides, or into a software package that can join the data (for example, Stata, SPSS, R, etc).
The objective is to trigger some operations during collecting data and avoid export then import them each time.
So is there any table in postgresql where data is strored in our server ? Or the database is just used to manage the survey and users?
We need to locate the table or the file where data is stored also if we can’t open it.
Is there any table in postgresql where data is strored in our own server SuSo Installation ?
Or the database is just used to manage the survey and users?
We need to know exactly the table or the file where data is stored also if we can’t open it.