MobileRead Forums - View Single Post - Export notes and Highlights

Juliepac · 11-25-2011, 03:37 PM

The tutorial is really big, but once you learned how to do it and have what you need, you do it in 5 minutes.
There you go, hope it helps!

HOW TO IMPORT NOTES AND HIGHLIGHTS FROM EREADER (can work for stanza too) FOR APPLE DEVICES

YOU NEED A JAILBROKEN IDEVICE
YOU NEED A WAY TO ACCESS THE FOLDER IN YOU IDEVICE (I USE IFILES FROM CYDIA AND SSH/WINSCP - IF YOU DONT KNOW HOW TO DO IT, GOOGLE IT)

1. TAKE .DB FILE FROM EREADER FOLDER IN IPAD/ IPOD/ IPHONE (ITS IN VAR/MOBILE/APPLICATIONS/... (YOU HAVE TO FIND THE EXACT FOLDER)...
2. OPEN THE .DB FILE WITH SOME SQLITE MANAGER
3. USE A FORMULA TO SORT OUT THE DATA YOU WANT (NOTES OR HIGHLIGHTS)
3.1 FOLLOW THE EXAMPLE - (SELECT * FROM BOOKS, NOTES WHERE BOOK.ID = 4 AND NOTES.ID > 1061)
3.2 FORMULA DEPENDS ON YOUR DATA/TABLE. EXPLORE IT.
4. AFTER YOU SORTED OUT THE DATA YOU WANTED, EXPORT IT AS A CSV FILE
5. OPEN EXCEL
6. GO TO THE DATA TAB
7. IN TAB DATA, CHOOSE OBTAIN EXTERNAL DATA FROM TEXT
8. CHOOSE THE CSV FILE
9. CHOOSE THE CORRECT MARKER THAT SEPARATES THE COLUMNS, IN THE CASE HERE QUOTATION MARKS
10. CHOOSE UTF8 AS TEXT CODIFICATION
11. CHOOSE WHAT COLUMNS TO IGNORE (i IGNORE EVERYTHING EXCEPT TEXT)
12. SOMETIMES, THE IMPORTED TABLE IN EXCEL WILL HAVE MORE THAN ONE COLUMN. TO GET ALL COLUMNS IN A LINE INTO ONE CELL (OTHERWISE YOU MAY END UP WITH TABULATION SPACES WHEN YOU GET THE TEXT INTO WORD) APPLY THIS FORMULA TO THE FIRST EMPTY CELL IN THE LINE: =A1&B1&C1&D1 ETC.
12.1 FORMULA DEPENDS ON YOUR DATA
12.2 DRAG FORMULA TO THE OTHER LINES
13. ERASE THE BAD FORMATTED DATA AND KEEP JUST THE NICE ONE. NOW YOU HAVE A NICE EXCEL TABLE WITH ALL YOUR NOTES OR HIGHLIGHTS. SELECT THE DATA AND COPY IT
14. OPEN WORD
15. PASTE WHAT YOU COPIED FROM EXCEL INTO WORD. YOU WILL HAVE A TABLE IN WORD. THAT'S NOT WHAT I WANTED. I WANTED PLAIN TEXT I COULD MANAGE HOWEVER I LIKED.
16. SELECT AND COPY THE DATA YOU HAVE IN WORD
17. OPEN NOTEPAD
18. PASTE WHAT YOU COPIED FROM WORD INTO NOTEPAD. TA DA! NO TABLE ANYMORE.
19. SELECT EVERYTHING IN NOTEPAD AND COPY
20. GO BACK TO WORD AND PASTE THE NEW "UNTABLED", PLAIN TEXT INTO WORD.
21. THAT'S IT. NOW YOU CAN FREELY MODIFY IT. FORMAT THE WAY YOU WANT. TURN IT INTO A BEAUTIFUL SUMMARY ETC.
22. ;-)

