The location is there; it is the "user_from" field. You are correct about the website field not being available. Try adding the following toDaffy-7 wrote:I have (finally) got the TOOL working and understand it but the User Import 'form' does not show all the basic user's UCP profile fields in the Board's display ie 'Website' and 'Location'.
Code: Select all
'user_website' => 'String',
Code: Select all
'user_from' => 'String',
What do you mean they are added but not overwritten?Daffy-7 wrote:I have created custom profile fields but they are added, not overwritten, in the UCP display.
A little clarification from me - sorry.prototech wrote: Daffy-7 wrote:I have created custom profile fields but they are added, not overwritten, in the UCP display.
What do you mean they are added but not overwritten?
What does the error say when you try to add it?Daffy-7 wrote:The system did not like me trying to add another profile field for 'firstname' (or whatever). Apparently the database needs adjusting for this some other way? I would like to know how!
Re-reading my reply I realise I may have given the wrong impression; I tried to include (add) a new field for 'user_firstname' in the file includes/acp/acp_import_users.php as I did to include the 'user_website' field name as suggested!prototech wrote:What does the error say when you try to add it?
Code: Select all
General Error SQL ERROR [ mysqli ] Unknown column 'user_firstname' in 'field list'  SQL INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt, user_from, user_birthday, user_firstname) VALUES (content removed) BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/includes/db/dbal.php LINE: 754 CALL: trigger_error() FILE: [ROOT]/includes/db/mysqli.php LINE: 182 CALL: dbal->sql_error() FILE: [ROOT]/includes/functions_user.php LINE: 250 CALL: dbal_mysqli->sql_query() FILE: [ROOT]/includes/acp/acp_import_users.php LINE: 389 CALL: user_add() FILE: [ROOT]/includes/acp/acp_import_users.php LINE: 227 CALL: acp_import_users->import() FILE: [ROOT]/includes/functions_module.php LINE: 507 CALL: acp_import_users->main() FILE: [ROOT]/adm/index.php LINE: 74 CALL: p_master->load_active()
firstnamein the form provided in that page and select
Single text fieldand submit. Adjust the settings as necessary in the next two pages. Once the profile field is created, it will show up under the Custom Values section of the Import users page.
Thank you 'prototech'. I did include the custom profile field for 'firstname', as you described.prototech wrote:Type in firstname in the form provided in that page and select Single text field and submit. Adjust the settings as necessary in the next two pages. Once the profile field is created, it will show up under the Custom Values section of the Import users page.
The most recent update of this convertor is herepierrelabrecque wrote: So, I google it, and what I found is viewtopic.php?f=65&t=1494875, which seems the more recent post I can find...
As far as I know: yes. I fixed all known anomalies and I tried to add the maximum operator or input data error diagnostics.pierrelabrecque wrote:Please could you tell me if this tool is stable ?
I did very limited regression tests with the 3.0.11. So again as far as I know it is compatible with this release.pierrelabrecque wrote:compatible with 3.0.11 ?