NEW: For a prettier blog interface, see the Wordpress version!

Tasks
Priorities - A: high, B: medium, C: low; Status - _: unfinished, X: finished, C: cancelled, P: pending, o: in progress, >: delegated. Covey quadrants - Q1 & Q3: urgent, Q1 & Q2: important
A_Set up an iptables rule for Windows Update
B_Improve file upload method so that we don't have to share passwords : E-Mail from Harvey Chua
B_Look into how files are kept confidential : E-Mail from Harvey Chua
B_Check out features of Quickbooks and see if we are maximizing them in terms of recording and generating reports : E-Mail from Harvey Chua
B_Computerize recording of release and return of photo equipment : E-Mail from Harvey Chua
B_Create mailing list
B_Install instant messaging system on server
B_Install IM clients on each computer
B_Improve appearance of scheduling application
B_Set up Celine's laptop for offline e-mail
B_Make nice default page for iMac
B1_Link to Kathy's pbase: E-Mail from Harvey Chua
B0_Look into stock photography
B5_Add new pictures
B6_Move the portfolio links to the front page
C_Set up intranet Jabber
C0_Write instructions for people setting up their computers for mail
BXAssign e-mail addresses to Eric, Obet and Jun : E-Mail from Harvey Chua (2005.07.13 Adphoto)
BXScan mom's ads (2005.07.04 Adphoto)
BXCheck out http://dmvproduction.com and see if they lifted material from us (2005.07.02 Adphoto)
BXHelp Kathy with her market study (2005.07.02 Adphoto)
AXTeach dad the wiki way (2005.06.30 Adphoto)
AXMake spreadsheet for cost estimate (2005.06.17 Adphoto)
BXMake signs for Adphoto (2005.06.17 Adphoto)
BXRetype Mom's form (2005.06.17 Adphoto)
ACSet up an iptables rule for an antivirus scanner (2005.06.17)
BXAdd www.adphoto.com.ph to the proxy rules (2005.06.16)
BXRemove hi-res links from portfolio (2005.06.16 Adphoto)
AXUpload new website : Adphoto (2005.06.15 Adphoto)
AXProtect the pmwiki with a password (2005.06.15 Adphoto)
BXFinish the portfolios (2005.06.15 Adphoto)
AXSet up squid proxy (2005.06.10 Adphoto)
BXUpdate Adphoto website : E-Mail from Harvey Chua (2005.06.10)
BXAdd a gallery (2005.06.10 Adphoto)
BXMove the existing content into the wiki (2005.06.10 Adphoto)
BXInstall a wiki on my computer (2005.06.10 Adphoto)
BXConfigure the wiki skin to look like the Adphoto website (2005.06.10 Adphoto)
BXAdd writeup and photo : E-Mail from benjamin (2005.06.10 Adphoto)
BXDocument how to add a user (2005.06.02)
BXMake an account for Karen (2005.06.02)
BCRevise Adphoto website, putting flashbulb in upper left corner (2005.05.12)
BCChange gallery to be all on one page (2005.05.04)
BXWrite press release for dad (2005.04.22)
BXWrite instructions for uploading files (Adphoto 2005.04.21)
BXRevise write-up for Papa (2005.04.20)
BXWrite write-up for dad (2005.04.20)
ACUpdate the server and set up iptables (2005.04.20)
ACWrite script for followup call ... (2005.04.04)
AXAsk Papa about 10 b/w images he would like to share (2005.03.30)
AXFigure out why server is not being properly routed ... (2005.03.30)
AXCheck website status (2005.03.30)
AXSolve networking crisis downstairs by plugging in adapter (2005.03.30)
AXBuy networking stuff - crimper, wall mounts, UTP cable, ends, tester (2005.03.29)
BXAdd writeups (2005.03.29)
AXWrite user manual for equipment inventory (2005.03.22)
AXPrototype user interface for equipment: equipment check-out (2005.03.22)
BXRemove Greenbelt contact info : E-Mail from Harvey Chua (2005.03.08)
BXSet up IBackup account for Adphoto (2005.03.08)
AXFollow up with Globe tech support (2005.03.07)
AXSet office computers' homepages to http://192.168.1.3 (2005.03.04)
AXCreate mail account for Gemma (2005.03.04)
AXSet up second Ethernet card to be Internet-facing and regularly poll glines (2005.03.04)
AXConfirm scheduling still works! (2005.03.03)
AXReset all passwords on scheduler (2005.03.03)
AXSend test mail from Globe (2005.03.03)
AXBuy two switches and some RJ45 ends (2005.03.03)
AXSet up the router to use DSL (2005.03.03)
BXAdd equipment list (2005.03.02)
BXUpdate studio list based on AdphotoProfile1.pdf (2005.03.01)
BXSubmit site to web directories ... (2005.03.01)
B21XAdd corporate profile (2004.12.04)
B22XLook at new pictures (2004.12.04)
B23XAdd map (2004.12.04)
B17XReply re once-over: E-Mail from Sean Uy (2004.12.03)
B18XSet up sitecopy (2004.12.03)
B19XReply to Sean about copywriting: E-Mail from Sean Uy (2004.12.03)
B20XReply to Dominique: E-Mail from Dominique Cimafranca (2004.12.03)
B15XChange dad's number of years of experience (2004.12.02)
B16XUpdate contact information: E-Mail from Harvey Chua (2004.12.02)
C2XReply about great website design from E-Mail%20from%20Harvey%20Chua {{Tasks:1099}} (2004.10.09)
B14XReply about design studies from E-Mail%20from%20Harvey%20Chua (2004.10.06)
B7CFind information on dsef 828 sony {{Tasks:998}} (2004.04.29)
A2XDownload a request tracker {{Tasks:949}} (2004.04.27)
B12XSneak openoffice.org onto Maritess' computer {{Tasks:960}} {{Schedule:12:00-12:30}} (2004.04.24)
B13XDownload openoffice.org and upload it to the server {{Tasks:959}} {{Schedule:20:30-21:30}} (2004.04.24)
C1XBuy another patch cable. Maybe I should assign patch cables per computer. Aww, Dominique got it one--nice! {{Tasks:895}} (2004.04.24)
A1XPick up the projector {{Tasks:916}} {{Schedule:8:00-9:00}} (2004.04.21)
B10XFind receipts for new equipment {{Tasks:920}} (2004.04.21)
B11XBuy mom Super Lemons and a huge box of chocolates {{Tasks:899}} (2004.04.21)
B9XFind a quotation for a bar code scanner {{Tasks:875}} (2004.04.15)
AXSet up an iptables rule for BIR
AXUpdate server software
AXReview website statistics
AXWrite instructions for switching to Globe
AXFigure out Globe connection details ...
A3XLook for any information on Ruby Imaging, Singapore, or Phase One
BXConsider website suggestions : E-Mail from Harvey Chua (TaskPool Adphoto)
BXReread general manager answers for Adphoto : E-Mail from Harvey Chua (TaskPool Adphoto)
BXPut outline into wiki : E-Mail from Harvey Chua (TaskPool Adphoto)
BXFind a good way to archive files : E-Mail from Harvey Chua
BXSet up dad's laptop for e-mail
BXWrite accomplishment report
B24XCheck out Brian's site designs from E-Mail from Harvey Chua
ACSet up smarthost forwarding to Globelines
ACSet up DNS server for local system
ACSet up the home network so that lots of people can browse
B0CLook into barcodes: E-Mail from Harvey Chua
B8CBackup Mom's files {{Tasks:961}} {{Schedule:12:30-13:00}}
Globe information

