Google Base Feeder Support Thread [OLD]

SaMortensen:

Yes, mine is a version 5 - so does that mean this will be something I will be unable to use unless my host upgrades? Or does someone know how to work around this issue?

Actually, the problem is...your host DID upgrade. Which means I'm going to have that problem soon because my host is planning on upgrading in the next few weeks.....oh this is gonna be bad.

It means a lot of scripts will have to be updated to use a different SQL query command. I'll look into it in the future but cannot say when.

my sites are running mysql 5 and ive got no problems!!

I just downloaded and installed the latest version 1.6.8, and my question is regarding the "sql updates" folder that came with the installation files. Am I supposed to install each sql updates in that folder? Or do I only install the one sql file that is outside of the folder: update_1_6_8.sql? It would seem that I'm supposed to install all of them otherwise why would they be included. But just want to make sure.

Thanks,
Brian

That depends, are you installing a fresh copy or upgrading from a previous version?

If you are upgrading, then you need to run the sql patches for all version between your old version and the new version. The patch outside of the previous_sql_patches folder is the current sql patch to upgrade from the version exactly previous to the current version (i.e. v1.6.7).

I love this contribution, but I'm having trouble getting it to work with Google base. I always get an "Upload Failed" message when I try to manually upload the output of googlefroogle.php indicating that something was wrong with the XML format.

Is anyone else having this problem?

Thanks!

I noticed that special characters (such as the German ä,ü,ö) are not processed when creating the XML file. The language is set to English, but some products and manufacturers names contain these characters.

They may have been removed as they will cause XML parsing errors.

UTF-Charachters don't cause parsing errors and a look at the german google base shows me it is supported.

I checkeded out the code and the following command on line 461 is the culprit:

$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?]", "", $str);

A quick fix for umlauts would be something like:

$str = eregi_replace("[^[:alnum:][:space:].,!()'-_/+=?äÄöÖüÜß]", "", $str);

I'm testing this out, but there must be some easier way to filter out the "bad stuff" but still keep all the UTF-8 goodness.

mypashop:

HOW do you limit
Default limit google base feeder to one language (english only) ...
is there a need / recommended to limit to one and only language ?

to not spam google base i would like to turn french and german off ...

please reply in this thread
http://www.zen-cart.com/forum/showthread.php?t=85506

Sorry to bug you numinix about all the lanuage issues. I have the same thing as this person had, yet when I set the language to english only, it still parses out all the rest.

I checked the code and ```php
$languages->fields['languages_id'];

I've made some minor changes in the latest version, hopefully it will make a difference.

I have installed this mod and I can't get the products to show up on google.
The SQL installed correctly and the google base tab shows up under tools in the admin.
When I create the feed it processes correctly and when I upload the feed it says it uploaded successfully. My feed folder has data in it.
What about the settings at google. Do I need to change the following:

Encoding
UTF-8 Latin-1

Delimiter
Tab (\t) Pipe (|) Tilde (~)

What should these be set to?

My web address is: https://myshop.internationalcoffeeandbeverage.com/secure

coucho:

I have installed this mod and I can't get the products to show up on google.
The SQL installed correctly and the google base tab shows up under tools in the admin.
When I create the feed it processes correctly and when I upload the feed it says it uploaded successfully. My feed folder has data in it.
What about the settings at google. Do I need to change the following:

Encoding
UTF-8 Latin-1

Delimiter
Tab (\t) Pipe (|) Tilde (~)

What should these be set to?

My web address is: https://myshop.internationalcoffeeandbeverage.com/secure

I went to my feeder file and copied the contents into .txt format and manually uploaded the file. It got published so something is getting lost in translation with my google base feeder. Any suggestions?

The file should be registered as .xml

numinix:

The file should be registered as .xml

In the feed file it is an .xml file but I'm having to go into my file system and copy the contents from within the folder, open notepad and save as a text file. I then manually upload to google. My products are getting published that way but I can't get them published using google base ftp from within the admin. It tells me the products upload ok but they never show up in google base. I have rechecked my ftp settings and all the settings are correct. I'm on a dedicated server and my host allows ftp transfers.

It sounds like you just need to tell google to expect an xml file rather than a txt file.

Ok, hopefully I can find some help with this...

I have version 1.6.8 installed and running (kinda)...

When I create a product feed all I get is a text file without any extension (not xml and no "_products.xml" on the end)

I have been making this work by calling the file "froogle.txt" and uploading that to Google...

But now they need the unique product ID in the file - I do have this turned on in the configuration, but it just won't show up in the text file... any ideas on what's going on? (the two problems may be related - but even if I can get the txt file to work would be great)

I am running zencart 1.3.8 - I have also uninstalled and reinstalled the mod to no avail - always get the same results...

Any help would be appreciated.

http://www.numinix.com/index.php?main_page=document_general_info&products_id=756

coucho:

In the feed file it is an .xml file but I'm having to go into my file system and copy the contents from within the folder, open notepad and save as a text file. I then manually upload to google. My products are getting published that way but I can't get them published using google base ftp from within the admin. It tells me the products upload ok but they never show up in google base. I have rechecked my ftp settings and all the settings are correct. I'm on a dedicated server and my host allows ftp transfers.

I don't know why but the base feeder started working tonight. I have changed no settings since I installed this mod. Maybe it was a google thing.

I use zencart1.38a, and Google Base Feeder 1.6.11,but I got this erorr
PHP Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /home/www/www.xxx.com/data/googlefroogle.php on line 452