byon’s blog – my daily rant!

just what you’ll expect from your daily joe

McDonald Monopoly Singapore 2009

with 5 comments

I’ve quite a number of repeated pieces, sigh! Anybody wants it? :) :)

at last, when will i win the final prize of $50,000!

Written by byon

November 2, 2009 at 3:16 am

Posted in Blogroll

Randoms

leave a comment »

- Been going down to velvet, phuture and zouk lately for work related purposes; day time
- Explored various imaging techniques, various raid transferring stuffs, it’s interesting how various licensing can be cloned from one system to another
- I’m gonna catch funny people movie tomorrow
- Windows OEM SLP for the win (:

Written by byon

October 16, 2009 at 11:19 pm

Posted in Technology

LogParser v2.2 Output to MySQL

leave a comment »

There are multitudes of reasons why you should backup your data to a trustworthy location. Went back to office this afternoon, realised that the files on the server was being deleted; thus causing the script to malfunction, infact the main script was deleted. Anyway, i had to recode from scratch. sigh.

The company is running a standalone MyMailList Deluxe software for years, and they need to merge the datas on the software with the internal application i created for the company. Not everything is automated, the administrator still has to export the CSV file manually to the proper designated folder that propagates the data into database.

Here goes my codes for those who needs it.

———————————————————–

@echo off
echo **************************
echo * Author: John Goh, byon@testaccelerator.com
echo * Date: Oct 06, 2009
echo * Description:
echo * Allows internal application to retrieve latest
echo * company mailinglist information
echo *
echo * Remember to save ExpFile.csv in C:\
echo *
echo * Pre-requisite for server setup,
echo * – install LogParser 2.2, MySQL ODBC 5.1 Driver, MySQL Server 5.0
echo * – Setup ODBC DSN to: mailListDSN under Control Panel (WinXP/2K3)
echo * – Scheduled Tasks this Script Daily
echo * – Put this script in a important directory D:\Applications\
echo * – Remember to do daily backups to this file
echo * – Setup LogParser in the ENVIRONMENTAL PATH VARIABLE
echo *
echo **************************

logparser “SELECT [Acct Start], [Address1], [Address2], [Attn], [Business], [Check Digit], [Company], [Credit], [Custom1], [Custom10], [Custom11], [Custom12], [Custom2], [Custom3], [Custom4], [Custom5], [Custom6], [Custom7], [Custom8], [Custom9], [Special Instructions] AS [SpecialInstructions]  FROM C:\ExpFile.csv TO maillist WHERE NOT Company = ”” -i:CSV -o:SQL -server:localhost -database:courier -username:root -dsn:mailListDSN -driver:”MySQL ODBC 5.1 Driver” -cleartable:ON -createtable:ON

———————————————————–

Save it as query.bat and run it off Command Prompt, or Schedule Task it!

Written by byon

October 6, 2009 at 1:56 am

Singapore 3.5G Dongle Login for 3G Routers

leave a comment »

For people who wants to connect their 3G or 3.5G dongle to a router that supports 3G (HSDPA) dongle, in Singapore,

For M1
Dial number: *99#
Username: ppp@aplus.at
Password: ppp
PDP Type: IP
APN Name: sunsurf

For SingNet/SingTel
Dial number: *99#
APN Name: internet

For StarHub
APN name: StarHub Internet
Access Point Name: shinternet
Username: none
Password: none
Authentication: Normal

Written by byon

October 5, 2009 at 11:48 pm

Posted in Technology

Humans akin me, make mistakes

leave a comment »

I make terrible mistakes, I want to know if you are forgiving about it. I’m sorry.

You are the only one whom i have ever been real close with ever. (:

Let’s enjoy the show later.

Work now, cya.

Written by byon

October 5, 2009 at 3:04 pm

Posted in Blogroll

Solution: Google Earth: ‘DirectX’ mode not supported

leave a comment »

I’ve been using Google Earth on various computers and laptops until i installed Google Earth on Fujitsu Lifebook S6421. The problem doesn’t lie in the proper drivers that are not installed or directx 9.0c. It should also affect: Fujitsu Lifebook S6421BW, S6420WS.

I even went to install DirectX 10 on my Windows XP. But it still fails.

Solution:
- Start -> Settings -> Control Panel -> Display -> Settings tab
- Click ‘Advanced’ button, ‘Troubleshoot’ tab
- Under ‘Hardware acceleration’
- Move the lever to Full
- Check ‘Enable write combining’
- Press ‘Ok’

Now try Google Earth again!

Written by byon

September 22, 2009 at 2:16 am

Solution: Uninstall/Removing TrendMicro OfficeScan Password

leave a comment »

I have been searching everywhere on removing Trend Micro OfficeScan pre-installed on laptops bought in SMU matriculation. I’ve successfully uninstalled it, here’s the solution if anybody is interested.

Necessary steps:
#1. Change Registry Keys
HKEY_LOCAL_MACHINE\SOFTWARE\TrendMicro\PC-cillinNTCorp\CurrentVersion\Misc
- AllowUninstall value to 1
- NoPwdProtect value to 1

#2. Disconnect from the Internet / Disable Wireless/LAN Adapter

#3. Modify certain values in C:\Program Files\Trend Micro\OfficeScan Client\OfcScan.ini

- Search for [INI_CLIENT_SECTION]
- Change the Keys to these Values
Uninstall_Pwd=70
Client_Allow_Uninstall=1
Client_Allow_Unload=1

Save Ofcscan.ini, Uninstall. It didn’t prompt me for a password, but if it did, enter “1″.
* if it doesnt work, restart the laptop/computer, disable internet connection, then uninstall.

I’ve installed ESET NOD32 over this.
Cheers.

Written by byon

September 22, 2009 at 1:54 am

shrek

with one comment

i’ve got the shrek 1/2/3 downloaded.
wanna watch? (:

Written by byon

September 21, 2009 at 2:45 am

Posted in Blogroll

Singapore Traffic Police system has cockups!

leave a comment »

notice the date i was fined, 27 Jun 2009 11:58pm.

TPCockup

i was only licensed to drive a class 3 vehicle on 4 Aug 2009
I passed my Class 3 Driving License on 4 August 2009.
license

Some facts during the period, June, to specifically 27 Jun 2009.
- I just enrolled driving and only drove Mitsubishi Lancer EX
- I was at home sleeping at the point of offense
- I did not have a valid license
- I did not drive SCW604B during that period

definitely a major cockup in their TP computer system. There were no system validations at all. and i almost wanted to pay for it. were they just out for the profits?

fyi, it is a fact that government entities e.g., LTA, are expected to run like a profit organisation. it should ring a bell the day they decided to outsource their traffic management services to Cisco security.

Written by byon

September 9, 2009 at 8:40 am

loving you

leave a comment »

No one else can make me feel
The colors that you bring
Stay with me while we grow old

And we will live each day in springtime
Cause lovin’ you has made my life so beautiful
And every day my life is filled with lovin’ you

Written by byon

September 7, 2009 at 12:13 am

Posted in Blogroll