As in,

http://en.wikipedia.org/wiki/Act%21

(I'm really surprised there's an entry for it, but it's definitely there.)

As far as I can tell, this crappy little program (which has a distinctly 
Windows 3.1 GUI) just stores contact details. A bit like... the contacts 
list feature of Outlook. All it seems to do is store and retrieve client 
information. That's its entire function.

Now, if the program did this especially well, you could understand my 
company deciding to use it. But it doesn't. It is the most unreliable 
crock of junk EVER! It is just so complicated to set up. And sometimes 
you set it up, and for no reason, it just won't work. And you have to 
set it up all over again. Sometimes it takes several attempts before it 
will work correctly. Sometimes it never works quite how it should.

The program keeps a local database in some undocumented proprietry 
format. When you first set this thing up, you have to email the 
application administrator and ask him to build a "blank database" for 
the new user. You put this on the hard drive and point the software at it.

The best part is that these databases are kept synchronised BY SENDING 
EMAILS! That's right. When you enter some new data into your local 
database and you want to propogate it to the other users in the company, 
you press a button and the software builds a database diff and SENDS IT 
IN AN EMAIL to the application administrator. He imports this into the 
master database. Periodically, he sends out emails to everybody to 
import into their local databases to bring them back up to date.

Yes, you heard me correctly. In the year 2008, people are trying to 
manually synchronise seperate databases by sending diffs back and forth 
by email. And if your database gets out of synch somehow, next time you 
send out a sync it can "corrupt" the master database, causing general 
disaster. You also have to be very careful about exactly how you update 
information in your local database, to avoid lost updates and other 
well-known database problems.

(There's also an "optimise database" option that has to be used only at 
certain times to avoid corrupting your database next time you import... 
You see what I mean about complicated?!?)

The best part is when you've set up a new PC with a blank database. You 
then have to import an "initial synch packet". Unlike the regular diffs 
which only contain updates, this packet contains EVERYTHING.

I'm doing such a process as we speak, actually. The full packet is a 
mere 6 MB in size. And yet, even on brand-new top-of-the-line hardware, 
it takes several *hours* to import all the data. The entire time, there 
seems to be very little CPU usage, but massive HD thrashing.

Like, WTF? *How* can it possibly take this long to process a mere 6 MB 
of data?? What the hell is it *doing*?! x_x

(I started processing at 2 PM today. It is now 3 PM, and currently 32% 
processed.)

Throughout all of this, I keep asking why the hell we're using this lump 
of crud. The answer I keep getting is "we don't have anything else to 
use". Why somebody can't throw together something superior in Access in 
about 10 minutes is beyond my powers of comprehension...

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message