Categories
Ramblings

13 Things To Make Your Corporate Website Suck Less

Ok, lately I have been looking online at places all over Madison, either to eat out, or do something, or whatever, and I have noticed some trends and some “no-brainers” about corporate/commercial/business websites.

There are reasons people are using the web to find you. The first easy reason is, to get your phone number. Think old ways, where you would look in the phonebook for a place, and find the phone number, and call them. So..

#1 – always have your phone number on your website.

#1.1 – get technical, and have links to open skype with a link

Now, thinking back to our old phonebooks. Most places didn’t get a huge ad in the Yellow Pages, just their number, no other info, but that is different when you have a site. What else does the phone book let you have in there by default?

#2 – always have your address on your website.

And, lets get a little fancy here, a little technical. Not only can you just have the “text” of your address, you can make it easy for people to find you.

#2.1 – put a static map on your site

#2.2 – put a link to popular online map services with your address already in the link as the “to” destination

#2.3 – format your address so that people can just “copy” it and paste in online map services. Note, most map input boxes are NOT multiline. Ex:

this is good: 123 East Johnson St Madison WI, 53718

this is bad:

123 East Johnson St.
Madison WI, 53718

Ok, so we have the two major information items from the old phonebook taken care of. For a minute, lets look at some usability issues.

#3 – your main site page, if you decide you want to just have a crazy flash intro that 99% of people skip, should check if flash is enabled, and have a lo-fi version of your site. This is a big one for mobile browsers. The iPhone is 30% of searches or something, but no flash. I hit your site and can’t do anything, so I move on.

#4 – don’t play music in the background (check out the majority of “spa’s, salons, etc”, and martini lounges sites) – and if you really think you need to, have a big OFF button. NO, this music is not going to make me think I am at your spa, or martini lounge. I just want the information I need.

Now, what else do we need to make a good decision your business?

#5 – POST THE HOURS YOU ARE OPEN!! – nothing is worse than trying to find information on a place, and they don’t post the hours. What time are you open? When do you close? And note – “We close at bar time” or, “Our hours are 5 PM to Close” doesn’t really help. So we have to go figure out when bar time is? Till close? So you expect people to drive to your business, only to find it closed?

#6 – Allow me to email you an order, order a gift certificate online, basically avoid any human phone contact and allow me to do my business. – Local pizza place? Let me email you my order and have it ready when I get there. Online spa/salon, let me buy my girlfriend a gift certificate without having to call you, or even worse, drive there and figure it out. I don’t have time for that, I know what I want, I just don’t have an easy way to get it, give me the ability!

#7 – Post some pictures of you place, inside and out

#8 – Link to review sites (like Yelp, etc) so I can see reviews on your business – good or bad. Hey, even get technical and have a blog to explain or make up for negative reviews.

#9 – Don’t have “Under Construction” or “We want to have this site updated by Feb 2007” on your site, anywhere, when its a year later and it is still not updated Shows us you don’t really care. If it is under construction, just remove it.

#10 – We would rather have a 1 page site, very toned down, basic, with all the info we need than a 15 page flash monster with sound playing, QuickTime movies, and no real info, rather just having each page with 2 sentences of info that doesn’t really give us information to decide if we should give you our money.

#11 – If you are a restaurant, have a PDF link to your menu

#12 – search yourself on Google. Let’s say I ran “Steve’s Pizza” in Madison, WI (another note, you should get a non-generic name for your business – How many Steve’s have pizza places all over the world?) Search for

a) “My Business Name Hours”  – “Steve’s Pizza Hours”

b) “My Business Name Address” – “Steve’s Pizza Address”

c) “My Business Name Phone” – “Steve’s Pizza Phone”

d) “My town/ zip code and your business name” – “Madison WI Steve’s Pizza”

e) “My town/ zip code and my industry” “53718 Pizza”

If you don’t show up first or in the first 10 results in Google, you are doing something wrong. If you don’t show at all you have real problems. Go buy some Google Adwords so that you actually start showing up. People are really searching for this info, and can’t find it, and give up.

#13 – if you don’t have a site at all or too cheap to make a basic site (hey, you can do this for like 100 dollars a year, and you don’t need to be a geek, or hire someone, see #10) – then you better go check out all the review sites – Yahoo Travel, Yellow Pages, Yelp, etc, etc and make sure that your address, phone, and hours are all updated there, but you shouldn’t depend on these sites to have your basic info.