7571502 Tech 7301357

Server plans
Inward: eth0

- Local mail server - Web server - Scheduler - TODO: Jabber server

Outward: eth1

- Poll globelines mail to satisfy POP before SMTP requirements

Routing

- Traffic from my computer should be NATted and routed to the Internet

so that I don't have to worry about where I am.

- Traffic from Cristy's computer going to bir.gov.ph should be allowed.

Current setup: no routing between interfaces.

If the packets are from my computer, received on eth0 and destined for the external network, route through eth1 and masquerade.

All this will have to wait until I compile iptables support into the server.

Hmm.

Notes

15. Adphoto notes: 19:00

Categories: 2005.04.07:2 -- Permalink
- 1. What must a sales person be, have, know or learn to be effective in sales? - 2. Difference between sales and marketing functions; sales vs sales management

- presentable; pleasing personality; approachable - communications: spoken, written English and Tagalog; negotiation; good listener; presentation skills; computer literacy/savvy - ethics - training: product knowledge: equipment, services, photographers' skills and expertise; sales, presentation skills - job description - familiarization with company (people, facilities, policies, organization structure, presentation/sales kits (images, spiel/script) - clients: know clients and their requirements; who? territorial assignments - pricing - competitors - performance - employment contracts

training: when? - as soon as hired - continuing training - periodic

