View Single Post
Old 11-25-2011, 04:37 PM   #13
Juliepac
Member
Juliepac began at the beginning.
 
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. ;-)
Juliepac is offline   Reply With Quote