imports only part of a csv file

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: not resolved

Tagged: , ,

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • 11/05/2018 at 8:45 am #476465
    Ron Jagers
    Participant

    i have a file of more than 2.500 rows, but only 137 are imported.
    the file works well in openoffice, inexcell, but here the import fails.
    i tried a comma seperated file, i changed it in a tab separated file but nope.

    what can be the cause?

    11/05/2018 at 9:09 am #476468
    Steven Zahm
    Keymaster

    @ Ron

    Can you please attached the file you are importing and a screenshot of the mapping step?

    11/05/2018 at 9:35 am #476471
    Ron Jagers
    Participant
    Attachments:
    You must be logged in to view attached files.
    11/05/2018 at 10:17 am #476476
    Steven Zahm
    Keymaster

    @ Ron

    After an inspection of the CSV file it seems it does not meet the minimum requirements.

    You need to have at least a first and last name OR an organization name.

    • To import an entry as an individual, you need both the first and last name fields mapped.
    • To import an entry as an organization, you need to map just the organization field. If you have a contact name, you would map the name to the contact name field(s)

    The very end of the file, there is no names at all, just an email address for many rows.

    The the 137 entries that import are only those which have a Organization name which is not blank. If you notice the status during import it does say it is skipping most rows. It also offers a download link to an updated CSV which contains only the skipped rows.

    Hope this helps!

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

You must be logged in to reply to this topic.