lack of training

- not productive - short of knowledge - lack of confidence - wrong information - not professional

- train, keep - train, lose - not train, keep - not train, lose XX

Why do clients get Adphoto?

- quality of work - support service - good food - Lucas - fast delivery - high tech - good reputation - facilities - we go to them

what do we need to train: (materials)

- portfolios - list of equipment and usage - photographers' profiles - list of clients - pricing guidelines / rate sheets / stock photos / equipment rental / studio rentals - company policies - sales policies - job descriptions - reports / forms / analysis: billing (per qtr, per client, per ...), collection, cost estimate, job, sched, delivery receipt. frequency, volume, value. - workflow - corporate profile - services - supplies - performance evaluation - advertising and promo materials - employment contracts

Action:

- 1. prepare a training manual - 2. prepare a training program - 3. update old employees' employment contracts, job description - 4. look for someone to handle sales training

「ええ、かわいい、ちいさな、ふわふわしたねこですよ」年をとったおばあさんが言いました。 "Yes, a sweet little fluffy cat" said the very old woman.

14. Networking: 22:17

Categories: 2005.03.30:3 -- Permalink
The network tester I bought yesterday was very useful. Celine and Yaya suddenly lost network connection, and the tester quickly showed me that both cables going to the first floor had been significantly damaged. I showed Jun how the network tester tests individual wires. We think rats might have chewed on the wires. Jun will rewire the connection going downstairs. I gave him the wall mounts, networking jacks, cable reel, and network tester: he's all set to do some major networking stuff.

Celine didn't receive some mail Mom sent her, so I confirmed that the server had plenty of free space and I sent another test message. However, my mom's default settings with Globelines didn't work.

To prevent its mail servers from being used for spam, Globelines requires users to check their Globelines account before allowing them to send mail through its servers (POP before SMTP). I didn't want to save my mom's Globelines password on all the computers that needed to send mail. On 2005.03.03, I installed another network card in our IntranetServer and configured it to check my mom's Globelines account regularly. This worked without a hitch because I had assigned addresses to keep the two networks separate.

When they plugged the wireless router in, though, the factory defaults conflicted with my addressing scheme. I suppose she had luckily managed to avoid those problems for a while. Still, fixing it was just a matter of sitting down and configuring the router properly. I set the router password and the wireless security settings as well.

We're still not done arranging for Mom's flight to Canada. Argh. The printer's annoying, the website's somewhat frustrating... Mrph.

彼らは熱烈にいがみ合っている。 They fight like cat and dog.

13. Figure out why server is not being properly routed

Categories: None -- Permalink
Wireless router was put in between DHCP-serving router and rest of world. Had default settings, even for password. Changed password. Set WEP key. Fix all the subnetting.
95597DB265
CCC63BDF56
7B61E42A99
797CFE899F

12. Write script for followup call

Categories: None -- Permalink
GOALS:

- Give client warm and fuzzy feeling - Get feedback

OUTLINE

- Thank client for letting us help them create the images they want - Mention new services - Ask for feedback - Thank client again

SCRIPT

Good morning/afternoon! May I please speak with <person>? This is <my name> from Adphoto calling about <shoot>

IF YOU GET TRANSFERRED:

Hello, <contact name>. This is <my name> from Adphoto.

MAIN BODY

