Bennixville - Tech News| Blogging | Reviews & More -


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 = "www.yourdomain.com /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 Rakuten.com 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.



I have to share with you,so far my personal shopping experiences with Lazada are great in terms of delivery and customer service. Another advantages, it offers a number of payments methods to you  pay your order conveniently. Lazada accepts payments securely by Cash on Delivery, Credit Card, BDO Installment, Megalink and off course, Paypal, where I will be discussing a little bit on how to do it straightforward.
 
1. First, find the item you want to order then, click the BUY NOW button

2. Next, click PROCEED TO CHECKOUT

3. Now Lazada will prompt you to login. Just type in your email address and password and click CONTINUE. (If you don’t have existing account use your email address only then, fill up the shipping address as required)

4. Click CONTINUE again if your delivery information is good to go.

5. Assuming you’re in the Payment Info page already, make sure to click the PAYPAL tab before clicking PLACE YOUR ORDER. At the right side of the page you will see your order summary with the total cost plus shipping charges.



5. Lazada will ask you to login in your PayPal account just follow the process and once complete you will receive a confirmation email regarding your payment and delivery status of your order.

If you’re outside Manila you’ll have to wait at least 3 days to receive your order. Goodluck!

Thanks for dropping by, please feel free to comment below.





As we all know, Slimbox 2 is a popular clone of Lightbox a script use to display fanstastic images and other web content.Slimbox 2 was developed by Christophe Beyl and released under MIT License.
 
One of things you will love about Slimbox 2 is the responsiveness of the jquery script, it allows you to close it immediately at any time using the keyboard or mouse and to instantly navigate to any image before the current image has loaded or the animations are complete.


Another good things; the script is fully customizable, compatible to modern browsers, and it offers more options compared to Lightbox.

For more information about Slimbox 2 you can read here: http://www.digitalia.be/software/slimbox2

Now let's go for the setup guide the main lesson of this post.

SETTING UP SLIMBOX

I know some beginners will find it hard to install or make it work correctly so, I made this simple guide.


2. Extract the file and put it to your localhost root folder (Why localhost? You must test it first before finally uploading to your site)

3. Create a new html page or open an existing one to Dreamweaver (you can have any html editing tool you’re incline to work with)

4. In your page add this line before <html> tag : 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">

*Without this doctype Slimbox 2 will not display correctly, images will go to the bottom of the page.

5. Next, include the script in the header of your page, after the inclusion of the jQuery library

<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/slimbox2.js"></script>
*Change this scr ="actual jquery path"accordingly

6. Include the CSS file in the header of your page, or add it to an existing CSS style sheet:

<link rel="stylesheet" href="css/slimbox2.css" type="text/css" media="screen" />
For right-to-left language:
<link rel="stylesheet" href="css/slimbox2-rtl.css" type="text/css" media="screen" />

*Change this scr ="actual css path"accordingly

7. To ACTIVATE slimbox script in your image, add the rel="lightbox" attribute to the links.

  example: <a href="images/image-1.jpg" rel="lightbox" title="my caption">image #1</a>

8. TO ACTIVATE  the Slimbox 2 Gallery Mode or displaying sets of related images that you want to be navigable, add a group name to the rel attribute just after the “lightbox” word, for example:

<a href="images/image-1.jpg" rel="lightbox-bike">image #1</a>
<a href="images/image-2.jpg" rel="lightbox-bike">image #2</a>
<a href="images/image-3.jpg" rel="lightbox-bike">image #3</a>

* In this example, I put up the word " bike" after lightbox, so the result whenever I click a single picture in a page it will open up series of images I tagged for the bike attribute.So, its now a gallery of images!

*Make sure to set the Loop: bollean value to TRUE. Open the slimbox2.js and search for the keyword " LOOP".

9. Works perfectly? Oh,you can upload the attire script to your site root directory and have fun.!

If you have any question pls feel free to get in touch..T.Y



Whether you’re a newbie or veteran user in Twitter accept the fact that there are two types of followers you will encounter; the active and inactive one.

The active one is simply you’re followers who always visits Twitter, post updates,&  re-post  other’s post. They love to compliment and interact to other people. They won’t miss a trend.

 While the inactive is the opposite one, lack of interest to engage, very passive, and almost abandon her/his account. In short, inactive followers are just dead / lazy / busy and even fake followers. And these inactive followers could be you also.
 
Well, not just of the type followers but of users as well:

Mashable posted the 10 Users You Will Meet on Twitter , it provides clear insights that people coming to Twitter has different interest and personalities. So, you can’t please and engage with everyone. As what experts said,it always  takes time to build rapport with you and your followers.  

Kissmetrics.com 20 Days to a High-Quality, Highly-Engaged Twitter Following, the author mentioned that the more engaged the follower, the more likely they are going to exchange value with you…whether by subscribing to your blog or actually paying you money for your product or service.

Quality vs Quantity

