Combining Cells or Columns of data in Excel
While working on a KnowledgeLake project on MOSS 2007, I had to create a site column for state. They wanted it to be a drop-down box with state abbreviation and name. I had two choices: Manually type in all fifty states with abbreviations. Find a list on the internet. Of course, I chose the second. I could not find a list that met my requirements: State Abbreviation-State Name. An example would be: AK-Alaska. Enter the & function in Excel, which combines the contents of several Excel cells into one. I found a list on the internet of two columns, abbreviations, and states. I then used the & function as described here to combine them. Then I pasted the result into my SharePoint site column box, and voila! … Read entire article »
Filed under: Techie
The Mickey-slipping Broadcom Exec
Apparently IT guys aren’t boring. This post describes the colorful behavior of a Broadcom Exec. Which begs the question: is that why their NICs require much wrangling to work properly? … Read entire article »
Filed under: Humor, News/Insight, Techie
Baseball Coaches’ Game Outline
I know the five people who read my blog have been waiting a while for this, so I will end the suspense. Here is a link to my game outline. A brief overview… There are three tabs (worksheets is the proper term). Field Outline is used for defense. Batting Order is used for assignment of Michigan and Florida delegates for the upcoming political convention in Denver (kidding). The third sheet is a roster. Field Outline has color-coded the innings and different fonts for different spots. The table on the left is who plays where when. It has dropdown menus for each position, and feeds from the Roster sheet. The table on the right totals the innings by battery, infield, and outfield. It uses the COUNTIF function and Excel Named Ranges defined in … Read entire article »
Filed under: Marriage/Family, Sports, Techie
Configuring Citrix to open a specific Access database
We deployed Citrix Presentation Server 4.5 in a five-server farm at one of our clients. They use it for Office 2003 and ERP program application serving. I’ve worked with Citrix in the past, and my impression is it’s a great product that takes a while to learn. It takes longer to get really good at it. The Citrix community seems like a secret club where they are nice to their big resellers and the others are just an afterthought. We are not a Citrix Partner, nor do we play one on TV, nor are we auditioning for any roles. My last interaction with Citrix was a support call to get pass-through authentication to work. I had to call because their support site is lame. I was 90% there, but was missing … Read entire article »
Filed under: Techie
The Wonders of CSS
I am interested in CSS so I can improve my blog appearance. My niece’s boyfriend told me about this site which explains just how far CSS goes in changing a page’s look. Way cool! If anybody knows how to do CSS, I would be interested in retaining you. … Read entire article »
Filed under: Techie
XP Remote Shutdown
I have a client that uses RDP to hit two workstations. Google “XP remote shutdown” and you get many links to crappy third-party utilities. This article highlights a built-in MS function. … Read entire article »
Filed under: Techie
KnowledgeLake Error: Product Activator is Missing
So I go to enter the product keys on my KnowledgeLake Imaging installation on MOSS 2007 enterprise, and I get this error: The KnowledgeLake KB had nothing on it, so I enlisted the great help from KL support. He had me check the following directory for ProductActivator.exe. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS Missing, but found in: C:\Program Files(x86)\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS It’s so simple and I have to admit a mea culpa here. I installed the 32-bit version and not the 64-bit version. Here’s the fix: since Imaging is the only product installed on this box, I could simply remove it via add/remove programs. You may have to copy C:\Program Files(x86)\KnowledgeLake to C:\Program Files KnowledgeLake so the uninstall completes. I didn’t have to, because I installed KL in E:\Program Files\KnowledgeLake. I will … Read entire article »
Filed under: Techie