We used to import CSV file by the thousand records into our Business Directory Plugin — no sweat, works like a charm.
After several months of usage (about 16,000 records of data), we noticed that the Test Import of over 1000 records would show success. But when we actually import this, the % and progress bar does not moved at all.
When we check our data, only the first 40-records where successfully imported — and the rest of the data did not import at all.
What could be wrong?
Meanwhile, we cut our database import into chunks of 40-records size, and it uploads fine. But this is too cumbersome and not sustainable when we have to upload thousands of data. We are using the Free version of BD.
Thanks for feedback.
Sorry to hear that. What version of WP and BD plugin do you have? The import capacity basically depends on various different things such as your server capacity/traffic, CPU, RAM available, database throughput speed, PHP memory limit per thread, size of the images you’re importing and the hardware your server uses.
The thing about imports is that this isn’t just us shoving data into a table. We’re calling the WP API (because we’re a custom post type, and that’s what we’re supposed to do) for each record, so WP has processing to do on each one. We’re personally tested with 40K records on reasonable hardware and it imports in a reasonable time (I don’t recall the specific number) so we know this works but it may take some time to get it imported.
Having said that, only 40-records at a time does not seem reasonable. Did you try with a slightly larger data set, such as 100 records? Did it work? Or did you see any error messages?
Are you also importing images along with your CSV file?
Most Users Ever Online: 197
Currently Browsing this Page:
Guest Posters: 4665
Moderators: Pippin: 0, BDSupport: 16
Administrators: Business Directory Support: 1714