Excel Formulas to Extract Subfolder from URL String

To assist in your backlink analysis. With backlink data, you can then determine which folders are most linked to and investigate why, potentially replicating its success. For these formulas to work, it’s best to “FORMAT DATA AS TABLE” in excel.

Using Google Webmaster Tools Data

=IFERROR(MID([@[Your pages]],FIND("/",[@[Your pages]])+1, FIND("/",[@[Your pages]], FIND("/",[@[Your pages]])+1)-FIND("/",[@[Your pages]])-1),"home")

Using MOZ Backlink Data


=TRIM(LEFT(SUBSTITUTE(MID([@[Target URL]],FIND("//",[@[Target URL]])+2+IF(ISNUMBER(SEARCH("//www.",[@[Target URL]])),4),LEN([@[Target URL]]))&"/","/",REPT(" ",999),2),999))

 

 

 

15 Ways to Get Motivated & Avoid Procrastination [Infographic]

Wait but why wrote one of the best outlines of procrastination ever in their Why Procrastinators Procrastinate post, and it’s helped me quite a bit. This infographic, however, digests a few common and some not-so-common ideas to understand the reasons why we procrastinate, how to get motivated and avoid procrastinating even further:
Continue reading 15 Ways to Get Motivated & Avoid Procrastination [Infographic]

International Collect Calls from Verizon Wireless Phones Impossible

international-collect-calls-to-brazil

After Googling several variations of the term “how to place international collect calls” and getting absolutely nowhere, I decided to call Verizon for instructions. Much to my surprise, a nice Verizon rep flat out told me it’s impossible to place or receive international collect calls through a wireless phone.

Sorry, Verizon Wireless phones cannot receive or place international collect calls – Pam, Verizon support rep

One of the most promising results during my initial research period came from USA Today, which pointed me to a certain “0170” directory assistance number. Perpetuating the uselessness of demand media articles, however, the 0170 number is no longer available.

Embratel Brasil Direto

When I started to filter my research to “collect calls from USA to Brazil“, I was able to reach Embratel, a Brazilian phone operator, which has a neat service called Brasil Direto. Through their 800#, you’re able to reach an operator who will then connect you to any number in Brasil (you just need the area code “DDD”).

Why No Collect Calls?

I hope this is a Verizon-only issue. After all, why would any other operators block international collect calls through cell phones? Is it too hard to actually collect the money, or even enforce the charge, when dealing with overseas operators? I find that hard to believe, specially with increased connectivity and VOIP technology.

And if no cell phone can be used to place or receive a collect call, what option is left? If you’re a tourist, your hotel is likely to charge you an arm and a leg for it, and there aren’t any payphones available anymore. Guess we should all sign up for a Google voice account and deal with the $0.03/minute charges….

A Tale of 2 Street Fairs – Rutherford vs Lyndhurst, NJ

feat-img

After devouring David Foster Wallace’s A Supposedly Fun Thing I’ll Never Do Again (highly recommended!), which opens with an essay about the author’s visit to the Illinois State Fair, I never thought I could enjoy the decadence of a street fair the same way, but once again, I was wrong.

Today we had the pleasure of stumbling upon not just one, but two street fairs. Down the street on Union Ave, Leo and I noticed the “street closed” signs and decided to check it out. What a phenomenal party! Later on in the evening, on our way to Lyndhurst town park, once again we hit “street closed” signs only to land on another fair.

rutherford--street-fairs-9
1 of 3 bounce houses available 100% free at the Rutherford street fair on Union Ave

Rutherford Wins by Knock-Out

According to a fireman I spoke to while Leo was exploring their firetruck, the goal of the fair was to bring more attention to upper end of Union ave, a school area with a few blocks of commerce that doesnt get nearly as much attention as the area around Park ave (next to the Rutherford train station). Whether that was the real goal I dont know, but the town did a really nice job of drawing the public, specially kids. In addition to the usual street fair food and booths, they brought:

rutherford-street-fairs-6
Free train ride for the kids, set up by Cliffhanger Productions.
  • 3 bounce houses
  • A gymnastics trampoline with harness
  • Live music
  • Kids character routine w/ Elmo, Mickey, Minnie, and Dora
  • Kids train rides

