Sign in to follow this  
Followers 0
peethebee

Galenda - a calendar application in AutoIt

47 posts in this topic

#1 ·  Posted (edited)

Hi!

A team of coders from www.autoit.de has developped this applications under my leadership. Special thanks fly out to GtaSpider and GunFood who helped from the beginning. Moreover I'd like to thank anyone mentined in the credits and here espacially Chicago for several extenisve bug testing sessions.

In medias res:

This calendar has many quite advanced features. It supports many ways of defining appointments. First there are single appointments. Moreover there can be appointments which last more than one day and such that reoccur e.g. every week. Therefore the creation of new appointments is very fleible. Any appointment can have unlimited number of alarms attached to it, such as alarm windows or sounds. You can even let an e-mail be sent at the defined time. It is possible to define unlimited categories and put your appointments in there. Any cat has its specific color, which makes it easy to see what kind of appointments are in your list. You can display this list for one day or a whole week - just as you like it.

There is a advanced HTML export availible, which is based on templates. You can decide, which timespan shall be covered and which categories shall be exported. It is possible to upload either this exported view or the calendar database on your own webspace via FTP to make it accessible via password from anywhere ion the world.

The whole calendar can be saved encypted in a strong way where your password is saved nowhere.

It is possible to import other calendars to merge them into one.

By now Galenda should run under any language version of windows. It contains German and English language files which are easily updatable. You can add new languages without any problem.

There is an automatical update funktionality availible which should no longer require user interaction to keep Galenda up-to-date.

Galenda can be run directly from a USB device - there is no installation needed. It is much smaller as 1 MB.

I'm sure, I forgot some key features, but neverheless: Test it, we hope, you will enjoy it!

peethebee

This was my original forst post here:

Hi!

With some helpers I started to code a calendar application completely in AutoIt.

Here is it's "headquarter" with download links in the first post:

http://autoit.aufwaerts.de/board.php?boardid=18

What is included so far:

- advanced creation of appointments

- Show appointments of a day in GUI

- HTML export

- printing via HTML

- some backup functionalities

But all is in very basic state. We only implemented things so far that were easy and fast to code or that are necessary for first basic tests.

At the moment it is only useful to test it if you are speakind German and using a German copy of Windows. This script will have to be changed at some points to make in correctly work on English Windows.

Problems:

- how can I encrypt a SQLite database without saving the password? I could check correctness of the pass by hashing original and decrypted file. But it seems that normal text encryption functions do not work with that kind of data. Would be great if somebody could help!

peethebee

post-5348-1159974563_thumb.png

Edited by peethebee

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites



peethebee,

This is fantastic. I've been wanting to write my own PIM, but wasn't sure how to do the display.

I'd like to help, but I haven't spoken any German in about twenty years, and even then it was non-technical.

I'm not sure how it could be done, but if we could work out a way to get both english and german discussions going, it could help things along.

It would be cool to have the UI based on language files too, so that it's international.

Walkabout

Share this post


Link to post
Share on other sites

Hi!

Thanks for your interest.

For the display of the appointments I still have 3 possibilities in mind ;-)

As we use wuite a lot date functions, the script unlikely will work on English copies of WIndows. Perhaps you could test that? We will correct that if possible. For making it translatable we probably will use my script PowerTranslate which automatically scans for the strings to be translated and makes them availible in a text file for direct editing.

What would help us at the moment would be a very small exe which you can use to crypt a file via command line. Has to be free of course.

Moreover I need some little help in FTP-things as they do not work for me...

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

too bad i dont speak german

Share this post


Link to post
Share on other sites

We will work out an English version, but there is still so much to do in the background that it will still take some time.

Would be great if someone can it least test it on English Win (see http://dict.leo.org when you are lacking words).

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

What would help us at the moment would be a very small exe which you can use to crypt a file via command line. Has to be free of course.

I had a bit of a poke around, and options which immediately sprung to mind were crosscrypt, truecrypt and gpg.

The first two are more about mounting virtual drives which use encrypted files to store their data, so they are probably not ideal. GPG is a strong possiblity. It is GPL, and proven, but the exe is about 850k. Is this too large?

I'm also wondering what you want it for. Could a DLL do? How strong do you want the encryption? Would something simpler do (eg ROT13) or does it need to be encrypted? Do we want open source, or would closed source freeware do?

Moreover I need some little help in FTP-things as they do not work for me...

Just let me know and I'll try to help.

Walkabout

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

I had a bit of a poke around, and options which immediately sprung to mind were crosscrypt, truecrypt and gpg.

The first two are more about mounting virtual drives which use encrypted files to store their data, so they are probably not ideal. GPG is a strong possiblity. It is GPL, and proven, but the exe is about 850k. Is this too large?

Yes, that's too large as the whole installer is < 600 KB all together. Would be great for this part to be at least < 200 KB, better < 100 KB.

I'm also wondering what you want it for. Could a DLL do? How strong do you want the encryption? Would something simpler do (eg ROT13) or does it need to be encrypted? Do we want open source, or would closed source freeware do?

DLL would do it, but I never called a DLL, so I would need a little help in that. Thinking of the size a DLL would be slightly better I think.

Closed-Source would be no problem, but it has to be free. The algo should be far better than ROT13 as the calendar data will be encrypted that way. Moreover ROT13 just works on text, not on binary data.

FTP works almost, just a little problem when creating dirs, but I should be able to fix that. Thanks!

peethebee

Edited by peethebee

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

Moreover ROT13 just works on text, not on binary data.

Does that mean you might want to encrypt binary data. If so, and if you don't mind me asking, what binary data would a calendar application want to encrypt?

I'll have a troll through the forum to see if I can track down a good encryption UDF.

Walkabout.

Share this post


Link to post
Share on other sites

Hi!

It uses SQLite for its databases which procudes binary data I think.

Correct me if I'm wrong. Exe or DLL would be much faster than UDF...

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

Hi!

It uses SQLite for its databases which procudes binary data I think.

Correct me if I'm wrong. Exe or DLL would be much faster than UDF...

peethebee

If you are using an exe I'm assuming you want to do one of two things.

1) Encrypt the database file. This could only be done safely when the database was not in use, either by:

