Re: python script to archive all events
 

hmm - it seems, that there is a problem with the sql-file. what is the output of "ls /home/user/.rtcom-eventlogger" ?
there must be an archive-file (because it opens one), but not a valid one.

Re: python script to archive all events
 

and: do not run glogarchive as root! the script searches for the DB in the user-directory - the user-directory for root is /root - and there are no files. i get the same error, when i run the script as root...
what is the output, when you start it as user?
run-standalone.sh python2.5 /opt/glogarchive/glogarchive.py

Re: python script to archive all events
 

Hm :/

Here is output and directory listing:




BusyBox v1.10.2 (Debian 3:1.10.2.legal-1osso30+0m5) built-in shell (ash)
Enter 'help' for a list of built-in commands.

~ $ run-standalone.sh python2.5 /opt/glogarchive/glogarchive.py
Traceback (most recent call last):
File "/opt/glogarchive/glogarchive.py", line 596, in <module>
listall(ui)
File "/opt/glogarchive/glogarchive.py", line 309, in listall
cur.execute("select events.event_type_id, count(events.id), events.outgoing from events group by events.event_type_id, events.outgoing order by events.event_type_id, events.outgoing")
sqlite3.OperationalError: no such table: events
~ $
~ $
~ $
~ $ ls -al /home/user/.rtcom-eventlogger/
drwx------ 4 user users 4096 Jun 16 15:29 .
drwxr-xr-x 58 user users 4096 Jun 16 20:33 ..
drwx------ 6 user users 4096 Jun 10 14:48 attachments
-rw------- 1 user users 37888 May 26 11:33 el-v1-before-restore.db
-rw-r--r-- 1 user users 240640 Jun 16 16:53 el-v1.db
-rw-r--r-- 1 user users 0 Jun 16 16:53 el-v1.db-journal
-rw-r--r-- 1 user users 0 Jun 16 12:31 el.db
-rw-r--r-- 1 user users 0 Jun 15 10:41 el_archive-v1.db
drwx------ 2 user users 4096 May 17 16:47 plugins
~ $

Re: python script to archive all events
 

ah ok. a
rm /home/user/.rtcom-eventlogger/el_archive-v1.db
should solve the problem.

Re: python script to archive all events
 

That's it? Because it's working :))
THANKS!!!

Re: python script to archive all events
 

no problem =)

Re: python script to archive all events
 

First i would like to say that the application is very good, i love it :)
but also i like to ask, is it possible in some way to delete only one phonenumber, i mean only a few messages not the whole archive, not all messages and calls???
thanks :)

Re: python script to archive all events
 

hi doris,
there is a way, but not with glogarchive itself. use sqlitebrowser to edit the archive: http://sourceforge.net/projects/sqlitebrowser/
1. copy the archive from your phone, to your pc. this is the file: /home/user/.rtcom-eventlogger/el_archive-v1.db
2. make a backup of the file
3. open the file with sqlitebrowser
4. there you can browse the table "Events" - delete records you want to delete
5. save the file, move it back to /home/user/.rtcom-eventlogger/el_archive-v1.db on your phone

note: if you have the deleted records on your normal conversations-history, it will be archived again next time...

all right?

Re: python script to archive all events
 

bananenfisch could you check the topic about the sms counter
(http://talk.maemo.org/showthread.php?t=38364&page=9)
I have a question...

Re: python script to archive all events
 

Thanks for this application!
I was trying to find a way to export my sms and I couldn't find one (If I'm not wrong it is not possible from ovi suite is it?)