Wordpress: Import list of keywords as posts?

_Austin

Junior Member
Joined
Apr 9, 2009
Messages
147
Reaction score
39
I have a list of keywords and I would like to turn each keyword into it's own
post. I don't feel like making it all SQL and I don't feel like making a script to
do it, that's last resort.

Anyone know of a plugin or a little hack I could do to make this process
easier? I could always hire a grunt from DP.

_Austin
 
there is a plugin that makes posts based on keywords .. WPRobot it's his name ..
it crawls the web based on specific keyword than makes a post with article it finds
 
there is a plugin that makes posts based on keywords .. WPRobot it's his name ..
it crawls the web based on specific keyword than makes a post with article it finds

Hey thanks for the response man, yeah on my search I found that but
it's not exactly what I'm looking for. Sounds weird but I just need the
keywords made as the post title and then just a blank post made.
 
so you want something like a dictionary ..

No, I just need the blank posts made with the keywords as the titles, I have plans
for the posts later on as I keep working on the site.

_Austin
 
would you be down to make a text file for each keyword, and surround the keyword with these tags: <title></title>?
 
Here is a script that i used for some other stuff.
make a text file called xyz.txt
you will need the values seperated by a comma (if they not you can change the script with one line of code)

this will store the entries into a table (which you must create before hand)
then export the SQL from that table, and import it into the wordpress titles table
Hope it works!


<?php

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'blogtitles';
mysql_select_db($dbname);



$handle = @fopen("xyz.txt", "r"); // Open file form read.

if ($handle) {
while (!feof($handle)) // Loop til end of file.
{

$theData = fgets($handle, 4096); // Read a line
if (strlen($theData) > 2) {
if (strrpos($theData, ",") === false ) {
$blogtitle = substr($theData, 0, strpos($theData, ",") ); // goes from character position 0 to the first occurance of a comma


$queryinsert = "INSERT INTO yourDB.blogtitles (blogtitle)
VALUES ('$blogtitle')";
$result= mysql_query($queryinsert) or die ("error in query: $query. " . mysql_error());

}

}

}
fclose($handle);


?>



gimme a shout if you need help with it
 
$queryinsert = "INSERT INTO yourDB.blogtitles (blogtitle)

this isnt a wordpress query tho

it would have to be something like this

$insert_query = "INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES";

$insert_query .= "('', '1' , ' ' , ' ' , '$postcontent' , '$posttitle' , '', ' ' , ' ',' ',' ', ' ' ,'','', ' ', ' ', '', '0', ' ', '0', 'post', '', '0')";
 
Thanks for the script eskimo, I went ahead and just hired some guy from Bangladesh to do
it for pennys per keyword. I love DP!

_Austin
 
Here you go. This works like a charm.

Save your pennies.

Code:
http://wordpress.org/extend/plugins/mass-page-maker/

Damn, that could of saved quite a few pennies.

Thanks,
_Austin
 
Back
Top