pierre1wp

I don’t believe cron is the problem as other tasks are running. But I don’t know if my hosting is limiting anything.

But, I’d like to understand something. If I do a manual import from the Import tab, the plugin imports all rows of the CSV in one shot, never a problem. So why doesn’t it do the same thing in the Recurring Import? Why the need to work in chunks?

And if I can’t get the recurring import to work properly, how could I schedule the single import using cron? That would work for me if that’s doable. Maybe that would be the solution (for me anyway).

Thanks.

Pierre

Hi Javier,

I installed 2.0.5 and let the plugin do its hourly import. It still imports in chunks of 29, and there is a time gap of about 2 minutes (give or take) between chunks imported. So it EVENTUALLY imports the entire CSV, but it takes 15 minutes or more from the import of the first chunk til the last one.

So my question to you, which I think I asked earlier, is: what happens if the CSV is updated during that 15+ minute span?

Thanks.

Pierre

Clarification / key reproduction detail
After further testing, I can consistently reproduce the issue and have narrowed it down:

• Manual Import tab processes the full CSV correctly (300+ rows import successfully in one run).
• Recurring Import (“Execute cron task now”) always processes exactly one batch (~28 rows) and then immediately marks the job as “Finished”. No further batches are executed.

This behavior is fully reproducible and does not depend on:

• CSV content (tested by moving rows around and using the same file)
• reinstalling the plugin
• PHP version (now upgraded to 8.4)

The key issue is that recurring/batch mode stops after the first chunk and does not continue processing remaining rows, despite the import completing successfully in manual mode.

So the problem appears specific to the recurring import execution path, not the CSV or WordPress environment.

I hope this additional info helps narrow down the problem, and hopefully a fix.

Thanks.

Indeed it is fixed. And indeed I had turned off “Enhance List Tables” as a temporary workaround. It’s back on now.
Thanks.

WARNING: LONG POST

I installed the plugin you referenced. Two to three hours later, I didn’t see any emails in my inbox nor anything in the log tab of the WP Mail Logging plugin, even though the import had happened. I even ran the import manually by pressing the button “Execute cron task now” and still nothing.

Then I sent a test email (from the Mail options tab) and received it, along it being logged in WP Mail Logging. The email was sent to MY email (the user logged in, not the webmaster). So now that got me thinking.

I have the recurring import configured to NOT send an email to a user when a user is added or updated. Does that mean the webmaster will not get any email, even though the checkbox “Send email when using periodic import?” is checked?

My understanding about that checkbox is that it would send an email to the webmaster when the the recurring import occurs. That is, in my opinion, a separate issue from sending emails to users. But apparently that is not the design intent.

Am I understanding the expected behavior correctly? If so that explains why I am never getting any email (to webmaster) when the import runs. Given the location of the checkbox in the settings tab for recurring import, it makes it sound like it’s a global email (to webmaster) that it is referring to. But unfortunately it isn’t.

If my interpretation is now correct, the wording of the text for the checkbox needs to be changed to better reflect what it really is for. Instead of “Send email when using periodic import?”, you may want to consider “Send email to affected users when using periodic import?”

Better yet, I am not sure if the checkbox is even needed since it is the settings in the Mail Options tab that determine whether an email is sent.

If you want to keep the checkbox, with the suggested change of text above, then add a NEW checkbox that would say “Send email to webmaster when an import occurs?” And that email should contains success or failure information and the stats about the import.

Thanks for reading this long post. What do you think?

I have not activated any cron server (that I am aware of).

Anyhow, I did activate WP_DEBUG_LOG. After a couple of days, there were tons of entries (Notices and Warnings only) in the debug.log file but nothing about Import and Export that I could find (the word “Import” is not found in the log).

So I decided to change the schedule of the recurring import from “Twice a day” to “Every hour”. As soon as I saved the new setting, it ran an import. It has been importing every hour ever since. Still nothing in the debug.log to show that it ran, but that’s ok.

Still wondering why I am not getting the emails every time it runs though. I do have the box “Send email when using periodic import?” checked. Do I need anything else? I am assuming it’s using the WordPress webmaster email address as the recipient.

I just tried the test email on the “Mail options” tab and received it. So that part works.

Any suggestions?

Hi Javier,

Here is the publicly available link to a sample data CSV file
https://drive.google.com/file/d/1Ucji4cKU47Tx6Ip1X5b-I-WDdikxEPJ3/view?usp=sharing

I tried the above link for the import URL as well as
https://drive.google.com/uc?export=download&id=1Ucji4cKU47Tx6Ip1X5b-I-WDdikxEPJ3

Both failed. Thank you for looking into it for me.

Pierre