roadmap icon indicating copy to clipboard operation
roadmap copied to clipboard

Published 20 hours ago • verified publisher icon DMPRoadmap

project details on plan csv export breaks csv

Open nicolasfranck opened this issue 4 years ago • 3 comments

Please complete the following fields as applicable:

What version of the DMPRoadmap code are you running? (e.g. v2.2.0)

3.0.2

Expected behaviour:

The functionality "download plan as csv" should deliver a workable CSV.

Actual behaviour:

If you check the checkbox "Project details coversheet" you'll get a "broken" CSV. Reason: the csv headers are not on the first line. Anyway, the number of columns for the project details and those for the questions are different so it would never work.

Steps to reproduce:

nicolasfranck avatar Aug 13 '21 07:08 nicolasfranck

would the solution just be to hide the "Project details coversheet" checkbox when the user selects the CSV format?

StCyr avatar Nov 08 '22 12:11 StCyr

the newest release also adds another set of data to the csv: research outputs, which have different columns.

This looks more like an Excel file than a CSV. Would it be better to generate an Excel, and put all of those different kinds of data in separate tabs to make it more machine readable?

nicolasfranck avatar May 23 '23 12:05 nicolasfranck

@nicolasfranck that will definitely be an improvement since we have prioritised making the tool more machine actionable. I have added this to our project board. If you have already worked on this for your instance of DMPRoadmap please feel free to create a PR to this repository. Or if you have more ideas for this, let us know. Thanks!

gjacob24 avatar Jun 21 '23 08:06 gjacob24