Cron Job error: No such file or directory #8164

Hello,
The path to the PHP executable in your cron command is missing. Have a look at the the documentation on setting up the cron job.

Hello,

This is not possible. CSVI always writes a new file. The only way around it is that you create a filename that has a timestamp for example. Have a look at the Customizing the export filename document.

Hello,

Is it possible to delete the input csv file after an import?

This depends. If you are loading the file From Server, and you click on the Advanced button you will see the option to Delete the file after import. Deleting From URL isn't possible and From FTP isn't implemented yet.

How can I set the range of date for export "customers" and "orders" ?

In your template on the Options tab you can set a date range.

Hello,

How can I delete a csv file after an import using cron job ?

Same answer as before. If you want to control it yourself, you will need to create a bash script to do so.

Every day I need to export only users or orders created the day befroe. Is there an option or a filter in cron line command ?

For orders you have the option in your template to export "Since last run", this is usually used to get the last batch of items.

For customers you will need to do it on the command line as this doesn't have the "Since last run" option. The Setting up a cron-job explains how to add command line arguments.

To use a date you will need to use the system functions to generate the date for you. There are quite a few posts about that on the forum but people in general use something like this

 --form.orderdatestart=$(date -v-5d +"\%d-\%m-\%Y")

You will need to find out for yourself how it works on your server.

Hello,

I don't have the key cron in my template options.

You don't have CSVI 6 installed? Older CSVI versions are no longer supported, so an update is recommended. Make sure you follow the update guide of CSVI 6.

form.orderdatestart=$(date -v-5d +"%d-%m-%Y") don't work

This was a suggestion, I wasn't implying that this would work just others have used it. This is no longer CSVI code but has to do with your server operating system.

You will need to find out which works for your server, perhaps ask your hosting provider.

Test the code you want to use, since you have SSH access that is the easiest way to do it. The date command should output a date in the format of day-month-year (example: 31-12-2015).

Hello,

The problem is that CRON.PHP don't read the date from command line.

Well the question is if there is any date actually supplied. Did you check by specifying the date directly into the command line? Like this:

php /var/www/vhosts/admin49178387.localhost/quorestore.it/administrator/components/com_csvi/helper/cron.php --key="mafrat" --template_id="1" --form.userinfomdatestart="01-01-2016"

In your command you are missing the " around the date value.

The option "delete after import" do not work !!.

That is another question for another thread. Supply more information than "It doesn't work", I can't help you if that is all you tell me. Make a new thread and post the information requested under Looking for a useful answer?.

Hello,

The debug log tells me something very interesting: PHP version: 5.3.3

CSVI requires a minimum of PHP verison 5.4, so I think you will need to adjust your cron command to use a newer PHP version. Usually this is located in a place like /usr/bin/php but you may need to ask your host for the exact path.

So let's use an up-to-date PHP version first and then see what happens. Although PHP 5.4 is out of support as well by the PHP developers :)

Hello,

Thank you for giving your solution.

As for appending the output, I am not sure, this is the first time this has been asked and I don't see the true benefit of it. If you are appending, you may was well change the date from when it needs to be exported. For example, on Monday you export Monday and on Tuesday you export Tuesday but you want this appended to the Monday export. Why not export Monday and Tuesday on Tuesday?

Hello,

The software of the other company that pulls the export files from FTP, can it handle multiple files in a single folder? If that is possible, you could have CSVI create unique files per day. That way you could see which files are actually processed and which ones are not. If they failed, they could try again.

As for deleting the file from FTP, that is on our todo list.

Hello,

So we have to change something because they can't handle it :) You can modify the core file administrator\components\com_csvi\models\exports.php by finding this line

$this->handle = fopen($this->processfile, 'w+');

and change it to

$this->handle = fopen($this->processfile, 'a+');

see if that works for you.

Hello,

The only difference between w and a is that w will always empty the file on export or create it if it doesn't exist and a will always append to the file on export or create it if it doesn't exist.

This means if you want to append, you must specify a filename in your template. That you have done as far as I can see. So the question is if data has been appended or not.

You said nothing happened, that is very little info, so with a+ no file, nothing happens?

Hello,

The fopen in maintenance has nothing to do with the export.

To change the filename, have a look at the documentation Customizing the export filename. That will do what you are asking.

Hello,

I did not test appending because it won't be in the core. That is why I said you can check if it works for you. By the way it is not the -a parameter, it is a+. I assume you used that.

Every time you export you get a new file? What happens to the content of the file on export?

Not according to the PHP documentation.I see I should only ask 1 question at a time.

Every time you export you get a new file?

Does the file have the same name?

Ok, so the data in the file is different for the first and second export?

So this gave me another idea. The option w+ or a+ do work differently but CSVI works on a temporary file which is eventually copied to it's final location.

The copy is done with JFile::copy() function. This function has no append option. So if you want to append you may need to rewrite the whole part where this is handled. This is line 1121 in the exports.php file where you made the other change.

Hello,

Not tired yet, been doing this for 10 years now :)

That may well be a bug, we will look into this.

Hello,

This is being worked on for the next release, so in CSVI Pro 6.6.0 the FTP export will also be able to use these placeholders.

Hello,

Apply the patch attached and your FTP filename should be updated as well. Let me know how it goes.

• patch_ftp_filename_20160510.zip