Question: Importing due date from excel or sql query

34 views
Skip to first unread message

Cristiano Lancerotto

unread,
Feb 4, 2019, 7:55:57 AM2/4/19
to abstractspoon-t...@googlegroups.com
Dear all,

I need to import the due date of tasks from excel or directly from sql query, provided that the task's name is the same.

Is it possible? How?

Thanks
Cristiano

.dan.g.

unread,
Feb 4, 2019, 8:49:02 PM2/4/19
to ToDoList (AbstractSpoon) Support
If you have the due dates in CSV form then it's quite easy:

1. Tools > Import Tasks

importmerge.PNG


2. Clear all attribute mappings except 'Due Date' and 'Title'

importduedate.PNG


3. OK

Cristiano Lancerotto

unread,
Feb 5, 2019, 9:38:27 AM2/5/19
to ToDoList (AbstractSpoon) Support
Dear Dan,

Great, thanks!

And is it possible to automate it?

Thank you

.dan.g.

unread,
Feb 5, 2019, 6:38:05 PM2/5/19
to ToDoList (AbstractSpoon) Support
Unfortunately not.

To automate it you would need to write code (JavaScript or C#) to open the tasklist, update the tasks, and then save the tasklist, whereupon TDL would reload it for you.
Reply all
Reply to author
Forward
0 new messages