Jump to content
joepan

Work Chats Limited by Date

Recommended Posts

I'm looking to find a way to extend the earliest work chat showing in Evernote from two months to infinity--I want access to all my work chats. I brute forced the sql lite file into text & can see it contains work chats from long before, but I have no idea how to get those texts unjumbled. For some stupid reason Evernote only lets me see work chats from two months ago, but I need all the info from chats farther back. Can anyone help with a suggestion?

Share this post


Link to post
9 hours ago, joepan said:

I brute forced the sql lite file into text & can see it contains work chats from long before, but I have no idea how to get those texts unjumbled.

Can you provide details on the tables you accessed for this.
I'll take a look; my first thought is to copy the tables into a spreadsheet.

Share this post


Link to post

I just now got it to work, the only problem is, the dates have been converted to numbers with decimals. Know why dates would be converted to decimals, or how to change them back? 

Share this post


Link to post
3 hours ago, joepan said:

Know why dates would be converted to decimals, or how to change them back? 

Its a computer thing; date/times are stored as the number of seconds from a given epoch date (1/1/1970)

It should be possible to convert the number to a date using a script or formula
My head hurts just thinking about it; here's a solution thanks to @JMichaelTX

 

  • Like 1

Share this post


Link to post

Okay, I'm going to mark this "Figured out myself after 3 days" & keeping my findings here to help others with the problem.

First of all, Evernote DOES keep chats online, despite what they say. One has to return to "old mode" before you can see them. Otherwise you can't, which is ridiculous.

Second, you can scrape texts by downloading a program like RazorSQL, finding & opening the database, & exporting all the tables into an Excel file. One will have all your saved messages aka work chats in there.

 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...