Import stops in the middle – some troubleshooting
-
I’ve used RSCI successfully a few times, but this last attempt is the first time I’ve tried to import an image for each post, and it hasn’t worked so far. Here’s what I’ve done so far:
1) Tried to import 300+ posts with 8 fields, two of them ACF fields. After waiting a long time I checked how many posts had been generated and saw there were 71 new posts, and that there were corresponding images for each of them, except the last image was in the media library, but was blank. I was using Safari on the Mac, although I don’t think that’s a factor. I know that it was finished because the time of the last post was hours earlier – all the posts that been generated in a short time period, and then hours went by before I went to check why it wasn’t doing anything.
I noticed as well that the custom fields had not been imported. I thought perhaps it was because I had created new categories and forgotten to add them to the ACF field group, although that seemed strange (i.e. the fields exist even if they’re not shown, so why wouldn’t they get imported?). I added the new categories to the field group.
2) I split my CSV into 50-line files (and copied over the header line for each one obviously). I tried importing and this time it stopped at 41 posts. Same thing with the most recent image being blank.
The two custom fields still had not been imported. I finally realized the problem – one of the fields was a Select field and I had changed the values (i.e. I was importing values that did not exist in the Select options). I switched the field to a text field so it wouldn’t be an issue.
3) I moved over to Chrome just in case that mattered. I split the CSV into 25-line chunks and imported the first file. This time I got a 504 Gateway Time-out. I had checked how many posts were generated a minute earlier and it was up to 21, so I expected it to finish about then anyways. What’s really odd is that when I went to check how many posts there were, there were 41 – and yet there were only 25 in the CSV. Did it somehow run a repeat of the previous import? No idea. Doesn’t seem it could be a caching issue since the name of the file was different.
The custom fields did get imported this time. The odd thing is that if one custom field can’t be imported, why did both fields not get imported in previous attempts?
4) Thinking perhaps it might be connected to the fact I use Cloudflare, I switch Cloudflare to Development Mode and tried exactly the same thing as before (25 rows in Chrome). This time it seemed to import 50 posts, but never timed out. After enough time went by I stopped the import and looked at the 50 new posts. What I noticed was that it was not 50 unique posts, but 25 posts twice. The second set of 25 was not in exactly the same order, although close.
Not sure what to learn from this round, although there were 50 complete images in the Media Library, but they were not attached to any posts yet. Not sure what the order that the plugin works in, but I’m guessing the images are imported and only later assigned to the appropriate posts.
5) Disabled all the caches in W3, and moved over to Firefox just for good measure (I know the browser likely had no effect, but I figured it couldn’t hurt). This time I got an Error 520 in Cloudflare saying the site was offline. I don’t know exactly when that happened, as I wasn’t watching it. I opened the site again and it worked fine. I checked out the posts and there were indeed 25 new ones this time. Everything seems to have worked correctly, even though there was the error at the end. Still, it’s only 25 rows, and I have a few hundred more to do.
- The topic ‘Import stops in the middle – some troubleshooting’ is closed to new replies.
