{"id":14435,"date":"2009-04-03T17:17:18","date_gmt":"2009-04-03T23:17:18","guid":{"rendered":"http:\/\/hill-kleerup.org\/blog\/?p=14435"},"modified":"2009-04-03T17:17:36","modified_gmt":"2009-04-03T23:17:36","slug":"slowly-unraveling-twitter-tools-and-timestamps","status":"publish","type":"post","link":"https:\/\/hill-kleerup.org\/blog\/2009\/04\/03\/slowly-unraveling-twitter-tools-and-timestamps.html","title":{"rendered":"Slowly unraveling Twitter Tools and Timestamps"},"content":{"rendered":"
<\/div>\n

So a bit ago I decided I wanted to run Twitter Tools<\/a> giving a daily archive of Tweets on my blog, rather than echoing each one. For one thing, I didn’t like the use of the first 30 characters of the post for the title (I know how to work around that, maybe, now, but …). For another thing, I didn’t think individual Tweets were that interesting, and I was spending too much time thinking, “How is this going to look as its own post.”<\/p>\n

I switched the Twitter Tools options “Create a blog post from each of your tweets?” to No, and “Create a daily digest blog post from your tweets?” to Yes. Unlike what some of the comments folks have made in various forums imply, I did not find any sort of options appearing to set what date it should be.<\/p>\n

The daily digests were showing up at midnight, which meant that all the comments for day X were on a post dated X+1. Not what I wanted.<\/p>\n

\"\"<\/div>\n

Dug into the web pages, Google, WordPress forums, etc. Let messages. Tried to figure it out.<\/p>\n

Nada.<\/p>\n

I found in the WP database (in wp_options) a field titled aktt_digest_daily_time<\/em>, but it was blank, and there was no sort of guide as to what should go in there — or even what format to try out. Given the vagaries of time standards in UNIX and PHP and such, I was reluctant to just guess.<\/p>\n

I checked with Doyce, who runs this. He had a very old datestamp in there. Weird. I tried that. No change. I tried a different timestamp in the format of the install_date field. nada.<\/p>\n

Finally, I tried “11:01 p.m.” by itself.<\/p>\n

Ch-ching. Midnight comes and another post gets done.<\/p>\n

So I tried (because I’d found a reference to something format like that in a post someone had written) “23:01”.<\/p>\n

And … aha! I got a Tweet digest<\/a> at … 5:23 p.m.?<\/p>\n

What the heck?<\/p>\n

I hadn’t had a chance to look at it this afternoon, but was poking into the WP dashboard for the blog and noticed … a Tweet digest … already in place? Scheduled but unposted?<\/p>\n

And I looked at it, and, yup, it was scheduled for 5:23p.<\/p>\n

So I opened up phpAdmin again and looked in the wp_posts table, and saw that the post_date for that post was “2009-04-03 17:23:00” — but the post_date_gmt for the file was “2009-04-03 23:23:00”. And, yes, during Daylight Saving Time, we’re GMT-6.<\/p>\n

Aha!<\/p>\n

So the aktt_digest_daily_time<\/em> field is a GMT date, in a 24-hour hh:mm format. For some reason, there’s some sort of lag in it (perhaps based on when the widget actually gets thrown to look for tweets), giving a 20-odd minute lag.<\/p>\n

So, if I change that timestamp to “05:15”, I should get a daily digest at 11:30 p.m. or so at night. Just what I want.<\/p>\n

Let’s see if it works.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

So a bit ago I decided I wanted to run Twitter Tools giving a daily archive of Tweets on my blog, rather than echoing each one. For one thing, I didn’t like the use of the first 30 characters of the post for the title (I know how to work around that, maybe, now, but … Continue reading “Slowly unraveling Twitter Tools and Timestamps”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[55],"tags":[],"class_list":["post-14435","post","type-post","status-publish","format-standard","hentry","category-blogging-technical"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":32884,"url":"https:\/\/hill-kleerup.org\/blog\/2013\/03\/24\/twitter-tools-and-archives.html","url_meta":{"origin":14435,"position":0},"title":"Twitter, Tools, and Archives","author":"***Dave","date":"Sun 24-Mar-13 12:08am","format":false,"excerpt":"My Twitter Tools daily archives on this page have been broken since early February, and I'm unable to get them working again at this point. Twitter Tools -- the Twitter\/WP plug-in I use -- for some reason isn't generating the daily (or weekly) digests it is supposed to. It will\u2026","rel":"","context":"In "Blogging - Technical"","block_context":{"text":"Blogging - Technical","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/blogging-technical"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/hill-kleerup.org\/blog\/wp\/wp-content\/uploads\/2013\/03\/Technical-difficulties.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":30586,"url":"https:\/\/hill-kleerup.org\/blog\/2012\/10\/16\/twitter-and-blogging-and-informational-domains-oh-my.html","url_meta":{"origin":14435,"position":1},"title":"Twitter and blogging and informational domains (oh my!)","author":"***Dave","date":"Tue 16-Oct-12 12:28am","format":false,"excerpt":"So I have this wildly complex and intricate informational ecology going on, including (for example) my Google Plus posts feeding into my blog.In fact, I consider my blog (https:\/\/hill-kleerup.org\/blog\/) the Site of Record for All Things Me. \u00a0Beyond G+, I also have the Twitter Tools plug-in in my WordPress blog\u2026","rel":"","context":"In "~PlusPosts"","block_context":{"text":"~PlusPosts","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/plusposts"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":18558,"url":"https:\/\/hill-kleerup.org\/blog\/2010\/09\/13\/tweets-from-2010-09-13-6.html","url_meta":{"origin":14435,"position":2},"title":"Tweets from 2010-09-13","author":"***Dave","date":"Mon 13-Sep-10 11:30pm","format":false,"excerpt":"Well, that weekend blew away a good week of dieting. Plus, er, we now have many leftovers. # Rrg. Twitter Tools still randomly posting multiple dupes of daily Twitter digests on blog. Looking for alternatives. # Green Elf needs haircut, badly! # It was nice having Mary out, and will\u2026","rel":"","context":"In "~Tweets"","block_context":{"text":"~Tweets","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/tweets"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":30582,"url":"https:\/\/hill-kleerup.org\/blog\/2012\/10\/15\/tweets-from-2012-10-15.html","url_meta":{"origin":14435,"position":3},"title":"Tweets from 2012-10-15","author":"***Dave","date":"Mon 15-Oct-12 10:45pm","format":false,"excerpt":"3 of 5 stars to Revenge of the Damned by Allan Cole Link # Saturday was pretty much non-stop relaxing entertainment for me. Nummy #GABF brunch at Fogo, then Margie and I playing #WoW most of the day. # Sunday was instad a series of low-grade frustrations which certainly could\u2026","rel":"","context":"In "~Tweets"","block_context":{"text":"~Tweets","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/tweets"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15703,"url":"https:\/\/hill-kleerup.org\/blog\/2009\/09\/02\/tweets-from-2009-09-02.html","url_meta":{"origin":14435,"position":4},"title":"Tweets from 2009-09-02","author":"***Dave","date":"Wed 2-Sep-09 11:30pm","format":false,"excerpt":"Queueing up for a very busy day, trying to meet assignments and clear desk before taking the rest of the weekend off. Anticipatory huzzahs! # Love being late for my train because boss changes deliverable specs at eleventh hour. Added bonus: vacation homework! Labor Day indeed. # Apologies, Tweeps. For\u2026","rel":"","context":"In "~Tweets"","block_context":{"text":"~Tweets","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/tweets"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14810,"url":"https:\/\/hill-kleerup.org\/blog\/2009\/05\/16\/tweets-from-three_star_dave-on-2009-05-16.html","url_meta":{"origin":14435,"position":5},"title":"Tweets from @Three_Star_Dave on 2009-05-16","author":"***Dave","date":"Sat 16-May-09 11:30pm","format":false,"excerpt":"Eight roses trimmed of deadwood. Junipers hacked back. Dandelions yanked. Sprinkler heads replaced. Yardworky virtue! # Powered by Twitter Tools.","rel":"","context":"In "~Tweets"","block_context":{"text":"~Tweets","link":"https:\/\/hill-kleerup.org\/blog\/category\/blogging\/tweets"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/14435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/comments?post=14435"}],"version-history":[{"count":0,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/posts\/14435\/revisions"}],"wp:attachment":[{"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/media?parent=14435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/categories?post=14435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hill-kleerup.org\/blog\/wp-json\/wp\/v2\/tags?post=14435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}