Page 1 of 3 123 LastLast
Results 1 to 10 of 28
Discuss Calendar Data Filepath at the Free Toolchain Software (Cydia App's) - Hackint0sh.org; I'm working on syncing the iPhone MobileCal directly into google calendar. Does anyone know where ...
  1. #1
    Newbie Array

    Join Date
    Aug 2007
    Posts
    9
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default Calendar Data Filepath

    I'm working on syncing the iPhone MobileCal directly into google calendar. Does anyone know where the calendar data file is located at on the iPhone?

    Any help is appreciated.

    -spicy



  2. #2
    Newbie Array

    Join Date
    Aug 2007
    Posts
    9
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    Found it! The file is a sqlite database file and is located at

    /private/var/root/Library/Calendar/Calendar.sqlitedb

  3. #3
    Senior Professional Array

    Join Date
    Jul 2007
    Posts
    445
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    30

    Default

    cool, does google calendars use something standard like syncml or something?

    Any idea where the mail is stored? Some users are looking into developing an "activesync clone" basically a script that accesses OWA or OMA and gets the emails and then acts as a pop server locally on the iphone to send that stuff to mail. if we could cut out the pop server we get PUSH email for exchange.... couple that with your efforts we can sync calendars, and if we find the contacts db we can sync contacts.... wow, then we dont need apple anymore, now do we? :p

  4. #4
    Newbie Array

    Join Date
    Aug 2007
    Posts
    9
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    A quick search tells me that they don't have it built in themselves, but some 3rd party vendors are trying.

    There is a mail folder at:

    /private/var/root/Library/Mail

    I haven't looked into it yet, but it may contain the mail data. (Considering that Library folder contains all the other user app information :-)

    Anyway I have been able to build a script that syncs events as long as they are not recurring. Recurring events are crashing the Calendar App...so I still have some ways to go. I'm posting my progress at:

    thespicychicken.blogspot.com

  5. #5
    Senior Professional Array

    Join Date
    Jul 2007
    Posts
    445
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    30

    Default

    Hey man,

    yeah, in the library/mail folder there is a file called "Envelope Data" that is actually an sqlite db... it has all mail in there, attachments are in a subfolder, nonetheless, I tried submitting an empty Envelope Data file back to the phone and my mail still appeared in the mail app, so I dunno exactly what that file is for... (even if deleted, the phone still showed my emails)...

    but its got to be somewhere...

    I'm gonna follow progress on your blog, if you release this I'd like to adapt it for exchange, it shouldnt be difficult at all to pull the calendar stuff from exchange, its just a question of adapting the mail scraper that is already out there...

    I'm still trying to find out if anyone's reversed the activesync code so we can get true push, as I was mistaken and the scraper does its thing at set intervals

    PS: I just noticed you downloaded and compiled your own sqlite, you can/could have use Erica's sqlite3 iphone binary also, dunno if its any different than yours, if you want to check it out its in http://iphone.natetrue.com/EricaUtilities0.15.tar its in the archive and its called sqlite3
    Last edited by RVN84; 08-24-2007 at 07:49 AM.


  6. #6
    Newbie Array

    Join Date
    Aug 2007
    Posts
    9
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    Yeah, I found Erica's version after I re-complied :-/

    I have posted the source thus far at:

    http://code.google.com/p/mobilegcal/

    There is also a pretty detailed description of all the problems with it.

  7. #7
    Newbie Array

    Join Date
    Aug 2007
    Posts
    9
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    You know, when you removed that sqlitedb file that you think has the mail data in it, did you kill the MobileMail app and restart it? It may have loaded the data in RAM and therefore not been affected by your delete.

    You probably tried it...just a thought.

  8. #8
    Senior Professional Array

    Join Date
    Jul 2007
    Posts
    445
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    30

    Default

    I think I can eventually get it to work... I did try killing the app and that is when it almost worked (although after that I discovered some stuff that I hadnt correctly put in the DB)...

    main problem is getting around to disable the checking... maybe running a fake pop server on the phone just to fool the mail app into thinking its checked the server would work...

    Another thing I havent yet tried but will get around to is running the inserts locally on the iphone, i'm convinced that this will work better since sqlite has its own locking mechanisms, and what I was doing was just a replace of the DB file each time.

    Right now I'm focusing on the inserting of contacts to get the addressbook sync. Since lh99 is doing the pop mail solution, i'm leaving that out for now. I can read contacts from OWA and I can insert contacts manually to the DB, now I just need to integrate both codes I mad which should be a couple of days.

    Since you are doing the cal stuff, if we all share code in the end we should be able to get a full sync solution before apple's release of something comparable (if they are planning to have such a release)...

    Thanks for the input though... I'm following your project closely

  9. #9
    Senior Professional Array

    Join Date
    Jul 2007
    Posts
    445
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    30

    Default

    Hey Spicy,

    just on a limb here, would you by any chance be able to compile PySQLite for others (like me) to use? :p

    I dont have experience in this sort of stuff for the iphone and i dont have a mac to compile this on for the iphone... It would be very helpful to be able to have SQLite support right in pythion, that way we dont need to always use the external binary, which will be quite inefficient...

    http://initd.org/tracker/pysqlite/wiki/pysqlite

    If you have the experience or know who might be able to do this it'd be amazing

  10. #10
    Rookie Array

    Join Date
    Aug 2007
    Posts
    28
    Post Thanks / Like
    Downloads
    0
    Uploads
    0
    Rep Power
    0

    Default

    I for one would love to have syncing capability with Google Calendar; similar to GooSync. Think it is a big gap in the iphone (+ that's the only way I can sync with my work calendar - Oracle CorporateTime)


 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Replies: 0
    Last Post: 03-31-2008, 03:24 PM
  2. Replies: 3
    Last Post: 03-28-2008, 01:38 AM
  3. Calendar app with Google calendar support
    By peteo in forum Free Toolchain Software (Cydia App's)
    Replies: 4
    Last Post: 12-17-2007, 07:37 PM
  4. Calendar data transfer
    By eljoevald in forum General
    Replies: 0
    Last Post: 11-01-2007, 04:54 PM
  5. google calendar sync with calendar app
    By hawaiipoolman in forum General
    Replies: 1
    Last Post: 10-31-2007, 05:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Powered by vBulletin®
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.
Search Engine Friendly URLs by vBSEO
(c) 2006-2012 Hackint0sh.org
All times are GMT +2. The time now is 10:10 AM.
twitter, follow us!