Jump to content
Due to limited holiday staffing, chat will be unavailable from Thursday, July 2 at 5:30 PM (CDT) to Monday, July 13 at 8 AM (CDT). This will allow us to reply to your email requests as quickly as possible. Thank you for understanding. ×

Cuchulain of Muirthemne

Level 1
  • Content Count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Cuchulain of Muirthemne

Profile Information

  • Subscription

Recent Profile Visitors

908 profile views
  1. Old thread - but here's my take I've had to replace the Windows Store version with the 'standard' download. One of the most annoying issues was the 'Send to' shortcut in File Manager - with Store version, because it placed in 'C:\Program Files\WindowsApps' - you need to go through additional steps to find out where the executable is located And it's not just the version number - Windows Store also appears to assign a suffix that makes your task even more difficult Basically my Send to shortcut was breaking with every version change. :-( /C
  2. I use a Firefox Add-in called SQLite Manager The tag_attr table stores the tags you're looking for. I use the following SQL scripts to copy the tags into a table ready for export. I perform a nested lookup (SQL2) to the grandparent level to better view tag collections Simple to export to Excel and run a Pivot table report /fancy printing Best /Cuchulain --SQL1: need to execute this once CREATE TABLE tag_attr_export (grandparent_name TEXT DEFAULT NULL COLLATE NOCASE, grandparent_uid INTEGER DEFAULT NULL, parent_name TEXT DEFAULT NULL COLLATE NOCASE, parent_uid INTEGER DEFAULT NULL, child_name TEXT DEFAULT NULL COLLATE NOCASE, child_uid INTEGER DEFAULT NULL, total_grandparent_tags INTEGER DEFAULT NULL, total_parent_tags INTEGER DEFAULT NULL, total_chilld_tags INTEGER DEFAULT NULL, total_notes_with_tag INTEGER DEFAULT NULL, date_created REAL DEFAULT NULL, date_updated REAL DEFAULT NULL, local_flags INTEGER DEFAULT NULL, subtag_count INTEGER DEFAULT NULL, note_count INTEGER DEFAULT NULL, is_linked INTEGER DEFAULT NULL, business_id INTEGER DEFAULT NULL); --SQL2: need to re-execute when tags are added (after emptying down tag_attr_export table) INSERT INTO tag_attr_export SELECT g.name AS grandparent_name, g.uid AS grandparent_uid, p.name AS parent_name, p.uid AS parent_uid, c.name AS child_name, c.uid AS child_id, g.subtag_count AS total_grandparent_tags, p.subtag_count AS total_parent_tags, c.subtag_count AS total_chilld_tags, c.note_count AS total_notes_with_tag, c.date_created, c.date_updated, c.local_flags, c.subtag_count, c.note_count, c.is_linked, c.business_id FROM tag_attr c, tag_attr p, tag_attr g WHERE c.parent_uid = p.uid AND p.parent_uid = g.uid ORDER BY p.name;
  3. Hi folks, I querying the SQLite DB directly and have had some strange encounters with the timestamp fields. From what I can gather they are supposed to be based on the Unix Epoch of 1970-01-01 This timestamp; 736012.8334375 is 2016/02/18 21:00 but trying multiple variants such as select datetime(((((736012.8334375)*1000/60)/60)/24), 'unixepoch'), datetime(((736012.8334375)), 'unixepoch'), datetime(736012.8334375, 'unixepoch'), strftime('%s', 'now'), strftime('7736012.8334375', 'unixepoch'), datetime(736012.8334375, 'unixepoch') Just gives "1970-01-01 02:21:58","1970-01-09 12:26:52","1970-01-09 12:26:52","1464340190",,"1970-01-09 12:26:52" This Excel formula =((((736012.8334375)*1000/60)/60)/24)+DATE(1970,1,1)+(1/24) 4/28/93 5:00 PM Has anyone dealt with this before? Can they shed some light into this hole I'm in Thanks /C
  4. Hi wbroek,

    Did you ever solve the problem of when the evernote timestamp is based from.

    I've been trying to work it out to but can't 

    SELECT datetime(736019.4148958334*1000 ,'unixepoch') , strftime('%s', '736019.4148958334', 'unixepoch'), strftime('%s','2016-01-01 02:34:56'), strftime('%s','now');

    It like it might be seconds from 01.01.1983 of something bizarre.


    Any assistance would be appreciated


  • Create New...