The kids’ attractions may not seem like much, but they were ALL 100% FREE! They were managed by Cliffhanger Productions, and I’m not sure if they donated the equipment and staff or if the town paid for it, but Cliffhanger did an excellent job. Their staff kept all of the kids in order, managed to keep lines always moving, and were always courteous with the kids. Leo went multiple times on all of the rides and bounce houses.

rutherford-street-fairs-4
Leo and his little friend lizard

As if offering free rides for the kids wasnt enough, Rutherford seemed to have struck gold with a few other vendors at the fair. Meadowlands YMCA had 3 or 4 booths, with games, balloons, and even cotton candy being offered free (Cotton candy asked for a $1 donation), and volunteers at the booths seemed to be enjoying their time as much as fairgoers. Another ultra-popular booth came from (I hope) a pet store, and consisted of several different lizard aquariums. In an ingenious move, they kept a friendly lizard out of its eco-cage and allowed the kids to hold it in their hands – instant win. When we walked in around 1pm, they had about 15 aquariums on display, all gone by 4pm. And to top it all off, the Rutherford fire department brought their rescue truck out, opened all of its compartments, and allowed the kids to explore its insides. Another huge win.

rutherford-fire-department-street-fair
Leo was beyond excited to “drive” the fire truck

Additionally, food was modestly priced and easily available (almost no lines!), and the weather held up well. With all of that going on, this was the first time we spent more than 1-2 hours at a fair. Leo’s battery didnt go out until way past 5pm, which was right around the time they were deflating the bounce houses.

Lyndhurst “Fundraiser”

To offer a drastic comparison, Lyndhurst could barely hold us for 30 minutes. The fair, which was a fundraiser for Hackensack University Hospital (according to the person on the microphone, hammering the message a few times/minute), had the entire park area roped off and expected folks to pay for access. I believe it was mostly a suggestion, since they didnt seem to be kicking anybody that simply passed under/over the ropes, but an aggressive technique nonetheless.

The worst part, however, was seeing the playground shut down at 7pm (when we got there). The Lyndhurst playgoung is open 7 days a week until 8pm, so I’m not sure if they simply closed an hour earlier or if they closed it entirely for the fundraiser. Roping the park is kinda bad, but shutting the park seems really unfair to the kids.

Considering they also had 3 bounce houses and a not-very-safe-looking spinning carnival ride, we were willing to consider it a trade-off. However, unlike Rutherford, each bounce house required its own $3 admission ticket. Plus, there was only one kid-driven booth (face paint), and another selling generic barely-made-in-china toys, neither free (the toy booth asked $10 for a toy available on dollar tree). Other booths had an eerie feeling of garage sales, with one selling nothing but bundles of socks. Overall, it seemed the entire fair was geared towards adults, which if true, makes total sense. We did arrive there later in the day.

Highlight of the event – crystallized Jellyfishes, colored with glow-in-the-dark paint and encapsulated in resin displays. A really cool idea! The jellies are dipped into liquid nitrogen, then painted somehow before being engulfed by resin. I might pick one up for Leo’s room if I ever find the lady’s card (she doesnt have a website, of course).

lyndhurst-street-fairs-10
crystallized jellyfish look awesome in the evening.

Spoiled by Rutherford

In 7 years living in the US, this little Rutherford street fair was the first to ever make us comfortable and in which we actually had fun. Is it fair (no pun intended) to expect other events to offer tons of free stuff for the kids? Probably not. But it does set some high comparison standards.

One thing is true – promotion for both events could’ve been much better. Leo goes to school in Rutherford, and we go to Lyndhurst town park at least twice a week, and we had no idea either event was happening today.

Migrate Your WordPress Website In 6 Steps Using PHPMyAdmin

Ok, the title is quite misleading. While there are 6 steps in this post, each step involves specific tasks. If I were to be totally true, the title would be “migrate your wordpress website in 59 steps using phpmyadmin, webhost manager, ftp, and notepad ++”. Gladly, the entire process is a lot easier than it sounds.

1st Step – Backup Your Database

You’ll need a fully functional, 100% safe backup of your current wordpress mysql database. Check out the steps to backup your db using phpmyadmin.

migrate-wordpress-steps-1

2nd Step – Setup Your New Domain

Whether you’re simply moving the domain to a new server or migrating the entire site to a new domain, you’ll need to have the new server properly setup before importing anything. If you use WHM on your VPS, you can check out the instructions to create a new WHM account.

