1. fatelettronica
  2. RO CSVI
  3. Tuesday, 26 July 2022
  4.  Subscribe via email
I have read the instructions for using the cron but I must say that the information contained is not sufficient to create a functioning cron system. I have also read some support articles.
Honestly, it is not well explained how to modify the cron.php file and therefore I will ask you some questions.
Which lines to modify (line number) content to modify and text to insert. I think everyone would be happy with it.
In the meantime, let's start with this.
Then the "mio.csv" file must be uploaded to the server, right, or do I have to upload it through the "Mio" template set as cron?
Ok I have to be accompanied step by step, I have never done this.
Thank you

Lorenzo
Accepted Answer Pending Moderation
Hello Lorenzo,

Which lines to modify (line number) content to modify and text to insert.
What are you trying to do? There should be no need to hack RO CSVI to run it as a cronjob.

Then the "mio.csv" file must be uploaded to the server, right, or do I have to upload it through the "Mio" template set as cron?
It seems you do not know how a cron job works. When you run a cron job there is no human intervention. So it is impossible to upload the mio.csv when the cronjob is running. This means you must have the file either uploaded to your server or have URL to your import file. You can set the location in your template where RO CSVI can find the file. This location cannot be your own computer. It must be in a location your server can reach.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Yes, I've never done a Cron job.
But this "Setting up a cron job in RO CSVI" does not help, indeed it is too confusing. Therefore the cron.php file should not be modified.
If I understand something you have to set the url of the cron.php file in the dedicated server section of the service. I am attaching screenshots of the settings.
I am also attaching the changes to the model to do the cron job.
Tell me if that's okay up to here.

Thanks

Lorenzo
Attachments (3)
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Lorenzo,
But this "Setting up a cron job in RO CSVI" does not help, indeed it is too confusing. Therefore the cron.php file should not be modified.

I don't know where you read it but there is no mentioning in the document to modify the cron.php file.

If I understand something you have to set the url of the cron.php file in the dedicated server section of the service. I am attaching screenshots of the settings.

That is correct. But I see that you have used absolute URL to run the cron command. You should check if you can use PHP executable path like /usr/local/bin/php to run the cron job. Check if that is possible with your hosting service.


I am also attaching the changes to the model to do the cron job.
Tell me if that's okay up to here.

From the screenshots I see that the cron import template does not have Secret Key set. You need to set the Secret Key to run the cron command.

I am explaining the parts of cron command with an example from the document


/usr/local/bin/php /home/domain/public_html/administrator/components/com_csvi/helper/cron.php --key="mysecretword"
--template_id="124"

/usr/local/bin/php -> PHP Executable path (This is based on your server)
/home/domain/public_html/administrator/components/com_csvi/helper/cron.php -> Relative URL of the cron file
--key="mysecretword" -> Secret Key set in import template
--template_id="124" -> ID of the import template to run as cron.


Let me know if that is clear.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
[*] I am explaining the parts of cron command with an example from the document

So do I have to modify the cron.php file by adding, as in the example, the model ID number and the secret key?
If yes, which are the lines to modify (number)
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
[*] You should check if you can use PHP executable path like /usr/local/bin/php to run the cron job. Check if that is possible with your hosting service.
If you mean this url you can't do it
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello Lorenzo,

When you create a cron job, which options do you see? Can you post screenshot(s) of that?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
I hope I have understood correctly
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Lorenzo,
Thank you for the screenshots. Your hosting does not support real cron jobs so setting cron command as explained in RO CSVI document will not work in your case. You need to check the document on how to Run an RO CSVI cron job using a URL on the frontend. Let us know if that helps.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Tharuna

I created the "Cron" menu item in the front-end. See screenshort
Modified the model. See screenshort
After starting the command I get the error page 500. See screenshort
Secret key removed in screenshort
thanks

Lorenzo
Attachments (3)
  1. 2 weeks ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Lorenzo,
This is a known issue and has been fixed already. The fix will be included in upcoming RO CSVI release. But you can load the attached patch file and run the frontend import again. Let us know if the patch fixes the issue.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Dear Tharuna

