category archives: computers & technology

picasa buttons: automatically sort video and raw files into subdirectories, delete orphaned raw files

[posted: ]  [0 comments]

here are two customized picasa buttons to automate things that i’ve done manually for far too long. i’m publishing these mostly so i’ll find them in the future myself, but they may also help others looking for a way to do something similar.

after: three new subdirectories are created and filled according to the criteria mentioned above. (picasa buttons: automatically sort video and raw files into subdirectories, delete orphaned raw files) after: three new subdirectories are created and filled according to the criteria mentioned above. (picasa buttons: automatically sort video and raw files into subdirectories, delete orphaned raw files)

sortfiletypes moves all raw files (.arw) and video files (.avi, .mp4, .thm) of the current directory into their own subdirectories, respectively, and deletes .lrv low-res video preview files.

syncraw compares the .jpg and .arw files in the current directory and moves raw files where the corresponding jpg file has been removed to a new subdirectory “deleteraw”, so you can easily delete or move them. [more...]

[category: computers & technology] [tags: , ]

[updated & simplified] how to convert an .avi file for use in gopro studio, using only freeware

[posted: ]  [14 comments]

[updated & simplified] how to convert an .avi file for use in gopro studio, using only freeware more than a year ago, i published the article how to convert an .avi file for use in gopro studio, using only freeware, which has apparently seen quite some interest. recently, the article has accumulated more and more comments about problems following the tutorial. after a fresh install of Windows and GoPro Studio, the Cineform HD codec is indeed no longer available in MPEG Streamclip.

here’s an easier method of converting non-GoPro videos for compatibility with GoPro Studio, which has worked for me. [more...]

how to build a digital photo frame with wifi and dropbox using an android tablet for 40 dollars

[posted: ]  [0 comments]

how to build a digital photo frame with wifi and dropbox using an android tablet for 40 dollars before leaving the country for an extended period of time, i was looking for a way to stay in touch with my parents that would be uncomplicated and effortless for them: they shouldn’t have to start their laptops/phones, open an app and write to see what’s been going on in my life lately. i would rather just “be around”, the way you can passively stay in touch with some friends on facebook without losing actual contact, but my parents aren’t on facebook.
the best way i could think of to achieve this sense of “being around” would be a digital photo frame that can be updated wirelessly. however, it turns out that wifi-enabed digital photo frames are quite expensive (for what they do), rather hard to get (in europe), and usually subscription-based. they also don’t work very well according to customer reviews, or their online service ends up being discontinued not long after product launch, or both.

thanks to the popularity and ubiquity of tablets, though, there is an easy way to create your own digital photo frame that can be updated wirelessly by simply copying images to a dropbox folder, and it can cost you as little as 50 dollars – or even less if you have an old android phone or tablet lying around! [more...]

working example form and graph: how to collect user input and present it in a graph on static websites, using google forms

[posted: ]  [0 comments]

how to collect user input and present it in a graph on static websites, using google forms here is a working example of a google form and chart embedded statically into a web page.
you may also be interested in a truly static version and/or the underlying data in this spreadsheet on google docs.
[more...]

[category: computers & technology] [tags: , , ]

how to collect user input and present it in a graph on static websites, using google forms

[posted: ]  [0 comments]

how to collect user input and present it in a graph on static websites, using google forms the problem: for a small web project that is going to run on a server with very restricted functionality (due to safety concerns), we wanted to include a web form where visitors can submit values. these values should then be presented in a graph, showing all submitted values and highlighting the latest addition.

the solution: after some digging, i found a way to do all of that using google forms/spreadsheets, which offers user input, a simple spreadsheet-based database, as well as dynamic image creation.
check out the working example page and the underlying spreadsheet, and continue reading for a step-by-step tutorial on how to create a web form that plugs into an automatically refreshing graph/chart using very basic means, and how to implement it all using just two static web pages, a google form, and a google spreadsheet. [more...]

[category: computers & technology] [tags: , , ]

how to convert Sony RX100 videos for correct aspect ratio in 1 Second Everyday

[posted: ]  [0 comments]

How to convert RX100 MP4 videos for correct aspect ratio in 1 Second Everyday MP4 videos recorded with the Sony RX100 appear distorted when processing them with the 1SecondEveryday app. this aspect ratio problem can be solved by converting the video and correcting the video dimensions with the Handbrake open source video transcoder.
here’s how:

[more...]

How to unprotect Word files without knowing the password

[posted: ]  [62 comments]

How to remove unknown passwords from protected Microsoft Word files I’m regularly annoyed at password-protected Microsoft Word files that only permit editing of certain aspects of the document such as form fields. By itself, Word’s “Restricted Editing” isn’t necessarily a bad thing. It’s the fact that file creators are usually very conservative and prefer to disallow editing something “just in case”, rather than giving users the option to add text somewhere unexpected.
The result is often that in order to complete a form, one must print it out and amend it with a pen, or convert to PDF and use the “comment” function.

Looking for a way around, I recently found out how to remove the Document Protection from Word files without knowing the actual password*:

* Note that this method only works with Word Docs that are protected from editing, not files that require a password to open. [more...]