Resolved error using cron

Hello Rick,

The best wishes for 2015.

Apologies for the late reply but I wanted to do it right rather than give half an answer. First off, I was wrong by saying that it worked the same way because the way CLI works in Joomla 3 is different.

Attached is a patch file you can load via the maintenance menu. After that is done you will have an updated cli script and help file. By entering php cron.php --help will give you the full details on how to use the CLI script. Also posted here verbatim. Let me know if you have any further questions.

Cron help system

============================



NAME

        cron - The CSVI cron import engine

SYNOPSIS

        cron    [--help] [--key=<value>] [--task=<name>] [--addon=<name>] [--operation=<name>]

                [--template_name=<name>] [--template_id=<value>] [--file=<name>]



DESCRIPTION

        The cron job can be used to run automated CSVI imports, exports or maintenance tasks.



OPTIONS

        --help

            Shows this help screen.



        --key

            Specify the secret key set in the template configuration.



        --task

            Specify maintenance to run a maintenance task otherwise do not use.



        --addon

            Specify the name of the addon to run the maintenance task for. For example: com_csvi



        --operation

            Specify the maintenance operation to perform. For example: optimizetables



        --template_name

            Specify the name of the template you want to run, enclose the name in double quotes. For example: "Product import".



        --template_id

            Specify the ID of the template. This can be used instead of the template name option. In case both are specified, the template ID takes precedence over the template name.



        --file

            Specify the filename to use for import or export. This must be the full name on the server, not only the name of the file itself, enclose the name in double quotes. For example: "/var/www/public_html/products.csv"

Roland,

Trying to find out how it works. putting only --help behind the cron.php gives me the help overview but when I try to setup the job the job:

/usr/local/bin/php /home/user/domains/http://site.nl/public_html/administrator/components/com_csvi/helper/cron.php --key=secretkey --addon=VirtueMart --operation=Product --template_id=1 --file=/home/user/domains/http://isite.nl/public_html/b2b/file.csv

I get the following result in my email:

/bin/sh: ^: command not found

No template has been specified

Where did I do something wrong?

Rick,

Change the command to this:

/usr/local/bin/php /home/user/domains/http://site.nl/public_html/administrator/components/com_csvi/helper/cron.php --key=secretkey --template_id=1 --file="/home/user/domains/http://isite.nl/public_html/b2b/file.csv"

Does that work for you?

Roland,

Still the same error.

Hey Rick,

So I setup a test server to see if I can reproduce what you are seeing but no such "luck".

This I get for an import

Processing started...
Template Joomla Users
Import has finished

and this for an export

Processing started...
Template Joomla Users

Perhaps you can contact your hosting provider to see what the line

/bin/sh: ^: command not found

means. It might be that something in the cron job is not supported.

Roland,

finally found the problem.

the fron-end/cron swich was still on no for this template :blush: :blush:

Thanks for the help

Rick,

Thanks for the feedback, I will see if we can get the cron to report that the template is not enabled for cron usage.