Step 1: Export ChatThread using following SQL statement from PalmDatabase.db3:
How?
* Install SQLite Manager (Firefox Addons) * In SQLite Manager, "Database" menu ⇒ "Connect Database" ⇒ open Palmdatabase.db3 * Paste SQL in the "Execute SQL" tab on the right hand side * Highlight all results ⇒ right click ⇒ "Copy Row(s) as CSV (MSExcel compatible)" * Paste to MS Excel * Copy from Excel and paste to text editor and save to js file as stated (To remove the double quote in the beginning and the end of each line)
Save the result to ct_old.json.js (in the same directory as this file)
Step 2: Export Messages using following SQL statement from PalmDatabase.db3:
Save the result to message.json.js
Step 3: Turn on "Airplane mode" on the WebOS device, run following shell script to export Person and ChatThread database from WebOS 2.1 db8
How?
* use novacom to open WebOS terminal: novacom -t open tty:// * Paste the shell script after the terminal is opened ("root@" should be shown) * Close the terminal exit * use novacom to transfer files back to local disk: novacom get file://media/internal/persons.json.js > persons.json.js novacom get file://media/internal/ct_current.json.js > ct_current.json.js
File will be saved to persons.json.js and ct_current.json.js. Transfer them to the same directory as this file
Warning: following steps will modify WebOS db8 database!
Step 4: Click the following button to generate shell script to insert chat thread to WebOS db8
Save to ins1.sh and run it
A updated version of chat thread will be saved to ct_current.json.js again
Details ...
* use novacom to transfer ins1.sh to WebOS device novacom put file://media/internal/ins1.sh < ins1.sh * use novacom to open WebOS terminal: novacom -t open tty:// * Run the shell script after the terminal is opened ("root@" should be shown) sh /media/internal/ins1.sh * Close the terminal exit * use novacom to transfer files back to local disk: novacom get file://media/internal/ct_current.json.js > ct_current.json.js
Step 5: Refresh the page and click the following button to generate shell script to insert messages to WebOS db8
Save to ins2.sh and run it
Details ...
* use novacom to transfer ins2.sh to WebOS device novacom put file://media/internal/ins2.sh < ins2.sh * use novacom to open WebOS terminal: novacom -t open tty:// * Run the shell script after the terminal is opened ("root@" should be shown) sh /media/internal/ins2.sh * Close the terminal exit