Please help while i still have hair left LoL

7 years 7 months ago - 7 years 7 months ago #284604 by SimGameIt
I get the following error. I know this seems to be a common issue and ive read until my eyes are about to bleed and brain is about to explode lol. Is the delimiter asking for a table prefix like abc_ or what am i missing here. Ive looked on the CBJuice website because i seen a forum entry say there was a PDF file but i couldnt find it. Please help me. I dont know what else to do. -Mike The Watchman News

***Edited to add ok my first issue is i was trying to upload a SQL file. This is what i get when i try to upload the CSV file.

Starting an ADD-EDIT Run in CBJUICE2
CB Version =2.0
CBJ2_HEADER_VARIABLES are
Array ( [0] => 852 [1] => Jennifer White [2] => GangstaGigglez [3] => XXXEmail EditedXXX@yahoo.com [4] => $2y$10$yPKGoe7KK6eXPF5wR9ScruwzDyKcDrdMS99.SlAi45hnDFNql1RuG [5] => 0 [6] => 0 [7] => 2015-12-23 23:58:03 [8] => 2016-08-09 02:54:25 [9] => [10] => {"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""} [11] => 0000-00-00 00:00:00 [12] => 0 [13] => [14] => [15] => 0 )
There are duplicate header variables which is not allowed.
Array ( [852] => 1 [Jennifer White] => 1 [GangstaGigglez] => 1 [XXXEmail EditedXXX@yahoo.com] => 1 [$2y$10$yPKGoe7KK6eXPF5wR9ScruwzDyKcDrdMS99.SlAi45hnDFNql1RuG] => 1 [0] => 4 [2015-12-23 23:58:03] => 1 [2016-08-09 02:54:25] => 1 [] => 3 [{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""}] => 1 [0000-00-00 00:00:00] => 1 )

Please Log in to join the conversation.

7 years 7 months ago #284605 by wolverton
Replied by wolverton on topic Please help while i still have hair left LoL
Your csv file needs a header row to define the fields. Export users to a csv file and open it in OpenOffice, the first row will be the headers.
The following user(s) said Thank You: SimGameIt

Please Log in to join the conversation.

7 years 7 months ago - 7 years 7 months ago #284607 by SimGameIt
Replied by SimGameIt on topic Please help while i still have hair left LoL
Ok i had to download and install open office. So i did that and this is what i see. What do i need from that image and what do i do with it? I really appreciate your reply.
Attachments:

Please Log in to join the conversation.

7 years 7 months ago #284608 by SimGameIt
Replied by SimGameIt on topic Please help while i still have hair left LoL
Ok i got it thank you for your help. I found out how to export the file with the heading info which is what i wasnt doing before. Sorry for taking up your time. I knew it was something simple. Just never did it before and i exhausted all avenues i could think of before i came here for help. Thanks again.

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.188 seconds

Facebook Twitter LinkedIn