lech Posted November 29, 2009 Author Share Posted November 29, 2009 I am afraid at the moment Feedmachine does not produce xml feeds. I might add this functionality in a future version, but to be honest I think that xml is inefficient for product feeds and all product search engines should except tab-delimited/csv feeds. What product search engine are you trying to create a feed for and does it only accept xml feeds? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 30, 2009 Share Posted November 30, 2009 In the windows which opens I am getting this error: Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458 Quote Link to comment Share on other sites More sharing options...
devine952 Posted November 30, 2009 Share Posted November 30, 2009 Hi, Great Contrib! I have used the first one for a couple of years and now I have just upgraded to this one. During the install I experienced problems with the end of the SQL file: `url_parameters` varchar(256) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `config_filename` (`config_filename`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; It wouldn't accept this so I had to change it to varchar(255) and remove ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; Is this ok? or does it have bad consequences. As I said it is creating my fm-feeds file ok. The other problem is FTP settings when viewing feedmachine_admin.php I haven't used FTP before with google, rather uploading manually. google says uploads.google.com but they don't specify a path. Also when I update, FTP always stays OFF. Is this normal? even after scrolling it to ON, when I update it goes back to OFF. Any help welcome. Regards, Rob Quote Link to comment Share on other sites More sharing options...
devine952 Posted November 30, 2009 Share Posted November 30, 2009 Hi, Great Contrib! I have used the first one for a couple of years and now I have just upgraded to this one. During the install I experienced problems with the end of the SQL file: `url_parameters` varchar(256) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `config_filename` (`config_filename`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; It wouldn't accept this so I had to change it to varchar(255) and remove ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; Is this ok? or does it have bad consequences. As I said it is creating my fm-feeds file ok. The other problem is FTP settings when viewing feedmachine_admin.php I haven't used FTP before with google, rather uploading manually. google says uploads.google.com but they don't specify a path. Also when I update, FTP always stays OFF. Is this normal? even after scrolling it to ON, when I update it goes back to OFF. Any help welcome. Regards, Rob I just wanted to add that I am getting an encoding error in description field. I don't know why so I have linked the text file. I reduced it to 4 items, so the file won't be too big too look at. Text File Quote Link to comment Share on other sites More sharing options...
lech Posted December 1, 2009 Author Share Posted December 1, 2009 In the windows which opens I am getting this error: Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458 Hi, Please make sure you are using the latest version and that you have updated all files. Do all feeds have a language selected in Feedmachine Admin? Quote Link to comment Share on other sites More sharing options...
lech Posted December 1, 2009 Author Share Posted December 1, 2009 Great to hear from a user of the original Feedmachine! I hope you will find the new system even better. The changes you made to the sql are fine. The FTP On/Off problem is a small bug that I will sort out in the next version - thanks for pointing it out. The problem is that the drop-down is not displaying the correct status, though you are turning ftp on and off when updating. Hi, Great Contrib! I have used the first one for a couple of years and now I have just upgraded to this one. During the install I experienced problems with the end of the SQL file: `url_parameters` varchar(256) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `config_filename` (`config_filename`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; It wouldn't accept this so I had to change it to varchar(255) and remove ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; Is this ok? or does it have bad consequences. As I said it is creating my fm-feeds file ok. The other problem is FTP settings when viewing feedmachine_admin.php I haven't used FTP before with google, rather uploading manually. google says uploads.google.com but they don't specify a path. Also when I update, FTP always stays OFF. Is this normal? even after scrolling it to ON, when I update it goes back to OFF. Any help welcome. Regards, Rob Quote Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2009 Share Posted December 1, 2009 Hi, Please make sure you are using the latest version and that you have updated all files. Do all feeds have a language selected in Feedmachine Admin? We have uploaded the latest version. Do we must/have to do the SQL? Quote Link to comment Share on other sites More sharing options...
lech Posted December 1, 2009 Author Share Posted December 1, 2009 No. Do all feeds have a language selected in Feedmachine Admin? We have uploaded the latest version. Do we must/have to do the SQL? Quote Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2009 Share Posted December 1, 2009 (edited) No. Do all feeds have a language selected in Feedmachine Admin? yes, they have catalog path: /home/verzekerd/www/ languages array built currencies array built taxes array built countries array built categories array built number of products: 220 number of cycles: 1 feed configurations checked... output begun. cycle: 1 products array built products attributes array built feed generation in process... Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458 done. Edited December 1, 2009 by misa Quote Link to comment Share on other sites More sharing options...
lech Posted December 1, 2009 Author Share Posted December 1, 2009 Hi, Are your feeds empty? please add print_r($cur_feed); foreach( $products as $key => $value ) { echo $key . "\n"; } directly below line 457 and let me know what you get. yes, they have catalog path: /home/verzekerd/www/ languages array built currencies array built taxes array built countries array built categories array built number of products: 220 number of cycles: 1 feed configurations checked... output begun. cycle: 1 products array built products attributes array built feed generation in process... Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 458 done. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2009 Share Posted December 1, 2009 I am getting thid in the popup window: catalog path: /home/verzekerd/www/ languages array built currencies array built taxes array built countries array built categories array built number of products: 220 number of cycles: 1 feed configurations checked... output begun. cycle: 1 products array built products attributes array built feed generation in process... Array ( [name] => Google Product Search Simple Configuration [authors] => Lech [filename] => google-product-search.txt [schema_version] => 2.0 [fields] => Array ( [id] => Array ( [output] => products_id [type] => DB ) [title] => Array ( [output] => products_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [price] => Array ( [output] => FINAL_PRICE [type] => KEYWORD ) [brand] => Array ( [output] => manufacturers_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [mpn] => Array ( [output] => products_model [type] => DB ) [product_type] => Array ( [output] => CATEGORY_TREE [type] => KEYWORD [options] => Array ( [0] => STRIP_HTML [1] => STRIP_CRLF ) ) [link] => Array ( [output] => PRODUCTS_URL [type] => KEYWORD ) [image_link] => Array ( [output] => IMAGE_URL [type] => KEYWORD ) [condition] => Array ( [output] => new [type] => VALUE ) [description] => Array ( [output] => products_description [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) ) [add_field_names] => 1 [seperator] => [text_qualifier] => [category_tree_seperator] => [newline] => [encoding] => utf8 [currency_decimal_override] => [currency_thousands_override] => [include_record_function] => [id] => 1 [config_filename] => google-simple.php [ftp_status] => 0 [ftp_server] => [ftp_path] => [ftp_username] => [ftp_password] => [ftp_upload_period] => 0 [language_code] => 4 [currency_code] => EUR [countries_iso_2] => NL [url_parameters] => [currency_decimal] => , [currency_thousands] => ) 4 Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 462 Array ( [name] => Pricerunner UK [filename] => pricerunner.csv [authors] => Lech [schema_version] => 2.0 [fields] => Array ( [Category] => Array ( [output] => CATEGORY [type] => KEYWORD [options] => Array ( [0] => STRIP_HTML [1] => STRIP_CRLF ) ) [Manufacturer] => Array ( [output] => manufacturers_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [Product ID] => Array ( [output] => products_id [type] => DB ) [Product Name] => Array ( [output] => products_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [Price] => Array ( [output] => FINAL_PRICE [type] => KEYWORD ) [Product URL] => Array ( [output] => PRODUCTS_URL [type] => KEYWORD ) [image URL] => Array ( [output] => IMAGE_URL [type] => KEYWORD ) [shipping] => Array ( [output] => 0 [type] => VALUE ) [stock Level] => Array ( [output] => In Stock [type] => VALUE ) [Retailer message] => Array ( [output] => [type] => VALUE ) [Description] => Array ( [output] => products_description [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) ) [currency_decimal_override] => [currency_thousands_override] => [add_field_names] => 1 [category_tree_seperator] => [seperator] => , [text_qualifier] => " [newline] => [encoding] => utf8 [include_record_function] => [id] => 2 [config_filename] => pricerunner-uk.php [ftp_status] => 0 [ftp_server] => [ftp_path] => [ftp_username] => [ftp_password] => [ftp_upload_period] => 0 [language_code] => du [currency_code] => EUR [countries_iso_2] => NL [url_parameters] => [language_id] => 4 [currency_decimal] => , [currency_thousands] => ) 4 done. ----------------------- Feedmachine Report ----------------------- start time: 2009-12-01 17:47:28 CET end time: 2009-12-01 17:47:29 CET runtime: 0.30362010002136 GLOBAL UPDATE TRIGGERS ---------------------- this was a force update NOTICES ------- this was a manual update this run was triggered via HTTP F E E D S Google Product Search Simple Configuration ------------ update status: feed updated as part of a force update upload trigger status: feed upload not triggered because feed upload is disabled upload status: feed was not uploaded(0) Pricerunner UK ------------ update status: feed updated as part of a force update upload trigger status: feed upload not triggered because feed upload is disabled upload status: feed was not uploaded(0) Quote Link to comment Share on other sites More sharing options...
lech Posted December 1, 2009 Author Share Posted December 1, 2009 I think you've entered language_code in the google feed config manually. If so you need to delete the 'language_code' line from the configuration. I am getting thid in the popup window: catalog path: /home/verzekerd/www/ languages array built currencies array built taxes array built countries array built categories array built number of products: 220 number of cycles: 1 feed configurations checked... output begun. cycle: 1 products array built products attributes array built feed generation in process... Array ( [name] => Google Product Search Simple Configuration [authors] => Lech [filename] => google-product-search.txt [schema_version] => 2.0 [fields] => Array ( [id] => Array ( [output] => products_id [type] => DB ) [title] => Array ( [output] => products_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [price] => Array ( [output] => FINAL_PRICE [type] => KEYWORD ) [brand] => Array ( [output] => manufacturers_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [mpn] => Array ( [output] => products_model [type] => DB ) [product_type] => Array ( [output] => CATEGORY_TREE [type] => KEYWORD [options] => Array ( [0] => STRIP_HTML [1] => STRIP_CRLF ) ) [link] => Array ( [output] => PRODUCTS_URL [type] => KEYWORD ) [image_link] => Array ( [output] => IMAGE_URL [type] => KEYWORD ) [condition] => Array ( [output] => new [type] => VALUE ) [description] => Array ( [output] => products_description [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) ) [add_field_names] => 1 [seperator] => [text_qualifier] => [category_tree_seperator] => [newline] => [encoding] => utf8 [currency_decimal_override] => [currency_thousands_override] => [include_record_function] => [id] => 1 [config_filename] => google-simple.php [ftp_status] => 0 [ftp_server] => [ftp_path] => [ftp_username] => [ftp_password] => [ftp_upload_period] => 0 [language_code] => 4 [currency_code] => EUR [countries_iso_2] => NL [url_parameters] => [currency_decimal] => , [currency_thousands] => ) 4 Warning: Invalid argument supplied for foreach() in /home/verzekerd/www/admin/feedmachine.php on line 462 Array ( [name] => Pricerunner UK [filename] => pricerunner.csv [authors] => Lech [schema_version] => 2.0 [fields] => Array ( [Category] => Array ( [output] => CATEGORY [type] => KEYWORD [options] => Array ( [0] => STRIP_HTML [1] => STRIP_CRLF ) ) [Manufacturer] => Array ( [output] => manufacturers_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [Product ID] => Array ( [output] => products_id [type] => DB ) [Product Name] => Array ( [output] => products_name [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) [Price] => Array ( [output] => FINAL_PRICE [type] => KEYWORD ) [Product URL] => Array ( [output] => PRODUCTS_URL [type] => KEYWORD ) [image URL] => Array ( [output] => IMAGE_URL [type] => KEYWORD ) [shipping] => Array ( [output] => 0 [type] => VALUE ) [stock Level] => Array ( [output] => In Stock [type] => VALUE ) [Retailer message] => Array ( [output] => [type] => VALUE ) [Description] => Array ( [output] => products_description [type] => DB [options] => Array ( [0] => STRIP_HTML [1] => HTML_ENTITIES [2] => STRIP_CRLF ) ) ) [currency_decimal_override] => [currency_thousands_override] => [add_field_names] => 1 [category_tree_seperator] => [seperator] => , [text_qualifier] => " [newline] => [encoding] => utf8 [include_record_function] => [id] => 2 [config_filename] => pricerunner-uk.php [ftp_status] => 0 [ftp_server] => [ftp_path] => [ftp_username] => [ftp_password] => [ftp_upload_period] => 0 [language_code] => du [currency_code] => EUR [countries_iso_2] => NL [url_parameters] => [language_id] => 4 [currency_decimal] => , [currency_thousands] => ) 4 done. ----------------------- Feedmachine Report ----------------------- start time: 2009-12-01 17:47:28 CET end time: 2009-12-01 17:47:29 CET runtime: 0.30362010002136 GLOBAL UPDATE TRIGGERS ---------------------- this was a force update NOTICES ------- this was a manual update this run was triggered via HTTP F E E D S Google Product Search Simple Configuration ------------ update status: feed updated as part of a force update upload trigger status: feed upload not triggered because feed upload is disabled upload status: feed was not uploaded(0) Pricerunner UK ------------ update status: feed updated as part of a force update upload trigger status: feed upload not triggered because feed upload is disabled upload status: feed was not uploaded(0) Quote Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2009 Share Posted December 1, 2009 (edited) Ok..........thanks and fixed. This contribution wil help me a lot..........thanks Another question, will this work also on Creloaded? Edited December 1, 2009 by misa Quote Link to comment Share on other sites More sharing options...
lech Posted December 1, 2009 Author Share Posted December 1, 2009 Yes Ok..........thanks and fixed. This contribution wil help me a lot..........thanks Another question, will this work also on Creloaded? Quote Link to comment Share on other sites More sharing options...
Guest Posted December 1, 2009 Share Posted December 1, 2009 Yes am getting this error then: cycle: 1 products array built 1054 - Unknown column 'po.language_id' in 'on clause' SELECT * FROM products_attributes pa LEFT JOIN products_options po ON pa.options_id = po.products_options_id LEFT JOIN products_options_values pov ON pa.options_values_id = pov.products_options_values_id AND po.language_id = pov.language_id WHERE pa.products_id BETWEEN 11 AND 375 TEP_DB_ERRORR Quote Link to comment Share on other sites More sharing options...
frankc420 Posted December 7, 2009 Share Posted December 7, 2009 I've tried installing your earlier script and was unable to get it to work for whatever reason, so I've tried installing it again and when trying to run from command line it gets a segmentation fault after building the countries array. I find this very strange and it may be the exact problem that I had last time I tried using this contribution. Our store has over 1000 products and there is nothing really special about the database that would cause the php session to crash out. Any suggestions? PHP Warning: gethostbyaddr(): Address is not a valid IPv4 or IPv6 address in *snip*/whos_online.php on line 45PHP Warning: session_destroy(): Trying to destroy uninitialized session in *snip*/sessions.php on line 164 catalog path: *snip* languages array built currencies array built taxes array built countries array built Segmentation fault Quote Link to comment Share on other sites More sharing options...
frankc420 Posted December 7, 2009 Share Posted December 7, 2009 After doing a good bit of pondering, I figured it had to be crashing out because of all of the products we have. So, I installed a default OSC store and installed the feedmachine solution, it successfully generated 27 products. So, this brings me to my next question, how can we get this to work with larger stores? Thanks, Frank Quote Link to comment Share on other sites More sharing options...
kamalboucetla Posted December 8, 2009 Share Posted December 8, 2009 Hello, I've just installed this on oscommerce 2.2 and i'm getting this error message when I try and generate an upload feed: Server Requirement Error: register_globals is disabled in your PHP configuration. This can be enabled in your php.ini configuration file or in the .htaccess file in your catalog directory. However, when i enable register_globals the entire site falls over with a http:500 server error. Please could you advise on how to get around this? Thanks, Kamal Quote Link to comment Share on other sites More sharing options...
clarry Posted December 9, 2009 Share Posted December 9, 2009 Hi, I am trying to get this working on a heavily modified version of oscommerce. Seems to all be ok but the feed is going to an https:// URL and we do not currently have an SSL certificate enabled on the site. Web Location of your feeds https://www.balloondelivery2u.co.uk/fm-feeds/ Can you let me know where I can change this configuration. Thanks Quote Link to comment Share on other sites More sharing options...
frankc420 Posted December 9, 2009 Share Posted December 9, 2009 Hi, I am trying to get this working on a heavily modified version of oscommerce. Seems to all be ok but the feed is going to an https:// URL and we do not currently have an SSL certificate enabled on the site. Web Location of your feeds https://www.balloondelivery2u.co.uk/fm-feeds/ Can you let me know where I can change this configuration. Thanks Just remove the s from the https... no longer secure. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 9, 2009 Share Posted December 9, 2009 Hi, We are currently using the Feedmachine to upload our products to Google Shopping. All is working well apart from one thing, we are using Salemaker to promote a 10% discount Christmas sale at the moment, and the Feedmachine does not find the correct, lowered price. I have had a go at fixing this myself, but must admit I'm not the best coder in the world! Do you know of a way that I could make this work for us please? Many thanks in advance, Bill Quote Link to comment Share on other sites More sharing options...
frankc420 Posted December 9, 2009 Share Posted December 9, 2009 marco? Quote Link to comment Share on other sites More sharing options...
lech Posted December 9, 2009 Author Share Posted December 9, 2009 Hey guys, I will reply shortly. Quote Link to comment Share on other sites More sharing options...
clarry Posted December 9, 2009 Share Posted December 9, 2009 Hi, Thanks! Removing the S worked perfectly and the products are now live on google which is great but.... (always a but!) none of the pictures are uploading, not sure why, we have got a modified version if OSCommerce which has extra images but the feed is displaying a link to images that doesn't work so for example http://www.balloondelivery2u.co.uk/images/f350942921ee21ef5589bee91c4357f7.jpg The actual image can be seen here http://www.balloondelivery2u.co.uk/images/products/original/product-id-144.jpg Any ideas how I can fix this? Thanks Quote Link to comment Share on other sites More sharing options...
frankc420 Posted December 9, 2009 Share Posted December 9, 2009 Hey guys, I will reply shortly. Sweetness! I'm hoping you have a solution for large stores =) Hi, Thanks! Removing the S worked perfectly and the products are now live on google which is great but.... (always a but!) none of the pictures are uploading, not sure why, we have got a modified version if OSCommerce which has extra images but the feed is displaying a link to images that doesn't work so for example http://www.balloondelivery2u.co.uk/images/f350942921ee21ef5589bee91c4357f7.jpg The actual image can be seen here http://www.balloondelivery2u.co.uk/images/products/original/product-id-144.jpg Any ideas how I can fix this? Thanks Glad I could help with the https thing, lech or someone with some experience with this script will have to chime in on your issue. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.