1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Wordpress: Import list of keywords as posts?

Discussion in 'Blogging' started by _Austin, Oct 16, 2009.

  1. _Austin

    _Austin Junior Member

    Joined:
    Apr 9, 2009
    Messages:
    147
    Likes Received:
    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
     
  2. _Austin

    _Austin Junior Member

    Joined:
    Apr 9, 2009
    Messages:
    147
    Likes Received:
    39
  3. Claudiu

    Claudiu Regular Member

    Joined:
    Feb 28, 2009
    Messages:
    287
    Likes Received:
    81
    Location:
    127.0.0.1
    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
     
    • Thanks Thanks x 1
  4. _Austin

    _Austin Junior Member

    Joined:
    Apr 9, 2009
    Messages:
    147
    Likes Received:
    39
    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.
     
  5. Claudiu

    Claudiu Regular Member

    Joined:
    Feb 28, 2009
    Messages:
    287
    Likes Received:
    81
    Location:
    127.0.0.1
    so you want something like a dictionary ..
     
  6. _Austin

    _Austin Junior Member

    Joined:
    Apr 9, 2009
    Messages:
    147
    Likes Received:
    39
    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
     
  7. adbox

    adbox Power Member

    Joined:
    May 1, 2009
    Messages:
    658
    Likes Received:
    107
    Home Page:
    would you be down to make a text file for each keyword, and surround the keyword with these tags: <title></title>?
     
  8. eskimo

    eskimo Regular Member

    Joined:
    Dec 1, 2008
    Messages:
    474
    Likes Received:
    178
    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
     
    • Thanks Thanks x 1
  9. adbox

    adbox Power Member

    Joined:
    May 1, 2009
    Messages:
    658
    Likes Received:
    107
    Home Page:
    this isnt a wordpress query tho

    it would have to be something like this

     
    • Thanks Thanks x 1
  10. _Austin

    _Austin Junior Member

    Joined:
    Apr 9, 2009
    Messages:
    147
    Likes Received:
    39
    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
     
  11. swede

    swede Registered Member

    Joined:
    Oct 27, 2007
    Messages:
    50
    Likes Received:
    19
    Occupation:
    I Lease Servers on Second Life
    Here you go. This works like a charm.

    Save your pennies.

    Code:
    http://wordpress.org/extend/plugins/mass-page-maker/
     
    • Thanks Thanks x 2
  12. _Austin

    _Austin Junior Member

    Joined:
    Apr 9, 2009
    Messages:
    147
    Likes Received:
    39
    Damn, that could of saved quite a few pennies.

    Thanks,
    _Austin
     
  13. keywordspot

    keywordspot Jr. VIP Jr. VIP Premium Member

    Joined:
    Dec 17, 2013
    Messages:
    4,294
    Likes Received:
    1,480
    Gender:
    Female
    Occupation:
    contenu visuel
    Location:
    At Hill Station
    Thanks. I'll try this plugin. Hope its help it...