Google Base Feeder Support Thread [OLD]

[NFM]

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.

[numinix]

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.

[kitcorsa]

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

[bacibacio]

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

[numinix]

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).

[Wacheena]

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!

[tuor]

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.

[numinix]

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

[tuor]

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.

[tuor]

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

$languages->fields['languages_id']; 

is set to 1, which is correct. However my XML file still contains all the other languages. Any tips?