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:
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
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 ?
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
Once PEAR is installed on your server.
Install Net_URL 2:
cmd > pear install Net_URL2-0.3.0
cmd > pear install HTTP_Request2-0.5.1
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
Command: cd c:\wamp\bin\php\php5.3.0
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:
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:
;phar.require_hash = On
3) Uncomment the “;phar.require_hash = On” line by removing the semi-colon.
4) Change “On” to “Off”.
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