tag archives: how to

how to fix contact names in viber after data transfer or restore

[posted: ]  [0 comments]

how to fix contact names in viber after data transfer or restore when you factory reset your android phone or switch to a new smartphone, there is unfortunately no easy way to transfer your existing viber messages, received files etc. if you’ve got your mind set to it, there is an manual to migrate viber. the downside of this manual is that upon fresh setup of your android phone, your android contacts may change device-internal IDs, which are used to connect viber contacts with your phone contacts. as a result, messages and threads may be randomly assigned to other contacts in your address book, even if they don’t have viber accounts.

here’s how to manually fix the problem and correct contact names in viber: [more...]

[category: android] [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...]

how i fixed the problem of a nexus 5 being stuck in “turning on wifi” [solution]

[posted: ]  [44 comments]

how i fixed the problem of a nexus 5 being stuck in "turning on wifi" [solution] after a recent crash both in software and hardware terms, my nexus 5 running android lollipop 5.0.1 could no longer activate wifi. when touching the toggle, it would just show “wifi turning on”, but it never got around to actually scanning for wifi networks or even displaying its mac address.
after quite some online research i tried toggling aeroplane mode, deleting /data/misc/wifi (root), doing a factory reset, upgrading to the newest android version (lollipop 5.1.1), flashing other ROMs and kernels, etc. but nothing seemed to work.
since there was also a physical drop involved, i opened the N5 to check if there was anything noticeable in the internals, e.g. the wifi antenna connector being loose, but nothing was obvious. there were also several reports of google replacing wifi-faulty nexus 5 handsets under warranty due to a “hardware” or “motherboard” issue, but i wasn’t quite ready to give up yet. [more...]

[category: android] [tags: , , ]

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 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...]