Would be sweet to have this feature so you dont have to go via phpmyadmin... yeah yeah.. I´m lazy

I use an extern php script to dump the user database as an excel file. If it's something like that you had in mind I will post the script tonight when I get home

Mackelito wrote:

Would be sweet to have this feature so you dont have to go via phpmyadmin... yeah yeah.. I´m lazy

You can try this Mambo component:
mamboforge.net/frs/?group_id=2039&release_id=5691

mijji wrote:

I use an extern php script to dump the user database as an excel file. If it's something like that you had in mind I will post the script tonight when I get home

That script may be just what we need. Mijji, If you could post it that'd be great! We'd like to use CB as our member management for a not-for-profit org, but it's a little bit awkward. Plus, we have multiple users who would need to use it-- not ones I want playing around in the database...

Anyone know how difficult would it be to write a script that automatically updated user info from a csv file? I used a script I found on the Mambo forums to import my original list, which worked pretty well. I wouldn't trust it to overwrite selective info, though.

Any thoughts are welcome!
Thanks

Assuming your using Windows, you could install a MySql ODBC driver and write your script in MS Access. Just hook up a "linked" table to your MySql tables... I think MS Access can handle some basic CSV conversion...

Don't know the specifics at the moment... I think I got my ODBC driver from MySql's website... can get more info if needed.

Mijji's script works realy well, but's not a component or anyhow connected to Joomla. To make real use of it in this environment, I see having it built into Community Builder, maybe as a plug-in (?) so that in the backend, there would be an icon near "new" and "delete" etc that says "export."

The script uses MySQL to get very specific results from any table you want, so maybe it would be better as a part of CB proper, as "export manager," along side "field manager," and "tab manager."

Or maybe it would be most useful as a Joomla component, to export anything from the database to excel.

I'm willing to give it a try, but I'm not much of a programmer. Does anyone have experience with this? or thoughts on the matter?