|
|
|
|
"check_ep_data - v 1.0 - 18/04/2004
This is a simple command line PHP script that will scan through an easypopulate csv datafile and check for common errors. Most of the types of errors it looks for are the kind of typical cut and paste problems created when using a spreadsheet (duplicate product numbers, blank product numbers, duplicate product names, 'EOREOR' present, etc etc).
If you want, it will also print a category tree for all the products. This is to provide a visual guide to make sure you've not made a spelling mistake and inadvertently put a product on its own in some bogus category somewhere. The tree isn't as tidy as it could be, but it's good enough.
To use it :-
1) unzip it
2) You may want to change the shebang at the top of the file to point to your PHP executable
3) There are also a few constants and control parameters defined at the top of the file that you may want to alter to match your system. The various checks can be switched on and off as required.
If you just run the script with no parameters it will print some help info
The idea is that you run the script after you have edited your easypopulate data in your spreadsheet, but before you upload it to your site; a sanity check before you try and add your data back into the database
It's nothing mind shattering and the code is pretty ropey, but it is "correct" (I hope !) and might save someone some grief and time.
Any suggestion etc warmly welcomed.
Rich osc1@rbentley.com
Á" |
|
|
|
 |
| For more information, visit the official osCommerce contribution webpage. |
|
|
|
