Is it possible to export a list of all our categories to an excel doc or some other doc?
same thing with registered members.
thx
Michelle
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
October 22, 2007 10:05am
Subscribe [3]#1 / Oct 22, 2007 10:05am
Is it possible to export a list of all our categories to an excel doc or some other doc?
same thing with registered members.
thx
Michelle
#2 / Oct 26, 2007 6:56pm
bumping this up hoping to get some attention
#3 / Oct 27, 2007 1:32am
PHPMyAdmin actually has the ability to export table data in the form of CSV. You could then open that file in Excel and if you are good with spreadsheets then you would probably be back into your element.
A little trickier is data that extends across multiple tables. You could still do some things with Excel though. For instance, each member is given a member ID. If you needed to get member data from another table then that data would also have the member ID attached (needs that ID to be associated with the correct member.) If you have the data for both tables you could import each into two different Excel spreadsheets and then sort the rows by member ID. You could then copy and paste columns to get the data formatted as needed. Does that make sense?
Probably the hardest part of all this would be figuring out how the tables relate to each other and which table holds the data you need. If you have never worked with PHPMyAdmin then that could be difficult as well.
Otherwise, there are no automatic methods or scripts that I know of.