Skip to Content

IT not interested in Windows 7? Hardly a surprise

You might be expecting an anti-Microsoft rant about how IT folk aren't that keen on upgrading to Windows 7 (hat tip to twitter friend CXI) because of all the trouble they expect. The problem is that you could poll the IT community for almost any OS and you'd probably get the same response.

The problem isn't that new operating systems are so poorly designed - most aren't, even though I suspect Windows probably is - it's that IT isn't paid to improve things. They're paid to avoid unexpected costs and problems, and keep employees from abusing the system and their employer. Unpgrades mean change, change means risk, risk by definition entails the unexpected, and the average professional IT manager is about as risk-averse an animal as you can find. They don't get hurrahs when things are working great, they just get blasted when they aren't. If I worked in this world I'd fight any upgrade because people don't miss what they've never had. That's why IT is called the 'business suppression unit'.

Whether it's Ubuntu, Windows 7, or OSX it doesn't make much difference.

At some point a more enlightened management, combined with a more tech-savvy workforce will demand innovation from IT, and will be willing to sacrifice the handholding and 99.99997% uptime commonly demanded today to get it. Those early pioneers will lose some sleep, but they will be rewarded. Then we will get past the industry of professional IT that IBM and Microsoft built, and see the innovation we see on the web in common business.


More on importing data into Access

So you're trying to import data into access, and you're getting an error. "Subscript out of range" is a popular one, but some flavor of "import failed" with zero explanation is also infamous.

Here's the laundry list (in no particular order) of things I do to resolve the problem:

  • Export the data out of Excel into a csv file first, and then import into Access.
  • Check the data in Excel for the folloiwng. Sorting can reveal these issues, and search and replace can usually take care of them.:
    • Empty cells
    • A rare number in a text column or rare text in a number column. Some government agencies are fond of putting "N/A" in place of an empty cell or zero.The also are fond of putting years in as text rather than as a number.
    • Empty rows.
  • Let Access create the table on import, rather than trying to import into an existing table - resolves conversion issues.
  • Delete the rows below and the columns to the right of, the data. How many? Usually 10-20, but really the intent is just to get rid of any cells containing whitespace.
  • Use the Trim function in Excel to get rid of space before or after numbers, to prevent their being imported as text.

How do you solve these problems? Have a tough import problem? Let's have a look!


My experience - open vs closed networking

One of the recurring themes on almost any networking discussion group is whether open or closed networking is really more effective. There are lots of debates already stored out there, so I won't go through them here. Instead, I'll explain why I'm reversing on a decision I made last fall.

Last fall I decided to dump most of my 4050 contacts on Linkedin, and focus on those people with whom I had a genuine connection. I did it because some of the features of Linkedin, namely the network updates area, were becoming somewhat useless as they were inundated by updates from folks who I ddin't know very well. In addition, I no longer had the pressing need for a large network from a research perspective, and it seemed like a good time to experiment.

Well, the experiment is over. I'd spent lots of time on open networking, and now I've tried closed.

Open wins.

For several reasons:

  1. Linkedin is not just about documenting your network. It's also a personal advertising system. More connections = more exposure.
  2. Network updates only from my closest connections = boring. What can I say? These people are mature, responsible folks who have solid careers and are busy. They're not changing jobs every 15 minutes, or hurling sheep at each other - this isn't Facebook.
  3. I need people I don't know more often or at least as often as the people I do know. With a closed network it's much harder to find them.
  4. I found Linkedin less useful. No matter what I went looking for, I was less likely to find it. I was exposed to fewer questions, so I didn't answer as many. I felt more cutoff from the world.

I know that the open vs closed debate will probably rage forever, and this blogpost won't shift the balance, but for those who are teetering my vote is teeter more toward open.


Syndicate content