PDA


View Full Version : [HOW DO I] Import a list of urls


FrontRunner
07-19-2008, 05:51 AM
I just installed vBa Links Directory on a website I'm currently developing. I've got a txt-file with about a 1000 urls that I would like to see them in a vBaLD Category.


Is it possible to import this list of urls?
After the import, is it possible to have title and description fields filled automatically?



Hopefully this post can be renamed to [HOW TO]

Brian
07-19-2008, 03:57 PM
Sorry, but I don't think there's going to be an easy way to do that.

FrontRunner
07-27-2008, 12:54 PM
To bad there isn't an easy option within vbLink to import a list of urls. Maybe for a future version. However I found out that importing can be done using phpmyadmin and MS Excel.

My steps:


Open your db with phpMyAdmin
export the adv_links table (export setting: CSV for MS Excel data)
Open adv_links.csv with MS Excel
Add the url list to your excel sheet (fields i filled where: "linkid","name","linkurl","linkrecipurl","catid","description","keywords". I copied the information for the other fields from a previous record)
Export the csv file
Import the csv file to the adv_links table in phpMyAdmin (Format of imported file is CSV, just set the other option as needed).
Press start.

Thats it!