We'd like to thank you for giving us the opportunity to help you create the images you want. Did you have any problems opening the images from the <number of CDs> CDs you received right after the shoot?

THEN

By the way, we're always looking for ways to serve you better. We've just put wireless Internet in the main studio. Is there anything else you'd like us to improve?

We're looking forward to working with you in the near future. Thanks again for choosing Adphoto to help you create your images!

11. Accomplishment report: Getting in touch with my inner networking geek: 23:14

Categories: Adphoto report -- Permalink
Reorganized network in lobby and Internet room

- Prepared and printed instructions for connecting to the Internet and

configuring one's mail client. Posted on wall of Internet room.

- Discussed network configuration with Jun and networking technician.

They were both pleased at the reduction of work in my proposed star configuration because adding a switch downstairs means not having to rip out a cable every time something got broken. While I was out buying equipment, they laid a new line going downstairs and removed lines that were not responding. As a result, the hub is less congested now.

- Bought 2 8-port switches, 2 extra LAN cards and 20 RJ45 ends.

Paid cash and submitted receipts.

- Helped network technician crimp 6 lengths of 3 meter patch cable.

Chatted with him about networking and mentioned that I was planning to put one of the switches downstairs even though they had fixed the broken intranet connection already, as I would need another port anyway. He helpfully installed it, keeping in mind which line was straighter than the other. Nice person.

- (Here's the fun part.) Overhauled wiring in Internet room by myself.

Removed the DSL router. Connected the 8-port switch with the DSL router. Arranged the new cables. Successfully browsed.

- Panicked when Mac and Kathy couldn't send mail through Globelines.

Frantically tried to configure mail before giving them a direct connection to Destiny as a quick workaround.

- Successfully sent a test message from Microsoft Entourage using

webmail.glinesnx.com.ph after spending a total of almost an hour on the phone with Globelines tech support trying various combinations: with authentication, with SSL, etc.

- Configured Mom's laptop to send mail through Globelines. She

successfully sent mail from her main account, but then got "relaying denied" errors as her old accounts weren't configured yet. Finished configuring her laptop. No complaints so far.

- Neatly bound most wires with twist ties. Removed unnecessary things

from Internet room shelf and piled them outside.

Server

- Installed new LAN card in server. Wiped off most of the dust inside

the case. (We have dust bunnies. Eek.)

- Successfully turned on server. (It's always a scary thing, turning on

a computer with no monitor in sight...) 192.168.1.3 responded to both Web and login.

- Pleasantly surprised to see scheduling application still alive.

Reset scheduling application database and successfully tested job creation and and view/search.

Website

- Reviewed website statistics. Pleasantly surprised to see Taj Deluria's write-up

at http://www.themassif.com/sp_studio_equipment_rentals.php .

- Set http://www.adphoto.com.ph as the default website for Safari and

Internet Explorer on the Mac. Should come up with a better website for clients: Adphoto logo and bookmarks for well-used places on the Net.

Misc

- Bought cat litter and dog food. Paid cash and submitted receipts.

- Helped Miguel Paraz with a computer science parsing problem.

10. Supplier's directory: 11:44

Categories: 2005.03.03:1 -- Permalink
Supplier's Directory: Studio / Gear Rentals lists Adphoto, Inc. =) Nice write-up.
In brief: A well-established firm that rents out studios--from modest 40 sq. meter units to a columnless 240 sq. meter studio for cars and huge setups. They've got studios with kitchen facilities for food photography, and studios with adjoining dressing / make-up rooms for talent / fashion shoots. They also rent out a full-range of digital equipment (think Hasselblads, Sinars, Fuji, and PhaseOne digital systems) and can build sets and source props.

They also provide photography services through their pool of in-house photography pros--John K. Chua, G-nie Arambulo, Mac Antonio, Kathy Chua, and Ben Chan.

Note: A full-service studio that has near everything you can dream of needing. They've also been operating for years and years. For more info, you should look for Ms. Harvey V. Chua (that's not a typo, SHE should be able to help you out).

Page maintained by Taj Deluria.

Adphoto

9. Accomplishment report for 2005.03.01: 16:53

