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.
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.
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.
09/24/2015 at 2:07 am #347979
I’m trying to import a large file and along the way, my wifi was dropped and the import was interrupted. The import was not done alphabetically, so I can’t really tell what order it was imported. Is there any way I can resume the import without creating duplicates, or do I need to wipe the database and import everything again?09/24/2015 at 9:21 am #348017
I figured out how the import is sequenced so this is no longer an issue. I do have a somewhat related question — I am in the process of uploading a large file –60k+ entries. Any tips on how to get this done?
09/24/2015 at 10:51 am #348019
- This reply was modified 7 years ago by christian Carballo.
I tested importing about 30k entries in a single CSV file on a shared host (Bluehost) and it imported without issue. The only real limitation at this point is server resources provided by the web host. When I do imports or others, as freelance work, I usually break the CSV file in 10k chunks.
Hope that helps!09/24/2015 at 1:16 pm #348044
Great. I have bluehost also. How long did it take to import 10k?09/24/2015 at 1:54 pm #348051
It’s been awhile since I’ve since my last import of this size… it does take quite a bit of time especially on shared hosts because they will throttle CPU utilization. Honestly, when I start one this large, I leave the browser window open and do something else.09/24/2015 at 2:01 pm #348053
I seem to freeze every 1k or so. I’m just under 10k now and deleted what’s been uploaded and restarted the upload again a few minutes ago.09/24/2015 at 2:57 pm #348055
re: I seem to freeze every 1k or so.
Suggestion would be to make sure all PHP error reporting is either disabled or logged, my preference is the latter. Best practices dictate all PHP error reporting be suppressed on a production site so it does not expose potentially sensitive server info.
It is possible the error was logged, it may be worthwhile to look in the PHP error log to see if there seems to be anything related to the import.09/24/2015 at 5:18 pm #348064
I have no clue what you just wrote but I will look it up. Thanks for the tip09/24/2015 at 7:35 pm #348065
I checked the error logs and didn’t see anything that indicates an error with the upload. Granted, I’m not very literate in all of this, but the times for the handful of errors listed didn’t match up. Either way, I turned off the error reporting after learning what it was and what it entailed. Downloading it again — I have about 50k left. Bluehost said not to increase the memory speed beyond 128. Do you agree?09/24/2015 at 8:12 pm #348066
So I turned off the error reporting and increased the speed to 256 but it still stopped after 100 entries. Any other ideas?
You cannot reply to this support topic. Please open your own support topic.