move a copy of all my notes into a SQL DB

[WestSideRailways 1]

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

[JMichaelTX 4,117]

The EN Win data is already in a SQLite DB.  So with a little (or maybe a lot) of inspection you can decipher the structure.

 

This is an old thread, so it may not apply any longer, but maybe it will be of some help:

See Working Directly with the Evernote Database / SQLite3 access to Evernote.sql

[WestSideRailways 1]

Thank you for your answer, will look into it. :-)

[JMichaelTX 4,117]

You're welcome.  Good luck.

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

[WestSideRailways 1]

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