[RESOLVED] File download rename then upload

[stehl]

I have a form working where it writes the order information to a csv file which is great. Is there a way to download the file it writes to and rename it according to the date and move it to a secure directory so my client can download it and process that days orders. Then reupload a blank copy of the csv file back onto the server for the next days orders.

A better understanding:

the formmail writes to orders.csv
at a set time the file is copied and renamed according to the date
Example orders20090911.csv

then its uploaded to a new directory such as a folder called orders. The the client can download the days orders via a secure ssh/ftp thing and password.
Next a blank orders.csv is uploaded to the original directory so the form can write another days orders.

I need a script to do this. I plan on having it run everyday with a cron job setup on the server.

Hope this makes sense. I appreciate anyone's insight or ideas. This is the last thing i need to setup for the client to approve the site.

[big_nerd]

I will help you along with it, but don't have time to write the whole thing,BUT:

PHP Manual On:

fputcsv() - Writes CSV file
mkdir() - Makes a folder/directory BE SURE you have the parent folder set to 0777 or chown to the PHP user.
copy() - Copy's a file
unlink() - Delete's a file
touch() - sets access & timestamp to file, creates if not exist

i.e.

$csvfile = 'orders.csv'; // assuming already created;
$month = date('M');
if (!file_exists($month) || !is_dir($month)) {
mkdir($month);
}
$fileto = $month.'/'.date('m-d-y_h-i-s').'.csv');
copy($csvfile,$fileto);
unlink($csvfile);
touch($csvfile);
?>

I have no error checking there, and its actually quite terrible, but the idea works..

[stehl]

Thanks for the quick reply

[stehl]

Yes the orders.csv file is already created. The form writes the order info to it. I need to:
-- copy it
--rename it
-- move/ upload the newly copied and renamed one to another directory on the server
--delete the original
--upload a blank copy of orders.csv located in another directory to place of the original

[big_nerd]

that's pretty much what I gave you, but you migh twant to read up and do some error checking on those functions..

Please mark thread resolved if its helped.

[stehl]

Where you have:

$csvfile = 'orders.csv'; // assuming already created;

and it says orders.csv, can i put the path to the file there?

$month = date('M');
if (!file_exists($month) || !is_dir($month)) {
mkdir($month);
}

and from my little php knowledge, this segment makes a variable called $month and makes a directory month? correct?

Why does it need a directory called month?

$fileto = $month.'/'.date('m-d-y_h-i-s').'.csv');

can I also put the path to the destination here?

[big_nerd]

the $csvfile variable should be the path to the csv file, yes, yo ucan use a path, keeping in mind its not a web path, its a path based on the OS.

Question 2, The directory month was only for illustrative purposes, I find it easier to contain items within months, as I keep at least 1 year retention on all transactions, but thats me.

Question 3:

Yes, exactly, that names the file using the date function, if you have any questions on that one, see the manual page.

$fileto is the PATH and FILENAME you wish to use,not just the path.

[stehl]

So If i do no need to create the directory month or a new directory at all, I can omit those lines. Because the Directory are already there. I just need to copy the orders file. Rename and put it into another directory.

[big_nerd]

well yes exactly, that mkdir section is only to create a folder for the month.

[stehl]

I appreciate your help and I have tried implementing your code. I am a noob and cant get it to work. 🙂

This is What I have:

<?php

$csvfile = '/home/content/r/e/s/resmedin/html/xtra/junk/orders/orders.csv'; // 5>

$fileto = home/content/r/e/s/resmedin/html/xtra/secure/$month.'/'.date('m-d-y_h-i-s').'.csv'; 

copy($csvfile,$fileto);

unlink($csvfile);

touch($csvfile);

?>

And I get these errors: I tried looking them up but no avail at fixing them.

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: Division by zero in /home/content/r/e/s/resmedin/html/xp.php on line 6

Warning: copy(/11-09-09_01-05-32.csv) [function.copy]: failed to open stream: Permission denied in /home/content/r/e/s/resmedin/html/xp.php on line 8

[big_nerd]

That's because you didnt quote the fileto, nor start with a leading slash:

you have

$fileto = home/content/r/e/s/resmedin/html/xtra/secure/$month.'/'.date('m-d-y_h-i-s').'.csv';

Should be:

$fileto = '/home/content/r/e/s/resmedin/html/xtra/secure/'.$month.'/'.date('m-d-y_h-i-s').'.csv';

Not to mention, IF you are keeping the files in ./xtra/secure/ you need to change it further:

$fileto = '/home/content/r/e/s/resmedin/html/xtra/secure/'.date('m-d-y_h-i-s').'.csv';

that $month was from my previous example, not sure if you wanted it there.

[stehl]

I actually got it working. Ima run a test order and such and see if its 100 percent. If it is I thank you greatly. If not , Ill be back in about 5 min. Haha.

[stehl]

It works flawlessly. I GREATly appreciate your help. I was Googling all day and had nothing until you helped me. Once again thanks. [THREAD RESOLVED]