MerciJacquieMichel.vbe

So I stumbled across this suspicious looking VBScript file not too long ago, and only 3 engines had picked up on it from VirusTotal.com with little info around the web so I thought I’d add some meat the bone. A user complained that their laptop was slow and that he was getting antivirus notifications everytime he plugged in his USB stick – he mentioned this is the 2nd USB stick he has gone through as …

Read more

Raspberry Pi: Using rdiff-backup with my automated Python script

So you’ve followed my Raspberry Pi: Publicly accessible file server and you want to be a bit smarter on how you back up your data. People tell you to back up your data all the time, and you’re probably like me and grunt at the thought of the manual burden of physically copying and pasting your data. Do you want your backup to be automated? Do you want to be able to retrieve older revisions of your files? …

Read more

Raspberry Pi: Using rsync with my automated Python script

So you’ve followed my Raspberry Pi: Publicly accessible file server and you want to be a bit smarter on how you back up your data. People tell you to back up your data all the time, and you’re probably like me and grunt at the thought of the manual burden of physically copying and pasting your data. Do you want your backup to be automated? Do you want to choose the files and folders that you want to …

Read more

Raspberry Pi: Map a Network Drive

You’ve configured your external hard drive to be accessed within your LAN to start sharing your files, but wouldn’t it be easier to have that drive automatically mounted on other clients within the network at startup, and easily addressed via drive letters? What I mean is instead of typing your RPi’s IP address and Samba share name within Windows Explorer’s address bar, you can just access it like any other attached device in the left …

Read more

Raspberry Pi: Install and configure No-IP on Raspberry Pi

No-IP enables you to address your Raspberry Pi publicly by hostname rather than IP address. For example, when accessing your machine via SSH from outside your LAN, it’s difficult to remember your public IP. So intead No-IP allows you to create your own easy to remember domain, and assign it to your IP address. This is heavily documented elsewhere on the web. You can check out the official guide here by No-IP themselves, but this includes a neater startup …

Read more

Delete all products in Magento CE

For a while I wondered how to delete all products in Magento without using PHP scripts and SQL queries, and for a while I couldn’t find a definitive answer anywhere online. Today I just realised that there’s nothing on the Internet purely because the answer really is straight forward and I’m embarrassed I didn’t explore around a little before asking Google. This works for people using the Community Edition v1.9.1.0 Login to your backend, go to …

Read more

Codecademy: JavaScript “Search Text for Your Name” 7/7 – Victory!

My Sunday nights are even more crazier. “Log it!” 6/7 code: var text = “Adam said: Who the hell is this, paging me at 5:45 in the morning \ crack of dawning. Wipe the cold out of my eye, see who’s this paging \ me, and why. My name is Biggie Adam Smalls.”; var myName = “Adam”; var hits = []; for (var i = 0; i < text.length; i++) { if (myName[0] === text[i]) …

Read more

Codecademy: JavaScript Build “Rock, Paper, Scissors” 9/9 – Next Steps

My Saturday nights are wild. Below is my solution to Codecademy’s JavaScript 9/9. The three goals of the tasks were to: What if a user makes an inappropriate choice like ‘dog’? How can we extend the function to handle that? What if players in the game could also choose Rope in this game? In this version, if both players make the same choice, the game returns a tie. What if the game didn’t end there …

Read more

Raspberry Pi: Installing Raspbian

Required equipment In terms of equipment, you will need the following: 1x SD Card I’m using SanDisk Extreme 16GB Class 10 More information about compatible cards and other information can be found here. 1x Raspberry Pi I’m using the Rev 2.0 Model B w/ 512MB RAM 1x HDMI cable 1x Ethernet cable plugged into your LAN However I’m using the TP-LINK TL-WN725N USB Wireless Adapter which works quite well. 1x compatible keyboard 1x Powered external hard drive I’m …

Read more

Extract data from other Excel worksheets using VLOOKUP

Screenshot 2014-09-29 22.09.54

My landlords approached me and asked if I knew anything about Excel. My initial thoughts were “I know how to add and subtract with =SUM() and that’s about it”. But I thought, how hard can it be? They tasked me to sort their product list into one file so all their products had the appropriate product codes, UPC codes, descriptions, cost & sell price and physical attributes (length/width/height/weight). The idea was to then import the …

Read more