Error when importing users

9 months 3 weeks ago #306571 by aalisg
Hello,

We are running a website using latest version of Joomla! which is 3.8.10 and latest version of Community builder wich is 2.2.1.

We are trying to import a large amount of users using CB Juice but when we test the import process we get this error:

CB Version =2.2
CBJ2_HEADER_VARIABLES are
Array ( [0] => name [1] => username [2] => email [3] => password [4] => block [5] => sendEmail [6] => registerDate [7] => lastvisitDate [8] => activation [9] => params [10] => lastResetTime [11] => resetCount [12] => otpKey [13] => otep [14] => requireReset [15] => user_id [16] => alias [17] => firstname [18] => middlename [19] => lastname [20] => hits [21] => message_last_sent [22] => message_number_sent [23] => avatar [24] => avatarapproved [25] => canvasapproved [26] => canvasposition [27] => canvas [28] => approved [29] => confirmed [30] => lastupdatedate [31] => registeripaddr [32] => cbactivation [33] => banned [34] => banneddate [35] => unbanneddate [36] => bannedby [37] => unbannedby [38] => bannedreason [39] => acceptedterms [40] => cb_geolat [41] => cb_geolng [42] => cb_privacy_settings [43] => cb_section [44] => cb_type [45] => cb_title [46] => cb_spousename [47] => cb_quality [48] => cb_promotion [49] => cb_lastclass [50] => cb_childfirstname [51] => cb_childlastname [52] => cb_childsection [53] => cb_childpromotion [54] => cb_childlastclass [55] => cb_country [56] => cb_address [57] => cb_address2 [58] => cb_zipcode [59] => cb_city [60] => cb_highschoolfonction [61] => cb_schoolsubjectdepartment [62] => cb_endofactivityyear [63] => cb_pro1company [64] => cb_pro1position [65] => cb_pro1activitysector [66] => cb_state [67] => cb_phone [68] => cb_fax [69] => cb_registered [70] => cb_validemailaddress [71] => website [72] => location [73] => occupation [74] => interests [75] => company [76] => address [77] => city [78] => state [79] => zipcode [80] => country [81] => phone [82] => fax [83] => cb_alumnistartyear [84] => cb_campus [85] => cb_baccalaureatetype [86] => cb_unisteps [87] => cb_uni1city [88] => cb_uni1name [89] => cb_uni2city [90] => cb_uni2name [91] => cb_uni2subject [92] => cb_uni3city [93] => cb_uni3name [94] => cb_uni3subject [95] => cb_uni4city [96] => cb_uni4name [97] => cb_uni4subject [98] => cb_uni5country [99] => cb_uni1country [100] => cb_uni1diploma [101] => cb_uni2country [102] => cb_uni3country [103] => cb_uni4country [104] => cb_uni2diploma [105] => cb_uni3diploma [106] => cb_uni4diploma [107] => cb_uni5city [108] => cb_uni5name [109] => cb_uni5diploma [110] => cb_uni5subject [111] => cb_uni1subject [112] => cb_startofactivityyear [113] => cb_uni1profile [114] => cb_secondaryemailaddress [115] => cb_emailapproval [116] => cb_uninames [117] => cb_unicountries [118] => cb_unicities [119] => cb_unidiplomas [120] => cb_unisubjects [121] => cb_prosteps [122] => cb_uni1state [123] => cb_uni2state [124] => cb_uni3state [125] => cb_uni4state [126] => cb_uni5year [127] => cb_uni1year [128] => cb_uni2year [129] => cb_uni3year [130] => cb_uni4year [131] => cb_uni5years [132] => cb_uni5state [133] => cb_pro1year [134] => cb_pro2company [135] => cb_pro2activitysector [136] => cb_profirststepfieldactivity [137] => cb_pro1country [138] => cb_pro2country [139] => cb_pro3country [140] => cb_pro4country [141] => cb_pro5country [142] => cb_pro3company [143] => cb_pro4company [144] => cb_pro5company [145] => cb_pro1state [146] => cb_pro2state [147] => cb_pro3state [148] => cb_pro4state [149] => cb_pro5state [150] => cb_pro1city [151] => cb_pro2city [152] => cb_pro2position [153] => cb_pro2year [154] => cb_pro3year [155] => cb_pro3city [156] => cb_pro3activitysector [157] => cb_pro3position [158] => cb_pro4year [159] => cb_pro4city [160] => cb_pro4activitysector [161] => cb_pro4position [162] => cb_pro5year [163] => cb_pro5city [164] => cb_pro5activitysector [165] => cb_pro5position [166] => cb_procountries [167] => cb_procities [168] => cb_proactivitysectors [169] => cb_procompanies [170] => cb_propositions [171] => fb_userid [172] => twitter_userid [173] => linkedin_userid [174] => windowslive_userid [175] => google_userid [176] => instagram_userid [177] => foursquare_userid [178] => github_userid [179] => vkontakte_userid [180] => steam_userid [181] => tumblr_userid [182] => cb_antispam_ipaddress [183] => cb_antispam_captcha [184] => cb_cbjuicepassword [185] => reddit_userid [186] => twitch_userid [187] => stackexchange_userid [188] => pinterest_userid [189] => amazon_userid [190] => yahoo_userid [191] => paypal_userid [192] => disqus_userid [193] => wordpress_userid [194] => meetup_userid [195] => flickr_userid [196] => vimeo_userid [197] => line_userid [198] => spotify_userid )
Error in register store: Veuillez saisir votre nom.
rodrias@posteo.es Rodrigo Albert Serr� Email: connectedrobots@gmail.com Password: could not be added
Count of Records Imported=1
Count of Records Used=0

First, we think there is a file encoding error as accented characters are not well "assimilated" (Rodrigo Albert Serr� for example where "�" should be an "é").

Second users are just not registered.

Can you help us to solve these problems?

Regards
9 months 3 weeks ago #306572 by jciconsult
The normal coding should be UTF-8. If you were working in Excel, this is probably screwed up. My suggestion is to open the CSV file with notepad++ and force a conversion to UTF-8. Or use Libre Office.
The following user(s) said Thank You: nant
9 months 3 weeks ago #306575 by aalisg
Hello and thank you for reply,

The problem is that we use a Macbook so we do not know which software to use to do so.

Regards
9 months 3 weeks ago #306576 by wolverton
Test file was in ANSI mode.
I converted to UTF8 in Notepad++, which is not available for Mac
You can also convert in LibreOffice
You should probably remove the name and user_id columns
9 months 3 weeks ago - 9 months 3 weeks ago #306577 by aalisg
Hello and thank you for your message,

In fact, removing the name and user_id columns made the importation process successfull but the accents are not well displayed.

Regards
9 months 3 weeks ago #306578 by wolverton
Make sure " Check this box to send a confirmation email to the user." is checked.

You'll probably have to convert the original file to UTF8 to get accents correct.

The file you sent was ANSI, so they were already messed up.
Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.398 seconds
Facebook Twitter Google LinkedIn