i) Decrypting at startup and then encrypting at close. This would leave the database file unencrypted the whole time the application was running, which would almost be pointless from a security perspective. Especially as calendar applications tend to remain open most of the time.

ii) Decrypting every time you wish to access the database and then re-encrypting when finished would slow down response times and be very inefficient.

2) Encrypt the data via a temporary text file and then feeding that in to an unencrypted database file. Sounds painful and unlikely to be faster than using a UDF.

If you use a DLL to encrypt data on the fly, then you are really only encrypting text, and therefore a UDF would do. There doesn't seem to be many free open-source encryption DLLs out there anyway.

Are you sure that an exe/dll is the right way to go? Why don't you use one of the many good UDFs here on the forum and then save the encrypted text into an unencrypted database file?

Walkabout.

Share this post


Link to post
Share on other sites

Hi!

Thanks for your thoughts!

The encryption has two main aims:

1. Have databases completely encrypted when transferring them via/into the internet.

2. Have databases encrytped while not working myself on my computer. So nobody else can watch my appoinments while I'm not there. It would be not a big problem I think to have it decrypted the whole time I use the computer than.

You are absolutely right that encrypting the whole file on every access is too slow and painful.

But your favorite solution sounds not very good to me:

- you have all the structure of the database file unencrypted. So you can draw conclusions where real data are stored. Watching the IDs for example, you can assume what values it has. This is really a security risk.

- you have to ask for the passwort at every database access, unless you store it - which would be unsecure again.

I already found an exe which should do it, but I did not test it yet.

http://www.scheerer-software.de/v2.html

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

Hi again!

En-/decryption is in with the Exes I mentioned before.

Perfect woule now be hashing.

We'll see if I can find a exe for that too (thinking of md5.exe)

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

#13 ·  Posted (edited)

Hi again!

En-/decryption is in with the Exes I mentioned before.

Perfect woule now be hashing.

We'll see if I can find a exe for that too (thinking of md5.exe)

peethebee

You might want to take a look at these options:

MD5 Plugin (By JSThePatriot)

StringHash and FileHash (By Me)

StringMD5 (By MSLx Fanboy)

MD5 UDF (By SvenP)

Edited by SolidSnake

HKTunes:Softpedia | GoogleCodeLyricToy:Softpedia | GoogleCodeRCTunes:Softpedia | GoogleCodeMichtaToolsProgrammer n. - An ingenious device that turns caffeine into code.

Share this post


Link to post
Share on other sites

Thanks for the links. I searched the forum myself a little bit and found a great SHA1-DLL and AutoIt-Call.

Works perfectly. I can verify the password without storing it and even without storing a hash of it *proud* *grin*.

The new version 0.30 supports appointment, that reoccur in a certain period of time ever and ever again with numerous possibilties to defeine them.

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

Thanks for the links. I searched the forum myself a little bit and found a great SHA1-DLL and AutoIt-Call.

Works perfectly. I can verify the password without storing it and even without storing a hash of it *proud* *grin*.

The new version 0.30 supports appointment, that reoccur in a certain period of time ever and ever again with numerous possibilties to defeine them.

peethebee

hey looks nice..

http://translate.google.com/translate?u=ht...a89e8f72a594b05

what is dtdes.exe and etdes.exe?

Share this post


Link to post
Share on other sites

hey looks nice..

http://translate.google.com/translate?u=ht...a89e8f72a594b05

what is dtdes.exe and etdes.exe?

Hi,

these exe files are for encryption and decryption. Look at the link above mentioned by peethebee.

So long,

Mega


Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Share this post


Link to post
Share on other sites

#17 ·  Posted (edited)

Hello!

Just wanted to say, that the final release is near. Up to now we are at version 0.93 and will soon have the feature freeze.

I think we can be proud of what we coded in AutoIt.

It works fine for me in daily use already.

Screens will follow, download is possible via the German forum or http://sourceforge.net/projects/galenda

peethebee

Edited by peethebee

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

Hi!

It is finally there: Version 1.0 Beta 1 is out.

Here are some Screens for you: http://galenda.de/index.php?section=gallery&cid=1

And the download: http://galenda.de/index.php?section=media1...alenda_testing/

It will probably not run under English versions of Windows...

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

If it won't run on an English Windows, why post it on an English board?

Share this post


Link to post
Share on other sites

Ever thought about you have German users here also?

Moreover it shows what's possible with AutoIt. Would be great if anyone could help converting it. Or even test if it already works.

peethebee


vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvGerman Forums: http://www.autoit.deGerman Help File: http://autoit.de/hilfe vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0