Wordpress: Import list of keywords as posts?

_Austin · Oct 16, 2009

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

_Austin · Oct 16, 2009

OMFG hahahah indexed and ranked in 31 mins... http://www.google.com/search?q=word...s=org.mozilla:en-US:official&client=firefox-a

Claudiu · Oct 16, 2009

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

_Austin · Oct 16, 2009

Claudiu said:
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.

Claudiu · Oct 16, 2009

so you want something like a dictionary ..

_Austin · Oct 16, 2009

Claudiu said:
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

adbox · Oct 16, 2009

would you be down to make a text file for each keyword, and surround the keyword with these tags: <title></title>?

eskimo · Oct 16, 2009

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

adbox · Oct 16, 2009

$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')";

_Austin · Oct 18, 2009

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

swede · Oct 19, 2009

Here you go. This works like a charm.

Save your pennies.

Code:

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

_Austin · Oct 19, 2009

swede said:
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

fullyniche · Jun 24, 2014

Thanks. I'll try this plugin. Hope its help it...

swede said:
Here you go. This works like a charm.

Save your pennies.

Code:

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

Wordpress: Import list of keywords as posts?

_Austin

Junior Member

_Austin

Junior Member

Claudiu

Regular Member

_Austin

Junior Member

Claudiu

Regular Member

_Austin

Junior Member

adbox

Power Member

eskimo

Regular Member

adbox

Power Member

_Austin

Junior Member

swede

Registered Member

_Austin

Junior Member

fullyniche

BANNED

Main Menu

Marketplace

Making Money

BlackHatWorld

Other