Why active followers are important to marketers? Though huge numbers of fake followers will portray your business or company as influential outside but in the long run you need bunch of active followers to help you promote your stuff in Twitter. If those active followers are bloggers and online experts, you can even offer to establish a mutual partnership that can benefit both parties.

Tools to Analyze and find Active Followers

Active followers are not hard to find but just don’t rely on Twitter platform, find useful third party tool that will enable you to analyze follower’s activity and trends.

Though the simplest way to check your follower’s activity is by going to:  https://twitter.com/activity, there are free third-party tool that can help you analyze your follower’s activity and find new active followers better.
For this tutorial, I recommend my two favorite tools: TwitterDeck and Tweepi.com

TwitterDeck –Allows you to login without registration by using your Twitter credentials. TwitterDeck has a streamline interface, it provides real-time view of your followers activity, notifications, messages, and  live tweets.  Usually, I use TwitterDeck to find active followers by looking through the activity column; I can easily communicate and follow them. Also, it allows you to easily spot online users that if you follow them there’s good chance that they will notice you and follow you back instantly. Cool right?

Like in the Twitter interface, you can also follow, tweet back, send DM, mute, and black followers using TwitterDeck. Cons, you can’t do mass following or unfollowing. But above all this tool is totally free.

Tweepi.com – It’s a known free tool for Twitter. Using Tweepi it allows you to easily  flush users who don’t follow you back or reciprocate following.With Tweepi you can easily spot inactive users, force them to unfollow you or cleanup. An added feature, the Geeky Follow via copy/paste utility to Tweepi. You can use this Tweepi tool to see loads of information about those tweeps, see who follows you of them, and even follow or unfollow select users using Tweepi simple interface. Upgrading to Premium subscription will provide more flexible features for a social media savvy.

I am using Tweepi since last year for my client’s and I am very happy for the good results.

PS : I wrote this post a year ago and it’s funny how this took so long to be published.. I hope it would still help you guys..I’ll update if I find something cool out there..Salamat





As what we have posted last year, Davao City had planned to converge its BPO and IT sectors by putting up an IT Park in Matina area - consists of 3 buildings beside S&R Shopping (along McArthur Highway).

The first building which was constructed since last year is now near in completion..see the photos below (double click to view in full).


Nestled in a 3,000-square-meter, the first building project cost estimated to be around P100 million.

For the second phase, the building will rise in a 2,000-square-meter lot while the third phase will have a total of 1,500 square meters.

The Matina IT Park is expected to be the biggest IT Park to rise soon in Mindanao with the capacity to accommodate huge BPO companies and generate thousand jobs for the locals.

ICT Davao is promoting four IT areas in the city; Damosa IT Park, SM City Davao , Abreeza Mall and soon the , Matina IT Park.

I'll update soon this post..
ICT Davao is promoting four IT areas in the city---Damosa IT Park, SM City Davao , Abreeza Mall and soon the , Matina IT Park. - See more at: http://www.bennixville.net/2012/08/matina-it-park-will-rise-soon-in-davao.html#sthash.XNuBOrXm.dpuf
Expected to be the biggest IT Park soon in Mindanao to accommodate more BPOs that could produce 1,500 call center agents and other allied service workers. - See more at: http://www.bennixville.net/2012/08/matina-it-park-will-rise-soon-in-davao.html#sthash.XNuBOrXm.dpuf
Expected to be the biggest IT Park soon in Mindanao to accommodate more BPOs that could produce 1,500 call center agents and other allied service workers. - See more at: http://www.bennixville.net/2012/08/matina-it-park-will-rise-soon-in-davao.html#sthash.XNuBOrXm.dpuf



Unmanned Aerial Vehicle (UAV) or commonly known as drone is being eyed in Davao City as a tool for disaster and emergency response, reported in Mindanao news site on Sunday.

The city's Public Security and Safety Command Center (PSSCC) Chief Francisco Villaroman said he has proposed to the city government to invest in aerial drones for emergency response situations after testing a unit a week after the April 4-5 fire that hit two barangays in Isla Verde.


Duterte, he said, would be the one to decide if the city can afford drones and whether to use the device as a regular unit of the city’s Central 911 emergency response system.

He said the drones cost around P80,000 commercially and could be able to zoom in to focus on distant subjects on the ground if upgraded with cameras with zoom-in capabilities.

Villaroman had earlier said in several Facebook postings that he was impressed with the capabilities of the Quad Copter Phantom 2 drone, which allowed city officials a wider visual perspective of the extent of the damage of the fire that hit barangays 22C and 23C last April 4, and rendered homeless some 3,000 families.


He said the city could use “other modern apparatus to avert crime and terrorism, calamity mitigation, and traffic accident monitoring.

“For example, during a robbery, it would be very easy to spot a car that escaped a crime scene if we had something like that,” Villaroman said.

It can be remembered that in 2013, Mayor Rodrigo Duterte reportedly rejected a U.S government proposal  to utilize the city's old report as an operating base for its drone program against terrorism and insurgency.[Inquirer.net]