Resolved External URL for import cron job

Hello,
There is no option in CSVI to call external URLs for cron jobs. One solution to try here is that you can create your own script which calls CSVI cron.php file and trigger your script as a cron in http://www.easycron.com.

There is already a solution for this.
https://csvimproved.com/support/questions-and-answers/1117-setting-up-a-front-end-template

Make a hidden menu, choose type CSVI PRO, choose subtype EXPORT or IMPORT. Call this menu link from your cron scheduler.

BTW you can use also http://cron-job.org/ . This is a free of charge service, interval choice can be as small as 1 minute!

Hi there
We have an external source (XML) to import. That means we have to create a menu item and set up a cron to call that url. I have created a menu item, type is import and I did the proper settings. When I call this url, the import runs and it works fine. Then I created a cron on my server and called the same url and the server says it runned successful. Checking in Virtuemart, there are no products. There is no error, the log shows that no products are imported.

What am I doing wrong?

Hello,
You need to send us your import debug log to check what has gone wrong with your import. Check How to get debug information? document to get the debug log.

Here is my log!

Hello Marcel,
Your debug log shows no rows are processed. How have you set up the cron job? Can you post screenshot of how you have the menu item setup? Does this import template work when you run the import manually from backend?

Just so you know, there are two ways to run the cron. One using CLI and setting up a cron job document explains on how to run the cron using command line. Other is by creating a URL on frontend to run the cron and that is explained in Run cron using URL on frontend document.

Yes, when I call the url manually it works. I tried sef and non-sef urls, they both run the import.
Check my screenshot

Thx!

Hello Marcel,
You menu item looks good. Considering that you are running your import on server9.nl site, Did you run your front end import by using the below URL? where xx is the template id and XXXX is the secret key of the template. Can you run using this URL and send me the latest import debug log to check?

https://www.server9.nl/index.php?option=com_csvi&view=import&csvi_template_id=xx&task=import&key=XXXX

Th cron did exactly that. According to the report I got from the server and the log form CSVI, the problem looks solved.
Thanks again Tharuna!