Hi @jobfinder,
I would like to know if there is a way to delete the Jobs from that specific import via MySQL or any other command.
It would be possible to do it via MySQL, but the query would likely be pretty complex, and I’m afraid I don’t have an example.
Instead, you could temporarily raise our records per iteration in the Import Settings to 50 or 100, then use the “Delete” button under the import: https://d.pr/i/jrmaXR (this will likely timeout multiple times and you’ll have to restart it). Or, use a “bulk delete” plugin that’s built for this type of operation.
With that said, it doesn’t make sense that the cron jobs would import way too many jobs like that, and ideally we could just stop that from happening rather than having you delete all of them periodically. Can you please replicate this on a sandbox site at http://www.wpallimport.com/debug/ and open a support request at http://www.wpallimport.com/support/?
@wpallimport thanks for your reply.
The problem is that not too many jobs are imported with every import, but every 2-3 months (e.g. because the import has a problem, because something has been changed on the feed, such as switching from 50,000 jobs to 250,000).
-
This reply was modified 5 years ago by
jobfinder.
Hey @jobfinder,
So, the feed itself is adding a bunch of jobs that you don’t want to import, then the import runs and creates them? If that’s the case, is there some kind of common data point in those jobs that you don’t want? It sounds like you may be able to use a filter to prevent them from being imported: http://www.wpallimport.com/documentation/advanced/filtering-with-xpath/.
Hi @wpallimport
i use filter on that import and i have set a limit “only import jobs 1-10000”.
But some times the import takes longer, because there are 200.000 jobs in the feed.
When it takes too long the import does not finish and rotates for a long time, with that rotation it imports far more jobs than wished.
it is hard to discribe…
Hey @jobfinder,
This sounds really strange. Can you please open a support request at https://www.wpallimport.com/support with details about the issue and a link to this thread for reference? It sounds like we’ll have to check the import directly to understand what’s going on.
