Friday, February 10, 2012

Outlook Notes Sychronization with Android

Just a quick recommendation of a free App for synchronizing notes between Outlook (Exchange Server) and Android phone.

Notes For Exchange is an application for synchronization notes between Android and MS Exchange/Gmail/Other.
This application will NOT send/store your Notes to/in third-party server.
It uses the standard calender synchronization mechanism of Android.

* I am NOT the author of this tool and have NO connection/linking/relationship/benefit to/from the author.

Friday, June 26, 2009

Native Notes Sychronization

The iPhone 3.0 firmware can now do Notes Sychronization natively that you can sync all the notes you write on your iPhone back to your Mac or PC.

It is hopefully that the slight steer of the product roadmap is a truthful response to the community and is only a beginning to offer the whole set of essential features.

As a result of the release, iOutNotes is no longer developed since the satisfactorily accomplishment of her mission.

Again, thanks for your appreciation.

Wednesday, April 15, 2009


iOutNotes is an Open Source Software designed to fill the missing piece in the data synchronization between Apple iPhone and Microsoft Outlook where purely through the USB connection. Prior to iPhone firmware 3.0, Apple iTunes supports only the synchronization of Calendar events and Contacts between iPhone and Microsoft Outlook; hence there is no native support for synchronizing Notes before.

There are certainly other solutions available for synchronizing data over the air with sites in the Internet. Unless there is a need of online personal notes access, it is obvious that synchronizing data over USB has more advantages to end-users than other means. While both ends of the communication (i.e. iPhone and PC) are situated in front of the user, the most efficient method is undoubtly to connect them together directly. The introduction of unrelated party mandatory governing the data exchange is unnecessary and questionably, which consequently inducing the risk of accidental information disclosure especially when the Internet is the pathway, and not even mention about the trustworthiness and the truthfulness of the party in doubt.

By considering the total cost, direct USB synchronization can reduce the time cost, the data carrier airtime cost, the third party subscription and storage cost, and the iPhone maintenance cost - a result of the lengthen mean time between battery charging.

Owing to the lacking of the freedom, iOutNotes becomes a zero cost response to the shared needs of common iPhone users.

iOutNotes is coded in VBScript (A text file containing the batch instructions for the computer to work on) interpreted by the built-in Microsoft Windows Script Host interpreter, which is in human readable format reducing the threat of virus or Trojan (See the decision). According to Microsoft, Windows Script Host may be used for a variety of purposes, including logon scripts, administration and general automation.

The operation of iOutNotes requires two prerequisite third parties Windows applications, the SQLite ODBC Driver and the iPhone Utility Client. The SQLite ODBC Driver enables programmatic access to the format the iPhone notes database is constructed. The iPHone Utility Client (iPHUC) is the second generation of iPhoneInterface which allows convenient command line access to the iphone from a desktop computer. Other than jailbreak, there is no extra application required on iPhone.

During the execution time, notes are retrieved from both iPhone and Outlook and are compared with each other one by one. Once an iPhone note matches with an Outlook note, the one with the latest modification time stamp is retained and replicated to the other end.

In short, the synchronization logics are summarized as follows:-

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
9. If both sides have no note  --> Do nothing

There are 2 users' most concerned default limits, the maximum note size (2088 characters long) and the maximum number of notes allowed (32767 notes), that are modificable for fitting individual user's needs. All the users tunable parameters are listed as follows:-

DEBUG_FLAG = 0               - 1 = Debug mode
MAXNOTES = 32767           - The maximum number of notes
MAXNOTESIZE = 2088        - The maximum size (Characters) of each note
BACKUPLEVEL = 5             - The number of backup file versions to be kept
IPHONE_TIMEOUT = 30      - The time (Seconds) to wait for iPhone to be connected to PC


iOutNotes是一個開放源碼軟件, 設計用作填補蘋果iPhone和微軟Outlook之間通過USB連接同步的缺欠。由於在iPhone固件3.0之先, 蘋果iTunes僅能支持iPhone和微軟Outlook之間的日曆事件和通訊錄的同步, 沒有直接支持筆記同步。

在坊間也有一些其他疑似同步的方案, 都是利用互聯網將iPhone與網站數據庫連結同步。除非有需要在線上存取個人筆記,對於終端用戶而言,使用USB同步會比其它方法有更多明顯的好處。只因兩個同步對象(即iPhone和個人電腦)是近在用戶的咫尺間,最有效率的方法無疑是直接地將它們連接同步。引入與用戶無關的服務公司是什麼的一個鑽錢的方案?! 使用互聯網作數據交換和儲存的直接風險, 就是有意外洩漏資料的可能, 再者服務公司的可信賴性亦是用戶需要擔心的未知風險。



iOutNotes是以微軟視窗的VBScript編寫(文字檔案包含着個人電腦的工作指示),以人類可解讀的格式儲存去減少病毒或特洛伊木馬的憂慮。根據微軟所言,Windows Script Host可作為多用途的個人電腦工作指示檔使用,包括登入程序、管理程序和一般自動化程序。

iOutNotes的操作必須配合另外两個第三方視窗軟件、就是SQLite ODBC Driver and the iPhone Utility Client。SQLite ODBC Driver使iOutNotes能直接存取iPhone的筆記數據庫。iPHone Utility Client (iPHUC) 是iPhoneInterface的第二代, 允許iOutNotes能從個人電腦直接對iphone下工作指示。 除Jailbreak以外,沒有其他軟件需要安裝在iPhone上。



1. 新的Outlook筆記        --> 會被複製到iPhone數據庫
2. 新的iPhone筆記         --> 會被複製到Outlook
3. 修改過的Outlook筆記 --> 會被更新到對應的iPhone筆記
4. 修改過的iPhone筆記  --> 會被更新到對應的Outlook筆記
5. 刪除了的Outlook筆記 --> 會刪除對應的iPhone筆記
6. 刪除了的iPhone筆記  --> 會從Outlook恢復到iPhone數據庫
7. 如果Outlook沒有筆記 --> 會詢問是否從iPhone恢復所有筆記到Outlook或完全清除iPhone數據庫
8. 如果iPhone沒有筆記  --> 會從Outlook複製所有筆記到iPhone數據庫
9. 如果雙方都沒有筆記   --> 那就什麼也不做了

程式中有两個用戶比較關心的限制參數、其為最大筆記大小(最長為2088個字符) 和最大容許的筆記數量(32767則筆記),用戶可因着個人需要作出改動。以下列出所有用戶可自行改動的參數:-

DEBUG_FLAG = 0               - 1 = 開啟偵錯模式
MAXNOTES = 32767           - 最大容許的筆記數量
MAXNOTESIZE = 2088        - 最大筆記大小(最長可以有多少字符)
BACKUPLEVEL = 5             - 被保留的備份版本數量
IPHONE_TIMEOUT = 30      - 等待iPhone被連接到個人電腦的時間(秒)

Is Jailbreak a must?

Yes, Jailbreak is still necessary because Apple barred the access to the data area by default.

For details about Jailbreak, please visit:

Nevertheless, I do *NOT* mean to suggest, encourage, influence, convince or attract you to jailbreak your iPhone.

System Compatibility

Latest Version is 1.0f Build 20090515
(See "What's New?" for details)

Users Tested Configurations
Operating Systems:
Microsoft Windows 2000/XP/Vista/2008

Outlook Versions:
Microsoft Outlook 2000/XP/2003/2007

Apple iPhone Versions:
iPhone 2G/3G with firmware 2.0/2.0.1/2.0.2/2.1/2.2/2.2.1 (Jailbreak)

SQLITE ODBC Driver Versions:
0.78 or Later