While the CYS platform provides for a great diversity of reporting options and calculations in its dashboarding section, we understand that sometimes you would like to check some separate records or create your own analysis over the gathered data. 


In this case, creating a manual export of the raw data of a project is a great solution. 


Table of contents:


How to m ake a manual export?

To create a manual export of your data garden, please follow the steps below:

  • Choose Data garden > Database in your main menu to open the overview of all your project databases. Go to the database that contains the data you want to export and click 'Edit database' to access it. 


  • Within your project database, go to the Data View tab. Use the selection boxes at the left side of the data view and check the records that you want to include in your Export. Use the checkbox at the top that is located in the column headers to select all records at once.  


 

  • After making your selection, open the Actions menu at the top right side of the data view tab and click the option Export to Excel. 


  • You will get a pop-up window in which you can confirm if you would like to export the selected records only, or all records that are present in the database. Make your choice and click Submit to confirm. 


 

  • An Excel file will now be generated and automatically downloaded in your browser. Please be aware that in case of large data sets, it might take a while for the data file to be generated. However, you can continue your work and the process is executed in the background. As soon as the file is ready, it will pop-up at the bottom of your browser and be present in your Downloads folder as well.  

     

What is in the export?

All records that you selected are now exported in Excel format. 

 

Your export will contain two tabs. The tab that is labelled "Data" contains all project data that is available in the database. The second tab, labelled "Data map" contains a legend or translation, explaining all column headers with the type of data  that is logged in them. This way you are able to look up what answer corresponds to a particular option code and what question it belongs to.