Category Archives: General

How to Install Google Analytics on a WordPress Blog

If you are interested in finding out statistics about visitors to your blog, the best free way of adding tracking to your blog is to install Google Analytics. Google provides a free Analytics service – you create a new account with Google and they give you some code to place on your website which lets Google track visitors to your site. You can log into your Analytics account on Google and see stats such as the number of visitors from different countries, the number of times specific pages were viewed and so on.

You can sign up for Google Analytics here. The instructions for signing up and enabling tracking are fairly easy to follow if you are capable of adding a HTML file to your webhost account. Placing the tracking code on a WordPress blog though is not as obvious as it might be with a static website. However, the method is similar – all you need to do is place the tracking code just before the </body> tag in your WordPress theme.

To find the </body> tag in your current theme, follow these steps:-

  • Log into your WordPress blog as an administrator.
  • Under the Appearance menu on the left, click the Editor option.
  • Click on the Theme files options on the right to find one that contains the </body> tag.

The </body> tag may be in the footer.php file on your theme but on mine I found it in a file called end.php.

  • Paste your tracking code into the theme file just before the </body> tag and then save the file.

google-analytics-wordpress

Your Google Analytics account should now show stats for visitors to your blog. It may take up to 24 hours for the first visitor stats to appear in your account.

Importing CSV data from Excel into phpMyAdmin

When importing CSV data saved from Excel into a MySQL database using phpMyAdmin, I was getting an error indicating that there was an “Invalid field count in csv input on line 1″. The settings in phpMyAdmin asked for fields to be delimited by double quotes (“field”) but even after doing that I was still getting the same error message.

In order to get the input to work, I resaved the Excel file as a CSV (and didn’t place quotes around the columns) then removed the first row containing the field titles. In phpMyAdmin I then chose the following settings:

Format: CSV using LOAD DATA
Columns terminated by ,  (not the default of ; )

All other settings were left at their default.

I was then able to successfully import the CSV file.

New Help Desk Launched

As part of our ongoing efforts to improve customer service, SliQTools has now opened a new support help desk feature at support.sliqtools.co.uk. The new help desk software allows customers (or potential customers who are using trial versions of our software) to submit support or sales tickets and track their progress to closure.

The new help desk brings a number of benefits to our customers such as the the ability for customers to see their old tickets and replies. From SliQTools point of view, an added bonus of the help desk is that it provides us with a mechanism to expand our knowledgebase of frequently asked questions. The help desk lets our support staff to write articles to support tickets. These articles then become available for other customers to search through. As the knowledgebase builds up content, customers should increasingly be able to find answers to common support queries so that their problems are solved more quickly.