Cuchulain of Muirthemne

Member
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

1 Neutral

Recent Profile Visitors

287 profile views
  1. HOWTO: Print list of tags? [NOT CURRENTLY POSSIBLE]

    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;
  2. Tags UI Change - and Feature Request

    Take your time - I didn't get into the Tag mess overnight. I'm running 10.11.5
  3. Tags UI Change - and Feature Request

    Hi Michael, I have my old Macbook up and running again - I'd be interested in that offer of the Automator / Apple Script is it's still open Thanks in advance /C
  4. Tags UI Change - and Feature Request

    Hi Michael, I'll take you up on that offer. The OC in me had all of my tags in a *super-duper* hierarchical structure that's impossible to keep up with. So, I've been analysing my tag structure lately via the SQLite DB on Windows and created a table that stores the parent and grandparent of the tag - this table I've been looking at in Gephi for insights. Not wanting to lose the info in my tags, I planned on writing some of the key ones in the note_title field - so your AppleScript would be welcome. Interestingly Gephi showed that ~25% of my tags are not in use any more and ~50% are only used to tag one or two notes. My Gephi project is very rough at the moment too - but if you're interested in it let me know. Thanks /C INSERT INTO mig_tag_attr 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_child_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;
  5. 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
  6. Tags UI Change - and Feature Request

    Well thankfully I had a copy on Laptop and Desktop - because the procedure for rolling back to a previous version is not one I like.
  7. 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

    /Cuchulain

  8. Tags UI Change - and Feature Request

    I'm afraid that it may be too late, I have a 30 GB Database & 3,932 tags - the screen to manage them was quite poor anyway - but removing it entirely left me astounded.