So there we have it, a list of BASIC, EASY things you can do to make your corporate website suck less. Remember, people under 30 don’t care to use phonebooks anymore. Most don’t have home phones, or phonebooks. They have cell phones, and use the web as their phonebook. When you move your business online, remember to make the essential information available, we WANT to give you our business, we just want to be the most informed consumer first before we open our wallets!

Categories
Geeky/Programming Product Reviews

MobileMe's Mail – Glaring Omission

So we have MobileMe setup. I still use GAFYD for my main email, but I had Emily use MobileMe with my old iPhone. Today a glaring omission was pointed out. No rich text, formatting, coloring, smileys, font changing, italics, bold, underline, etc to be found.

mobile_me_compose

There are options to send, draft, spelling, and add contact. Also in the Mail preferences, there is a “Composing” tab, but no settings for formatting at all. For some people, this is the show stopper feature they want. You would expect any first rate email client to have these things. Of course, some people don’t want these settings, but if they are there, then you can turn them off, but if they aren’t there, you can do anything, and you go back to Hotmail so you can send smileys and 24 pt wingding font in red 🙂

Categories
Blogging Geeky/Programming

WordPress Export

WordPress Export. There is a menu item in WP that lest you export out to an XML file, they call it “eXtended RSS or WXR”. The options is under Manage->Export.

Well you should use this to keep a half way decent back up of your blog, but if you want to transfer to another blog service or anything then you want this file. I have been toying around with moving my blog, to TypePad, or MT, or WordPress hosted, just to see what happens, and really, none of them are better than self hosted WordPress.

What I did find, is that the export wasn’t working for me. Was getting cut off at like 1.4, 1.5 MB and tons of my posts were missing from the export. I read in the forums and such on WordPress support but nothing really gave a good answer. So I did what you usually have to do when WordPress chokes on some export or import, play with the memory and execution settings in php.ini

What I found was the max execution time was 30 seconds for a script, which was about how long it was taking to export my file. So I upped it to 120 seconds

max_execution_time = 120;

And ran the export again, and lo and behold, my entire blog archive was now in the import file. Yessssss.

Categories
Geeky/Programming

Microsoft Word Is NOT A Place To Share Images/Screenshots!

Now, every once in a while, being a computer user, you will have to or be asked to take a screenshot. Either a full screenshot of your computer desktop or maybe just the app you are using. Then you will want to share it, by emailing it.

It seems the norm for some people is to take a nice screenshot, open up Microsoft Word, and paste it in there, then email it off. On the receiving end, you open up word and you can barely see the image, and have to zoom in close like 200% to see anything, and it isn’t formatted well, etc. Take a look at the two screenshots below. One getting it word, one without. BIG difference. And even bigger if your Word opens in "reading mode" when opening from email.

with_word without_word

So, information workers of the world, how do you magically create good screenshots and not use word as the medium to transfer them? Well the easiest (and built in) way is to use Microsoft Paint.

Well, do your prtscrn or alt+prtscrn and get your image on your clipboard, then do a start->run->mspaint and fire up good old Microsoft Paint. Do a quick ctrl+v, and then save it as a jpeg (not a bmp – too big!) close it and email the image! Yipee!!

There are many other options as well. Using the built in snipping tool in vista, or getting a 3rd party screen grab tool, go for it, just please don’t email me a word doc with an image embedded in it!!

Reasons? 1) I might not have word, 2) it is embedded as a crazy OLE object and tough to pull out if I want to edit, 3) it is tough to read

Just email images please, the jpeg kind, it is more than enough to get a good screenshot across the wire.

Categories
Blogging Geeky/Programming

Obligatory Post From iPhone

Post from wordpress app on iPhone. It’s open source I think. I should raise pocketblogger from the dead and merge it with this or something. This could be cool for reporting news real time, but for now here is good old Winston

photo

Categories
Geeky/Programming

The Apple Fandom.. Continues

Woah, well it has been a while since I talked about my “Media Center” experience I am trying go for, but I will get into that later.

First, yes, I have the iPhone 3G. I was off Friday for other stuff and decided to “camp out” since I had the time, hoping I would get out early. I went to AT&T on the East Side at 4:30 AM with a chair and my laptop and waited until 8:00. I was 6th in line. It was a good time, Einstein Bagels opened at 5:30 so we had coffee and bagels, and just had fun talking with fellow iPhone geeks. I already had the 2.0 Firmware beta loaded because I am in the dev program, and I was running iTunes 7.7 Confidential Beta as well.

