How to Import Multiple VCF contacts into iCloud
One of my users recently came to me with an interesting problem this week. She had left her old job but had left all her contacts on her work account. Once the account was deleted, all the addresses were wiped out as well. By sheer luck, her iPad had a copy of the contacts since she never connected it to a new network which prevented any type of sync. We managed to export the contacts off the iPad to VCF cards but were now left with the tedious task of importing them all into iCloud for her to use on her phone. I tried dragging and dropping all the VCF cards into the browser but iCloud displayed 300+ errors saying the card could not be imported, without specifying which ones were a problem. The import would error out after clicking OK at around 300 times and not actually import a single one. I remembered that the format of the cards is simple text and you can easily merge the files into one big file to import.
Mac Outlook 2011 Reply All Includes My E-mail (with solution)
I've started a new job and was assigned a Macbook for my daily work. I've found equivalents for most of my applications. Personally, I find the native Mac apps are just extremely underpowered for my computing needs. I hate Mail especially, and even more so how all the apps are split out into separate apps. Luckily I have Office for Mac. Not so luckily, Outlook Mac 2011 is not as well designed as Outlook for Windows in so many ways. One of the bugs I ran into was the "Reply All" bug where your e-mail is included in the CC field. It's rather annoying having to choose from having to manually delete your address or having an extra e-mail to delete from your inbox. The fix turned out to be rather simple for me. It turns out that Outlook for Mac isn't very smart. It doesn't seem to be able to tell which address you're sending the e-mail from even though it's doing the sending. When my account was initially setup, the company set it up with one of their subsidiary domains which was incorrect. Rather than creating a new inbox, they simply created an alias for the domain but never updated my configuration. To fix the issue, do the following:
How to remove win64/sirefef.AE trojan & c:\windows\system32\services.exe win64 patched b.gen trojan
I'm kind of the default "go to" guy for all PC issues with friends and family. One of the most common problems people bring to me is malware. Going forward, I'm going to document the removal process for some of the more difficult ones I encounter. The most difficult trojan I've encountered thus far is the sirefef.AE trojan. It infects the PC by replacing c:\windows\system32\services.exe which is pretty ingenious in that it's extremely difficult to remove since Windows requires it and it's always in use which keeps the antiviruses and applications from being able to remove it. I just spent a few days battling this one and successfully cleaned it off the system. To remove it:
Uninstalling Trend Micro Client/Server Security without a Password
Lost or forgot your Trend Micro Client/Server Password? How about inheriting a computer that had the software installed by an IT team or consultant that won't give up the password? I had to work on a network with the latter and it's rather annoying. The product is utter crap as the machine is spyware infested even though the antivirus is running and present. I went to uninstall it but can't because the previous person/company password protected it and nobody has it. Here's how to bypass the protection:
Drobo Dashboard Can’t Connect to Drobo when ESET Firewall is Active
Have a Drobo storage unit? If you have ESET Smart Security Firewall enabled, you'll probably find Drobo Dashboard can't connect while the firewall is on even after adding all the required ports and services to ESET's rules from the Drobo online help site (http://goo.gl/iVKVU). After enabling the detailed logging in ESET, I found that ESET's firewall was flagging Drobo Dashboard as an intrusion attempt and blocked it. From the Drobo help page (http://goo.gl/iVKVU):
Round Up to Whole Numbers in Excel (10s, 100s, 1000s, etc)
After years of using Excel, I realized today I have never had to round up to the nearest whole number before - until today that is. I was organizing my finances and realized that I wanted to round some of the amounts up to the nearest 10. So to round to the nearest decimal place in Excel, the formula is: =ROUNDUP([Range],[Position]) Count the number of places after the 0 to round to and set [Position] to that value So if you had 1234.25 in Cell A1 and wanted to round up to the nearest cent, =ROUNDUP(A1, 1) would produce 1234.30.
Kill Multiple Processes at Once Via Command Line with Taskkill
Ever have a program or process that doesn't end properly and runs in the background continuously? I recently encountered this issue with VLC on one Windows 7 machine where it keeps the process never terminates. Since I never reboot the machine for other than Windows Updates, this amounted to 633 copies of VLC running in memory. Each process only used about 633k so it wasn't an astronomical memory hog but multiply that by 633, you begin to feel the machine slowing down. Task Manager doesn't let you kill multiple processes in bulk and I didn't want to go through killing them one by one or rebooting. The solution? Good old command line. Open up command prompt (start -> run -> cmd.exe). This snippet will kill all processes that start with the taskname: