rulasg / githubprojects Goto Github PK

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

1. Input is a CSV file
2. Output may be a new Project or an existing project
3. Mapping from csv column to project fields type is another csv.
4. prune parameter will exist if we want to delete items that are not in the input.
5. You can run the update several times. It will update the project.
6. Optimice to avoid update calls to projects if the value is already there

Data Mapping

1. Which column is the title
2. column to field mapping
3. column to field data type

Field type mapping

1. Fields that will populated to project with the data from the input CSV
2. Column name to project field type
3. If the data type is incompatible with data it will ignore if and log it as an error
4. Pre processing task to check data with mapping data type to fail/warn if any data is incompatible and therefore will not be added
5. Fields types (Text, Number, Date, Single select, Iteration)
6. Fields types will grow so we need it to be able to add more data types in the future

Constrains

1. Code will be in a PowerShell Module that will be downloadable from PsGallery as first step of a Workflow or script
2. For first version we should use GH CLI commands to interface with GitHub

Export the items of a project to CSV

This is blocking test workflow from working as we can not rely on a PAT for testing.