Norse Technologies Knowledge Base Free Knowledge Articles

Start the PHP file with this:

<?php
/*
Template Name: Snarfer
*/
?>

Posted under WebDev, WordPress

Thanks to Mike Dent’s efforts and OTRS, we now know how a CSV file can be imported into the MySQL database directly. Here is the sample code:

mysql> load data infile '/tmp/otrs_test.txt' into table customer_user
fields terminated by '\t' lines terminated by '\r' (first_name,
last_name, address, postcode, phone1, email, customer_id, valid_id,
create_time, create_by, change_time, change_by, login);

Make sure to import all the required fields (that is, the ones that the database requires, see the table schema for details, >show table x;)

Posted under Freeware, MySQL, WebDev

WordPress provides an easy method with which you can update your posts easily as you view them within your site. It is simply logging into your admin area, then viewing your site as a normal visitor. You can edit articles/posts/pages as you view them.

Here’s how:
Login to your site’s Admin area. This is usually something like “http:///www.yoursite.com/wordpress/wp-admin”.
Once logged in you’ll see a link at the top of the admin page that you’re looking at (just following your website name) that says View Site >> . Click It.
Now you’re viewing your website. Simply go view the page that you want to edit. You’ll notice a link below the article that reads Edit or “Edit this entry” or something to that effect.
Just click thet Edit link, and you’re in edit mode. Edit as usual.

Posted under WordPress