lightweight/right-tree
1
0
Fork 0
Code Issues 17 Pull requests Projects Releases Packages Wiki Activity Actions

Adjust spreadsheet ingestion script #16

New issue
Closed
opened 2021-11-02 08:05:28 +13:00 by danalambert · 5 comments
danalambert commented 2021-11-02 08:05:28 +13:00 (Migrated from gitlab.catalyst.net.nz)
Copy link

Colin has updated the spreadsheet and tidied up the data, column names have also changed which causes the current script to fail.

  • Fix the column mappings to the spreadsheet
  • Note any further data discrepancies
Colin has updated the spreadsheet and tidied up the data, column names have also changed which causes the current script to fail. - [x] Fix the column mappings to the spreadsheet - [x] Note any further data discrepancies
danalambert commented 2021-11-02 08:05:28 +13:00 (Migrated from gitlab.catalyst.net.nz)
Copy link

assigned to @danalambert

assigned to @danalambert
danalambert commented 2021-11-02 09:16:31 +13:00 (Migrated from gitlab.catalyst.net.nz)
Copy link

The spreadsheet is looking good! The only rows which cannot be ingested now is

  • Row 93 (Blechnum chambersii) - spacing value is 0..5
  • Row 259 (Coprosma grandifolia) - spacing value is 2014-01-01
  • 50 Rows containing string values for MAX HT, we will need default height values for the following fields (we can sort the mappings (the spreadsheet doesn't need to change):
    • vine
    • epiphyte
    • hemiparasite
    • aquatic
The spreadsheet is looking good! The only rows which cannot be ingested now is - Row 93 (Blechnum chambersii) - `spacing` value is 0..5 - Row 259 (Coprosma grandifolia) - `spacing` value is 2014-01-01 - 50 Rows containing string values for `MAX HT`, we will need default height values for the following fields (we can sort the mappings (the spreadsheet doesn't need to change): - vine - epiphyte - hemiparasite - aquatic
danalambert commented 2021-11-02 09:16:36 +13:00 (Migrated from gitlab.catalyst.net.nz)
Copy link

marked the checklist item Fix the column mappings to the spreadsheet as completed

marked the checklist item **Fix the column mappings to the spreadsheet** as completed
danalambert commented 2021-11-02 09:16:36 +13:00 (Migrated from gitlab.catalyst.net.nz)
Copy link

marked the checklist item Note any further data discrepancies as completed

marked the checklist item **Note any further data discrepancies** as completed
danalambert commented 2021-11-02 16:04:31 +13:00 (Migrated from gitlab.catalyst.net.nz)
Copy link

mentioned in merge request !11

mentioned in merge request !11
alistairmcintyre (Migrated from gitlab.catalyst.net.nz) closed this issue 2021-11-03 11:28:51 +13:00
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
v1.0.1
No results found.
Labels
Clear labels   
Bug

A software bug we've noticed. (These may not necessarily be show-stoppers)

  
Client: Biosphere Capital

   
Client: Central Hawkes Bay District Council

   
Client: Forward Works Viewer

   
Client: Kea/Kākā Databases

   
Client: Otorohanga District Council

   
Stage: Blocked

Something is causing us to be unable to currently fix this issue.

  
Stage: Doing

An issue that's assigned and being worked on

  
Stage: Peer review / Staging

An issue waiting to be given the all clear for production deployment.

  
Stage: Ready

For tickets that have been quanitifed, have acceptance criteria, and can be safely moved to the To Do column.

  
Stage: UAT AT

Work waiting to be deployed to production.

No labels
Bug
Client: Biosphere Capital
Client: Central Hawkes Bay District Council
Client: Forward Works Viewer
Client: Kea/Kākā Databases
Client: Otorohanga District Council
Stage: Blocked
Stage: Doing
Stage: Peer review / Staging
Stage: Ready
Stage: UAT AT
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: lightweight/right-tree#16
No description provided.
Delete branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?