Error when importing users

5 years 7 months ago #306571 by aalisg
Error when importing users was created 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

Please Log in to join the conversation.

5 years 7 months ago #306572 by jciconsult
Replied by jciconsult on topic Error when importing users
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

Please Log in to join the conversation.

5 years 7 months ago #306575 by aalisg
Replied by aalisg on topic Error when importing users
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

Please Log in to join the conversation.

5 years 7 months ago #306576 by wolverton
Replied by wolverton on topic Error when importing users
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

Please Log in to join the conversation.

5 years 7 months ago - 5 years 7 months ago #306577 by aalisg
Replied by aalisg on topic Error when importing users
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

Please Log in to join the conversation.

5 years 7 months ago #306578 by wolverton
Replied by wolverton on topic Error when importing users
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.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.213 seconds

Facebook Twitter LinkedIn