almost-there

Almost there… last leg of the journey: Go there, say your name and that a letter is waiting for you here. POK.

Count the number Unique Items in Excel

I have stumble upon the only way to calculate the number of unique items in Excel and I am taking notes here

Add a column to the database and then add that field to the pivot table.

For instance if we want to count the unique occurrences of URL/Keyword, we shall add in the raw data:
– the row URL/Keyword in the raw data.
– In the first data row, enter a formula that refers to the URL and Kws columns. For example:


  =IF(SUMPRODUCT(($A$2:$A2=A2)*($C$2:$C2=C2))>1,0,1)

Copy the formula down to all rows in the database.
Then, add the field to the data area of the Excel pivot table.

source: Pivot technics

Google Farmer update in the UK

Has Sunday been a sunny day in the UK or has the Panda Google’s update already stricken? Crawl rates show that the bots are done indexing the UK sites. It should be a matter of weeks. Any thoughts ?

symfony propel-build-model wamp error due to XSL extension

Description:   I was trying to run the symfony PHP framework. I tried to build the model using command
php symfony propel:build-model.

And it gave error Could not perform XSLT transformation. Make sure PHP has been compiled/configured to support XSLT.

Environment: Wamp server 2.0, PHP 5.2.5, Apache 2.2.6.

Reason: PHP-XSL extension is not enabled. By default, Wamp server doesnt enable php-xsl php extension. and php-xsl is required.

Solution: Enable php-xsl extension.

left click on WAMP’s tray icon and than in PHP>PHP extensions select php-xsl and enable it.But there is one more php.ini file, which WAMP won’t change, we need to do it by hand, open: C:\wamp\bin\php\php5.2.5\php.ini and remove “;” from the line xsl.dll

Number of backlinks of a domain

There is a redirect on the URL you want to measure the number of BL with SEO quake : problem

Use the yahoo BL capabilities by searching : linkdomain:SITE.com -site:SITE.com

note: use as many -site: as needed to remove sidewides links

Installing pear on WAmp

TRY

Command: cd c:\wamp\bin\php\php5.3.0

Command: go-pear.bat

French version (http://www.6ma.fr/tuto/installer+pear+avec+wamp-455)

IF IT DOESN’T WORK if you are using php5.3.0 so you have refer to http://blog.pear.php.net/2009/07/01/php-53-windows-and-pear/

1) Locate the “php.ini” file.  In my case, I found it at this path:

C:\wamp\bin\php\php5.3.0\php.ini

Don’t use the WAMP system tray icon to edit this file. It didn’t work when I tried – you have to manually locate it.

2) Find the following line, in bold:

; http://php.net/phar.require-hash
;phar.require_hash = On

; http://php.net/phar.require-hash

;phar.require_hash = On

3) Uncomment the “;phar.require_hash = On” line by removing the semi-colon.

4) Change “On” to “Off”.

; http://php.net/phar.require-hash

phar.require_hash = Off

Fill in the fields. Done

ADD the Pear variable in your environment variables and check that the include_path=”.;c:\wamp\bin\php\php5.3.0\pear”

is in both of Wamps php.ini located at c:\wamp\bin\php\php5.3.0\php.ini and C:\wamp\bin\apache\apache2.2.11\php.ini.

Restart your computer


Installing the http_request package:

pear install Net_URL2

pear install HTTP_Request2-0.4.0 => install ok