How to add information to user profile or database?

Hello again Max,

Everything is working really smoothly now and I'm wondering about how to add information to a person's profile from chronoforms forms.
Basically I have two forms one during registration and another one just after registration which field data needs to be added to the user profile.

The info collected in the form will be then added to the user profile and the registration confirmation email.

Should I add database fields to the user database with the exact same field names as in the form fields and activate the database connection in both forms?
or
Should I create another table?

Thank you,

L.

Hi Laure,

I can't understand, you have a table with user details, now what you wanna do ?

Hello Max,

I created a registration form that collects more information than Joomla usually does.
For example zip code, date of birth....
I need to record this information in the joomla user table.

I want this information to appear in the user profile.

Can you tell me if I should add corresponding fields to the user table like zip-code and date_of_birth and
enable data storage with chronoforms on my user table?

Thanks,

L

Hi Max,

I found some information in your FAQ.

Should I use table jos_chrono_form1 instead of jos_users and that will work with your profile plugin?

I created a table jos_chrono_form1 linked it to one of my forms and everything worked nicely except that it deactivated the
automatic login you had given me in some way. I didn't get automatically logged in after registration like I did without
linking to the database.

I'm still not sure whether I should add field names to jos_com_user table or use jos_chrono_form1 instead.
I'm thinking that if someone delete his profile it wouldn't get deleted in the jos_chrono_form1 so then we would get a distorted view of how many users we have.

Which database does your profile plugin uses to display information collected in the forms?

Thanks,

L.

Hi Laure,

all what you said at the last message is correct, the problem will be deleting users, still you cant add fields to the jos_users, you will destroy the joomla database.

how much time you have for this project ? somehow I'm required to build a user registration/profiles component very soon, it will has the Chronoforms flexibility on registration page/profile design and all the registration/profile features with extra features of course, can you wait ?

Max

Hi Max,

I replied partly in PM.

I have three questions for you.

Is it possible to create a bridge between jos_com_users and jos_com_chronoforms1 so that they share the same profile data or that one gets updated by the other from time to time?

Can't I just have someone create a routine for me that just compares both databases and does something like this
If jos_com_user "email" exists in "jos_com_chronoforms1" then get "email" extra fields from "jos_com_chronoforms1" and display them in profile.

That seems fairly basic to do and could do the trick for me.

How do I get the automatic login to work again?

Thanks a bunch,

L.

Hi Laure,

I replied to the PM there.

regarding the first part here, Joomla 1.5 support this but a special plugin needs to be written, I will write one when I do that project and it may be changed alittle to work with Chronoforms.

I don't know what stopped auto login, a hint for you, a form page with profile plugin needs to be a standalone form, so if you want to have a profile form then this form will have ONLY profile plugin enabled, that's your case ?

Hi Max,

regarding the first part here, Joomla 1.5 support this but a special plugin needs to be written, I will write one when I do that project and it may be changed alittle to work with Chronoforms.

Which of the two please? the bridge between the two tables or the unique profile display from two tables?

I don't know what stopped auto login, a hint for you, a form page with profile plugin needs to be a standalone form, so if you want to have a profile form then this form will have ONLY profile plugin enabled, that's your case ?

I had two registration plugins on two forms when I did the test. I then corrected it to one registration plugin form and one profile plugin form. I hope this fixes the problem.

So what should I do Max?
Should I do the jos_com_chronoforms1 table link and wait for your plugin. I will pay extra for it if you'd like.

Regards,

L*****

The automatic login is gone no matter what I do.
I deleted the interfering form.
I'm lost here. I'm desperate.
I don't know how to make this thing work.
It all worked well and after connecting to the database it's all gone. No more automatic login.

Please help,

L.

Hi Laura,

I was meaning the bridge.

what about creating a new registration form and test the auto login code again ? new table also, delete all your test users!

Regards

Max

Will do Max.

Let me know when you think the bridge will be ready and the price.

Must the database I create have the name jos_com_chronoforms(formname) exactly?

Kind regards,

L********

Hi Laure,

the table name maybe anything, are you in rush for the bridge ?

ASAP?

The automatic login still doesn't work.

L...

Hi Laure,

No idea why the auto login stopped, c'est bizarre, you are testing with a complete new form and tables and users, correct ? are you sure it worked before ?

I will try to make that bridge ASAP.

Regards

Max

Hello Max,

The automatic login works but there's a bug. I used the fields from the jos_com_user table instead of the table I had created and it worked fine.
However when a person is already registered there is no error message and the automatic login fails.

As far as the bridge, do what you can OK. I don't want to put any pressure on you but thank you very much for wanting to help.

Kind regards,


Laure

Hello Max,

Please let me know when your bridge is ready.

That sounds pretty exciting.

L.

Of course, I think it will be ready with V3.1

Regards

Max