Thread

Hi there. I’m trying to create a page that displays data that has been imported using “datagrab”. I have the pages being created dynamically, but I need to create the ability for it to only be accessed by the person who belongs to the information. It will only be one page per user, but it has to be password protected for each user.

We will be updating the user information on a daily basis and performing a datagrab import. We just need it to be protected, so each user can only see there information.

Is there a way to use the data being imported to create a username and password for the user or is there a way that the user can register on their own and we can manually link them to the correct user page. I’m grabbing at straws at the moment. We will likely only have a couple hundred users at most. So part of this can be manual.

Any suggestions would be most appreciated.

Hello dodgson,

Thank you for posting your question here on the ExpressionEngine forums.

I am not sure how you would implement that. I am going to move this over to the Community Help Forum. I believe you may get some really good ideas there.

Thank you,

Thanks Shane.

Hey dodgson,

On second thought, I would like to try and understand a bit more about what you are trying to do. Though the process starts with datagrab, what you are trying to accomplish sounds doable in ExpressionEngine.

So a few questions.

1. Are getting member info with the import or just data about a certain user?

2. If so, does that include pre-existing passwords that the members would know and could then use to login to this page?

3. I did some looking around, but I do not see an Add-On that would build members on the fly. I suppose you could do something with htaccess with a local script. This gets a bit deep, but parsing the imported data with a script and then assigning a username/password and writing that to the htaccess file might be a route to take. I have not thought through this one all the way, just an idea at this point.

I think that is enough to get us started. I am grasping at straws a bit myself. I cannot get my head around a procedure that does not involve some system level scripting. I am going to have one of my partner’s in crime take a peek at this as well.

Cheers,

Again… Thanks Shane. Very much appreciated.

Ideally we would like to have the members register themselves for the reward program. My client will be managing the reward credits manually, assigning them on a daily basis based on sales. Originally we thought it might be best to have our client manage an excel spreadsheet that could be imported using datagrab. The problem we’re having is trying to figure out a way to assign the user info to a specific user who has registered.

After tons of consideration, we thought that maybe we could have users register themselves which would add them to a “Rewards Member group”. We could then add the credits through a custom member field. I’m not even sure if you can display these fields in templates. Is this possible?

We’re trying to keep the updates to each of these users as simple as possible for our client. I would be great if we could view users much like you see users who have submitted a form using Solspace’s freeform (it shows you all of the columns with the inserted data). This is easy to view and there’s an edit button where we could add the credit amounts.

The key here is that we need users to only have access to their row of data and we need to display it within a template for them.

Sorry…Very long winded. Let me know what you think and thanks again for taking a look.

Mark

Hi Shane, Just a thought… Freeform does almost everything I need. Is it possible to create a new member through freeform. The user would register with all of the info we require as well as adding the fields to create a new user.

Not sure if freeform would allow a member to only see one row with their data.

Let me know what you think.
Thanks Again

Hey dodgson,

I am not sure about Freeform and registration. I did not see it in their docs, but I think User is more apt to do what you are thinking. User brings the backend magic to the front end. I would think that User might also help limit access on the front end as well.

I believe that to show the data, you could be using the query module. You could then filter on the “Rewards Member group” and show whatever fields you want. More freedom.

An idea. You might run this by the SolSpace community and see what they say. You can post a link here to save yourself some time and typing. I wonder if a combo of FreeForm and User would be helpful or if you only really need FreeForm.

Now that we have a clearer picture of your goal, I will ask my counterpart to take a look at this as well. He has a big brain. Good for solving issues, bad for the inevitable Zombie Apocalypse.

Cheers,

LOL. Thanks Shane, That’s very helpful. I’ve just purchased a copy of user. I will start working with it today. I’ll post back later in regards to its implementation. Thanks for taking the time to look into this.

Hey dodgson,

Awesome! I am totally interested in how this plays out and if User works for this. I will keep an eye out for your update. Best of luck man.

Cheers,