Shifter Converter
By
@Djayden
- 4 Devlogs
- 11 Total hours
A project to convert a proprietary calendar format into .ics files
Ship #1
Pending review
I made a program that turns a useless format (.Shifter) into a format that anyone can use and import into almost any calendar app. My parents only use the Shifter app to manage all family planning, but I am more fond of Google Calendar. Now with this program I can easily import their calendar. I am proud of what I made, but less proud of the fact that it is currently 2:45 AM, an hour before the deadline.
1h 54m 22s logged
3h 51m 31s logged
I FOUND IT!
I finnaly know now what the problem was, for some reason the developer of the Shifter app decided that it would be a good idea to use integers for the months. So jan is 00, feb 01, etc. This took me way too long to figure out, but I eventually did. I found out because I saw my little brothers birthday in the notes, but it was shifted by exactly one month and then I looked at all the dates and saw that years ended with 11, instead of 12. Now I just need to fix a little problem I created myself by using timezones to parse the dates. This causes dates to shift an hour because of winter time.
3h 24m 25s logged
Decided to simplify the idea
Originally I was planning on making the program connect with your Google account to make it automatically upload the calendar. But since Stardance is almost ending and I have a lot of other projects I also want to finish I decided on just turning the file into an .ics and just manually uploading the file to Google Calendar.
Below you can see I have already made the program parse the .Shifter into a list of standard classes, so turning that into an .ics file is easy as cake.
2h 1m 41s logged
Finished importing shifts from file
The file that I am trying to convert has a . Shifter file extension, but is just an SQLite3 database file. So it should be pretty easy to work with, except for the fact that all tables and columns are in Spanish and have no documentation whatsoever. So I made a demo file and used Google Translate to convert all the names, and with some context it is pretty easy to understand the data. I have already made the code that gathers all the shifts from the file.
I should probably explain what this file even is. It is from a program called Shifter from LHRSoft, its goal is to inventarise all your work shifts. My parents use this program as the family calendar, but the problem is that there is no easy way to upload the full calendar to Google Calendar (atleast none that is quick and easy to understand). And that is why I am making this project; to make it possible to easily upload the . Shifter to Google Calendar
