Questionnaire > Analysis Page

Your data is stored on secure servers at Amazon Web Services in the United States of America.

With DataWinners, you have an unlimited amount of space to store your data.

Your data is stored in DataWinners server throughout your DataWinners subscription. But you can export your data at anytime and store it where you choose.

You can sort your data by data sender or by submission date. You also have the search option allowing you to display only the data you want.
You can do all these analysis in the Analysis page and the Submission Log page.

With DataWinners, you can view your collected data in table formats, pie and bar charts. Data can be filtered by submission date, by data sender, by case and you can even make a search for keyword.

Analysis Chart

Click to enlarge

No. It is not yet possible to view your data on the Smartphone application. You can view your record only from the Web application.

Data Senders must be registered as Users to be able to access the data page. To do so, delete them from the Data Senders list and register them as a User. Then you can link them to the specific Questionnaires you want them to send in data.

Each week for example, the Project Manager can export the basic information, print it out and share with the Data Senders.

Data can be exported to Excel in one click.

DataWinners has also an API functionality allowing users to push the data collected with DataWinners to a third party application, automatically.

 

  1. Export your data to Excel from Analysis or Submission Log page
  2. Open SPSS Analytics
  3. Click on File > Open > Data > Choose Excel in the file dropdown list
  4. Select the Excel file containing your data > Paste
  5. Choose the sheet in the dropdown list > Click on OK
  6. Register the syntax so you won’t have to redo these steps for your future data.

Yes. If your Android phone connects over a GPRS network, then our App can download newly created forms and send back filled out questionnaires.

If you have a very long Questionnaire of more than 250 questions, note that the maximum number of Submissions which can exported at a time is 10,000 Submissions.

Filter your data date for example and export your data per wave.

Please try downloading the file again. The Excel file may be corrupted if the Internet connection is not very good when downloading your data.

No. To ensure the security of your data, this is not feasible. You will have to register your users in your application one by one.

The analysis page shows only successful Submissions.

If you cannot find your data in the Analysis page, please go to the Submission Log page. Successful and error Submissions are displayed in this page.

All the choices are displayed in a single column, separated by a comma (“,”).

As a workaround, you can split the data in different columns using Excel: Select the cells, go to Data –> Text to columns –> Choose “Delimited” in the pop-up window, then choose a delimiter (a semi-colon or a comma) and your data will be parsed into separate columns.

Yes. When you export your data to Excel, the latitute and longitude fields are displayed in separate columns. This should facilitate the exportation into Arc GIS

  1. Export your data from Analysis or Submission Log page
  2. Open SPSS Analytics
  3. File> Open> Data > Choose Excel in the file dropdown list
  4. Select the Excel file containing your data > Paste
  5. Choose the sheet in the dropdown list > Click on OK
  6. Register the syntax so you won’t have to redo these steps for your future data.

DataWinners can export up to 4094 at a time.
To avoid problem, you can filter your data — by date for example — and export it in multiple batches.

With DataWinners, you can export your data to Excel and from Excel, export it to SAS, SPSS, etc. Another way is to use our APIs.

Yes. To edit a data record, click on the “Submission Log” page for the Questionnaire, select the data record you wish to edit by clicking on the corresponding box in the left-most column, and select “Edit” from the Actions drop down menu. Make all the necessary changes and click “Save changes.”

Please watch our video tutorial: How to Edit Submissions.

Submission Log error

Click to enlarge

The best way to test the data extraction webservices is to use curl command.

If you have curl installed, please use the following line in your command terminal:

curl –digest –u ‘yourdatawinnersloginemail:yourdatawinnersloginpassword’ https://app.datawinners.com/api/get_for_form/002/

Otherwise you can try putting the URL https://app.datawinners.com/api/get_for_form/002/ in a browser address. You need to provide username and password when prompted.

Your server could invoke the webservice by sending a request directly with the URL and providing the user credentials for digest authentication. Most programming platforms support sending digest-auth requests.

And your server should be able to get the response with data in its content.

The whole process is entirely automatic.

Data extraction within a specific time period:

DataWinners data extraction webservice API supports downloading data within a certain period. To do so, please include the start date and end date in.