Anyways, getting the iPhone, they let the first 9 in, and out of the 9, 2 people got activated and went home. Mine wasn’t working so they just let me go, and since they upgraded my SIM, I left with 2 bricked iPhones. Ugh. Once home I connected it and let it sit and it finally went through. Cool! I like the GPS and the 3G, Exchange Sync, MobileMe sync, the apps, it is all good. Battery life could be better, and there are always ways to improve, but my biggest gripe with the iPhone (no SDK, etc) is now gone. I find myself using my computer less and less, since I can do most “personal computing” stuff on the iPhone (read feeds, facebook, etc)

In between getting my Mac Book Pro, and the new iPhone, I picked up two other things on my Apple wishlist. First, the Time Capsule. 1 TB and AirPort Express N – this thing is sweet. The best part is my MBP is backed up every hour on the hour to the Time Capsule. I feel way more “secure”

The other item is AppleTV. I used to be a HUGE fan of Netflix and would watch 10-12 movies a month. But once you get through all the ones you want to watch, it gets stale. Also, not being able to get all of them in Blu-Ray, it is kind of a downer. I still have Netflix, but I reduced my plan down to like 1 at a time, I might re-look at Netflix now that Xbox has native streaming, and also the plugins for using MCE as an extender, but for now I am good there. The PS3 announcing downloadable movies TONIGHT!!! and with the Xbox 360 streaming, and Netflix discs and streaming, PLUS the AppleTV, I am pretty much set.

What does AppleTV bring? Well first, the HD movies , downloaded direct, and other movies, which is nice. TV shows, Music, Photos and YouTube. I have found myself watching YouTube on the couch now for like an hour straight, crazy. I really like being able to get Flickr pix or MobileMe pix as a slideshow, and also syncing with my MBP iTunes, and even better, the iPhone 2.0 firmware has the iTunes Remote which rocks, and controls iTunes on your laptop or Apple TV.

My guess is I will be cutting back my Charter lineup (I wish I could just get the HD channels, that is all I watch anyways!)

So, finally , some iPhone apps that rock.

Midomi – I use this to tag songs and buy on iTunes

GuitarToolkit – must have for any guitarist

iTunes Remote – I already talked about this, it rocks

Tuner, VisuaRadio, AOL Radio, Pandora, Last.FM – all your music needs, taken care of (check out Tuner… they have a Beatles Radio station – lovely!!!)

Loopt, Whrrl, iFob – pretty cool LBS based social networking

Others? Pownce (ok), Twitterifc (I am not impressed)

Facebook, Myspace – meh iphone.facebook.com is better than the Facebook app!

MonkeyBall – hard, but fun

I am sure there will be more, but right now I am surrounded by Apple, never would have thought (although I am writing this post on Vista on my Dell Laptop, which I fixed the Hard Drive on :))

Categories
Geeky/Programming Ramblings

A Good Memory Is A Great Thing To Have

Well, I haven’t posted in a while. Still busy as ever. Was up north for the 4th and my 10 Year reunion. Pics are on Flickr.

Anyways, this post is about a “Good Memory”, or even better, the ability to memorize things. Memorization.

So what does memorization have to do with anything? Well, as far as computer stuff goes, programming, development, database stuff, networking, sysadmin, all aspects, even just regular old users using their computers. Memory (not RAM), but remembering how to do things is going to make you better. Not just better, but substantially better.

Remembering things will probably make you a very good developer. How? You won’t have to keep looking things up. It should start out with you remembering the syntax of the language you are using. Then comes remembering how to setup and tweak your tools (IDE), then comes remembering different concepts (loops, OOP patterns, etc). Next comes remember old code you wrote to solve some problem, and going back to it and using it again. This is just the tip of the iceberg.

As any good developer should, you should be able to remember how to use the OS and tools you are using. If you can’t even do that, you probably shouldn’t be developing software. A simple example, like setting up a printer in Windows XP, or pinging Google, or using CTRL+C and CTRL+V – these simple concepts are going to make you a better computer user, not just a developer. There is no excuse for not knowing these simple things!

Now, if you can remember tons of little things like that, and then start adding in Framework libs, and IDE tricks and how the network works, or every other nugget of info you should be remembering. You might not remember every blog or site bookmark full content, but you should remember that you bookmarked it and why. Just little things.

Another area where memorization is key is with music. Playing music. Singing music. Take playing guitar or piano for instance. You can read off the music time and time again, but you are using part of your brain on that, not focusing on actually playing. Once you memorize the music, you can play it better, and focus on actually playing, not where you are on the music page.

