Seesmic Desktop 2 Plugin Video Preview plugin updated to 1.1.2.1 to address erroneous incompatibility issue

Apparently an issue arose around SD2′s newest version reporting an incompatibility issue with the Video Preview plugin. This update addresses this by correctly specifying the full SDP version in the assembly… so no changes to the user here, simple backend maintenance stuff to alleviate this single issue. To download, head over to my project page here or the just grab it off of the Seesmic Desktop Marketplace (auto-updates to the latest).

Seesmic Desktop 2 Plugin Video Preview plugin updated to 1.1.2.0 adding unshort.me support

I updated the Video Preview plugin to 1.1.2.0. This adds support for URL shortening services that are supported by unshort.me. To download, head over to my project page here or the just grab it off of the Seesmic Desktop Marketplace (old version is the initial download but it auto-updates to the latest).

Seesmic Desktop 2 Plugin Video Preview updated to 1.1.1.0 with added migre.me support

The Seesmic guys are a pretty friggin awesome. My original version that was posted to the Seesmic Marketplace had a small typo in the AppManifest that prevented automatic updates. I fixed it and those guys immediately assisted and put the new version up on their site… on a Saturday!

Anywho, enough gushing over how awesome the guys behind Seesmic are… I’ve updated the plugin yet again this time adding migre.me short URL support. Thanks to bit.ly and migre.me for providing easy APIs to expand short URLS… and to is.gd, you need to get with the program and provide this service too!. I also hopefully enhanced performance a little by multi-threading the actual creation of the thumbnails themselves so there may be a half-second delay in their creation but you’ll thank me when you see 10 posts in a row with video links and the app doesn’t slow to a crawl trying to create the thumbnails.

You can get the newest version here.

As for the previously mentioned issue around auto-updating, I’m doing everything right and SD2 is properly checking the right URL but it’s still not working… I hope it’s just a caching thing on my local machine so hopefully just an issue with me and not everyone else. I’ll update on this situation if I see any change…

EDIT: It’s working now! Forgot to put the build number for the Platform version.

Seesmic Desktop 2 Plugin Video Preview updated to 1.1.0.0 (bit.ly support!)

I submitted my plugin to the Seesmic Desktop 2 Marketplace and it was approved but more on that in a bit. So after some excellent suggestions by Seesmic’s Director of Community & Partnerships, I addressed a small issue where, if the video is playing and the popup dialog is closed, the sound will continue playing for a certain amount of time. Even better though, per his suggestion, I added support for the video preview to show up for short URLs which makes it even more awesome than before. You can read more about the new additions here.

Updated Seesmic Deskop Plugin (Video Preview) to 1.0.0.3

I’ve updated the Seesmic Desktop Plugin project Video Preview to 1.0.0.3. This one is using the latest 1.0.0 SDK (SDP) and has the ability to auto-update. Also, on a side note, I’ve submitted it for the Seesmic plugin marketplace so let’s hope it gets on there. In the meantime, you can download the new one here.

Simplified take on an Access Database query SQL ‘ROW_NUMBER’/ranking equivalent

Earlier this week I needed the ability to write a query in an Access Database similar to the functionality provided by MSSQL’s ROW_NUMBER (OVER …) keyword. It took some thought and a little googling and wasn’t apparenty even though there were a few examples out there but they were kinda muddied up and not obvious (too much extra crap) so I thought I’d provide a simpler version here. So in my case, I just needed to read from a table with unknown rows a list of names… but I needed a unique identifier for each name (row) which I could use with an incrementing integer. While I did have an ID column available, it couldn’t be depended on to be sequential due to deletes that may have occurred.

The resulting Access query is this:

SELECT [Name],
(SELECT Count([ID]) AS C
FROM [tblNames] AS A
WHERE A.[ID] > [tblNames].[ID]) AS [Row]
FROM [tblIssues]

From this, I can add a WHERE clause like ‘WHERE [Row] = 0′, ‘WHERE [Row] = 1′, etc. to specifically get each individual name from the table. Nice and easy (and more readable logic than most of the examples I found out there).