migrate-wordpress-steps-2

3rd Step – Import Your Old Database

Once your new domain/server is setup, you’ll have to upload your database. If you’re migrating to a new domain, you’ll want to edit your database to replace every instance of [yourolddomainaddress] with [yournewdomainaddress]. I recommend using NOTEPAD++ to do so.
You can follow step-by-step instructions to upload your mysql database using PhpMyAdmin.

4th Step – Make A Local Backup of your File System

This is by far the easiest step – simply FTP into your top folder, select all of your files, and drag them into your computer to create a local backup. As you can imagine, we’re going to upload them to the new server in the next step.

5th Step – Prepare and Upload Files To Your New Server

The only thing you need to do before uploading your files to the new server is to edit your WP-CONFIG.PHP file. You’ll need your database name, username, and password. See below:

edit-wp-config-file

Good old Notepad++ is perfect for this task. Once your wp-config file is ready, you may FTP into your new server and upload all of files.

6th and Final Step – Switch Nameservers

The very last step is to switch your nameservers, pointing them to the new server. The DNS switch usually takes 3-24 hrs to complete, and a good way to check its status is to open a command prompt screen and simply PING the site (type “ping ‘mydomainaddress.com'”) and verify which IP is responding to the PING.

Creating New MySQL Database & Importing Your Old One Using PhpMyAdmin

If you’re migrating a site to a VPS, your first steps are to backup your database and then create a new account for that site in your WebHost Manager. This tutorial constitutes the 3rd step in the migration process.

Log Into The New Site’s CPanel

Once your account is fully migrated, you’ll be able to access CPanel by going to yourdomain.com/cpanel. Until then, visit the following address to access it:

https://YourVPSRootAddress:2083

cpanel-login-whm-address1

To log in, you’ll use the credentials setup during the new account creation process.

Create a new MySQL Database

You’ll need a new database and a new username, and then you’ll add that username to the database, giving it FULL POWERS. See below:

mysql-add-user-privileges1

Log Into your PhpMyAdmin

Once your new database is created, you’ll find it in the left-nav of your PhpMyAdmin. Click on it to begin the import process.

new-acct-import-phpmyadmin2a

Find the .sql backup file you saved during the 1st step and make sure its filesize is not larger than the maximum allowed by your server. The defaul import settings will work for 90% of these cases:

Allow partial import

SQL format

SQL compatibility mode – NONE

Do not use AUTO_INCREMENT for zero values

Once your Database is successfully imported, you’ll be able to see all of its tables. PhpMyAdmin will let you know how many tables were uploaded and if there were any errors.

How To Add a New Domain To Your WebHost Manager (WHM)

The instructions below are helpful when you’ve just bought a new domain and want to include it in your VPS, or if you’re migrating a site into your VPS. Once you properly add a domain to your WHM, you’ll have access to Cpanel and all of its functions, including PhpMyAdmin and FTP, even if you havent yet transferred nameservers.

Log into WebHost Manager (WHM)

This tutorial will assume that you’re adding a 2nd or 3rd domain to your VPS, which means you’ve already created “hosting packages” that fit your server’s configuration.

Click on “Create New Account”

You’ll find it under “Account Functions” on WHM’s left-side nav.

whm-setup-new-account

On the domain field, you’ll want to add your domain’s address without the http:// and include the top-level extension (.com/.net, etc..). Make sure you choose extremely-strong passwords for these credentials will give you access to that account’s CPANEL and ROOT.

whm-setup-new-account-dns

DNS Settings – check the box to use nameservers specified by the domain registrar.

Mail Routing Settings – Using local mail exchanger is the simplest way to go about it.

You can leave all other options as “default” and hit “create”.

Confirm Successful Account Creation

whm-setup-confirm

Look for “List Accounts” under “Account Information” and find your newly-added domain there. If properly setup, you’ll be able to visit the new account by going to YourServerIP/~UsernameChosenDuringSetup.

whm-setup-confirm-2

Done. You May Start Working On The Site!

Your new/migrated domain is now ready to be worked on via FTP, MySql, etc… You’re also able to install WordPress in this domain, but you might run into some issues unless your WordPress General settings specify the YourServerIP/~UsernameChosenDuringSetup as your site’s address.