Google Base Feeder Support Thread [OLD]

[numinix]

UPDATE!

Google Base has alerted me, as I had just completed the Google Base Adwords support, that they are discontinuing Google Base Adwords.

Please revert back to v1.3.8 until I release v1.4.1 which will also allow you to feed only certain categories. Should be ready in the next few days.

[numinix]

v1.4.1 - GOOGLE BASE FEEDER

1. Removed Google Base Adwords;
2. Allow category selection;
3. Module now known as Google Base Feeder;

#2 was completed as a special request by a user in this thread. I will consider requests for the Google Base Feeder, but please donate as a lot of time and effort is put into updating this module.

[Woodymon]

- GOOGLE BASE FEEDER
Module now known as Google Base Feeder.

Time to create a brand new thread titled "Google Base Feeder support" or similar ;-)

Woody

[PastGenToys]

Numinix,

I uggraded to the current version ( I was two back) and I still get the same message when I try to see the files in google base:

Froogle Merchants FTP content:
Connected to: uploads.google.com
Connection failed: uploads.google.com
I do have the correct username / pw in the cart. It does create the file but I have to manually load it in google base to make it work. Any suggestions?

[motti]

[FONT=Times New Roman]Hi[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]This is the error I am getting[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]It is a fresh install of the 1.41 on zen 1.37 , I set the feed and his folders to 777[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Froogle Data Feeder v.1.4.1 09.07.2007 12:00 started 2007/07/09 16:22:35
Feed file - /home/tiledepo/public_html/store/feed/GOOGLE_FROOGLE_OUTPUT_FILENAME
Processing: Feed - Yes, Upload - No[/FONT]
[FONT=Times New Roman]1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY p.products_id ASC' at line 13
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler, pc.categories_id, cd.categories_name, c.parent_id FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN products_description pd ON (p.products_id = pd.products_id) LEFT JOIN product_types pt ON (p.products_type=pt.type_id) LEFT JOIN products_to_categories pc ON (p.products_id = pc.products_id) LEFT JOIN categories_description cd ON (pc.categories_id = cd.categories_id) LEFT JOIN categories c ON (c.parent_id = pc.categories_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC][/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]please advice[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]p.s i tought i already post it here, for some reason i dont see my earlier post[/FONT]
[FONT=Times New Roman]Thank you[/FONT]

[motti]

I got it to work

Just run the sql file again and it all ok now

[numinix]

Numinix,

I uggraded to the current version ( I was two back) and I still get the same message when I try to see the files in google base:

Froogle Merchants FTP content:
Connected to: uploads.google.com
Connection failed: uploads.google.com
I do have the correct username / pw in the cart. It does create the file but I have to manually load it in google base to make it work. Any suggestions?

You are using the FTP username and password and not your Google Base account settings right?

I got it to work

Just run the sql file again and it all ok now

It clearly says to cut and past the SQL file and not use UPLOAD in order to avoid any errors.

[PastGenToys]

You are using the FTP username and password and not your Google Base account settings right?

I am using the FTP creds. I tested that by using the same creds to open the actual FTP site within Google Base.

[numinix]

Oops, the error you are getting has nothing to do with your login information. Your host isn't connecting to Google. This part of the script was written previous to my updates so I am not too familiar with the requirements for the ftp_connect() functions used in the script. Try contacting your host.

Also, could you please time the length it takes to return the "connection failed".

The script uses the default timeout of 90 seconds.

Try changing the code on line 366 and 368 from:

if($ssl)
   $cd = ftp_ssl_connect($url);
  else
   $cd = ftp_connect($url); 

to:

if($ssl)
   $cd = ftp_ssl_connect($url, 21, 120); // port 21: timeout: 120 seconds
  else
   $cd = ftp_connect($url, 21, 120); 

[numinix]

Time to create a brand new thread titled "Google Base Feeder support" or similar ;-)

Woody

The mod name was changed automatically when I upgraded to 1.4.0b so I thought I might as well make it official. I'll just get this thread renamed.