jump to navigation

Data Migration is Evil.. 1 May 2006

Posted by deunan in Work.
1 comment so far

Well, I say that the hard part is almost done. Duplicates eliminated, hanging records purged. Now, I only need to create new 'Registration No', since the new system requires on 16 characters, instead of 25++ in the original.

What else? Oh yeah, remove all hyphens ("-") characters in the Identity Card Number column (This one needs a bit thinking). Seperate all I/C #s from old to new (This one's peanuts). Remove all instances of the apostrophe ("'" – heh!) and ampersand ("&") from Names and Addresses Fields (Ought to be fun!).  Yeah, don't forget to split the addresses field by 35 characters  😉  (More to remind myself than just a simple blogging  😛  )
Umm.. Hope I can finish by midnight!

Advertisements

Weekend.. Shot! 30 April 2006

Posted by deunan in Work.
add a comment

Darn, sometimes I hate my life.  My boss asks me to redo the whole database for the state of Kedah.  Exactly 33,297 records in the database.  First I have to clean them for duplicates, then I have to slowly and painfully update them to prepare for upload into the new database and eventually, new system that they gonna use at the Ministry.

Someone else might do the job ala – "chin chai"..  Well, someone else did..  I started the job first, did it about 20% to a quater of the way.  Later my boss told me to turn it over to someone else and told me to concentrate on my prime duties.  Well, they botched it bad enough that my boss asks me to redo it again, from the top.

Oh well..

Hello world! 27 April 2006

Posted by deunan in System.
1 comment so far

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!

Yeah, yeah.. I get it.. This is the umphteenth time I started a blog.. Dunno whether this one lasts.. or maybe not.. I'll damn well'll give it a try.. a shot.. whatever..