Page 3 of 3 12 3
Reply
Thread Tools
daperl's Avatar
daperl is offline daperl
2010-04-01 , 05:33
Posts: 2,427 | Thanked: 2,986 times | Joined on Dec 2007
#21
Originally Posted by oneFinn View Post
I did some testing with sqlite and calendar db. I downloaded mmy db to PC and used sqlite3 cmd tools (win). Most important data from search perspective are in calendars and components tables. Calendars keeps track of all calendars and components holds all dates descriptions and summaries etc.

Sqllite supports SQL's LIKE operator, so I was able to query the db with wildcards. Pretty easy to find, say, birthdays or meeting dates with certain customer.

I didn't find docs about date/time formatting (stored as integers).
Good stuff.

Is the date a 4 byte integer? If so, it probably represents the number of seconds since January 1st, 1970 (U*nix time). I think there are standard SQL commands to deal with this. Just google for:

unix time conversion sql

There are plenty of hits.
__________________
N9: Go white or go home
 
oneFinn is offline oneFinn
2010-04-02 , 09:18
Posts: 67 | Thanked: 24 times | Joined on Dec 2009 @ Helsinki Finland
#22
Hi daperl,

Yep, the date/time format is epoch, stored as integer value to sqlite.
So, easy to convert to something readable.
This also revealed the reason why calendar does not show (and is not able to do it anyway) person's age when displaying his/her's birthday (feature that was in Symbian already), poor calendar thinks that no one was born before 1th of Jan. 1970.
Contacts handles this, but calendar not. If the date of birth from contacts is older than 1.1.1970, calendar stores it as 1.1.1970.
 

The Following User Says Thank You to oneFinn For This Useful Post:
cb00 is offline cb00
2010-04-02 , 19:24
Posts: 24 | Thanked: 4 times | Joined on Mar 2010
#23
I find it so annoying that I can't search emails so I really hope this will be added soon.
__________________
cb00
http://www.freemaemohelp.com
 
oneFinn is offline oneFinn
2010-04-10 , 06:17
Posts: 67 | Thanked: 24 times | Joined on Dec 2009 @ Helsinki Finland
#24
Did some further basic research around the search issue.

Two packages could be used to index and provide full-text search of emails (and other file content, too): recoll and beagle. Tracker that is used in n900 already is configured to play with filenames only, don't know whether that can be changed to scan file contents too

Recoll seems to support incremental indexing and is able to track changes in file system to keep the search db in sync.

I'd imagine that porting recoll/beagle to n900 should be fairly straighforward + we'd need a simple UI for search and configuration management + make indexing "battery friendly".
 
jacktanner is offline jacktanner
2010-04-10 , 06:34
Posts: 228 | Thanked: 145 times | Joined on Dec 2009
#25
Originally Posted by oneFinn View Post
Two packages could be used to index and provide full-text search of emails (and other file content, too): recoll and beagle. Tracker that is used in n900 already is configured to play with filenames only, don't know whether that can be changed to scan file contents too.
Reconfiguring tracker (probably requires a recompile and a config file) seems like a much safer bet. It's already ported to the N900...
 
NokTokDaddy is offline NokTokDaddy
2010-04-10 , 06:41
Posts: 248 | Thanked: 240 times | Joined on Mar 2010 @ Wiltshire, UK
#26
Just wanted to say thanks to all you good people for giving up your time to look into this.

Your effort, skiils and energy underlines what N900 and Maemo is all about.

What (if anything) can us humble users do to support/help you?

Wish I'd tried harder at school...
 
oneFinn is offline oneFinn
2010-04-10 , 14:54
Posts: 67 | Thanked: 24 times | Joined on Dec 2009 @ Helsinki Finland
#27
Originally Posted by jacktanner View Post
Reconfiguring tracker (probably requires a recompile and a config file) seems like a much safer bet. It's already ported to the N900...
yep, I was thinking the same, but tracker conf. etc. are probably in the OS core, so using what would happen when Nokia gets next PR out... Unless Nokia guys realise that finding information is a crucial feature in our "digital life", and n900 currently has close to zero support to locate data from one's personal device.
 
paai is offline paai
2010-04-10 , 16:43
Posts: 162 | Thanked: 25 times | Joined on Dec 2009
#28
Originally Posted by oneFinn View Post
Hi Andre,

I voted already earlier. I'm not asking a solution right away, I'm more concerned that this kind of crucial functionality is missing and haven't seen any activity from the vendor.

Calendar search is probably easier to make, email cna be trickier.
Although the N900 in itself is good enough, I feel absolutely cheated by Nokia as far as the calendar, todo and similar applications are concerned. Not to mention the fact that you cannot sync reliably with Google.

I /hoped/ that Nokia would deliver, but we are waiting for six months now and it seems that now Nokia has our cash, it is not interested any more in improvement.
 
oneFinn is offline oneFinn
2010-04-11 , 16:55
Posts: 67 | Thanked: 24 times | Joined on Dec 2009 @ Helsinki Finland
#29
Originally Posted by paai View Post
Although the N900 in itself is good enough, I feel absolutely cheated by Nokia as far as the calendar, todo and similar applications are concerned. Not to mention the fact that you cannot sync reliably with Google.

I /hoped/ that Nokia would deliver, but we are waiting for six months now and it seems that now Nokia has our cash, it is not interested any more in improvement.
Well..I wouldn't say cheated (never promised), but I'm quite a bit surpised that since the launch..no progress has happened in areas of email search and calendar functionality (new features, not bug fixes).
Anyone close to Nokia and R&D, is there anything going on?
 
Reply
Page 3 of 3 12 3

« Previous Thread | Next Thread »
Thread Tools

 
Forum Jump


All times are GMT. The time now is 15:38.

Contact Us - Home - Archive - Top