Categories: Adphoto report -- Permalink
Confirmed Globe DSL SMTP server

- Found webmail.glinesnx.com.ph written on DSL box. - Sent and received test e-mail. - Confirmed with DSL tech support and Ben. - Next action: None

Updated studio list on website

- Cut, cropped, and recolored photos from AdphotoProfile1.pdf. - Placed the pictures on Adphoto: Studio &raquo; Facilities. - Next action: Get better information on studios (dimensions, facilities)

Submitted site to web directories

- Open Directory Project, http://www.photo.net.ph, Tanikalang Ginto, photographers.com (specializations: Advertising, special effects, digital, stock, product/studio still life) - Expect two weeks or more before listings show up. - Blurb used: Advertising photography and digital imaging from award-winning pioneers John Chua, G-nie Arambulo, Mac Antonio, Kathy Chua. 30+ years of experience of working with both local and international clients. - Next action: None

Worked on Haribon sponsorship letter

- Rewrote proposal to be more attractive to potential sponsors. - Next action: Follow up with Dad

8. Submit site to web directories

Categories: None -- Permalink
- http://dmoz.org/cgi-bin/add.cgi - Asiaco.com - add url error - http://www.photo.net.ph - Tanikalang Ginto: http://www.filipinolinks.com - http://www.photolinks.com/ResultsPage18.html?COUNTRY=Philippines&STATE=Manila&CITY=Manila&CATEGORY=Advertising%20Photography : feedback form not responding - http://www.photographers.com : Advertising, special effects, digital, stock, product/studio still life

7. Figure out Globe connection details

Categories: None -- Permalink
SMTP server: webmail.glinesnx.com.ph

6. Stock photography: 15:18

Categories: 2005.02.27:2 -- Permalink
http://www.indexstock.com is an online stock photography service. Check out the guidelines. I think this is a good service for us to look into. Besides, we need to tag photos and cross-reference them with model releases anyway.

5. File transfers: Xdrive: 15:13

Categories: 2005.02.27:1 -- Permalink
Xdrive looks like a promising way to transfer files between clients. It's an additional USD 9.95 a month for 5 GB. If I can find a cheaper mail/web host that still lets me do PHP hacking, then we can move off ipowerweb next year.

4. Brilliant idea about my summer schedule: 18:43

Categories: 2005.02.18:5 -- Permalink
I need to hack a couple of things in Adphoto. For one, the scheduling system needs to be improved. Also, we need to work out a smooth way to transfer files to clients.

The best way to get me to work on these things would be for me to get annoyed with them.

The best way for me to get annoyed with these things would be for me to have to do them.

So that can be my summer job. If my mom doesn't mind having me underfoot, I will work for Adphoto. First, I need to hack scheduling. In the process, I'll probably also tweak office communication. When I'm not scheduling things or improving the scheduling infrastructure, I can work on making the website more informative.

Sounds like a good plan.

1. Request tracker: 15:01

Categories: 2004.04.23#1 -- Permalink
My mom would like a way to keep track of tasks not covered by Job Orders. A request tracker would perfect for this, as it'll help her see open tasks and to whom they are assigned.

2. The one-hour hack strikes again!: 08:04

Categories: 2004.12.02#3 -- Permalink
http://www.adphoto.com.ph

Not bad for a one-hour hack straight out of bed. Time to change clothes and eat breakfast...

3. More gallery stuff: 22:53

Categories: 2004.12.03#5 -- Permalink
Tala said:
You might also want to try Coppermine. http://coppermine.sourceforge.net/ =)

E-Mail from Richi's server

Previous day | Next day

I'd love to hear about any questions, comments, suggestions or links that you might have. Your comments will not be posted on this website immediately, but will be e-mailed to me first. You can use this form to get in touch with me, or e-mail me at [email protected] .

Page: Adphoto
Updated: 2006-01-2807:16:3707:16:37-0500
NOTE: ANTI-SPAM MEASURE NOW IN PLACE. Please answer the following question with the right number in order to send me your comment.
What is two minus one? (hint: one ;) )
Name:
E-mail:
URL:
Comments: