Category Archives: Uncategorized

Uncategorized

Shortcut to programs control panel Windows 8

Well we have to hand it to the monkeys in Washington, they stepped in the proverbial open can of paint with Windows 8.  So to help myself and others I’m putting together tidbits to try to ease the pain.

Start Button + r = run screen

appwiz.cpl takes you right to the Programs and Features window

Uncategorized

The name game with Excel spreadsheets

Basic take-away is:

=LEFT(A1,FIND(” “,A1,1)-1)

=RIGHT(A1,LEN(A1)-FIND(” “,A1,1)

Here is a really good article on it.

Uncategorized

Creating symbols using alt codes

I know this is out of no where but every occasionally you want to me able to use various symbols that aren’t readily available on the key board, let’s face it when was the last time you were able to find the ¢ symbol on a keyboard.  Okay I agree I can remember the last time I needed it either but in any case here is a list of some common ones that you can use with most HTML editors that I found here:

 

 

how-to-make-symbols

 

Uncategorized

File Renamer

So I was working with some pictures and was manually having to rename the files for the event, I decided that was tedious and decided I was going to write a program to do it, but to save myself some work and I came across this program called File Renamer – Basic by Sherrod Computers.  I really handy little app if you need to rename bunches of files.

Uncategorized

New project attempt, Taleo TCC resume export

We have an ATS that runs on Oracle and we have a tool to get data out of it but the trick of it is that it’s in base64 compressed string…  Yeah if you missed any of that this post isn’t for you.

So what I get is a string, quite large, that I need to run through a base64 decoder and then (just to add a little challenge) it becomes a zip that you have to extract the original file out of, but not in the pretty Microsoft way, you have to use something like 7zip to get the job done… Not sure if this is a consideration but the 7zip CLI is 7za.exe and it only comes in a 32 bit flavor…

If you’ve gotten this far in the post you’ll know I’m talking about Taleo and using TCC to trigger this process.  This post is a working documentation on getting this done…

Uncategorized

Default page for GoDaddy hosting

I keep running into this question so here is the list provided by GoDaddy for both Windows and Linux hosting environments.

Uncategorized

Raspberry Pi

I was reading about this project and it’s a really small inexpensive computer called Raspberry PI and I thought to myself for $40 buck shipped how bad can it be, just got it today.  I’m not sure what I’m going to do with it but for it looks pretty cool.RaspberryPi

Uncategorized

Using Powershell to Keep Directories Clean

As an integration engineer I have log files that provide me an audit trail so I can track things down when they go astray.  Now this is fine and well but what happens when you’ve had an integration in place since 2007 and never needed to look at those files?  Yes you’ve got 5 years worth of files that are taking up space on the drive.  To alleviate the issue you can use Powershell to clear the directories of any files over a certain age.  Here is the code on how to do it:

# Delete all Files in the TCC Archives over 60 days old
$Path = "C:\Taleo\TCC\Prod\Export\AirlandRequisition\Archive"
$Daysback = "-60"
$CurrentDate = Get-Date
$DatetoDelete = $CurrentDate.AddDays($Daysback)
Get-ChildItem $Path -Recurse | Where-Object { $_.LastWriteTime -lt $DatetoDelete } | Remove-Item

clear-variable -name Path
clear-variable -name Daysback
clear-variable -name CurrentDate
clear-variable -name DatetoDelete

$Path = "C:\Taleo\TCC\Prod\Export\AppTrackCSW\Archive"
$Daysback = "-60"
$CurrentDate = Get-Date
$DatetoDelete = $CurrentDate.AddDays($Daysback)
Get-ChildItem $Path -Recurse | Where-Object { $_.LastWriteTime -lt $DatetoDelete } | Remove-Item

clear-variable -name Path
clear-variable -name Daysback
clear-variable -name CurrentDate
clear-variable -name DatetoDelete
Uncategorized

Google Safe Browsing

I run quite a few web sites and every occasionally I run across an issue where I want to check to see if there is anything that Google has found about possible issues.  You can utilize their safe browsing site to check your sight:

http://www.google.com/safebrowsing/diagnostic?site=www.example.org

Uncategorized

New blue tooth keyboard

image

I just got a new blue tooth wireless keyboard for use with my tablet.  I like it, it allows me to enter information to it a hell of a lot faster than the on screen keyboard.  So far I like it but as you can see it’s a little small but I think that I can adjust to it…