I uploaded the patch
Now I see, in the front-end page, the loading starts as in the back-end. I close the page, nothing in particular can be seen in the bach-end.

How do you check if everything has gone well?

The process log is attached. It seems to me that it has not concluded, the end is unknown

Thanks

Lorenzo
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
Hello Lorenzo,
I close the page, nothing in particular can be seen in the bach-end.

Did the import finish when you closed the page? As per the debug log products have been updated, May I know what you expect import to do and that it did not happen?

How do you check if everything has gone well?

If import went without any problem on frontend you should have seen a message that Import has been finished. Did you see the message?

The process log is attached. It seems to me that it has not concluded, the end is unknown

Can you post a screenshot on what you see when the import finished?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Dear Tharuna

The thing you suggested to do is not a Cron but it is a front-end command. Same thing as the back-end.
If I wait a few minutes, as in this test case, the message "import is complete" will appear
If the connection is interrupted or the page is closed, the process is not completed and is therefore useless.
Since I have a site where 17 ÷ 18 thousand lines of products have to be updated every day and to do this we need 8 ÷ 10 hours.
Now I have to keep the PC on and hope that the internet connection or anything else is not interrupted.
Is there a possibility to install an app on my site that does the Cron? With all the settings your Cron needs? Aruba provides the ability to activate the app, as we have seen with their "scheduled task".
Thank you
  1. 2 weeks ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Lorenzo,
The thing you suggested to do is not a Cron but it is a front-end command. Same thing as the back-end.

The frontend import URL in your case can be used to set the cron on your server as your hosting supports cron using URL.

If I wait a few minutes, as in this test case, the message "import is complete" will appear

Ok, that shows import completes without any problem and the URL can be used to run the cron.

If the connection is interrupted or the page is closed, the process is not completed and is therefore useless.
Since I have a site where 17 ÷ 18 thousand lines of products have to be updated every day and to do this we need 8 ÷ 10 hours.
Now I have to keep the PC on and hope that the internet connection or anything else is not interrupted.

You don't need to do that. Once you set the frontend URL as cron, it will run like any other cron command. There is no manual import or supervision needed.

Is there a possibility to install an app on my site that does the Cron? With all the settings your Cron needs? Aruba provides the ability to activate the app, as we have seen with their "scheduled task".

You don't need any of these settings once you use the URL to run the cron on your server.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
You don't need to do that. Once you set the frontend URL as cron, it will run like any other cron command. There is no manual import or supervision needed.

I did not understand this.
Once you set the frontend URL as cron

I have configured the menu and template as per "Run an RO CSVI cron job using a URL on the frontend"
have you seen the screenshorts? are they okay?

I repeat, as I am the Cron does not work
  1. 2 weeks ago
  2. RO CSVI
  3. # 15
Accepted Answer Pending Moderation
Hello Lorenzo,

Let me try to explain it in some simple steps.

  1. You go to your hosting provider Aruba
  2. Edit your cronjob
  3. Enter the URL from your website that you created with the menu item
  4. Save your cronjob
  5. Drink a coffee and wait for the cronjob to run :D
Let us know how it goes
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
Good morning

I drank coffee but the job didn't go well. See the logs.
I have already tried to change some parameters but it doesn't work.
I certainly can't know.
I am attaching screenshots of the logs and settings of the task
Tanks

Lorenzo
Attachments (2)
  1. 2 weeks ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
Hello Lorenzo,
There are no attachments in your reply to check. Please attach the screenshots on how you have set the cron job and also post the import debug log.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 18
Accepted Answer Pending Moderation
Tharuna

I am attaching screenshots of the logs and settings of the task
.
Tanks

Lorenzo
Attachments (2)
  1. 2 weeks ago
  2. RO CSVI
  3. # 19
Accepted Answer Pending Moderation
Hello Lorenzo,
Can you also post the debug log of the import? You can click on Download link on the page you sent in Logs_Cron_1.pdf and post the zip file here.

Also I noticed in the Task pdf I see that you have domain name in the URL twice. The first part is URL https://www.fatcomp.it in the list box and in the second box you have the URL again with https://www.fatcomp.it/index.php?option=com_csvi....... Is that correct?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!