duplicate header variables

7 years 8 months ago #201034 by htown
I have exported users from Joomla 1.5.23 using CB juice 1.8. I went to my Joomla 2.5.4 site and tried to import this same file (id's do not have to be the same). All the fields are the same name and i get no errors but I get this:

CB Version =1.8
CBJ2_HEADER_VARIABLES are
Array ( [0] => name [1] => lastvisitDate [2] => registerDate [3] => avatar [4] => avatarapproved [5] => username [6] => firstname [7] => middlename [8] => lastname [9] => lastupdatedate [10] => email [11] => hits [12] => params [13] => cb_website [14] => cb_occupation [15] => cb_interests [16] => cb_company [17] => cb_city [18] => cb_state [19] => cb_zip [20] => country [21] => cb_address [22] => cb_yearjoined [23] => cb_cellnumber [24] => cb_homephone [25] => cb_workphone [26] => cb_titles [27] => cb_spoucesname [28] => cb_email2 [29] => cb_psamember2 [30] => usertype [31] => block Houston Brown [32] => 5/23/12 14:36 [33] => 0000-00-00 00:00:00 [34] => 62_4d2d2603acca0.jpg [35] => 1 [36] => Houston [37] => Houston [38] => [39] => Brown [40] => 1/11/11 21:54 [41] => houston@hbip.com [42] => 25 [43] => admin_language=en-GB language=en-GB editor=rokpad helpsite= timezone=-6 [44] => www.houstonbrownphotography.com [45] => Web Developer/Photographer [46] => See above [47] => Split Light Designs [48] => Dallas [49] => TX [50] => 75228 [51] => [52] => 1721 Mariposa Dr [53] => 2007 [54] => 972-896-9193 [55] => [56] => [57] => [58] => [59] => [60] => Yes [61] => Super Administrator [62] => 0 . . . . .

(about 120 more records then I get this)

There are duplicate header variables which is not allowed.
Array ( [name] => 1 [lastvisitDate] => 1 [registerDate] => 1 [avatar] => 1 [avatarapproved] => 1 [username] => 1 [firstname] => 1 [middlename] => 1 [lastname] => 1 [lastupdatedate] => 1 => 1 [hits] => 1 [params] => 1 [cb_website] => 1 [cb_occupation] => 1 [cb_interests] => 1 [cb_company] => 1 [cb_city] => 1 [cb_state] => 1 [cb_zip] => 1 [country] => 1 [cb_address] => 1 [cb_yearjoined] => 1 [cb_cellnumber] => 1 [cb_homephone] => 1 [cb_workphone] => 1 [cb_titles] => 1 [cb_spoucesname] => 1 [cb_email2] => 1 [cb_psamember2] => 1 [usertype] => 1 [block Houston Brown] => 1 [5/23/12 14:36] => 1 [0000-00-00 00:00:00] => 156 [62_4d2d2603acca0.jpg] => 1 [1] => 140 [Houston] => 3 [] => 1225 [Brown] => 2 [1/11/11 21:54] => 1 [houston@hbip.com] => 1 [25] => 1 [admin_language=en-GB language=en-GB editor=rokpad helpsite= timezone=-6] => 1 [www.houstonbrownphotography.com] => 1 [Web Developer/Photographer] => 1 [See above] => 1 [Split Light Designs] => 1 [Dallas] => 57 [TX] => 119 [75228] => 1 [1721 Mariposa Dr] => 1 [2007] => 9 [972-896-9193] => 1 [Yes] => 36 [Super Administrator] => 5 ......... (the screen fills up with the rest of the records) Can anyone tell me what the problem is? i dont get it? Many thanks, Houston[email] => 1 [hits] => 1 [params] => 1 [cb_website] => 1 [cb_occupation] => 1 [cb_interests] => 1 [cb_company] => 1 [cb_city] => 1 [cb_state] => 1 [cb_zip] => 1 [country] => 1 [cb_address] => 1 [cb_yearjoined] => 1 [cb_cellnumber] => 1 [cb_homephone] => 1 [cb_workphone] => 1 [cb_titles] => 1 [cb_spoucesname] => 1 [cb_email2] => 1 [cb_psamember2] => 1 [usertype] => 1 [block Houston Brown] => 1 [5/23/12 14:36] => 1 [0000-00-00 00:00:00] => 156 [62_4d2d2603acca0.jpg] => 1 [1] => 140 [Houston] => 3 [] => 1225 [Brown] => 2 [1/11/11 21:54] => 1 [houston@hbip.com] => 1 [25] => 1 [admin_language=en-GB language=en-GB editor=rokpad helpsite= timezone=-6] => 1 [ www.houstonbrownphotography.com ] => 1 [Web Developer/Photographer] => 1 [See above] => 1 [Split Light Designs] => 1 [Dallas] => 57 [TX] => 119 [75228] => 1 [1721 Mariposa Dr] => 1 [2007] => 9 [972-896-9193] => 1 [Yes] => 36 [Super Administrator] => 5 .........

(the screen fills up with the rest of the records)

Can anyone tell me what the problem is? i dont get it?

Many thanks,
Houston
7 years 8 months ago - 7 years 8 months ago #201035 by wolverton
7 years 8 months ago #201040 by htown
The link you provided takes me right back to this post.
7 years 8 months ago #201043 by htown
I ended up using a text editor instead of Excel and it all worked.

Thank you.
7 years 8 months ago #201045 by wolverton
Sorry about that... I fixed the above link.
7 years 7 months ago #201655 by rustle44
HI guys, I am experienciing the same problem described above

I have opened the csv in Notepad++ (the original csv was generated in libre office) and changed the eol conversion to unix based

but I still get the duplicate heading error

could some please be a bit more descriptive with the solution to this error

thank you in advance
Moderators: beatnantjciconsultwolvertonkrileon
Time to create page: 0.409 seconds

Facebook Twitter LinkedIn