Thread

Hi,

I’ve set up member registration in a site, and I’ve created custom member fields. It’s all working fine.

What I need to do now is pull up a member list that includes all of the data I’m getting from the registered users. The Control Panel shows me only the default fields that come with EE.

How do I get all the information in one list?

And BTW, does anyone know of a good Export to Excel plugin for member lists?

Thanks,

G.

Take a look at the Custom Profile Data Tag.

Thanks Ingmar, I’ll do that.

Do you know about exporting Excel files of members?

Thanks for your help.

G

No, I’d just build a template to create a CSV and let Excel import that, much easier.

Again,

Thanks for answering,

: )

g

No worries 😊

The Custom Profile Data tag is great… but does it allow me to get the data for members only one by one?

Can I loop through all of them and generate say a nice table of my users?

Thanks,

G

The Custom Profile Data tag is great… but does it allow me to get the data for members only one by one?

Can I loop through all of them and generate say a nice table of my users?

Thanks,

G

Depending upon how many users you have you could place an embedded template that has the custom profile data tag in it inside a query which retrieves the member_ids.

If you had many many users though then a SQL query should be able to do it too.

Embedded Template Method
- Main Template

{exp:query sql="

SELECT member_id FROM exp_members

"}

{embed="embedded-profiles" query_member_id="{member_id}"}

{/exp:query}

- Embedded Template (embedded-profiles)

{exp:member:custom_profile_data member_id="{embed:query_member_id}"}

<div>{age}</div>
<div>{gender}</div>

{/exp:member:custom_profile_data}

Written very quickly but should hopefully work.

Best wishes,

Mark

Mark thanks so much. I’ll try that out. Sounds like a great idea.

: )

g.

Mark thanks so much. I’ll try that out. Sounds like a great idea.

: )

g.

No problem, hope it works okay. Let me know if there are any problems with it.

Best wishes,

Mark

Mark, you got man!

Thanks so much. As usual, you were very helpful.

Mark, you got man!

Thanks so much. As usual, you were very helpful.

No problem, any time.

Best wishes,

Mark