Monday, June 16, 2008
11,725 Duplicate Events

Roughly two weeks ago, I downloaded the latest Apple OS upgrade to MacDreamy.
Sometimes, this proves to be a very big mistake.
For the second time that I've done this over the past 6 months, this upgrade did something very, very bad to my calendar.
First of all, you have to know that I use the Calendar in Entourage as my main calendar. (I also use Entourage as my main email, contact and notes app.) I've been using one form-or-another of Entourage ever since I met Dick more than 9 years ago. (It used to be Outlook Express for the Mac).
So, let's remember: I have more than 9 years worth of data in this Calendar/Email program.
You can just see where this is going, can't you?
Here's where it gets loopy:
All was fine and well with me and my Entourage Calendar for the first 8+ years. We had a very nice relationship. I was able to track all of my events, birthdays, and my hours for various clients, and even got to color-code each one, which makes generating invoices much easier.
Last year, I bought my iPhone. One of the main reasons I wanted it was so that I could easily sync my calendar and contacts from my computer to my phone (and vise-versa).
In order to do this, I had to turn on Apple Sync to take my calendar events from Entourage and create a new calendar in iCal (Apple's calendar). This was fine: I had two copies of my calendar: the first one was in Entourage, where I managed everything in my handy-dandy-do-it-all program. It was continuously synced with a second version of my calendar in iCal, which talked to my iPhone.
In theory, this all sounds fine.
...until something goes wrong.
...and when it goes wrong, it goes wrong to the tune of 11,725 duplicate events!
What?!
Yep, for the second time in the last 6 months, after I installed an OS upgrade to MacDreamy, the calendar sync went into overdrive, and decided to duplicate, triplicate, quadruplicate, etc ALL of calendar entries from the past nine years.
This is where the nightmare began:
My first thought was to remove the duplicates manually from Entourage. I only focused on events from the last couple of years, just to clean it up. That took a couple of hours. That's when I realized how far back my calendar went, and the ridiculous amount of unnecessary data that was clogging up my computer.
Dick found a script written to take duplicate events out of Entourage. Brilliant, I thought! This should fix things up! After two days of running it (and rendering me unable to use Entourage at all) I had no idea how far at all it had gotten. I had to quit out of it so I could have access to my all-important email program again.
So, I went back to cleaning out my calendar by hand. I cleaned out about 5 years, figuring that was fairly substantial.
The next move: delete the Entourage Calendar Copy in iCal, then re-sync with the cleaned up calendar.
Dick ran through this step-by-step with me, because the last time I did this (a few months ago) I did it by myself, and the results were not good: it erased both of my calendars.
So, we deleted the calendar in iCal. Then we turned the AppleSync back on, and specifically told Entourage to sync to iCal, using the new data to create a new Calendar. Again, I have 9 years of data in my calendar - it took a while.
Once it was complete, I realized that it had AGAIN deleted all of my calendar events in both my iCal version AND my Entourage. I had no calendar events at all.
(insert: Trina Freaking Out here)
Luckily, I had been running Apple's Time Machine Application which makes back-up copies of all of your files.
We ended up deciding to restore the latest version of my iCal Calendar, figuring we could fix that, and eventually sync it back to Entourage. Dick warned me that I should probably stop using my Calendar in Entourage, and just start using iCal exclusively. He explained that this will probably continue to be a problem every few months, and that if I only used iCal, and take Entourage out of the equation, it would probably work just fine. I'm bummed because Entourage's Calendar is just so much more robust than iCal, and has so many nice little features that I use often.
Dick found (yet another) script online called "iCal Dupe Deleter" that we thought we'd try to get rid of all of the duplicate events in the iCal calendar.
Fine. Worth a Try.
Good news: it has a much better UI than the Entourage script - this one actually has a progress bar so you can see how far along it's going.
Bad news: It found a total of: 16,585 events in the calendar.
Of these, 11,725 were duplicates.
Good Grief!
This was last Monday afternoon. This script doesn't keep me from using any of my other programs, so I figured I'd just let it run it's course in the background until it was done.
Again, this was last Monday, June 9th.
Today is Monday, June 16th.
As of this moment, it has removed 6,851 duplicates. This is after running 24/7 for the past week.
At this rate, I'm hoping it'll be done by the end of this week, at which time I'll have to see if it worked, and I'll have to make some decisions.
In the meantime, I've been writing all of my billable client hours on a post-it pad on my desk. I also haven't been able to sync my iPhone to my computer for the past 2 weeks.
This is not the end of the world - I know it's better to have many-duplicates of my calendar info rather than having everything wiped out entirely. And I know it's just a calendar - there are worse types of data that could be wiped.
But still. I'm tired. At this rate, it'll take the entire month of June to get settled.
blech.
Saturday, June 14, 2008
still not impressed with the new SFgate.com
We took MUNI home today from the Embarcadero this afternoon. When we reached our station, we heard an announcement that there was an accident on the new T-Line, and that the line was shut down in the area of the accident.
It turns out that two MUNI Trains collided at 4th and King Streets - one T-Line and one N-Line.
I only just now found this out because I was scanning the news on MSNBC.com.
Mind you, I had just read SFgate.com, and didn't see anything about it there. I had to double check through all of the many headlines to make sure that I didn't miss it.
...the local SF news site doesn't have a thing about it, but the World News site does.
Not very impressive, is it?
It turns out that two MUNI Trains collided at 4th and King Streets - one T-Line and one N-Line.
I only just now found this out because I was scanning the news on MSNBC.com.
Mind you, I had just read SFgate.com, and didn't see anything about it there. I had to double check through all of the many headlines to make sure that I didn't miss it.
...the local SF news site doesn't have a thing about it, but the World News site does.
Not very impressive, is it?
Labels: rant, san francisco
Wednesday, May 28, 2008
Less is More
When web design goes very, very bad.
‹rant›
SFgate.com changed their design format again today. It's the second time they've done that within the last couple of months.
Here's the thing: I love sfgate. I visit it frequently each day. I like it because I'm able to skim the headlines easily - which are both local news as well as world news. It's easy and concise, and I can quickly decide which stories/headlines interest me the most.
Bad news: Change is Bad.
Over the course of the last two design changes, they've somehow managed to go from a site that was unique because it was quick, and easy to navigate site with local and world news to a news site that looks a whole lot like everyone else. They've gone from having one feature story with one photo and one column with headlines of mixed stories, and quick blurb about the story, to becoming just another news site with multiple feature stories, multiple sections and multiple headlines.
I liked it because it was a "local site". It focused on local things. It always included the important World News Events, and had a small column for 4 or 5 AP stories, but the rest of it was local news. I have a routine of going to sfgate for my local news, and msnbc.com for World/AP news.
Now, it looks like sfgate is trying to compete with all of the big news sites. It's going in a direction that goes against the very reason why I was such a fan to begin with.
They have a little "Give us feedback" link which is already filled with dozens of readers bashing the new design.
I've been a web designer for 11 years. My first rule of thumb when designing a site has always been: "Less is More". Keep it simple. Don't over design. Let the user find what they want easily. Don't muck up the site with too much content.
Why is that so hard?
(or maybe it's just me, because goodness knows there are a lot of over-designed web sites out there that make my eyes bleed.)
I'm hoping that the design staff at sfgate.com will read the feedback and take it to heart. Hopefully, they'll go back to (one of their) old design that set them apart from the other news sites.
update
Okay, I know that this is totally over the top, but I've just found two screen shots of the from sfgate.com - an old one from 2007, and the new version as it debuted today. I thought it would be interesting to compare them side-by-side.

sfgate: then and now
Look how much more content this new design has packed into it, and how much harder it is to read. Seeing them side by side like this really makes me wish they'd just go back to the old design.
Is there enough crap in that site for you?
Seriously, my eyes hurt just looking at it.
Get a clue, guys. This is bad design.
‹/rant›
‹rant›
SFgate.com changed their design format again today. It's the second time they've done that within the last couple of months.
Here's the thing: I love sfgate. I visit it frequently each day. I like it because I'm able to skim the headlines easily - which are both local news as well as world news. It's easy and concise, and I can quickly decide which stories/headlines interest me the most.
Bad news: Change is Bad.
Over the course of the last two design changes, they've somehow managed to go from a site that was unique because it was quick, and easy to navigate site with local and world news to a news site that looks a whole lot like everyone else. They've gone from having one feature story with one photo and one column with headlines of mixed stories, and quick blurb about the story, to becoming just another news site with multiple feature stories, multiple sections and multiple headlines.
I liked it because it was a "local site". It focused on local things. It always included the important World News Events, and had a small column for 4 or 5 AP stories, but the rest of it was local news. I have a routine of going to sfgate for my local news, and msnbc.com for World/AP news.
Now, it looks like sfgate is trying to compete with all of the big news sites. It's going in a direction that goes against the very reason why I was such a fan to begin with.
They have a little "Give us feedback" link which is already filled with dozens of readers bashing the new design.
I've been a web designer for 11 years. My first rule of thumb when designing a site has always been: "Less is More". Keep it simple. Don't over design. Let the user find what they want easily. Don't muck up the site with too much content.
Why is that so hard?
(or maybe it's just me, because goodness knows there are a lot of over-designed web sites out there that make my eyes bleed.)
I'm hoping that the design staff at sfgate.com will read the feedback and take it to heart. Hopefully, they'll go back to (one of their) old design that set them apart from the other news sites.
update
Okay, I know that this is totally over the top, but I've just found two screen shots of the from sfgate.com - an old one from 2007, and the new version as it debuted today. I thought it would be interesting to compare them side-by-side.

sfgate: then and now
Look how much more content this new design has packed into it, and how much harder it is to read. Seeing them side by side like this really makes me wish they'd just go back to the old design.
Is there enough crap in that site for you?
Seriously, my eyes hurt just looking at it.
Get a clue, guys. This is bad design.
‹/rant›
Labels: rant, san francisco, web design
Friday, March 14, 2008
Stupid DPT

yet another reason for me to be grumpy today!
Grrrr..
I'm Grumpy McGrumpster today.
Here's the thing. Dick and I both "rule followers". We follow the rules, we obey the laws - enough so that we actually joke about it. We won't cross the street if the little red hand is up. We don't jaywalk. We are good, law-abiding citizens!
Unless you talk to the SF D.P.T. that is. (Department of Parking and Transportation for you non-urbanites.) Apparently, Dick has been breaking the law for almost 4 years now.
Dick has had his trusty Vespa Scooter for almost 4 years now. He always parks it in the same place: on the sidewalk between two trees, in front of our house.
Yes, that italicized part up there is your clue. It is, indeed, parked on the sidewalk. We've always felt that as long as it wasn't actually blocking the access of the sidewalk, that it should be fine. It's in between two trees. Unless someone is intentionally walking from one tree to the other, it's really not in the way at all.
Over the past 3 years, we've received about a ticket per year for parking it on the sidewalk. Dick took this in stride, figuring that a car on our block was actually blocking the sidewalk by parking across their driveway, and that they then have to do a full sweep of the block. That's okay. We knew we weren't being targeted.
Well, today, I noticed a meter maid writing up a ticket in front of our house. I went out to discuss the matter with her. She was very nice about it, and explained that "they" really started to crack down about a year ago. Any vehicle parked on any part of the sidewalk was to be ticketed - no matter if it's actually blocking the sidewalk or not.
Now believe me, I started to argue my case, as did a few people who walked by, but she explained it wasn't up to her, and that she was "just doing her job". She actually agreed that we weren't blocking anyone, and she had let it slide by several times, but she has started to get in trouble for such things.
The ridiculous part was that she told me that I "technically" could park it within 2 feet of my front property line, and that she wouldn't ticket it. So I argued that I could park it in front of my window, or in front of my stairs, clearly blocking part of the sidewalk, and that would be okay? She said yes, that she couldn't ticket us if we did this, but that we should use our common sense. Whatever. That's just stupid, and it goes completely against any kind of common sense.
You can see the left-most line in the sidewalk in the picture above - the one closest to the front of the house. She says we technically could park within that line, and that she couldn't ticket us. This is crazy stupid, because that blocks the side walk a whole lot more than parking between the two trees.
I tried really hard not to get angry at her. It's not her fault, and she's just doing her job, and she was actually being very sensible when trying to explain the "rules" to me that she had to follow. It also clearly wasn't going to help my case if I got upset.
But the thing is, I see this all the time: people flat-out blocking the path of the sidewalk with their big enormous cars parking across their driveways because they're too lazy to actually go out and find a spot on the street. I've seen people pushing baby strollers, and worse: people in wheel chairs who have to go into the street to go around the car across the driveway and sidewalk. This infuriates me.
I also raised the point that not only are we not blocking the sidewalk, but we're also not taking up an actual parking spot on the street, which apparently, is what we'll have to do, now. This is really brain-damaged (which seems to be my expression of the day).
I decided to leave the ticket on the scooter until Dick comes home today (he drove to the train station, because it was supposed to rain today) so we won't chance getting another ticket from another meter maid. When Dick comes home, I'll ask him to move it to a spot on the street. Or, maybe we'll just park it in front of our front steps. (that would be the bitter person in me coming out.)
This is ridiculous.
Oh, and by the way, the penalty for parking on the sidewalk:
$100.00.
Stupid DPT.
Labels: rant, san francisco
Quickbooks on the Mac vs. Quickbooks on the PC
I've been using Quickbooks Pro for the PC to do all of my business accounting since 2002. I only use it for writing invoices, and receiving payments. I really don't use it for much, but these two functions are very important for me to keep track of things.
A couple of months ago, I made the switch to Quickbooks Pro 2007 for the Mac.
My assessment so far:
Quickbooks for the Mac totally blows.
(how's that for a professional assessment?)
I just spent about 2 hours sending out invoices. It should have taken me about 45 minutes.
It's amazing to me how different the two iterations of the program are. I guess I shouldn't be surprised. I know how these things go: each iteration is written by a completely different group: like Office for the Mac versus the PC.
But really, this is really brain-damaged.
Sending out invoices was always very easy and fast of the PC version. I'd write out the invoices, and send them out in batches. I could even have a standard "email body" that went onto each email, with correct customer name placed in the appropriate field. It was all very fast and simple. After writing the invoices out, sending as a batch took less than a couple of minutes.
Not on the Mac.
I have to send out each invoice individually, and send it as a large monster-sized PDF file. The PDF file is 1.7 MB, versus the size of the PDF files that I sent on the PC, which was 35 K. That's a HUGE difference. If I were a client of mine, I'd be wondering why the file has to be so large. That's ridiculous, and I look like a Lame-O.
There are a bunch of other features that don't exist in the Mac version. There are a bunch of things that just don't "work". There are so many things that I've come across that just take so much more time than they should.
Considering I only use this program to generate and send out invoices, and to record payments, I'm really amazed at how much I'm missing from the PC version. I feel lucky that I don't rely on this program for more. I'm so very unimpressed.
Boo on you, Intuit.
A couple of months ago, I made the switch to Quickbooks Pro 2007 for the Mac.
My assessment so far:
Quickbooks for the Mac totally blows.
(how's that for a professional assessment?)
I just spent about 2 hours sending out invoices. It should have taken me about 45 minutes.
It's amazing to me how different the two iterations of the program are. I guess I shouldn't be surprised. I know how these things go: each iteration is written by a completely different group: like Office for the Mac versus the PC.
But really, this is really brain-damaged.
Sending out invoices was always very easy and fast of the PC version. I'd write out the invoices, and send them out in batches. I could even have a standard "email body" that went onto each email, with correct customer name placed in the appropriate field. It was all very fast and simple. After writing the invoices out, sending as a batch took less than a couple of minutes.
Not on the Mac.
I have to send out each invoice individually, and send it as a large monster-sized PDF file. The PDF file is 1.7 MB, versus the size of the PDF files that I sent on the PC, which was 35 K. That's a HUGE difference. If I were a client of mine, I'd be wondering why the file has to be so large. That's ridiculous, and I look like a Lame-O.
There are a bunch of other features that don't exist in the Mac version. There are a bunch of things that just don't "work". There are so many things that I've come across that just take so much more time than they should.
Considering I only use this program to generate and send out invoices, and to record payments, I'm really amazed at how much I'm missing from the PC version. I feel lucky that I don't rely on this program for more. I'm so very unimpressed.
Boo on you, Intuit.
Labels: geeks, rant, technology
Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway --- oh right, I *am* my own employer!
;)
© Copyright 2003-2007, Trina Chow