Forums

Hello All !

I have to load my (new) site with an old user base of around 5500 members from an Excel file. I developed a form with ChronoForms to record specific user details (like company name, preferences, ...) that aren't managed by the standard Joomla registration process in a connected table, jos_cs_members.

Since I want to import all my data at once, I will use an extension called Userport to first create my Joomla users, then some MySQL utility (like phpMyAdmin) to import user details from a csv file into my table jos_cs_members.

jos_cs_members has 4 extra columns generated when I created with ChronoForms:

cf_id : an internal unique key for the table, generated by autoincrement. Ex: 34
uid : a string, certainly unique. Ex: IYmM4ZmU3MzZjZTg32ea03098b627bR82ab32373c59a2aa9a
recordtime : a string representing a date-time. Ex: 2010-05-21 – 14:00:24
ipaddress : the ip that made this record. Ex: 12.34.45.67
cf_user_id : the Joomla user id, an external key, from jos_users.id . Ex: 164

I would like to check what I have to put in some of these columns when I'll import everything:
. cf_id: a unique value, preferebly generated with the autoincrement function of the table
. uid: what needs to be in here ? what are the constraints on this column: unique ? can it be left empty ?
. recordtime: load time of the data, same format as example
. ipaddress: mine, just mine
. cf_user_id : taken from jos_users after user creation with a sub-select

I really need some help with the uid column: any idea ?

Cheers,
Paul-Henri

Hi Paul-Henri,

The uid field is a random string that ChronoForms generates to make sure that the record has a unique identifier. You can safely ignore it. You can also ignore the other columns unless you need them.

Bob

Hi Greyhead !

Thanks a lot for the quick answer !
Paul-Henri