Meeting notes
Topic: i-Solv Project
Notes on the meeting with i-Solv (from 10am to 2:20pm):

Attendance:

Cesar Agito, i-Solv GM
Alex Garcia, i-Solv Project Manager
Maricel Paz, i-Solv SysAd

JVAMJr, SFE Project Manager
DPP, Billing Supervisor
ELP, Encoder
FVV, OM
CFF, CA
Pie, Programmer
Gina, Pie's Asst.
Erap, Meter Reading
Mariliz, Meter Reading

i-Solv asked for the following:
1. Organizational Chart (from MSM)
2. Customer Application Form (ok)
3. Schedule of Rates (DPP, ok)
- other Rates (PPA, etc.)
4. Class Codes (Pie)
5. Chart of Accounts (MCAJr)
6. Structures of Tables (Pie)

My notes:

The Org. Chart is to determine ownerships of databases/tables.

Pie suggested that account numbers be changed into the following format: yymm99999... to reflect the date of application of each customer.

FVV, CFF, DPP & ELP disagreed and wanted to use a geographical approach.

Perhaps we can follow Apaul's old style, but we will include "yyyymm" in the last portion of the account number.

But i-Solv suggested that we assign Account ID's (separate and universally unique) to each applicant (& existing customers, I presume). I agree that this is the best approach.

We also discussed the possible hierarchical recording of customer address records according to Franchise, Feeder, Barangay, Sitio, Subd/Village, Street.

Suggestions/enhancements:

1. Record all adjusted readings for auditing purposes.
2. Criteria for disconnection -- table-based to be flexible

Questions:
1. Worst-case scenario: let's say merong customer na hindi na-reading for 2 years. How to input that?

On Wednesday, 10-27-2004, i-Solv wants our inputs and wishlists so they can documents all requirements and bound the Scope of Work.

Pie is asking for a Billing meeting so we can work out what we need to present on Wednesday. We said, FINE.

Personal notes:
FB - 5 collectors, 2 tellers

Problems:
1. Timely posting of bank payments ([almost] real-time)
2. Who will sign the Acceptance Documents? I guess one officer per module (3 modules) and the Project Manager (and the GM?)
3. How do we distribute partial payments? (Unbundling)
4. How to bill changed meters?

Engg1 PC
Topic: work
This one wouldn't connect to the network.

I cleaned it up and harvested 3 sweet potatoes (kamote).

Still it wouldn't connect.

I re-crimped the existing plugs, to no avail.

I changed the NIC-end plug, to no avail.

After 45 minutes, decided to postpone the repair work for tomorrow morning. Will test the cable on the AccThinkPad just to eliminate it from the possible problems.

Posted by Samboy at 4:49 PM JST

Share This Post

Post Comment | Permalink

TSG Mapping2 PC
Topic: work
Changed the vidcard, and it booted, but still wouldn't connect to the domain.

It turned out that they changed the IP address to another subnet.

Spent about 20 minutes on this.

Work done. PC Working.

TSG Mapping2 PC
Topic: work
The PC wouldn't boot, and I immediately diagnosed it as a video card problem, judging from the beeps.

I reseated the card and it booted, but it wouldn't connect to the network. Then after reseating the NIC, the video card died. :-(

I spent 30 minutes trying to resurrect it, but the vidcard only heats up, and the system beeps the same way as if there's no vidcard. :-(

I tried using the "flooded" vidcard remitted to me by Rico, but it displays nothing. :-(

Programming
Topic: work
Looks like I got enough to get me really going with accessing MySQL thru VFP. :-)

God help me.

Viruses
Topic: work
The following e-mail messages were found to have viruses in them:

Sender: jasmin_estacio@ph.nestle.com
IP Address: 61.9.24.55
Subject: Re: Thanks!
MessageID: 144341DD428
Report: ClamAV: message_part2.pif contains Worm.SomeFool.Gen-1
MailScanner: Shortcuts to MS-Dos programs are very dangerous in email (message_part2.pif)

Viruses
Topic: work
The following e-mail messages were found to have viruses in them:

Sender: ralisantil@yahoo.ca
IP Address: 210.5.126.222
Subject: Mail Delivery (failure xxx)
MessageID: 17E591DD428
Report: ClamAV: message.scr contains Worm.SomeFool.P
MailScanner: Windows Screensavers are often used to hide viruses (message.scr)
Report: MailScanner: Found dangerous IFrame tag in HTML message

Viruses
Topic: work
Wow, no viruses received for the day! :-)

I updated the server's antivirus software today, at around 1pm.

Programming
Topic: work
Continued researching MySQL access thru VFP clients. These n-tier achitecture thingies are driving me nuts! I hope I find some information (preferably tutorials and/or sample apps) on accessing SQL thru VFP.

Viruses
Topic: work
The following e-mail messages were found to have viruses in them:

Sender: marvin@askmarvin.ca
IP Address: 210.5.121.135
Subject: Mail Delivery (xxx)
MessageID: E95791DD428
Report: MailScanner: Found dangerous IFrame tag in HTML message
Report: ClamAV: message.scr contains Worm.SomeFool.P
MailScanner: Windows Screensavers are often used to hide viruses (message.scr)

Sender: _yo.urpromosdaily@qvo.tvsved.com
IP Address: 210.5.125.196
Subject: Re: Protected Mail Request
MessageID: 16C551DD428
Report: ClamAV: document.zip contains Worm.SomeFool.P