Thread

Hello people,

I need a bit of help with my member list.

I was provided with a list of 300+ members that needs to be imported into EE. Every member has a bunch of info, so i’ll create custom fields.

That’s where the fun starts. The Excel file I was given lists every member with multiple addresses as separate rows, so I’ve got duplicate members, and emails, which messes up the import process.

So plan B would be to reformat the Excel file, so that each row has address1, zipcode1, address2, zipcode2…

It sure makes a lot of sense from a database design point of view, but when I call my custom fields in the search dropdown included with the member list template, I end up with Zip Code 1 and Zip Code 2 as search options, which is obvisouly confusing.

I need to be able to search multiple database fields for zip codes at the same time.

So… i’m stuck. Any suggestion would be greatly appreciated.

Cheers - Nicolas.

Still trying to figure this out… what if I use the query module inside a regular template to build my own search function?

I have no SQL experience whatsoever… can anyone direct me to a resource that could guide me towards coding a simple search field?

This here below returns results, but I would need a way to input a search term.

Thanks in advance.

————

{exp:query sql="SELECT screen_name FROM exp_members WHERE screen_name = 'Search Term' "}
{screen_name}
{/exp:query}