| Tech News, Reviews & Tuts

Believed me, one of the most frustrating things about iPhone is how its battery drains so fast everyday.

Many users are complaining that even turning off features such as GPS, Wifi, Bluetooth, running few apps, etc, to optimize battery power still not enough. 
Last January 2013, Apple support finally admitted that there’s a battery flaw in iPhone 5:
A very small percentage of iPhone 5 devices may suddenly experience shorter battery life or need to be charged more frequently. The affected iPhone 5 devices were sold between September 2012 and January 2013 and fall within a limited serial number range. If your iPhone 5 is experiencing these symptoms and meets the eligibility requirements noted below, Apple will replace your iPhone 5 battery, free of charge.

Apple’s Engineer 6 didn’t mention about iPhone 4/4s which also had horrible battery life and reportedly says they have no idea what's causing the problem.

And this is what actually happened to my GF’s iPhone 5 – In just 10 months suddenly the battery got bloated and the iPhone 5 deformed. When charge it’s good to go for an hour only and it’s hotter.
I missed to take a photo of the iPhone 5 itself but if you will look on it, you will notice that the screen go up and had blue lines.

Battery Replacement
If you’re iPhone is not eligible for the free replacement your last resort is to buy online or get the help of local technician. The replacement will cost you around P1300 (approx. $35).
In eBay or Amazon, you can buy an iPhone battery replacement for as low as 5 dollars with tool, good as the original but you will install it by your own.

While Apple claimed that iPhone’s rechargeable battery has overcharging protection features we must be aware that it has a limited lifespan. After over 400 charges, the battery will eventually die. Leaving it charger connected overnight is not a good practice as well as it can cause overheat and it degrades it.

Some users claimed that a lightning strike can also destroy the battery if left connected in the wall so; having a power bank might be practical option.  

Note: the defective battery must be disposed properly. According to experts exposing it to heat / sunlight can cause explosion or damage.

If you are into web development or programming then you already know some sort of database thingy.To established connection to your database, basically you will need details such as Database name, Username, Password and the topic of this post –Hostname.

Most MySQL /SQL database uses Localhost as their default hostname but web hosting provider like Godaddy offers unique hostname. After creating your database follow the instructions below on how to find your database details in the Cpanel.

2) Find the Database menu (mySQL or SQL)

3) Open the specific database you want to connect with (still in the Cpanel)

4) In the Manage Database, click the dropdown menu and choose Details
5) Now in the Database details scroll down, there you will find the right Hostname.

You can check the Code sample menu as well for your guide.

6) Copy and save it. Connect. Connect.Your done!

If you're a BPI customer, you will likely get pissed off of this  frequent " You have been log off due to inactivity " experience when accessing  your account in BPI Express Online portal. This error happens even  in the middle of a session, even though the 5 minutes limit have not lapsed yet.( I know this is part of the bank's security protocol to avoid unauthorized access to others account they put up that 5 mins limit ).

The BPI troubleshooting page recommendation:

"There are ISPs who periodically change the IP address they provide to their subscribers. If the change of IP address occurs in the middle of a session, our website automatically logs off. You may also login again to Express Online and check the ISP settings with your Internet service provider."

But if this issue has nothing to do with your Internet Service Provider (ISP) or site maintenance here are my simple guide:

1. Clear your browser cookies
 - Open your browser then, in your keyboard press CTRL + Shift + Delete .
- Put check on the Cookies, Active Logins, etc
-  press Clear Now and try logging in.This works most of time for me.

2. Try to use different browser to login as well.Outdated browser can be the culprit sometime.

