Jump to content
WestSideRailways

move a copy of all my notes into a SQL DB

Recommended Posts

Hi everyone,

 

I would like to know how to export(if possible) all my notes into a SQL DB, so that I can do all sorts of things with the data.

 

What i would like to do, instead of manually inputting all the date. a way to code via vs2013 to input the date via a program that i can make. 

 

Thanks

Share this post


Link to post

You're welcome.  Good luck.

Please share your findings here.  There might be many others who are interested.

Share this post


Link to post

well i coped my evernote Db and renamed the extension to .db

 

then i used DB browser for sqlite

 

and used the following statements

 

SELECT `_rowid_`,* FROM `notebook_attr`  ORDER BY `_rowid_` ASC;
select '_rowid_',* from 'note_attr' ;
 
the first one got me a list of all the notebooks
 
the second one got me a list of all the notes and what notebooks they were in.
 
I have not yet been able to get a listing of a single note and it contents.
 
Rdgs
 
Michael

Share this post


Link to post

×
×
  • Create New...