Only importing 100 entries…

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
  • 07/11/2018 at 5:28 pm #467288
    Elena
    Participant

    Hello,

    I am having trouble uploading my CSV of 1217 entries. I have cut my list down to 300 for testing and the list still will not import them all, only 100 of them on the current version and only 20 on the beta version. The plugin just sits at Please Wait…and never updates that page. When after an hour, I click on manage to see if any imported and it’s always the same 100 (20 in beta version)…I have attached my csv file in case there are any problems with it. I can map the file just fine, but it won’t upload data for more than 20 in beta and 100 in current. Any help is greatly appreciated as I really need to get this completed this week. Thank you!

    • This topic was modified 8 years, 1 month ago by Elena.
    Attachments:
    You must be logged in to view attached files.
    07/12/2018 at 11:32 am #467385
    Steven Zahm
    Keymaster

    @ Matthew

    Please try the attached file. Does that work?

    If not, please see the suggestions I just recently gave another user in this post.

    Also try this:

    Lastly, if you can create a temp admin account using this plugin, I’ll take a look.

    https://wordpress.org/plugins/temporary-login-without-password/

    Attachments:
    You must be logged in to view attached files.
    07/12/2018 at 1:49 pm #467392
    Elena
    Participant

    Hi Steven,

    Thank you for your response. I am currently trying the new csv file you attached and will let you know how that went, but console errors did show up on my developer tools:

    Failed to load resource: the server responded with a status of 504 (Gateway Timeout)
    admin.php?page=connections_csv&action=import:1 Uncaught SyntaxError: Unexpected token o in JSON at position 1
    at JSON.parse (<anonymous>)
    at Function.n.parseJSON (load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,jquery-form,jquery-ui-core,jquery-ui-widget,jquery-ui-tabs&ver=4.9.7:4)
    at Function.a.parseJSON (load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,jquery-form,jquery-ui-core,jquery-ui-widget,jquery-ui-tabs&ver=4.9.7:9)
    at Object.<anonymous> (admin.php?page=connections_csv&action=import:318)
    at i (load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,jquery-form,jquery-ui-core,jquery-ui-widget,jquery-ui-tabs&ver=4.9.7:2)
    at Object.fireWith [as rejectWith] (load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,jquery-form,jquery-ui-core,jquery-ui-widget,jquery-ui-tabs&ver=4.9.7:2)
    at y (load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,jquery-form,jquery-ui-core,jquery-ui-widget,jquery-ui-tabs&ver=4.9.7:4)
    at XMLHttpRequest.c (load-scripts.php?c=1&load[]=jquery-core,jquery-migrate,utils,jquery-form,jquery-ui-core,jquery-ui-widget,jquery-ui-tabs&ver=4.9.7:4)

    I’ll follow the other directions and hopefully this error message will be of assistance.

    07/13/2018 at 10:40 am #467442
    Steven Zahm
    Keymaster

    @ Matthew

    Ok, that error indicates that the server returned an unexpected response and the importing stopped (well, actually the script that triggers the next step in the patch importing).

    If you can give a temp admin account, I can take a closer look and get this resolved for you more quickly.

    https://wordpress.org/plugins/temporary-login-without-password/

    07/13/2018 at 10:49 am #467443
    Elena
    Participant
    This reply has been marked as private.
    07/13/2018 at 11:23 am #467445
    Steven Zahm
    Keymaster

    @ Matthew

    Could you attach a screenshot of the mapping you are using for the import?

    May I delete the 20 entries which exist?

    Lastly, could you set the WP_MEMORY_LIMIT in the wp-config.php file according to this tutorial? Isee you have PHP set to 512MB but WP is still reporting only 40MB. You may also want to set WP_MAX_MEMORY_LIMIT too. Generally WP picks up these settings not certain why it would not is this case.

    07/13/2018 at 12:02 pm #467449
    Elena
    Participant
    This reply has been marked as private.
    07/13/2018 at 12:47 pm #467457
    Steven Zahm
    Keymaster

    @ Matthew

    Ok, I am to get 40 — 60 rows of the CSV file to import by deleting all the columns which are not to be imported. This translates into less processing time.

    Now, the issue is the server is responding to with:

    <title>504 Gateway Timeout</title>
</head><body>
<h1>Gateway Timeout</h1>
<p>The gateway did not receive a timely response
from the upstream server or application.</p>
<p>Additionally, a 504 Gateway Timeout
error was encountered while trying to use an ErrorDocument to handle the request.</p>

    PHP seems to be configured with a max execution time of 240 seconds which would be plenty as the average batch should only take about 30 seconds.

    But, it seems the host might be “hard” limiting the PHP process to only about 20 seconds. This is just a little too limiting.

    With this in mind, I altered the import process so it only imports 10 rows per batch instead on the default 20.

    I’ve started the import which should be complete in about 20 minutes assuming it doesn’t timeout.

    I’ll let you know the results very soon.

    I’ve attached the updated CSV file.

    Attachments:
    You must be logged in to view attached files.
    07/13/2018 at 1:30 pm #467462
    Steven Zahm
    Keymaster

    @ Matthew

    Ok, the file has been imported! I hope the data is correct (due to me altering headers and removing unmapped columns from the file.

    Which host are you using? I’d like to add an exception to CSV Import the batch limit so it’ll only attempt to import 10 rows per batch. I already do this for another host which hard limits max execution to 30 seconds.

    07/13/2018 at 1:44 pm #467463
    Elena
    Participant

    Excellent! Looks good so far! Thank you so much.
    Our host is inmotionhosting.com and we are on a VPS.

  • 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.