How to Setup?

Before running the script, you have to first download the following 3 x FREE packages:

   1. SQLite ODBC driver
       http://www.ch-werner.de/sqliteodbc/

   2. iPhuc Utility
       http://code.google.com/p/iphone-elite/downloads/detail?name=iPhuc%20Windows.rar&can=2&q=

   3. iOutNotes
       http://code.google.com/p/ioutnotes/downloads/list

onto your M$ Outlook-installed Windows machine.


Then perform the following 5 steps to let the solution works for you.

   1. Install SQLite ODBC driver

   2. Extract iOutNotes in a temporary directory (e.g. C:\Program Files\iOutNotes) on your PC

   3. Extract all files in the directory iPhuc Windows of the iPhuc archive in the same directory of iOutNotes

   4. Connect your iPhone to your PC

   5. Execute the batch file iOutNotes.bat or the script iOutNotes.vbs

If Outlook asks you for access permission, just tick the box to Allow access for 1 Minute and press OK

            


As always, BACKUP is one of the critical things to do when making changes. The script will automatic keep the five latest versions of the notes.db and the LOG file.


The additional iOutNotesDaemon script is written to be run in the background and automatic launch iOutNotes after each iTunes Sync.

   1. Execute the iOutNotesDaemon.bat or iOutNotesDaemon.vbs to start up the background service

   2. Execute the iOutNotesDaemon.bat or iOutNotesDaemon.vbs again to terminate the background service


Note: This procedure only holds for version 1.0b or later
              For earlier version, please refer to "How to do it Manually?"


You may want to refer to the tutorial of "How to Create a Shortcut on the Windows Desktop"


Please email to me if you need help.

如何安裝使用?

首先，您必須下載以下三個免費軟件到您的Windows機器上:

   1. SQLite ODBC driver
       http://www.ch-werner.de/sqliteodbc/

   2. iPhuc Utility
       http://code.google.com/p/iphone-elite/downloads/detail?name=iPhuc%20Windows.rar&can=2&q=

   3. iOutNotes
       http://code.google.com/p/ioutnotes/downloads/list


然後執行以下五個步驟:

   1. 安裝 SQLite ODBC Driver

   2. 解壓 iOutNotes 到一個臨時目錄裡 (例如: C:\Program Files\iOutNotes)

   3. 解壓 iPhuc 包裹裏的檔案到 iOutNotes 的同一個臨時目錄裡, 不要保留目錄 iPhuc Windows

   4. 連接您的 iPhone 到您的個人電腦

   5. 執行程式 iOutNotes.bat 或 iOutNotes.vbs

   如果 Outlook 要求您訪問權限，請允許1分鐘的權限即可


iOutNotes 會自動將最新的五個版本的 notes.db 和 記錄檔 保留。


附載的程式 iOutNotesDaemon 會運行在背景中, 並自動地在每一次 iTunes Sync 完成以後執行程式 iOutNotes。

   1. 執行程式 iOutNotesDaemon.bat 或 iOutNotesDaemon.vbs 以啟動背景服務

   2. 再一次執行程式 iOutNotesDaemon.bat 或 iOutNotesDaemon.vbs 以終止背景服務


註： 這個做法只適合 v1.0b 或以後的版本。 對於初期版本，請參見 "How to do it manually?"


如果您需要幫助，請發電子郵件給我。

どのようにインストールして使いますか？

まず、あなたは必ず以下の3つのフリーソフトをダウンロードしてあなたのWindows機械の上に着かなければなりません:

   1. SQLite ODBC driver
       http://www.ch-werner.de/sqliteodbc/

   2. iPhuc Utility
       http://code.google.com/p/iphone-elite/downloads/detail?name=iPhuc%20Windows.rar&can=2&q=

   3. iOutNotes
       http://code.google.com/p/ioutnotes/downloads/list


それから以下の5つの措置を実行します:

   1. インストール SQLite ODBC Driver

   2. 解凍します iOutNotes １つの臨時のディレクトリの中に着きます (例えば: C:\Program Files\iOutNotes)

   3. 解凍します iPhuc 小包の中の書類は着きます iOutNotes の同一の臨時のディレクトリの中で、 ディレクトリを保留しないでください iPhuc Windows

   4. あなたのにつながります iPhone あなたのパソコンに着きます

   5. ファイルを実行します iOutNotes.bat あるいは iOutNotes.vbs

   もし…ならば Outlook あなたに権限を訪問するように求めて、1分の権限を許してすぐ下さい


iOutNotes できるのは自ら最新だ notes.db とランクを記録する5つのバージョンは保留します。


