Support is offline. We are back Monday 23 November, 09:00.

How to setup a cron job to run a template with the table source? #60434

Resolved rusasadmins opened this topic Thursday, 31 October 2019 · 8 replies
Author

I have a RO CSVI template where the source is a table in my Joomla database. I can run it manually no problem. I can set the property for enable frontend/cron to Yes. Do you have any documentation on what else I have to do to make it work?

Support

Hello,
Take a look at Setting up a cron in RO CSVI document to set your template as cron.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Okay thanks that "Setting up a cron in RO CSVI" article looks detailed and something our System Administrators can work with.

I couldn't find anything in the document that spoke to the significance of setting "enable frontend/cron" to Yes. Did I miss it? If not, is the setting necessary and if yes, what does it do?

Support

Hello,

I couldn't find anything in the document that spoke to the significance of setting "enable frontend/cron" to Yes. Did I miss it? If not, is the setting necessary and if yes, what does it do?

You're right. There is no mention about this field in this document. This setting is absolutely necessary. Using RO CSVI it is possible to run import or export using Frontend and using a menu link. In lot many cases where cron cannot be run in command line, users use this frontend option to run the template. Once you set this option to Yes and when you create a menu item you can see the template in menu option. The template which has this setting set to No will not be listed. Check the linked document in my reply for more information.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

For the cron job, since I'm using a VIEW for the data (pulling data from the database), not a csv file, can I 'skip' the file parameter, or is that required?

my code I think would be:
/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helper/cron.php --key="cs-import-users" --template_id="19"

where:
key --> my secret word
template_id --> my template id

thanks,
Laura

Support

Hello Laura,
You can skip the file parameter as your import is from database. In your import template on Source tab you need to set your database details from where the data is imported. RO CSVI will use your template settings while running your cron.

my code I think would be:
/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helper/cron.php --key="cs-import-users" --template_id="19"

where:
key --> my secret word
template_id --> my template id

Yes, That's right.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

We actually receive an error when we do not submit the file name...

code submitted:

/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helper/cron.php --key="cs-users" --template_id="19"

where:
key --> my secret word
template_id --> my template id

Messages:
Processing started...
Template cs-import-users
No filename has been provided

We also tried to submit an 'empty' file name...

Can you verify how this should run if we are using the 'database as source', instead of file?

thanks,
Laura

Support

Hello Laura,
Please update to RO CSVI 7.14.0 version. This issue has been addressed with this version. Once you update you don't need to enter any empty filename. Cron will work with your template settings. Let me know how it goes.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

great, it works!

Log in to reply to this topic.