Exporting and Importing users - simple steps ?

7 years 8 months ago #180973 by gingerweb
Im sure this must be as frustrating for you as it is me! I have ensured that i have a comma in the delimiter box now and i get this now :

CB Version =1.7
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] => firstname [11] => middlename [12] => lastname [13] => hits [14] => message_last_sent [15] => message_number_sent [16] => avatar [17] => avatarapproved [18] => approved [19] => confirmed [20] => lastupdatedate [21] => registeripaddr [22] => cbactivation [23] => banned [24] => banneddate [25] => unbanneddate [26] => bannedby [27] => unbannedby [28] => bannedreason [29] => acceptedterms [30] => website [31] => location [32] => occupation [33] => interests [34] => company [35] => address [36] => city [37] => state [38] => zipcode [39] => country [40] => phone [41] => fax [42] => twitter_userid [43] => fb_userid [44] => cb_pgenable [45] => cb_pgautopublish [46] => cb_pgautoapprove [47] => cb_pgshortgreeting [48] => cb_pgtotalquotasize [49] => cb_pgtotalquotaitems [50] => cb_pguploadsize [51] => cb_pgtotalitems [52] => cb_pgtotalsize [53] => cb_pglastupdate [54] => cb_pgaccessmode [55] => cb_pgdisplayformat [56] => privacy_settings [57] => cb_pb_enable [58] => cb_pb_autopublish [59] => cb_pb_notifyme [60] => cb_pb_enable_blog [61] => cb_pb_enable_wall [62] => cb_pb_autopublish_wall [63] => cb_pb_notifyme_wall [64] => cb_golfclub [65] => cb_handicap [66] => cb_ballused [67] => cb_greatestachievementtodate [68] => cb_ironmake [69] => cb_woodsmake [70] => cb_clubcounty [71] => cb_malefemale [72] => cb_dob [73] => cb_howdidyouhear [74] => gj_autojoin [75] => fc_userid [76] => usertype )

gj_autojoin is not valid

fc_userid is not valid

Terminating because of undefined header variables

Could you details PLEASE what i change from the default on the export and what i change from the default on the import? All i want to do is get the same data into the new domain withouth chabging any of it, passwords and all.

thanks.
7 years 8 months ago #180977 by jciconsult
In your spreadsheet, you have to make sure that variables in both systems are spelled EXACTLY the same. cj_autojoin and fc_userid do not look like normal cb variable names. At the TOP of the session in the latest version of CBJUICE, the valid variables are listed. If you do NOT field the fields marked as invalid in that list, then that is your problem.
7 years 8 months ago #180980 by gingerweb
thanks i deleted those columns and it all imported !
fingers crossed for the rest now.

cheers
Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.563 seconds
Facebook Twitter Google LinkedIn