Load Center and Pole Numbers

FVV told Rico that in order to minimize human errors in encoding Load Center and Pole Numbers, we should input them during creation of the customer account, and not when the meter has been installed already.

Makes sense, but it will require A LOT of changes in the system -- in the program and in the reports -- not to mention the shift in encoding practice...

Initially, I mentioned that we should just transfer the fields from the meter page/table to the consumer master page/table, but we will not be able to track the pole and LC histories. So now I'm thinking of transferring the 2 fields to a NEW table, while Rico suggests that we just get them transferred to the consumer_connection table, which I think will take up more server disk space than necessary, as it will entail recording of the 2 fields every time there's a Reco and Disco for a customer where there's no change in LC and Pole.

Update, Apr. 29, 2008:

I've decided to create a separate table, despite it having similar (redundant) fields like modified_by, created_modified, current_status...

Why? Because there are times when the Eng'g. Dept. has to replace rotten poles and there may be METERS that will have to be removed and subsequently put back. We will have no individual job orders per customer then.

Toyota Casa bad feedback

from http://tsikot.yehey.com/forums/showthread.php?p=1046236#post1046236

Originally Posted by jaspi11

eto naman yung detalye ng 20k check up ko last march 26;

1.inspect valve clearance ( tiananong ko kung paano nila ini-inspect, di na daw at self adjustment daw yun)
2. inspect drive belt (parang di ko nakitang ininspect)
3. replace engine oil (nakita ko naman nilagyan ng 3 liters)
4. engine oil filter (pinalitan talaga)
5. inspect engine collant (dinagdagan lang ng tubig yung reserve)
6. inspect exhaust pipe and mounting (parang di ko nakitang ininspect)
7. replace sparkplug (meron namang recovery ng luma nilagay dun sa flooring ko)
8. inpsected battery( eto ang merong kwento mamaya)
9. inspected air filter (ang sabi ng SA papalitan daw pero nung tingnan hinanginan lang)
10. inspect PCV valve ventilation hoses & connection (di ko din nakitang ininspect)
11. inspect brake pedal and parking brakes (ininspect naman)
12. inspect clean and adjust break (oks naman nakita ko)
13. inspect break pad and disk (oks din)
14. inspect brake and clutch fuids (oks din)
15. power steering fuids (oks din)
16. inspect ball joint and dust cover (parang di ko din nakitang ininspect)
17 inspect steering wheel and linkage (basta parang more on brakes and change oil lang ginawa)
18. inspect transaxel and transmission oil (di nga sinilip eh)
19. inpsect front/rear wheel suspension (paano kaya ininspect)
20. inspect bolt and nuts on chassis & body (ang pinihit lag eh yung pang drain ng oil)
21. inpsect tire and inflation presure (oks naman na check)
22. inspect light horn washer road test( di din nagawa)
23. inspect aircon (parang di din nagawa)

tgmo (SL 20W50) 415.89
oil filter 657.02
spark plug 491.28
gasket 23.82
sand paper 18.00
brake cleaner 199.37
misc 122.45
----------
2,952.83
vat 354.34
----------
total 3,307.17

sa totoo lang wala pong malasakit ang toyota mkt sa customer basta maperform nila yung change oil kahit ang daming nakalagay sa job order/specs nila, tapos na, di lahat ginagawa.yung sa may battery ko nga meron palang umido di nila ginalaw at ng itawag ko kay toti meruena yung SA dun di daw kasali yung paglilinis ng batterykaya nga ako nagpa preventive maintenance eh..ituturo pa ako sa labas na lang daw ipalinis kundi ba naman talagang nasa loob na ako ng casa ituturo pa ako sa labas...kaya sa susunod na check up ko sa iba na lang casa.....yung carpet replacement ko di ko na din kukunin yun.... kasi iiwan yung car doon for 1 day...wala na akong tiwala sa toyota mkt...bibili na lang ako kay MARFIN nung leather carpet na kinabit nya worth 2k lang naman.

Linksys Gigabit switch down

This morning, Rose complained that she couldn't check her email.

I thought it was merely a proxy problem, but changing the proxy settings didn't matter.

Then Gina said she couldn't load up BCMS program.

While I was checking the server with a lot of "what if" scenarios on my mind, Mike announced that his network connection is "UNPLUGGED."

That's when I checked the switch, and voila, 3 of the 4 groups of 4 ports each were down.

Good thing I haven't installed the old Cnet 100Mbps switch at LH sub-office yet. I transferred all our network cables to this old unit so that Dinah can have the Linksys replaced, since it has warranty coverage up to Sept. 2008. Whew.

I'll be requesting for a spare unit ASAP, though.

Payment Editor

I snapped. Heh.

It was about time I grew tired of all the editing I have to do with all the mistakes in posting payments. Every time Agnes calls me to adjust batches of O.R. numbers, I have had to:

1. Load up the SQL front end.
2. Open my database of commands.
3. Open the commands table.
4. Select the second-to-last record for the template.
5. Copy the template's starting O.R.# to the clipboard.
6. Ask Agnes what the starting O.R.# to edit is.
7. Search and replace.
8. Copy the template's ending O.R.# to the clipboard.
9. Ask Agnes what the ending O.R.# to edit is.
10. Search and replace.
11. Copy the template's date of payment to the clipboard.
12. Ask Agnes what the posting date to edit is.
13. Search and replace.
14. Ask Agnes what to edit (teller_id, payment_date, O.R.#'s)
15. If O.R.#'s, switch to the command prompt or load one up.
16. Calculate the difference between correct and wrong starting O.R.#'s.
17. Search and replace.
18. Execute appropriate commands.

Now, with editpay.bat, I have compressed these steps into:

1. Editpay , , ,
2. Execute appropriate commands.

Kewl!!!

Floridablanca server disk full

Last night at around 9pm, Rico texted me and told me that he's getting errors.

I told them to go home because the problem had a simple solution: erase binary logs... and so I did, this morning. I went to the office before 7am and quickly solved the problem.

I also included Michelle to the sudoers, for good measure. So in the future, I can just instruct her over the phone...

Uploading meter reading data

Last week, I modified the MR Uploading module to include a check for the area's existence before the uploading proper started. In my blog entry, I prayed that I didn't introduce a bug "this time" but, guess what... (altogether now...) I DID!!! :-(

My latest quick fix failed to take Power Bills into consideration. Since Power Bills were read not by area but by reading day, the uploading process stops dead on its tracks at the area check.

I fixed it immediately.

Dvorak keyboard layout

There's been a sudden surge of the Dvorak keyboard layout in the plug mailing list lately, and it piqued my curiosity.

Now I switch to Dvorak when I can take time typing. Like now.

I'm still far from my qwerty speed though.