11-25-2011, 03:37 PM	#13
Juliepac Member Posts: 19 Karma: 10 Join Date: Nov 2010 Device: iPod touch, ipad, android phone	The tutorial is really big, but once you learned how to do it and have what you need, you do it in 5 minutes. There you go, hope it helps! HOW TO IMPORT NOTES AND HIGHLIGHTS FROM EREADER (can work for stanza too) FOR APPLE DEVICES YOU NEED A JAILBROKEN IDEVICE YOU NEED A WAY TO ACCESS THE FOLDER IN YOU IDEVICE (I USE IFILES FROM CYDIA AND SSH/WINSCP - IF YOU DONT KNOW HOW TO DO IT, GOOGLE IT) 1. TAKE .DB FILE FROM EREADER FOLDER IN IPAD/ IPOD/ IPHONE (ITS IN VAR/MOBILE/APPLICATIONS/... (YOU HAVE TO FIND THE EXACT FOLDER)... 2. OPEN THE .DB FILE WITH SOME SQLITE MANAGER 3. USE A FORMULA TO SORT OUT THE DATA YOU WANT (NOTES OR HIGHLIGHTS) 3.1 FOLLOW THE EXAMPLE - (SELECT * FROM BOOKS, NOTES WHERE BOOK.ID = 4 AND NOTES.ID > 1061) 3.2 FORMULA DEPENDS ON YOUR DATA/TABLE. EXPLORE IT. 4. AFTER YOU SORTED OUT THE DATA YOU WANTED, EXPORT IT AS A CSV FILE 5. OPEN EXCEL 6. GO TO THE DATA TAB 7. IN TAB DATA, CHOOSE OBTAIN EXTERNAL DATA FROM TEXT 8. CHOOSE THE CSV FILE 9. CHOOSE THE CORRECT MARKER THAT SEPARATES THE COLUMNS, IN THE CASE HERE QUOTATION MARKS 10. CHOOSE UTF8 AS TEXT CODIFICATION 11. CHOOSE WHAT COLUMNS TO IGNORE (i IGNORE EVERYTHING EXCEPT TEXT) 12. SOMETIMES, THE IMPORTED TABLE IN EXCEL WILL HAVE MORE THAN ONE COLUMN. TO GET ALL COLUMNS IN A LINE INTO ONE CELL (OTHERWISE YOU MAY END UP WITH TABULATION SPACES WHEN YOU GET THE TEXT INTO WORD) APPLY THIS FORMULA TO THE FIRST EMPTY CELL IN THE LINE: =A1&B1&C1&D1 ETC. 12.1 FORMULA DEPENDS ON YOUR DATA 12.2 DRAG FORMULA TO THE OTHER LINES 13. ERASE THE BAD FORMATTED DATA AND KEEP JUST THE NICE ONE. NOW YOU HAVE A NICE EXCEL TABLE WITH ALL YOUR NOTES OR HIGHLIGHTS. SELECT THE DATA AND COPY IT 14. OPEN WORD 15. PASTE WHAT YOU COPIED FROM EXCEL INTO WORD. YOU WILL HAVE A TABLE IN WORD. THAT'S NOT WHAT I WANTED. I WANTED PLAIN TEXT I COULD MANAGE HOWEVER I LIKED. 16. SELECT AND COPY THE DATA YOU HAVE IN WORD 17. OPEN NOTEPAD 18. PASTE WHAT YOU COPIED FROM WORD INTO NOTEPAD. TA DA! NO TABLE ANYMORE. 19. SELECT EVERYTHING IN NOTEPAD AND COPY 20. GO BACK TO WORD AND PASTE THE NEW "UNTABLED", PLAIN TEXT INTO WORD. 21. THAT'S IT. NOW YOU CAN FREELY MODIFY IT. FORMAT THE WAY YOU WANT. TURN IT INTO A BEAUTIFUL SUMMARY ETC. 22. ;-)