The platform now allows for data export, enabling you to download posts from the platform in CSV format. You can download posts via the export and tag data feature.
The setup in this guide is demonstrated in the video below as well. You can watch and follow the guide at the same time!
To export a CSV file,
Click on settings and select Export and tag data
Once there, click on the Export all data button within the same section.
You can also select the specific fields from each survey you want to export if you don't want to export all data at once. Once you have selected your fields, select Export Selected Fields
A small confirmation box will appear seeking confirmation on whether you would like to proceed with exporting your data.
Click on Got it to export your CSV file
Click on Cancel export if you would like to terminate the export process.
You should get a CSV file named after your deployment name in your downloads folder
HDX is an open platform for sharing data across crises and organisations. Its goal is to make humanitarian data easy to find and use for analysis.
The work done in the COMRADES project has received support from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 687847. This new addition to Ushahidi Platform V3+ was possible thanks to the COMRADES project partners and funders.
HDX is an open platform for sharing data across crises and organisations. Its goal is to make humanitarian data easy to find and use for analysis. HDX is managed by the United Nations Office for the Coordination of Humanitarian Affairs (OCHA) and is located in The Hague. OCHA is part of the United Nations Secretariat and is responsible for bringing together humanitarian actors to ensure a coherent response to emergencies.
HXL is a lightweight, data tagging standard that allows for data to be quickly harmonised, concatenated, and compared. The standard was developed by representatives from the Humanitarian Innovation Fund, IOM, OCHA, Save the Children, IFRC, UNHCR, UNICEF, USAID, the World Bank, and the World Food Program.
The COMRADES platform has integrated with the United Nations’ Humanitarian Data Exchange(HDX) and supports the associated Humanitarian Exchange Language (HXL). This integration ensures that COMRADES and now Ushahidi Platform V3+ users can export data sets in an acknowledged humanitarian data standard, to a secure and recognized humanitarian data sharing exchange that is in use by over 200 of the world’s most important humanitarian organisations. Users with both a Ushahidi Platform v3+ deployment and an HDX account can export data from their deployment into their HDX account.
The export can be appropriately tagged with HXL to allow the data to work with HDX’s suite of online tools including “quick charts” functionality. Building this functionality ensures that users’ data are stored securely even if the deployment is discontinued and is easily discoverable by a significant portion of the humanitarian community.
Ushahidi Platform V3+ has multiple ways to export data. You can choose to export data as a plain CSV file, download a CSV export file that includes a row for HXL tags and attributes, or export directly into the HDX platform. The following section explains the different options for exporting data and how to use them
Before starting a HDX upload, you need to configure the HDX User Id and API Key.
On the left hand menu bar, click on Settings
Then, click on Configure HDX API or in the link that appears while trying to start a HDX export for the first time.
Enter you user id(maintainer id) for HDX and your HDX API key.
This information is saved and used for each specific user when uploading to HDX, instead of being deployment-wide settings.
Go to Settings
Click on Export and tag data, then export.
Click on Assign tags and attributes to assign HXL tags and send data to HDX. This button will take you to a screen where you can configure and start an HDX export. You will see a screen where you can configure the HXL attribute mappings to your data fields.
Select the fields to be included and what HXL attributes and tags they map to. For a field to be included in the export, it has to be selected in the checkboxes to the left of each field. You can also click “Select All” for each survey if you want all its fields to be added.
After you are done selecting the fields you want to add to your HDX export, you have the option to export it as a regular file (this will generate a CSV with HXL tags, and behaves like the regular export) or to upload it to an HDX account by
Clicking on the UPLOAD TO HDX ACCOUNT button to continue.
You will see a warning to verify your content before you continue, and you can either check again or continue the process.
Once you are sure, click on ADD DATASET DETAILS AND UPLOAD TO HDX to continue.
You will see the HDX configuration screen where you can select the options that will be applied when your dataset is uploaded to your HDX account.
Private/Public: You need to select whether you want your data to be private, where only you and any other HDX members of your organisation can search, edit or download, or public where anyone can edit, search or download
Title of the data set: Enter the title of the data set. This will be the title that will appear on humdata.org
Source: The source by default is your deployment name. This helps the humdata.org people to know how the dataset is called and where it came from.
Select your organisation: The organisations available in the Organisation list are all the organisations your HDX account has access to. You may not be part of any organisation, in which case you may request to join one in the humdata.org website or create your own through their registration process for organisations.
License: Select the license for your organisation.
When you are happy with the configuration, click on SUBMIT TO HDX ACCOUNT.
You will see a notification that the export is being prepared, and can leave the page and continue working while it is being generated. You will be notified once the upload is ready.
Once the HDX upload finishes, you can see the exported data in your HDX account by logging in and going to the “My datasets” page in HDX https://data.humdata.org/dashboard/datasets if you want to see the details of your dataset, you can click on the blue link that has the name of your dataset.
Ushahidi's platform allows you to export your data as a CSV file or assign tags and attributes to your data and upload directly to a Humanitarian Data Exchange (HDX) account or export as a tagged CSV file.
In this section, you will learn how to:
Export all of your data from Ushahidi as a CSV, choose specific survey fields you want to export as a CSV
Assign HXL tags , HXL attributes and choose to upload to an Humanitarian Data Exchange account or download as a HXL 'tagged' CSV file.
