Importet over 2000 entrys..Help!

[armin2302]

Hello,

so I am still fighting with the csv import. Now I managed to creat an csv that seemd to work… however when I installed it I did not only geht the palyes in the scv but also all other empty cells in the Excel Sheet. So I ended up with over 100 pages and 2.000 Entrys that are empty.

Is there a way to delete those entrys other then selecting page by page?

Thank you
Armin

[Mark]

Amazing. Please send me the file you used and I’ll figure it out. I suspect you are right, you do not want to include all the blank lines from Excel in the CSV file. Or, what do you know, they get read in to the database. (I can make that better, but let me have a look at your file and see what’s needed.)

If you go to the players screen. You can check all the players you wish to delete and use the bulk delete option at the top left. You can even select them all with one click. Then be sure and go back and EMPTY the TRASH, so all those bogus players are not hanging around.

-Mark

[armin2302]

Hello Mark,

sorry I was sick. The file has been send. I just dont get what I am doing wrong. I am still getting the no forst name… after importing.

appreciate your imput

Thanks
Armin

[Mark]

Hi Armin,
I looked at your file. Looks like you combined all the fields (columns in Excel) into one column. Something like this:

“player_number,player_last_name,player_first_name,player_position,player_age,player_teams”
“2,Probst,Lucas,,11,U11 Micros”
“24,Straub,Alexander,,10,U11 Micros”

That won’t work. One column with one column header for each data field. One player on each row. Then SAVE it as CSV format. Don’t try to make your own (although you certainly can using a text editor).

As for why 2000 entries were created, I’m not sure. It should have just ignored the file. I’ll add that to the list.

-Mark

[armin2302]

Hello Mark,

thank you, but I am afraid that I just have to give up on importing the players… No matter what I try I am always getting the No_Name.. after import.

I am getting the players in an Excel sheet, so I added the needes Heading to each collum and exportet as CSV. I will send you botht files via mail.

I do have another questing but I will adress that in another post so not to mix those two up.

Best regards
Armin

[armin2302]

Hello, please discard the above comment. I managed to get it done, thanks to google spreadsheets 🙂

thanks for the help, I really do appreciate it

Armin

[Mark]

Great. In the CSV file you sent me, all the columns were mashed into one with ; as the separator. This won’t work. Something seems to be going wrong with your CSV save, perhaps the Windows Regional Settings. (??)

Looking at your XLS file, there was one mistake; the player_teams column has to contain the team SLUG, not the NAME. You can find the team slugs on the Teams screen. In your case, the slug for the team U11 Micros is probably u11-micros.

But it sounds like you got it figured out. Super.

Regards,
-Mark

[Author]

Posts