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.