As a GitHub user
I would like to be able to display a CSV data as a Project
this way I could much better display complex data for later to filter and visualice.
As a GitHub user
I need to be able to run the process local on my computer or as part of a Actions Workflow
so that I can create or update the project manually or automated with a Workflow
Acceptance criteria
Input is a CSV file
Output may be a new Project or an existing project
Mapping from csv column to project fields type is another csv.
prune parameter will exist if we want to delete items that are not in the input.
You can run the update several times. It will update the project.
Optimice to avoid update calls to projects if the value is already there
Data Mapping
Which column is the title
column to field mapping
column to field data type
Field type mapping
Fields that will populated to project with the data from the input CSV
Column name to project field type
If the data type is incompatible with data it will ignore if and log it as an error
Pre processing task to check data with mapping data type to fail/warn if any data is incompatible and therefore will not be added
Fields types (Text, Number, Date, Single select, Iteration)
Fields types will grow so we need it to be able to add more data types in the future
Constrains
Code will be in a PowerShell Module that will be downloadable from PsGallery as first step of a Workflow or script
For first version we should use GH CLI commands to interface with GitHub