To delete a data record, click on the “Submission Log” page for the Questionnaire, select the data record you wish to delete by clicking on the corresponding box in the left-most column, then select “Delete” from the Actions drop down menu.

You can use third-party software or you use your own software if preferred using feed API access.

DataWinners has an integrated feed API that helps the users to perform Extract, Transform and Load (ETL) operations on the data collected. DataWinners has also added an API for sending out SMS via the application. The feed access is secured using a HTTP Basic authentication. The user has to provide the username and password to access any of the Submissions in the account.

DataWinners streams the feed data. There is no maximum limit on the number of feed entries sent out of DataWinners. DataWinners will continue to stream data as long as there is valid data for the given query parameters, and will close the connection once the feed entry for the last Submission has been sent.

  • Submission Feed : app.datawinners.com/feeds/{form_code}?start_date={date}&end_date={date}
    *form_code = Questionnaire code
  • Identification Number API:
    https://app.datawinners.com/api/get_for_form/UID/
    * UID = The Identification Number Type.

Data Sender API:
https://app.datawinners.com/api/get_for_form/reg/

Yes. From the Submission Log page, follow these steps:

  1. Click on the Errors Tab,
  2. Select the Submissions you want to delete,
  3. Select “Delete” from the Actions dropdown menu.

error-submission

Yes. Deleted entries are still present in the Deleted Submissions page. You cannot have them back in your Submissions log but you can re-enter them:

  • Re-make the submission using the Web form. You can even select the Data Sender name.
  • If you have a very big Questionnaire, it would take time to enter manually. In that case, you can export the Deleted submission(s) to Excel and re-import using the “Import Submissions” function.

A Duplicate is a submission containing the same data as another submission within a predefined period. It can be:

  • Submissions with the exact same answers for each question
  • Submissions with the exact same Identification Number
  • Submissions made by the same Data Sender

Only successful Submissions are analyzed for duplicates.

A Duplicate

Click here to enlarge

 

To review possible duplicate Submissions, please follow the steps below:

  1. Choose the period using “Submission Date” filter
  2. Choose what case of duplicate Submissions you are looking for – use the drop down “Show Duplicates For”:
    • Submissions with the exact same answers for each question
    • Submissions with the exact same Identification Number
    • Submissions made by the same Data Sender

Note: Nested questions in Advanced Questionnaires are not evaluated for duplicates in the current version of DataWinners

Duplicate Submissions

Click to enlarge

 

Removing or editing duplicated Submissions will help you to clean up and improve the quality of the collected data.

Yes. To edit a Submission, please follow the steps below:

  1. Select the Submission you wish to edit by clicking on the corresponding checkbox in the left-most column,
  2. Select “Edit” from the Actions dropdown menu,
  3. Make all necessary changes and click “Save changes.”
Delete or Edit a Submission

Click to enlarge

Within your DataWinners account itself, you can have very basic charts.

If you want to generate custom reports, we’ll need to develop a customized application for you. If you’re interested, the costs will depend on your specific needs.

Analysis charts

Click to enlarge

This not yet possible but you can use the below workarounds:

  1. You can merge data from the Questionnaires in Excel using the unique IDs as an identifier. (example: teacher’s unique ID)
  2. If you plan to use Smartphone to collect data, you can create your questionnaires with XLSForm and merge all your Questionnaires in one Questionnaire. You can use teachers ID as an identifier, then have multiple groups for your different questionnaires. The Data Senders can skip the sections they do not have to fill out.

Yes, you can use our API to extract the data automatically from your DataWinners account to your own server. To learn more, please read our API Documentation.

 

Our API can be used to fetch data from the DataWinners’ database to your server. Fetching data to an external database is not yet available.

You can use our API to do so. To know more about our API, read the following document Submission Feed and Send SMS in our Website.

DataWinners has a very good API allowing you to link it to any external application. Data can be even pushed to external databases such as DHIS2. To learn more, please read our API Documentation.

With the standard DataWinners feature, repeated sets are always displayed in different sheets when exporting data to Excel. Please contact our Customer Support if you are interested in having all your data merged in one sheet.

submission-log-export-repeat

Yes. From the Analysis page, please click on “Customize View” on the right hand just above the data table and select the Data Senders GPS field.