Webmastersite.net
Register Log In

Export Links

Comments on Export Links

babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
Posted May 13, 2011 - 11:08 AM:

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
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted May 14, 2011 - 7:52 PM:

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.
babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England

Total Topics: 391
Total Comments: 1303
babrees
Posted May 14, 2011 - 11:46 PM:

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.
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted May 15, 2011 - 11:38 PM:

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.