Import from CSV

[dankdafied]

Please explain here what you were doing

I was trying to Import an .xlsx file to flowkeeper so I can take my task list (which is already built in an excel tracker) and execute the tasks using flowkeeper pomodoros.

Is there a xlsx csv or plain text template for importing tasks?

Have you considered tying this app into other more advanced programs like Power Automate?

I'd be happy to test any betas to help the progress of the app. Send any info to [email protected]

Versions:

• Flowkeeper: 0.9.1
• Qt: 6.7.0 (windows)
• Python: 3.11.9 (tags/v3.11.9:de54cf5, Apr 2 2024, 10:12:12) [MSC v.1938 64 bit (AMD64)]
• Platform: Windows 10 10.0.22631
• Kernel: Windows-10-10.0.22631-SP0

Stack trace:

Traceback (most recent call last):
  File "fk\desktop\import_wizard.py", line 126, in initializePage
  File "fk\desktop\import_wizard.py", line 148, in start
  File "fk\core\import_export.py", line 302, in import_
  File "fk\core\import_export.py", line 379, in import_classic
  File "<frozen codecs>", line 322, in decode
UnicodeDecodeError: 'utf-8' codec can't decode byte 0x9c in position 14: invalid start byte

[co-stig]

Hello @dankdafied, I was in front of my Mac and quickly implemented a simple CSV import based on your request:

Here's the CSV file. The import will create backlogs and tasks which don't exist yet:

You can download the release candidate from https://github.com/flowkeeper-org/fk-desktop/releases/tag/v0.10.0

Note that there are few bugs in this version. Notably, Back button doesn't work correctly in the Import wizard. Also, if you install on Windows, then Defender will likely detect installed Flowkeeper.exe as some sort of trojan, as it usually does before I submit it as a false positive. Please use the portable version (Flowkeeper.exe) for testing instead -- it is usually not flagged by Defender.

I usually submit those EXEs to Microsoft right before the final release, which is still a couple of weeks from us (I need to implement a few more features and fix some bugs).

Let me know if it works for you.

[co-stig]

Alternatively, you can go Power Automate route with any version of Flowkeeper, albeit in a bit cumbersome fashion.

Flowkeeper is fully driven by keyboard shortcuts, and PA can simulate keypresses: https://learn.microsoft.com/en-us/training/modules/pad-mouse-keyboard/

So, you can do something along those lines:

• For each row in your spreadsheet,
  • Press Ins, wait 10ms
  • Type the task name, wait 10ms
  • Press Enter, wait 10ms

Backlogs can be created similarly via Ctrl+N, [Type], Enter. You can see all shortcuts and change them in Settings > General > Shortcuts.

[co-stig]

@dankdafied Could you see if it works for you, please?

[dankdafied]

@co-stig I gave it a try and t did not seem to import any items. It did not throw any errors.

[co-stig]

@co-stig I gave it a try and t did not seem to import any items. It did not throw any errors.

Can you show an example of your CSV file, and what the last Import step (the summary) looks like, please?