You are here:  » automatic import


automatic import

Submitted by marco on Wed, 2017-07-05 09:38 in

Hello,

I can’t get automatic import to work on a new site.
Manual import does work, but automatic import (fetch of /scripts/cron.php) results in zero (or only a very few) products being imported.

Already checked:
- Database read and write settings for the user are active (Plesk)
- Tried $config_databaseDebugMode = TRUE; but gives no messages.
- Error logs give no message.

Cron notification is the same as a succesfull automatic import, except the number of products is zero.

Any ideas where to look further?

Best,
Marco

Submitted by support on Wed, 2017-07-05 11:23

Hi Marco,

I know you've been using the script for several years now so if this is a new installation on a new server that may be running latest PHP / MySQL but you are using an existing modified earlier distribution of Price Tapestry you may need to apply one or more of the Forward Compatibility Patches.

That may be all it is - the only other database issue that may be the case, if there is a difference in MySQL library version between your web server and command line PHP is the sql_mode reset required (now included in 16/10A distribution) described in this comment...

Hope this helps, if neither apply or still not importing from the command line let me know and I'll check it out further with you...

Cheers,
David.
--
PriceTapestry.com

Submitted by marco on Thu, 2017-07-06 13:45

Hi David,

Sorry, it think it was because of some modifications i made.
I am trying to combine manual product addings (storing them under the filename manual.xml) with automatic feed product addings.
In that case cron.php (import @ALL) is also not such a good idea of mine as it will delete the manual addings (temp products table)
Found a workaround with import.php instead.

Best,
Marco