How to recover iDo Notepad data from an iPhone

iDo Notepad (Diary/Journal) by Neil Thomas, is a simple-to-use notepad application, written specifically for the iPad & iPhone/iPod Touch.

If you have lost access to or deleted data from iDo Notepad after upgrading to iOS 11 or newer versions, please contact our support team by clicking Contact Support below. So long as the data is still present in your backup, we will be able to assist you in recovering this data with iPhone Backup Extractor.

If you already have an iTunes backup created when the iDo Notepad data was still present on your iPhone, you can move forward to the recovery section.

If you don't have an iTunes backup and you still have the iDo Notepad data on your iPhone, you can create one now using iPhone Backup Extractor or iTunes.

How to extract data from iDo Notepad:

• Launch iPhone Backup Extractor and select your backup from the left-hand navigation. Go to the “App View” tab and select the iDo Notepad app from the apps list.
• To extract your data from this app, you will have to extract the database file. To do so, click on the “Extract link” next to “All databases”. The extracted file is called iDo.sqlite and you can open it with a free SQLite tool.
• Open the iDo.sqlite file with DB Browser, then go to the “Browse Data” tab and look at the table called ZDIARY. Here you should find all the texts you have saved in your journal. You can also extract this table into a CSV file by using the File menu → Export → Table(s) as CSV file…
• An alternative way to extract the iDo Notepad data with the timestamp converted to local time format is using the Execute SQL tab in DB Browser and running this command: SELECT Z_PK, datetime(ZCALENDARDATE, 'unixepoch', '31 years', 'localtime') AS NoteDate, ZEVENTNAME, ZMESSAGE, datetime(ZTIMESTAMP, 'unixepoch', 'localtime') AS NoteTimestamp FROM ZIDIARY