CSV not importing

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 10 posts - 1 through 10 (of 11 total)
1 2
  • Author
    Posts
  • 10/05/2018 at 9:20 am #474173
    Richard Mitchell
    Guest

    Hello,

    I have an issue which is now causing some real problems. after setting up with an initial import by category from csv files I went on to configuring the various plugins as I wanted them. Now when I try to import more clients into the database they do not appear in the directory. I am using the same filetype to import and it is reported as complete with no rows skipped but it vanishes into a black hole. I also added one item manually which appeared in the “Manage” list in the correct category initially then and then disappeared.Help would be much appreciated as I am now trying to monetize my site.

    I am using cmap with a number of extensions and everything appears to be working except I cannot increment the database.

    Regards

    Richard M

    10/05/2018 at 9:34 am #474174
    Steven Zahm
    Keymaster

    @ Richard

    On the Connections : Manage admin page at the top of the page there are links. Click the one that says All.

    Right below there are three dropdowns. Make sure all of them are set to all and then click the Filter button.

    Right below those to the right is the controls for pagination, click the << button.

    Do the entries you’ve added/imported display on the Manage admin page now? If not, can you search for a name that you know that you’ve added/imported? Does it return as a search result.

    Let me know what you learn.

    10/05/2018 at 10:10 am #474175
    Richard Mitchell
    Guest

    Hi Stephen,
    I have checked as you suggested with no luck. The only thing I have to amend is that entries added manually do remain, my error in checking, they do increment the total content shown under manage but this does not change with csv import. I can send the last file I tried but cannot see how to attach it.

    Richard M

    10/05/2018 at 10:18 am #474177
    Steven Zahm
    Keymaster

    @ Richard

    RE I can send the last file I tried but cannot see how to attach it.

    You need to login before you can attach files. Alternatively, you can copy it to a publicly accessible locations and then share the link with me.

    Which version of the CSV Import do you have installed and using?

    10/05/2018 at 10:51 am #474179
    Richard Mitchell
    Participant

    Hi Stephen,
    I am using version 2 of the importer. I attach 2 files the one with the earliest date was successful the next one fails. I cannot remember when I updated the version of the importer so cannot be sure if it was the same version for both files. The webserver is mine and I have access to the database. Checking there the ID numbers agree with the reported ,ist in Manage. I have wordfence security installed is it possible that their server firewall could be intruding.

    Richard M

    10/05/2018 at 10:58 am #474180
    Richard Mitchell
    Participant

    Hi Stephen,
    The file upload is reporting file type .xls is not allowed to upload for security reasons.

    Richard M

    10/05/2018 at 11:05 am #474181
    Steven Zahm
    Keymaster

    @ Richard

    That would be correct, please upload the CSV file you are trying to import, not the originating Excel file.

    10/05/2018 at 11:30 am #474185
    Richard Mitchell
    Participant

    Attached are CSV files

    Attachments:
    You must be logged in to view attached files.
    10/05/2018 at 11:53 am #474189
    Steven Zahm
    Keymaster

    @ Richard

    I’m assuming the Upload210918okmail.csv file is the one you are trying to import? Correct?

    There were a couple issues with the file.

    The first was is there there were roughly a hundred blank rows. Should not be a major issue but does cause much more processing than necessary.

    The second was the file encoding. Please make sure it is UTF8 encoded when you export the CSV file.

    Attached is a corrected and test file.

    Hope this helps!

    Attachments:
    You must be logged in to view attached files.
    10/05/2018 at 12:20 pm #474191
    Richard Mitchell
    Participant

    Hi Stephen,
    Corrected file worked fine. I will try another upload soon and ensure it is utf8 encoded. Thanks for your awesome support.

    Regards
    Richard M

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

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