The current CSV export for 3W generates a file with 400 columns. This is due to it listing the admin areas in wide format. Wide format is difficult to use in mapping software where you want to join on one column.
https://goadmin.ifrc.org/api/v2/project/?format=csv
A long format means it can easily be mapped and used in tooling such as the HXL Proxy: https://proxy.hxlstandard.org/data/source
The long format currently is the standard format of 3W in the field.
Problems that will occur with repeating the project details is how to handle a single number such as reached over multiple rows. These could be remove for simplicity.
The current CSV export for 3W generates a file with 400 columns. This is due to it listing the admin areas in wide format. Wide format is difficult to use in mapping software where you want to join on one column.
https://goadmin.ifrc.org/api/v2/project/?format=csv
A long format means it can easily be mapped and used in tooling such as the HXL Proxy: https://proxy.hxlstandard.org/data/source
The long format currently is the standard format of 3W in the field.
Problems that will occur with repeating the project details is how to handle a single number such as reached over multiple rows. These could be remove for simplicity.