things-cli icon indicating copy to clipboard operation
things-cli copied to clipboard

Fields are output into different order at random times

Open mcgaritydotme opened this issue 1 year ago • 2 comments

To Reproduce Steps to reproduce the behavior:

  1. Run the following CLI command: things-cli --csv all > tasks.csv
  2. Open tasks.csv in any editor
  3. Make note of the column labels and their order
  4. Repeat the above steps

Expected behavior Each time the export is done, the same columns are exported in the same order

Additional context Not every time, but I run the export once per week, and the column headers will shift position:

Column order on 2024-02-07 export: title uuid type status area area_title notes tags start start_date deadline stop_date created modified index today_index project project_title heading heading_title

Column order on 2024-02-12 export (notice how the project* and heading* fields are swapped): title uuid type status area area_title notes tags start start_date deadline stop_date created modified index today_index heading heading_title project project_title

Column order on 2024-02-19 export (fields are now in a completely-different order): title uuid type status notes start start_date deadline stop_date created modified index today_index area area_title tags project project_title heading heading_title

Why is this important?

I import Things 3 tasks into a custom spreadsheet in order to perform analytics, but it expects the input (tasks.csv) to be the same structure each time. Reordering of columns breaks these analytics.

mcgaritydotme avatar Feb 19 '24 21:02 mcgaritydotme

Thanks, that's interesting. Not sure why this happens...

AlexanderWillner avatar Feb 19 '24 23:02 AlexanderWillner