付けます： この方法はただ適するだけ v1.0b あるいは後のバージョン。 初期バージョンについて、 "How to do it manually?"


はあなたはもし助けなければならないならば、電子メールを出して私にあげることを下さい。

What's New?

Download Link

Changelogs:
v1.0f: (Full-Sync + Automation + 64-Bit OS Support + Background daemon + FW2.2.1 Support)
Attempt to change data source to cope with iPhone 2.2.1 firmware
Fixed minor bug on script execution outside of the containing directory
Added the trimming of unrecognized tags

v1.0e: (Full-Sync + Automation + 64-Bit OS Support + Background daemon)
Fixed error reporting in iOutNotes.vbs
Modified iOutNotesDaemon.vbs to be run without command batch

v1.0d: (Full-Sync + Automation + 64-Bit OS Support + Background daemon)
Added background daemon script to sync notes after each iTunes Sync

v1.0c: (Full-Sync + Automation + 64-Bit OS Support)
Added 64-Bit OS Support

v1.0b: (Full-Sync + Automation)
First Full-Sync + Automation Version
Added Upload/Download via iPhuc Utility
Added LOG file backup and rotation
Added notes.db backup file rotation

v1.0a: (Full-Sync Only)
First Full-Sync Version
Added Notes sorting by Title in database **Not useful because iPhone displays latest notes first
Added control flags to accelerate the overall process
Added long Note (>2088 characters) truncation to accommodate iPhone's record limit
Added prompting for all Notes restoration from iPhone when Outlook has *NO* note
Reduced temporary table's usage to reduce resources consumption

v0.97e: (Half-Sync Only)
Fixed fonts difference
Added explicit Unicode detection
Modified to closely follow the iPhone presentation format
Modified to handle Cyrillic fonts
Modified to use FS.Stream for logging

v0.96: (Half-Sync Only)
Added log file output for tracing
Added batch file for novice users
Tested with more cases

v0.95: (Half-Sync Only)
Modified record duplication check to include the Outlook EntryID
Added iPhone notes record deletion if the note is removed from Outlook
One-way sync is accomplished

v0.9: (Half-Sync Only)
Moved most main program steps to subroutine for easy porting
Added record duplication check by the title text and the last modification time

v0.8: (Half-Sync Only)
Corrected the sorting SQL statement

v0.7: (Half-Sync Only)
Corrected the date function

v0.6: (Half-Sync Only)
Added notes.db file backup
Added drop temporary tables before create
Added Simple Error Handler

v0.5: (Half-Sync Only)
Added progress notification
Added sorting through Index ID to ensure unique note_id
Added verbose output





Special Thanks to:
Andrey
Raymond Yiu
Jesper Rasmussen

One-Click Sync Automation

BREAKING NEWS!!!

I am happy to tell you that I have worked out a way to automate the process of:

1. Retrieve the iPhone notes database note.db to PC
2. Synchronize the database with MS Outlook notes
3. Transfer the synchronized database note.db to iPhone

Therefore, the whole process can eventually be completed in one single click (excluding the "Allow access" click of Outlook).

See Installation Procedure

Full Sync Version (Alpha)

I just managed to complete the first Full Sync Version during the Chinese New Year vacation. Sorry for the long delay!

This version can sync Outlook notes with iPhone notes database, except for the operation of note deletion that would only cater from the Outlook side. In other words, a note being deleted on Outlook will eventually be deleted on both side on next sync, but note being deleted on iPhone will be restored from Outlook for the sake of data protection.

Here are the scenarios: [Based on Record Modification Time]
1. New note on Outlook -> Copy onto iPhone database
2. New note on iPhone -> Copy onto Outlook
3. Modified note on Outlook -> Update the corresponding note on iPhone database
4. Modified note on iPhone -> Update the corresponding note on Outlook
5. Deleted note on Outlook -> Delete the corresponding note on iPhone database
6. Deleted note on iPhone -> Restore the corresponding note from outlook to iPhone database
7. If Outlook has no note -> Ask whether restore all notes from iPhone to Outlook or purge the iPhone database
8. If iPhone has no note -> Copy all notes from Outlook to iPhone database

Download Link

Nevertheless, please be minded that this is an Alpha version and is not intended for production use.

Major Changes:
Added Notes sorting by Title in database **Not useful because iPhone displays latest notes first
Added control flags to accelerate the overall process
Added long Note (>2088 characters) truncation to accommodate iPhone's record limit
Added prompting for all Notes restoration from iPhone when Outlook has *NO* note
Reduced temporary table's usage to reduce resources consumption