Same thing with looking up things in help or guides for development. If you keep having to look up DATEDIFF in SQL books online, you are just wasting time. Learn how it works, learn the params and what they are, and memorize it.

I think the only time you should be using the help is to search for something that you haven’t memorized. Like, “I wonder if there is a C# function to do XYZ”. Then, you search help, even better Google, or ask someone who you think might know. But you shouldn’t have to Google or ask someone “Hey, do you know I set up a FOR loop?” – That you should know, and have memorized (plus a ton of other things!!)

The more you memorize, the better you will become, because you can focus on the problems to solve, not learning the tools and concepts you should already know. Oh, and you can play some wicked guitar as well 🙂

Categories
Uncategorized

For No One (Beatles) – On Piano!

Well, a couple of weekends ago, I recorded “For No One” by the Beatles on the piano, and I’m putting it up on the web! Enjoy

For No One (Piano Only)

Categories
Business Intelligence Geeky/Programming Ramblings

Excel 2003 vs Excel 2007

It is the year 2008, we are half way through. Excel 2003 is 5 years old. Stop using it please.

Why? Excel 2003 has the old “limits” – 65,000 rows, 256 columns, memory limits etc. Excel 2007 on the other hand, 1 million row limit, etc etc. That coupled with the way pivot tables work in Excel 2003 compared to 2007, and the SQL Server Analysis Services features with 2007, it is a no brainer to go to 2007.

Companies will say – “But we can’t move all our users to 2007, we can’t afford it” – well, think about just moving your power users. The users that have huge spreadsheet extracts, etc. It is worth it. They can save files in 2003 format if they need to share a smaller file or something, and the 2003 users can install a 2007 viewer.

Other options for huge spreadsheets and extracts are… Access – which your users need training on, or need to be able to adapt to, or another options is SSAS and Cubes, which you need executive buy in, and the infrastructure, and the training to get your users up to speed, and by that time you will want Excel 2007 to connect to the cubes, so…

just start using Excel 2007 – 2009 will be here soon!

Categories
Blogging Life

4 years Blogging

Four years ago, I started this blog. It was on blogspot, and then migrated to wordpress on HostMySite, then moved to my own server, but all the posts are here. I have had many different themes and it actually is fun to look back on posts and see what I was doing at the time.

You can look back and see when I was at Cell 2000, then went to W3i. You can see the jump from ASP Classic, VB.NET to C#, ASP.NET, from SQL 2000 to SQL 2005, from C# to C++, then to Data Warehousing and Business Intelligence, SSAS, SSIS, SSRS, and littererd in between with all the gadgets, vacations, photos, politics, fun, random tidbits over the last four years. Music I have recorded, videos too. Just everything. Nostalgic.

I started reading blogs about 2-3 years before I started actually blogging, so that is kind of my time line there. Right now I subscribe to roughtly 350 feeds (My Google Reader see’s a lot of j, j, j ,j, shit+s, s, j, j, j). Newer mediums come in and go. Twitter is one. I use twitter somewhat, but not as much as others. FriendFeed is a new one too. Pownce is good for sharing files. But none come close the full blown blog. I have gotten many friends and colleagues to start blogging, some keep it up, some don’t some come and go. It would be nice to have a “blogging buddy”, but I haven’t found that yet. Maybe in the next 4 years.

People ask me “why don’t you have multiple blogs? One for tech, one for personal, one for XYZ”. Well my answer to that is, this is my blog. This is me. I am all these things. I am music, I am tech, I am gadgets, I am geeky, I am politics, I am random stuff I like. That is me, this is my blog. It is fun for me to do, and once it stops being fun, then I will stop doing it.

I know recently my blogging has been less often, and I attribute that to my 2+ hour commute (even more now with flood detouring! yikes!), but that will change as I get different consulting gigs. I will be introduced to different technologis, different industries and it will get my mind swirling with things to blog about. – Some things are just small snippets that are almost good for Twitter. Like, did you know Excel 2007 lets you have more than 65,000 rows and 256 columns? I didn’t know till today. Not big enough for a blog, but a tweet…

We will see where the next 4 years leads me. I have been from St. Cloud, to Portland, now to Madison. My 10 year high school reunion is coming up in the next few weeks. Funny how time flies so much. Big, fun things to come. Can’t wait.

Fun stuff, and hopefully I get four more!