3. Use the BPI Express Online Mobile Apps ( Android & iOS)
Another best way to check your BPI balance is through the mobile apps (I have tried the BPI Express Online apps with iOS and its works flawlessly with lesser ads.Way much better than checking the site in payroll day.

*Note: I am not connected to BPI just one of their customers too.Hope it helps.

Wanted to convert any html page to a pdf file? That's not a problem .There are lots of tools in the web that offers free html to pdf conversion that don't charge even a single penny.But I highly recommend PDFaid, a site that offers bunch of PDF solutions.

PDFAid can convert html pages or web urls to pdf.All you have to do is to enter any webpage url or upload the html file from your PC  and it will be converted to a pdf file with amazing accuracy. All the hyperlinks, form elements etc will be converted to their pdf equivalents as well.

I use PDFaid most of the time when creating an image of my client site instead of using screenshot tool which can't really capture a lengthy page. After converting to PDF, I combine them using Photoshop then exported to JPEG, I then have a high quality site image that don't get pixelated.

PDFaid also allows  to build your own custom html page using its rich html editor and save it as a pdf document.his application will run on any standard browser and does not require any additional software to be installed

- No Page Size, Margins, Orientation options 
- Can't use it without an Internet
- Need Photoshop to edit or combine separate pages

- Accurate and High Quality PDF
- Easy to upload and convert
- No installation required and accessible anywhere online

Other Free HTML to PDF tools:
PDF Crowd

Nowadays, speaking of Technical Vocational courses, TESDA is the number 1 government institution in the Philippines that offers free assessment and certifications programs nationwide together with various accredited Technical-Vocational Institutions (TVIs), TESDA Technical Institutions (TTIs), Local Government Units (LGUs) partners, and other government agencies providing TVET programs and DepEd trainings.

The Technical Education and Skills Development Authority or TESDA since it was established through the enactment of Republic Act No. 7796 in 1994 boasted that it had produced thousands of skilled workers that our now working here and abroad particularly in USA, Middle East and Brunei.

Who are qualified to take TESDA? 

From barbers to hairstylist, construction workers, automotive experts, Public Utility Vehicle (PUV) drivers, workers, industry practitioners, professional, career shifter, Overseas Filipino Workers (OFWs), Filipino expatriates with relevant experience, industry practitioners who are prospective competency assessors are qualified to apply for free assessment and certification.
TVI, TTIs, and other educational institutions who want to be a partner of TESDA are also welcome to undergo trainings and certification.

What is National Certificate (NC)?
An individual needs to undergo competency assessment for the identified qualification in any of the accredited assessment centers nationwide. Passers of the competency assessment shall be issued a NC or COC.

A National Certificate (NC) is issued when a candidate has demonstrated competence in all units of competency that comprised a Qualification. Certificate of Competency (COC) is issued to individuals who have satisfactorily demonstrated competence on a particular or cluster of units of competency
Below is the list of program TESDA currently offers with National Certification.

- Computer Hardware Servicing NC II
- Visual Graphics Design NC III
- 2D animation NC III
- 3D animation NC III
- Programming NC IV
- Game Programming NC III
- Finishing Course for Call Center Agents NC II
- Finishing Course for Medical Transcription NC II
- Career Entry Course for Software Developers NC IV – Using JAVA
- Career Entry Course for Software Developers NC IV – Using Microsoft.Net
- Career Entry Course for Software Developers NC IV – Using Oracle
- PC Operations NC II

Tourism / Food / Health:
- Food and Beverage Services NC II and III
-Commercial Cooking / Cookery NC II
- Bread and Pastry Making NC II
- Housekeeping NC II and III
- Household Services NC II
- Household Service Worker NC II
- Bartending NC II
- Tour Guiding NC II
- Travel Services NC II
- Events Management Services NC III
- Caregiving NC II
- Tourism Promotions Services NC II
- Bread and Pastry Production NC II
- Health Care Services NCII
- Food Processing NC II

- Agricultural Crops Production NC II and III
- Horticulture NC II
- Animal Production NC II

Metals / Engineering:
- Shielded Metal Arc Welding NC II and III
- Machining NC II
- Heavy Equiptment Operator NC II
- Pipefitting NC II
- Transport RAC Servicing NC II
- Refrigeration and Air-conditioning Services NC II

- Consumer Electronics Servicing NC II and III
- CATV Operation and Maintenance NC II and III
- Mechatronics NC III
- Instrumentation NC III

- Masonry NC II and III
- Plumbing NC II and III
- Carpentry NC II and III
- Heavy Equipment Operators NC II
- Electrical Installation and Maintenance NC II and III
- SMAW NC III, SMAW NC II and construction painting NC III
- Construction Painting NC III
- RAC Servicing (PACU/CRE) NC II
- Transport RAC Servicing NC II
- Air Duct Servicing NC II
- Ice Plant Ref Servicing NC III
- Technical Drafting NC II

Automotive / Land Transport:

- Automotive Servicing NC II
- Driving NC II/Driving (Passenger Bus Straight Truck) NC III
- Motorcycle Small Engine Servicing NC I
- Auto Engine Rebuilding NC II
- Auto Body Repairing NC II
- Auto Body Painting/Finishing NC I

- Deck Seafaring (Able-Bodied Seaman) NC II   
- Engine Seafaring (Oiler) NC II

Services / Crafts / Trade / Others:
- Tailoring NC II
- Massage Therapy NC II
- Beauty Care NC II
- Hairdressing NC II
- Dressmaking NC II
- Photography NC II Trade Certification
- Security Services NC II
- Bookkeeping NC III
- Front Office Services NC II

Upcoming Programs:
Jewelry Making, Land Surveying, Barbering Services and Electrical power Distribution Line Construction.
If you are planning to take TESDA assessment and certification programs, take note of the following:

Requirements for application:
·         Duly accomplished application form
·         Self-assessment guide
·         3 passport size pictures in white background with name written at the back
·         Certificate of employment.

Visit the nearest TESDA Regional Center and inquire what certification programs they offer.

Hi everyone in this tutorial I will teach you how to create a very simple yet a life-saving excel macro. If you’re a Product Lister you might have experienced working on excel sheet with thousands of images file names or image path, updating them one by one, so tiresome right? 

But good news for you, I have discovered the easiest way to do that through excel’s own tools for designed repetitive task, the MACROS
This macro code allows you achieve the following task effortlessly:
--Add any image extension to any image name.
--Add additional text or path name before the image name.
--Select and run. Easy to customize.

1. First create a new macro, click the Excel's Developer Tab > Record.

2. Name your macro as RENAMER then, hit OK.
3. Click the MACROS menu —Microsoft Visual Basic module dialog will open

4. Between the Sub Renamer and End Sub add this line:
Dim Cell As Range
For Each Cell In Selection
If Not IsEmpty(Cell) And Right(Cell, 4) <> "..jpg" Then
Cell = "" & Replace(Trim(Cell), "", "-") & ".jpg"
End If
Next Cell
5. Press CTRL + S to save your code.

6. To run your macro, select an excel column with image file names that you want to add .JPG extension, then run your Renamer macro as shown:

Adding an Image Path
1. Just open your RENAMER macro and click the EDIT menu then add the image path inside the quote next the cell=.
Your final code will look like this:
Dim Cell As Range
For Each Cell In Selection
If Not IsEmpty(Cell) And Right(Cell, 4) <> "..jpg" Then
Cell = " /images/" & Replace(Trim(Cell), "", "-") & ".jpg"
End If
Next Cell

Here’s the screenshot using my fictitious image path.

Warning: The only problem with using this macro is can’t undo anymore after you run it. So you better careful by backing up your file.

Do you want to put your store in Rakuten as temporarily inactive or close everything by yourself? Unlike eBay or other ecommerce platform, Rakuten has no Vacation Mode features categorically. In Rakuten, store owners must access their shop administrator settings and switch their shop status to inactive or disable their content manually. Here are the steps on how to do it easily.   
1. Login to using your shopping account

2. In the RMS portal click the Manage Shop Settings

3. If ask, enter your Rakuten merchant account.

4. Under the Administration menu, click the Shop Settings

5. In the Shop Status set the following:
Shop Status = INACTIVE
Enable my Product Pages = UNCHECK
Use my Content = DISABLED

6.Don't forget to click the SAVE button 

7. You’re done! Wait at least 24 hours for the change to effect.

Note, you can also contact the Rakuten support team and ask them nicely to deactivate meanwhile your storefront.

Should you have any question regarding this article? Please feel free to comment below.