Forums

Hi guys. Great product you have here - and the support is wonderful. I've been using joomla for a while, but my php skills are practically non-existent😶 . Here's my situation:
I'd like to create a muilti-page form where users register to the site and in subsequent steps add in more information. I believe this part will be OK - I've already found answers on how to do this. what I'd like to know though, is this:
I've already got a list of a few hundred members in a csv file. Is it possible to upload this data into 2 tables (the jos_users and my members table) and if so, how would I go about doing this?

thanks
Jo

Hi Jo,

It's certainly possible but you'll need a deal of care and some Joomla + MySQL + PHP experience to do it.

Adding records to your own table is fairly simple - there's a tool here that can turn a CSV file into a MySQL script. You need to carefully set up the column headings to match the table column names first.

Adding users is more complex as several tables have to be updated. I'd probably do it my adding the CSV file into a temporary table then write a script to read the records from that table and create new users from then using the Joomla User Class.

Bob

Thanks for the info Bob. I've found the other 2 tables i'll need to update: jos_core_acl_aro and
jos_core_acl_groups_aro_map. I'll keep trying to beat it into submission - I'll let you know how I fair.
Regards, Jo

Hi all.
Ok - running into some strange issues here. I've got my multi page registration forms set up.
If I run form1 alone, it runs fine - saves the new members' details in the Joomla tables, and at the same time saves data to a separate table as it's supposed to.
However, if I run the Mother form, I get this error message on submit:

Fatal error: Call to a member function bind() on a non-object in /usr/www/users/studiq/incose/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

I've read through the forums and apparently, this error is related to incorrect field names - but i can't find where they're wrong.

Here's the debug from form 1:

Form passed first SPAM check OK
Form passed the submissions limit (if enabled) OK
Form passed the Image verification (if enabled) OK
Form passed the server side validation (if enabled) OK
$_POST Array: Array ( [name] => Shao Kan [username] => kan [email] => [email]kan@justimaging.co.za[/email] [password] => k [confirmpass] => k [chapter] => ksdjf [organization] => sdlksjdfl [division] => lkjfslkj [title] => lkdjfldks [chrono_verification] => kinrv [button_11] => Continue [fd3e0ee5473ac8960eee310b887e000f] => 1 [1cf1] => 75d4b1947c67434baf2f0a83938aeaf6 [chronoformname] => Reg1 )
$_FILES Array: Array ( )
Form passed the plugins step (if enabled) OK
Debug End

I've found that when i try to run form 2 on its own, there's a problem in that no data is saved - no error messages though. Here's the debug for form 2:

Form passed first SPAM check OK
Form passed the submissions limit (if enabled) OK
Form passed the Image verification (if enabled) OK
Form passed the server side validation (if enabled) OK
$_POST Array: Array ( [prefix] => Ms [fname] => Naz [initial] => n [sname] => Murei [nickname] => naz [yobirth] => 2008 [gender] => Female [button_16] => Continue [fd3e0ee5473ac8960eee310b887e000f] => 1 [1cf1] => 75d4b1947c67434baf2f0a83938aeaf6 [chronoformname] => Reg2 )
$_FILES Array: Array ( )
Form passed the plugins step (if enabled) OK
Debug End

Any idea where I might be going wrong?
Regards, Jo

Hi doefoot,

I got this working last week. I think I had to enable the DB Conennection on the Mother Form and on each Child Form (except possibly the last).

You then have to pass the record ID between the forms; I've just posted a snippet to do this in another thread.

Bob