I believe PHPMyAdmin has a CSV option. Otherwise, I suppose you might try making a custom RSS template where it's actually a CSV instead of RSS... but it's going to timeout if you have thousands of listings.
Thanks Paul. I did try phpmyadmin and although it exports it to csv I can't get the listings as one row and fields as separate columns. Tried different ways to export it but none would do it correctly.
Unfortunately I'm not profficient enough to do custom rss as csv.
Comments on Export Links
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Is there a way that I can export all data into a .csv file? So the file would contain a record for each link containing...
cat name, alias cats, link name, link description and a custom field.
TIA
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I believe PHPMyAdmin has a CSV option. Otherwise, I suppose you might try making a custom RSS template where it's actually a CSV instead of RSS... but it's going to timeout if you have thousands of listings.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Thanks Paul. I did try phpmyadmin and although it exports it to csv I can't get the listings as one row and fields as separate columns. Tried different ways to export it but none would do it correctly.
Unfortunately I'm not profficient enough to do custom rss as csv.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
In the "lines terminated by" spot put \r\n and in fields terminated by put a comma instead of the default semicolon. That should work.