We are planning on an import/export tool for the response data. How exactly this would work, is not decided yet.
The SQL statements used when exporting a survey is complex - it is distributed among a lot of different java source files (the db layer in our internal design), and it would be a lot of work for me to extract all of them.
The way it is currently done, is that the data is extracted the same way as when viewing a single survey response. Then it is repeated for all respondents in the survey.
Import data *from* an excel sheet sounds very difficult indeed. The SQL would be very difficult.
I think it would be a much better strategy to use the plugin api, and create respondents that way. Then you would not have to worry about the SQL, and you would be sure to get all the data saved correctly. It is usually not a good idea to insert data from another source. It should be done by Opinio, because there are internal index-counters that ensures that all unique keys are correctly generated.
Thought I would bump this thread and ask if the data import feature is any closer to reality as it was "a priority" in 2004.
As an aside, I have managed to utilise the pre-population feature to import a full survey response. The only downside being the need to log in to each record individually to get opinio to populate the survey responses.
Just thought I would bump this thread again and ask if the data import facility is any closer to existence. As online access is not available to all users the lack of a simple method to upload paper responses is a serious gap in the functionality of opinio.
Is the data import functionality in existence yet? We have hundreds of responses coming in via paper and would like to find a faster way of inputting them to the system than one by one. Can we upload an Excel file?
Having just looked at the current roadmap, the ability to import data does not appear as an upcoming feature. Despite reassurances over the past 10 years that an import option was a priority, we are no nearer to adding this facility.
If this functionality cannot be incorporated into Opinio are there any alternative workarounds e.g. via a plug-in or a script? As I mentioned earlier in this thread, it is possible to import a single record utilising the pre-population feature - coding each question response. The downside (apart from the time it takes) is that you have to log-in so can only do it one at a time. Ideally a plug-in or script would do the following for a specified survey: 1. Generate log-in codes (for specified number of responses) 2. Create a pre-population template (based on survey questions) 3. Combine a selected import data file with pre-population format 4. Using the log-in codes, automatically import the data file (as separate responses)