Hi David Hope all is well.
Have 2 questions.
#1 for some unknown reason I can't import feeds from LinkShare using the pricetapestry script.
I've checked my firewall settings but nothing seems out of place.
ftp format is as follows
ftp://USER_NAME:USER_PASSWORD@aftp.linksynergy.com/MERCHANT_ID/MERCHANT_ID_USER_ID_CATEGORY_cmp.txt.gz
This works fine on the live sites, and works in the url bar of IE9 and FF, but not Opera.
#2 Is there a way to run @all jobs by a list? I've added a few fields in my local jobs table hoping to make things somewhat easier.
exanple of sql...
$sql = "SELECT * FROM `".$config_databaseTablePrefix."jobs` WHERE `site` = 'Site-1.com' ORDER BY filename;";
Thank you in advance.
Bob L.
There is no doubt in my mind.
You be the man!
Thank you David.
I have never tried using curl locally.
But that did the trick. Thank you.
Will save me some bandwidth and time.
Hi Bob,
The first thing I would suggest regarding the fetching problem is (if not already) to switch the automation handler over to curl by changing line 43 of config.advanced.php as follows;
$config_automationHandler = "curl";Regarding finer selection from the jobs table using @operators; look in scripts/fetch.php for the following code beginning at line 34:
if ($filename == "@ALL"){
$sql = "SELECT * FROM `".$config_databaseTablePrefix."jobs` ORDER BY filename";
}
...and if you REPLACE this with:
if ($filename == "@ALL"){
$sql = "SELECT * FROM `".$config_databaseTablePrefix."jobs` ORDER BY filename";
}
elseif (substr($filename,0,6) == "@SITE:")
{
$site = substr($filename,6);
$sql = "SELECT * FROM `".$config_databaseTablePrefix."jobs` WHERE site='".database_safe($site)."' ORDER BY filename";
}
...then you could use
fetch.php @SITE:site-1.com
Hope this helps!
Cheers,
David.
--
PriceTapestry.com