Repeating Categories

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , , ,

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • 02/24/2015 at 10:23 am #320568
    Alex Botkin
    Participant

    After import I have ended up with one of the categories repeated for each entry.

    I have checked the csv with an ascii editor, and no hidden characters are there.

    Any reasonable solutions other than dumping the table and redoing?

    02/24/2015 at 11:34 am #320578
    Steven Zahm
    Keymaster

    @ Alex

    Not sure I follow, sorry!

    Are you saying a duplicatory was created each time an entry was added with the category?

    Was it just one particular category name … meaning were you importing other categories too?

    Can I get a copy of the CSV file to see if I can duplicate the issue?

    02/24/2015 at 3:06 pm #320605
    Alex Botkin
    Participant
    This reply has been marked as private.
    02/24/2015 at 3:07 pm #320608
    Alex Botkin
    Participant

    I suppose the previous should have been set private, can you change that?

    02/24/2015 at 8:05 pm #320632
    Steven Zahm
    Keymaster

    @ Alex

    The CSV file is malformed. There is a column where there is a valid value a some of the rows but with no column header, its blank. Also, there a dozen of so blank columns at the end of each row. These issues seem to mess up the parser. Fixing these issues, the file imports fine in both Connections 8.1.7 and the upcoming 8.2 version. If you are using Excel to create the CSV file, I suggest using LibreOffice as Excel can create some nasty CSV files.

    Not sure why this would cause duplicate category creation … my best guess is that the empty columns were somehow being appended creating a “unique” name which when checked for did not exist so a new one would be created.

    Probably the quickest way to cleanup is to go to the Categories admin page click the select all checkbox and then uncheck the categories to keep and then bulk delete the “duplicates”.

    02/24/2015 at 8:57 pm #320635
    Alex Botkin
    Participant

    It cleaned up fine. At least the counts by category are correct.

    Perhaps adding the need to delete excess columns and not having blank headers to he instructions would be a good thing. Makes sense in retrospect.

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

You cannot reply to this support topic. Please open your own support topic.