What is the problem? Please be detailed.
Am new to ODK,previously we have been using papers to collect data then later enter it in excel and aggregate it.
We now want to use ODK for data collection,Am done with building forms with ODK build and the aggregate server was set also.
The problem is if i export the data it gives me a CSV file and when i try running the files in our old aggregate we used in excel manually, it does not show results.
1.I need assistance on how to aggregate data please.
2.After exporting the data from odk aggregate what is the next step ?
Am attaching a screenshot of the aggregator we were using but when i run the csv file in it from odk aggregate it doesn't work
Anything else we should know or have? If you have a test form or screenshots or logs, attach here
First, I suggest you use ODK Briefcase to export data into CSV files first. That way, you will be sure you're exporting all the data stored in Aggregate (Aggregate's export capabilities are limited).
Second, if I understand correctly, you're using an Excel spreadhseet to aggregate data. I guess the spreadsheet will be able to show you data as long as it is compatible with the CSV files you feed it. In that sense, you need to make sure that the CSV file you get with Briefcase has the same columns as the one you used before. If they're not the same, you will probably need to make adjustments to your Excel spreadsheet.
when i export the csv file from odk aggregate , the looped questions come separated from the main form, what could be the problem. Is that how it is supposed to be or there is something i did not do well during building?
In the attachment, RTV data collection 2018 is my data collection form name and those other four CSV files are part of the questionnaire in the form but when i export they come while separated as seen above.
Those questions in build i selected the loop option in their group.
Hello, did you solve the first problem? Yes looped questions are separated, but if you look carefully, there is a key value for each file for the match.
Hello, cool. Once you've your data in Excel sheet it's ready for preparation and analysis. I'm I'd like to help you but this forum is only about data tools collection and related. You need some knowledge in statistics technic and your domain to analyze your data.
Thanks
One of the big benefits of this forum is that the public conversations help the next person who has a similar problem. If you can, please use this public thread so everyone can see the questions, everyone can have a chance to answer, and the answer will be seen by everyone.
