Is there anyway to bulk upload links into PHPLD

Discussion in 'Directories' started by overdrive, Nov 28, 2007.

0
  1. #1
    I have a large request for links to be placed in my directory and I want to know if there is anyway to bulk upload the links into my directory instead of putting them in by hand?
     
    overdrive, Nov 28, 2007 IP
  2. mikey1090

    mikey1090 Moderator Staff

    Messages:
    15,869
    Likes Received:
    1,055
    Best Answers:
    0
    Trophy Points:
    445
    Digital Goods:
    2
    #2
    Mack (floppydrivez) was asking this yesterday. The links we in an excel spreadsheet, so he converted that to CSV format and parsed it with php. Perhaps you should ask him.
     
    mikey1090, Nov 28, 2007 IP
  3. overdrive

    overdrive Active Member

    Messages:
    969
    Likes Received:
    39
    Best Answers:
    0
    Trophy Points:
    80
    #3
    That might be a good way, since all the links are in excel anyway. Thanks Mikey
     
    overdrive, Nov 28, 2007 IP
  4. enQuira

    enQuira Peon

    Messages:
    1,584
    Likes Received:
    250
    Best Answers:
    0
    Trophy Points:
    0
    #4
    If you have a column with the category id of each listing then the sql query can easily be generated otherwise you can still do that but will have to move the listings to the appropriate categories by hand from the admin panel.
     
    enQuira, Nov 28, 2007 IP
  5. floppydrivez

    floppydrivez Peon

    Messages:
    453
    Likes Received:
    51
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yeah, I had to go back an revamp the tactic a little bit. It is good you have to do that though because most of them need moderation. Titles, etc.

    On the revamp part, I had to go back and set the status, date modified to a new default value before I could insert all my new stuff to review.

    Beats the hell out of copy and paste though.
     
    floppydrivez, Nov 28, 2007 IP