I originally submitted this here, but I don't expect a reply.
After migrating a company from MS Exchange server to Google Apps, I had a hard time finding a comparable replacement for Outlook's "Tasks" feature.
I eventually came across Lightning and it is the closest match I've found. Yet, I'm struggling to devise a way for multiple workstations to see the same task set in Lightning.
Currently, I'm having the key-employee (the one entering and managing the tasks) export tasks to a network-share-folder a couple of times a day. And then, any employee who wants to sync with her lightning tasks, must delete all tasks they previously imported, and then do an import of what she exported to that network-share-folder (mentioned earlier).
I'm looking for a way to automate this, so that each non-task-managing-employee can always view (in Lightning) the latest tasks created by the task-managing-employee.
I wish there was a "Sync with Master" button or somthing like that.
Can you suggested some method by which I might acheived this objective of "almost realtime sharing of tasks between mutliple lightning clients"?
These workstations are Windows, but right now I'm playing around with Thunderbird-Lightning using Ubuntu. I came aross a location where tasks are stored: /home/username/.thunderbird/smmek7fl.default/calendar-data/local.sqlite
I made a copy of this file on my desktop, then I deleted all tasks (from within lightning). After this, I copied over this file with the copy I made before deleting the tasks, and restarted Thunderbird. The tasks were back.
There is probably a "local.sqlite" file on Windows too. Perhaps I can schedule batch scripts to routinely copy this file from the task-mananging-employee's computer to the network-share-folder. And then, on each non-task-managing-employee's computer, schedule batch scripts to routinely overwrite their copy of local.sqlite with the one from the share?
What do you think of this idea? Is there a better way?