All Over the Board… » Entries tagged with "technology"
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
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
Robocopy
Every time I say or see the word Robocopy, I think of the 1980s flick RoboCop. I never saw RoboCop, nor do I ever want to. Some of my friends liked it; when they were watching shoot-em-ups, I was watching old James Dean and Hitchcock movies. But I digress. Robocopy is standard on Vista and Windows 2008, but you can get it by downloading the Windows 2003 Resource Kit Tools. There is also a GUI interface to help you shape the commands. I’ve had two problems when XCOPY didn’t work because of insufficient memory. Another command line primer is here. There are so many options here, so make sure you know what they do before you go wild and shoot yourself in the foot. … Read entire article »
Our son, the OneNote user
OK, so we had this project for Jackson’s science class. Find an animal, research and get info from three different sources, and write the facts along with a picture to make the back of a cereal box. Interesting way to spin a research project, but I could do without the cereal box. The project took us four hours, but there is a story… Once I found out we could do it on the computer, I opened my laptop and turned Jackson loose on the EBSCO Database system through the MPL. We picked the golden eagle (no self-respecting Marquette student/alum lets their son report on badgers). I taught Jackson how to use OneNote to compile information. I gave him his own notebook section on my laptop and he copied and pasted the … Read entire article »
Filed under: Marriage/Family, Reads, Screens, and Sounds, Techie