PHPmill Forums

[PHPmill]

New features of version 2.1 of Datafeed-to-MySQL make it more powerful.

Version 2.1 - Released 8/11/05.
- Allows bypass of login screen.
- Allows bypass of submit form button.
- Script can be run by entering default form values into the configure.php file and visiting the url of the script.
- Can use automation to run the script by merely accessing it's url. e.g via Cron Job.
- Allows custom table name that is different from filename.

[BFG 9000]

Hi Guys,

Thanks for 2.1 - I like it a lot.
Would it be possible to have the script redirect to a url or another script when it's completed i.e. when it displays 'The requested actions were performed'?

TTFN

BFG

[PHPmill]

Not Supported.

You can turn off redirection by editing configure.php at line 81:
define('DATA_COUNTER', '1000000');

- SET THIS TO A VALUE LARGER THAN THE SIZE OF YOUR DATAFEED IN BYTES. IF YOU DO NOT SET THIS HIGH ENOUGH, THE ENTIRE DATAFEED WILL NOT BE PARSED IN ONE SHOT.

Next open index.php. In line 42 find the following:

$V2bd79aa0 = '<META HTTP-EQUIV=Refresh CONTENT="' . REFRESH_TIME . '; URL=http://' . $_SERVER['HTTP_HOST'] . HTTP_PATH . FILENAME_INDEX . '?page=' . $V38eedc42 . '&qc=' . $V0e5477d4 . '&fs=' . $V6eda31cc . '&rt=' . $Vc40a3f0c . '&st=' . $V37b0979a . '&p=' . $V31501723 . '&rc=' . $V4e719dfa . '&cm=' . $Vc7016f76 . '&ec=' . $V254b00ee . '">' . "\r\n";

- MOVE THIS DOWN TO ITS OWN LINE AND ADD // (TWO SLASHES) IN FRONT OF $V2bd79aa0. OR, EDIT THE URL TO ONE OF YOUR CHOICE.

Note that these suggestions have not been tested and will not be supported, they may or may not work. The file index.php is intended to be used as-is. Editing this file may have unpredictable or undesirable effects. If these suggestions do not work for you, we do not have a solution for you at this time. If you edit index.php, you do so at your own risk. Backup your database and files before making any edits. Thank you.

[nx7t]

Just looking at PHPMIll for the first time. I need a script that will do this with cron, my question is can it be made to change the imported file name based on the date. [b] The files I need imported to MySQL change file name daily and include the date as the last six characters before extension.[/b]

[quote="PHPmill"]New features of version 2.1 of Datafeed-to-MySQL make it more powerful.

Version 2.1 - Released 8/11/05.
- Allows bypass of login screen.
- Allows bypass of submit form button.
- Script can be run by entering default form values into the configure.php file and visiting the url of the script.
- Can use automation to run the script by merely accessing it's url. e.g via Cron Job.
- Allows custom table name that is different from filename.[/quote]

[PHPmill]

No, the filename must be the same. What you could do with another script is grab the file from the remote location, download it to the proper folder and have the script change it's name to the name stored in Datafeed-to-MySQL. We have done custom setups where this is done automatically with one cron job. Datafeed-to-MySQL is versatile and can be included in another script that does things before and/or after the program itself runs.