CSV Duplicates on upload! HELP

This topic contains 9 replies, has 2 voices, and was last updated by  Paolo 9 years, 1 month ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • April 9, 2015 at 8:01 pm #36716

    thebirdiemachine
    Expired Member
    Post count: 246

    Hi,

    I was trying to upload a CSV file when I noticed the import status bar saying that I had TWICE as many records as the CSV file REALLY contains – the good part is that I aborted to upload so I do not have any duplicates.

    I do need to upload lots of files – when is this issue going to be fixed or is this the first time you have heard of this (which I would doubt)? This is really a pretty big problem.

    I an running GD 1.3.9 and have NOT upgraded because I have seen posts with duplicate problems what seems to be a whole host of updating issues so I was waiting until these were resolved.

    Is this duplicate record upload related to the “duplicate” issue that I have seen cross my email box?

    Thanks
    Stacey

    April 9, 2015 at 8:07 pm #36718

    Paolo
    Site Admin
    Post count: 31206

    The duplicate post thing had nothing to do with CSV upload, if when uploading a CSV file you get more listings that it should it means the CSV file isn’t formatted correctly.

    Please attach one of your file and we will have a look.

    Finally you should really update your plugins.

    Thanks

    April 9, 2015 at 8:32 pm #36721

    thebirdiemachine
    Expired Member
    Post count: 246
    This reply has been marked as private.
    April 9, 2015 at 8:58 pm #36724

    Paolo
    Site Admin
    Post count: 31206

    cell N17 there is a comma before the coordinate.

    Let us know,

    Thanks

    p.s. please update your plugins

    April 10, 2015 at 1:14 am #36731

    thebirdiemachine
    Expired Member
    Post count: 246

    Hi Paolo,

    I fixed the comma in N17 – however that had did not fix the problem. GD uploader still saying there are 90 records when there are really 45.

    April 10, 2015 at 1:22 am #36732

    thebirdiemachine
    Expired Member
    Post count: 246

    Further when I select my file from my computer – in the GD window somehow a whole bunch of crap get inserted before actual file as below:

    http://www.muttmaps.com/wp-content/uploads/2015/04/temp_1/Yelp-Play-4.9.2015-Play-Upload-GD-Format1.csv

    The file that I am trying to upload is: Yelp-Play-4.9.2015-Play-Upload-GD-Format1.csv

    What is this about? Does it have something to do with me aborting the upload in process???

    Also I cannot undo this – meaning I try to erase everything up to the “Yelp…” with my delete button but no joy with that either.

    April 10, 2015 at 2:39 pm #36782

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    I see 2 things that could be the source of the problem.

    1 the & symbol used in category name. I would try to change it to & (html code for &)

    2 dots in your file name. Try to remane it to something like :

    Yelp-Play-4-9-2015-Play-Upload-GD-Format1.csv

    If the above doesn’t help, please provide url and wp admin credentials and I will have a look.

    Thanks

    April 10, 2015 at 3:00 pm #36788

    thebirdiemachine
    Expired Member
    Post count: 246
    This reply has been marked as private.
    April 10, 2015 at 3:44 pm #36792

    thebirdiemachine
    Expired Member
    Post count: 246

    I think I have it solved – I put the spreadsheet on its own SEPARATE file (instead of sheet) and it worked.

    Please mark this as resolved (for now LOL)

    Stacey

    April 10, 2015 at 5:21 pm #36801

    Paolo
    Site Admin
    Post count: 31206

    Ok thank you! 🙂

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket