6 months ago MxFlixParticipant
Whenever I want to bulk-add tasks to Skedpal, I’m using the import function (oftentimes with a little python script to automatically create the .csv file). That works wonderfully, and overall quicker than inputting all tasks by hand into the app, but it is still very tedious because it only speeds up entering the name and duration. What I’m getting at is: It would be amazing to have more columns available for importing tasks.
Most importantly a Project column, maybe even with the option to create a Project if the one specified in the file wasn’t found.
Also, a column to specify a task as a subtask, or maybe even entering the name of its supertask instead, would be very handy.
A column to fill the Note field would be VERY useful as well.
Additionally, columns to specify Time Maps, Tags, and Due Dates would be very welcome.
On the other side is the export option. I don’t use it as often, but when I do, I’m usually very frustrated with the outcome, especially the ordering: The Export function sorts the tasks by name, which, of course, makes it pretty much unusable for sequential projects (and even in some non-sequential ones, the order is still somewhat important). It really NEEDS to export the tasks in the order they are in Skedpal.
Also, it’s missing the column Note, and some sort of marker for subtasks would be neat as well.6 months ago derkorkParticipant
It seems you are a bit into programming, so maybe this is an option for you. I was recently tinkering around with some ways to get access to the data stored in SkedPal. The desktop client is written in Java, so it is actually quite easy to put together a simple project that allows for exporting data. SkedPal uses a H2 DB on Windows (probably also on OSX), so all you need is a small java program using JDBC and the H2 driver to get read access to the database. I did a quick search and it also seems to be possible to connect to the H2 db from Python but this may not be as straightforward.
The database is located in C:\Users\<username>\AppData\Local\SkedPal\h2. I would strongly suggest that you make a copy of the files there and work on the copy to avoid breaking your real database. In any case you can now query the data in there to your hearts content and can sort and order them in any order you would like before exporting them with any columns you like to any format you like. If you want to get an overview without any coding, grab some DB tool capable of interfacing with H2 and simply run a few SQL queries. Here I selected task count by project, but that’s really only a simple example (larger image here).
If you want to get a bit more fancy, you can even set up a small project using SkedPals internal API. Just add SkedPal2.jar and all the jars in the lib folder as dependencies and then you can explore what might be useful. The interesting class seems to be TaskJpaController. I put this little thing together that reads all tasks via the API and can also get the hiearchy. You can probably also get this from pure SQL but using the API may be easier (larger image here).
The more interesting part of using the API is that you might even be able to write data back to the database, as TaskJpaController offers quite a few functions for this. That being said, I don’t know enough about the internal model yet to feel comfortable writing to the DB. You may very easily end up with a broken DB and nobody can help you fix that, especially once the broken stuff has synched over to SkedPals servers. So I would leave the writing part alone, but at least now you have a few more options for the export.
You must be logged in to reply to this topic.