Archive for the ‘business’ Category

how to name files

Friday, February 1st, 2008

This isn’t exactly technology related, but I felt like it was worth getting out.

There are some basic communication tasks that I continually surprised that business professionals struggle with. The most notable problematic areas I have observed are:

  • naming files
  • writing email subject lines
  • choosing a communication medium
  • leaving voicemails

I can’t tell where the issue lies and how to correct it. Perhaps people aren’t taught communication enough in school. Perhaps communication isn’t stressed enough as something you have to learn. Perhaps people are just lazy.

I have a feeling that part of the problem is that not enough people correct someone when they aren’t being clear about something. I used to just ignore bad behavior, but in recent years I have become increasingly more likely to suggest improvements to people. I find that my clients and business associates who are the worst offenders tend to get worse as time goes on unless I speak up.

Now, before I start, I should note that these suggestions are partially just my personal preferences. There is no hard rule to good communication, but here are some ideas that work for me.

How to name Files:

Reserved Words

I cringe every time someone sends me a file with a name like “”. This would be fine except that in business there is never such a thing as “final”. When you get a file like this, you know that the next day you are going to get another file named “”, and thus begins the fun.

My list of words that should never appear in a file name:

  • new
  • temp
  • final
  • draft
  • master
  • complete
  • last
  • test

There are probably others I am forgetting. If you ever put one of these in a file name, write this list down on a sticky note on your computer and slap yourself every time you try to use one. Getting these out of your file naming vocabulary will make the world a better place.

Folder Content Sorting

Often times when people are sending a lot of files, they will attempt to name them things in order to force operating system sorting. File names like “_configuration.xml”, or “!configuration.xml”.

I don’t think I need to explain too much why this is a bad idea other than to say it assumes an importance of some files over others and assumes that the prefixed files are the most important. This thinking all too often leads to a prefix battle where newer versions become “!!configuration.xml” and “!!!configuration.xml”.

Prefixing files does not add in any way to the description of what is contained in the file, which should always be a goal.

If you do need a grouping of files to sort, you should think about these alternatives:

Are the files part of a set? If so a folder for each set plus a numeric prefix may be appropriate. Just remember to pad numeric file names with 0 to make sure they sort appropriately.

An example of this set naming might be:

  • bracelet 01.jpg
  • bracelet 02.jpg
  • bracelet 03.jpg

or even

  • 01 bracelet.jpg
  • 02 earring.jpg
  • 03 necklace.jpg

What about Dates?
Any file that is relevant to only a single date, or a date span can often be named with the appropriate date in the file name. This makes the file clear from the name what it includes, but also helps greatly with sorting.

You will thank yourself later if you come up with a way of writing dates that is consistent and logical.

Naming one file revenue_01_08.xls and another file revenue_2_2008.xls is all well and good, but your operating system isn’t going to group them together when you have a folder that has hundreds of these files.

I like to use the format: subject_#yyyy##mm##dd#.ext, with the day optional.

The above files would then become revenue_200801.xls and revenue_200802.xls.

The biggest issue with getting other people to go along with this format seems to be putting the date in the front. For some reason, Americans can’t grasp the concept that this really is the best way to write dates. Naming files with #mm##dd##yyyy# is okay, except that once you have several years worth of files together in a folder, they are all grouped by month, and not sorted in order.

As a general rule, it is usually good practice to make everything in the file name read from Generic to Specific. Again, this seems tough for many people to grasp but it is not all that wacky a concept. This is after all, we often name things with people’s last name before their first name.

The file name revenue_quarterly.xls is generally a better name than quarterly_revenue.xls because revenue is the more generic term. When you add revenue_yearly.xls, it will fit right in and all your revenue files will be grouped.

The File Name Itself

Choosing a file name is a lot like choosing an email subject. It is easy to just bang on the keyboard to name a file, but you should really be aware that your file is going to live on a computer system with thousands of other files. The name should help you or someone else find the file if they are doing a system search and not have to open up 20 files and read to find the correct one.

  1. Make sure the name says something about the content.
    The goal is to make the name generic, but not too generic. revenue_affiliate_quarterly_2007_4.xls is a lot better a name than revenue_2007_4.xls. People all too often use a simple throw away name rather than actually putting in thought as to what the file includes.
  2. Avoid using information about the reader in the name.
    At least once a week I get someone emailing me a file named something like “for_terrence.doc”. Don’t do this, period.
    This shouldn’t be confused with a document that is about a user. resume_curran_terrence.doc is a perfectly fine filename because the contents of the file are about Terrence Curran.
  3. Don’t be afraid have a long file name
    It has been a long time since we had DOS 8 character restrictions on file names. It is perfectly okay to have filenames that are 10, 20, 50, 100 characters. You should try to make the name short and concise, but there is very little reason to abbreviate or leave out information.

Hopefully this post is useful to someone out there. I will probably add to it in the future as I think of more things, just for my own reference.

Microsoft Tech Support Linguistics

Monday, December 10th, 2007

The copy of Windows Vista Business running on my laptop decided tonight that it was no longer activated and I had to re-activate it. I don’t think I need to go into how frustrating that a copy of software that you legally own decides that you no longer own it. I bet the cracked copies on the internet never have this problem.

Internet activation failed, automated phone activation failed, so I finally had to do the dreaded in-person phone tech support call.

Apparently the only difference between the in person call and the automated call is that the person asks you “How many computers is this software installed on?”. I guess it is easy to lie to a computer, but in person you are supposed to say “2?”, “3?” — and then they got-cha you filthy pirate. anyway.

So I’m all pissed off at this whole process that has now taken 30+ minutes, but I find myself thinking less about the pain in the ass and more about the voice of this woman on the other end of the phone line.

The woman, who knows where she is (it is 2am EST here), speaks near-perfect British English. I would think that I was speaking to someone in the UK, but she seemed to only have the exact vocabulary required to read off scripted answers. She couldn’t comprehend or reply to even the most basic question; like: “why do I have to even be talking to you when I own this software?”. It was almost like talking to a computer voice recognizing phone system, it was really bizzare. I had exchanges like this:

Q: Who can I write to complain about this:
A: I don’t understand

Q: I would like to complain about this process:
A: I have noted your complaint.

Q: Where can I send a complaint letter to
A: Yes

Q: I would like to mail a complaint, what is the address:
A: I will submit your complaint

Q: No, I would like to Mail a formal complaint to your company:
A: I don’t understand
Q: I would like an address to send a letter to
A: 1-800
Q: No An Address
A: ?
Q: Postal, Mailing, Physical Address
A: please hold
— 10 minute wait

Q: No, not email, I Need an address
(I googled the address a long time ago at this point, but I might as well see through)
A: please hold
— 5 minute wait
Microsoft Corporation
1 Microsoft Way
Redmond WA 98052-6399

Q: wow thanks
A: have a nice day

But here’s the best part: she didn’t know how to pronounce Redmond, so she just spelled it out for me:

Roman echo delta monkey oscar nile delta

She said these words faster and more perfect than I could reading them right now. She had obviously been trained to speak these specific words to spell things out.

I googled all over the place, figuring I could learn where this woman learned english based on the phonetic words she used.

This is a pretty good listing of different Phonetic alphabets used around the world. Each word in her list appears in one of the alphabets, but none contain all of the words. I guess it will forever be a mystery.

fyi. I put on my chandler task list to actually write a letter to Microsoft. But in reality, if vista decides it isn’t activated anymore again, I am probably just going to search for a crack to fix the problem. I am sure there is one out there. Maybe sp1 will save us all.