GUID to Names?
By Surbhi Gupta
I am trying to get the names of the user , by extracting it by manual SQL queries on PHPmyadmin. But I get it in terms of guid's , And i want it in terms of names of people , ANY IDEA how to convert this guids to names in MYSQL queries?
Beginning Developers
This space is for newcomers, who wish to build a new plugin or to customize an existing one to their liking
- Jerome Bakker@jeabakker
Jerome Bakker - 0 likes
- Surbhi Gupta@I_Am_surbhi
Surbhi Gupta - 0 likes
- emmanuel gbi@friendz_Diary
emmanuel gbi - 0 likes
You must log in to post replies.there is a table "users_entity" which holds the basic information of a user (name, username, email).
My question would be why are you using PHPMyAdmin to get this information? There are tools on the community like Profile Manager which allow you to export information about the users.
I want to make a graph in GEPHI so that has to be generated in the CSV format , which only PHPmyADMIN can do , do you know any plugin that can export information in terms of CSV or GEFX format ?
i dont know how soon you want it but i too have been trying to do this...let me see if i can get it done before end of next week...but follow @ jerome Bakker's advice; profile manager exports to csv