Thread

I am working on a website that uses ExpressionEngine v 1.6.9.

I need to build a password protected area where each team coach can login and be able to ‘only’ view / download the registrations that signed up for ‘their’ location.

Does this sound like a module that anyone has heard of out there?
or do you have any advice on some open source code I can use?

I’ve been trying to search but the keywords I’m using don’t seem to be the right ones cause I’m not finding anything.

Any help is greatly appreciated!

Thank you so much!

What are “Registrations”?

You may not need a module - just some member groups setup for each location and then templates with access privileges set per member group. 

But it depends on what the content is and where it’s coming from…

Thanks Boyink!

Since I posted, I did see ‘members’ and groups and was hoping that I might be able to use this to help me meet my goal.

Let me clarify further…

There is a registration form on the site. I’ve used freeform module.
The registration form has a drop down that specifies a specific site location.
Each division coach, controls 1 specific location.

So each division coach will get a login account to access the password protected area.

Once they logged in, my goal is for them to get to a page where they will be able to view or download all the registrations for the year ONLY at ‘their’ site location. They would not be allowed to view other divisions registrations.

Another function that I thought of while writing this is, Once they login…they’ll need a way to only view the registrations for the current year.  Since the data from previous years will always be there, it might need to be a search filter of some kind.

If you have heard of any resources that might be able to assist me in this project I would appreciate it!
Like I said, I’m not really even sure what keywords I should look up.

Any advice is greatly appreciated! Thank you!

What I ultimately want,

Just to clarify - because we’re using a word that might have >1 domain-specific meanings.

“Registrations” - in EE-land you can provide memberships in ExpressionEngine to have registered/logged-in users on the site.

But it sounds like registrations have a different meaning for you - what are they? When coaches “download” them - what does that mean?  What type of file would they need?

It might help also to give you some background into the site…

This site is for an athletic program for kids. People can ‘register’ for the program online using this email form…or what I was calling their ‘registration’ form to sign up for the program.

When they sign up, the registration email form, submits to an email address but also gets added to the mysql database. I used ‘freeform’ to setup the email forms on their site.

Right now, when I login to the expression engine ‘admin’ area for their site, I can go into the free form area and see a running list of ALL the form submissions on their site.  The problem is right now, that entire list can be exported into an excel document. With the amount of records, it’s cumbersome to manually go through the list and sort all the registrations per location to give to the coaches.  However, if they had an area where they could login to gather the information they needed themselves…it would be much more efficient.

For the coaches, I think excel would be fine. Whatever format would be easiest to implement.

Hmm…

The challenge you’re facing is that with all the data in the Freeform table you’ve lost all the EE functionality (other than writing your own queries using the Query module) available to you.  Freeform has an entries tag with some parameters but it’s not as powerful as the EE channel entries tags.

I would suggest instead looking at using Safecracker to present a public form that instead submits its content to a standard EE channel.

This way you could build coach-specific templates to present the data and in those templates specify whatever categories etc are appropriate for the specific coach.

You’ll lose a specific Excel format but could just create an EE template that presents the list in a comma delimited format that could be copied into Excel.

Thank you for your suggestions. At this point unfortunately, I’ll need to keep the forms the way they are developed (with freeform) and see what I can do to work with what i have.

Quoted: “This way you could build coach-specific templates to present the data and in those templates specify whatever categories etc are appropriate for the specific coach.”

This is what I was ‘hoping’ I could do with the data..i thought of it the other day…hopefully there IS a way for me to use the data from that free form table and set them up as you described as templates specfic to each person.

Any other suggestions of course are appreciated as well!  I might have to just build a separate area all together ‘outside’ of expression engine for this so I can just pull the database and manipulate the data with standard php code.  I was just hoping for a self contained easy way to manipulate the data within expression engine…

Well..the challenge is your data is only “sorta” in EE.  It’s in the EE database but captured with a 3rd party tool that doesn’t integrate fully back into the rest of how EE functions.  It’s one of the potential downsides of going outside of native EE functionality.  Freeform is great for basic contact type emails and data submission but you’re really needing more than that.

You still could look to use EE’s member groups and templates for coach log-ins, and then do any custom queries or PHP code in those templates - it’s all available to you at the template level.

I understand. Thanks for the input!

I have started looking into putting php code in the system…but I see messages though that warn you about enabling php code in the system.

Not sure if you are familiar with that message or not. I’m curious if that warning really applies to what I’m trying to do though…since it will be password protected pages.

Depends greatly on what the PHP is going to do.  If all you’re going to do is query/present specific content to different coaches I’m not sure what the PHP need is?

If you’re going to build updating mechanisms that open up the database to changes then you’re on your own as far as understanding and dealing with the risks..😉

The first notion is exactly right…it really will just be displaying specific content to depending on ‘who’ logs in.

Here’s hoping for the best!
Have a great day Boyink!