Make a WP posts database form an excel spread sheet or text file?

Discussion in 'SQL' started by CpaCash, Dec 15, 2010.

  1. CpaCash

    CpaCash Make Money Online

    Joined:
    Jun 8, 2010
    Messages:
    272
    Likes Received:
    1
    Trophy Points:
    0
    Ok so i have a wordpress site for game downloads, i finally found a full list of games with the title and download link and copied them into an excel spread sheet. the list has over 700 dl links.

    being that its such a big list i wanted to find a way to convert the list into an sql database to use as my post on the wp site, or take it a step further and add the full description.

    also how can i add html code to mask the link before uploading so i dont have to do it one by one once the list is imported?

    but i have no ideas how to do this, i looked around but still cant find out how to do this, any ideas? or should i just outsource this type of job?

    thanks
     
  2. NorCalRox

    NorCalRox Make Money Online

    Joined:
    Nov 23, 2010
    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    0
    This is a good question. I'd like to know the answers to these questions, too.
     
  3. wot

    wot New Member

    Joined:
    Feb 6, 2012
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    localhost
    You are over complicating it by trying to load the excel file. Save it as csv and load the values into an array. Post the values from the array to the database.

    That should be enough to get you going. If you have problems with that post here and I'll give you another shove in the right direction.

    Wow...just realized the is over a year old. Damn tapatalk and its monochromatic theme.
     

Share This Page