Google Base Feeder Support Thread [OLD]

[james739]

Just wondering, how would I know if my file has been uploaded successfully. Alos, would I have to create a froogle.txt file name at the google base website?

[barricades]

Hi,
First off, thanks for a great contribution

I've searched this thread and read all the posts that I can find that might be of use but haven't come across the answer to my problem yet.

I get the following when i try to upload the file that the mod creates

-----------------------------

Google Base Feeder v.1.5.3 28.08.2007 10:25 started 2007/10/19 12:50:56
Feed file - /hsphere/local/home/burningbarricade/traditionalirishgifts.com/feed/google_base.xml
Processing: Feed - No, Upload - Yes
Upload started...
First attempt (passive mode off): Upload Failed
Connected to: uploads.google.comLogin ok:Current Directory Is: /

Upload failed...

-------------------------------

Can any nice person please tell me what I'm doing wrong

cheers

[Invizix]

Just wondering, how would I know if my file has been uploaded successfully. Also, would I have to create a froogle.txt file name at the google base website?

You will know it is uploaded sucessfully because the uploader informs you "Upload OK!" it will also showup in your Google Base account with the filename you registered. Speaking of which, to answer your second question, the answer is YES you need to register the google_base.xml within your Google Base account.

The answer is located in the readme.txt file under the Install: section. It is as follows... 6. Register your bulk upload .xml file using the same name in your Google Froogle Configuration at base.google.com

This means that if your default .xml file is google_base.xml then you would register the file in your Google Base bulk uploads section with a filename of google_base.xml - when you register the file there is no need to upload the filename using Google Base bulk file uploader, simply use the one provided by the Google Base Feeder Zen-Cart plugin. Wait a few minutes and you'll see your Active tab be populated with products.

I hope I have been helpful.

[numinix]

Remember also that v1.6.X appends the feed type to your name. In the above example, the feed file would be called google_base_products.xml or google_base_documents.xml.

[warefare]

awesome module, i'm trying to install it right now

it's weird i'm installing the latest version and uploaded everything and installed the sql patches but there is no "configuration"

it's the same problem here
http://www.zen-cart.com/forum/showpo...&postcount=421

I get the sql error

Google Base Feeder v.1.6.2 01.10.2007 18:15:59 started 2007/10/20 22:43:51
Feed file - /www/htdocs/w008f72a/feed/domain_documents.xml
Processing: Feed - Yes, Upload - No
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_last_modified DESC' at line 11
in:
[SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_type, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0), IFNULL(p.products_date_available, 0)) AS base_date, m.manufacturers_name, pt.type_handler FROM fw_products p LEFT JOIN fw_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN fw_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN fw_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.products_type = 3 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_last_modified DESC]

just like him ..
but i double checked that all files are there


any ideas ?

[warefare]

hmm can I edit posts here btw ?


I'm using SEO url's and the language file is uploaded correctly I can access the googlefroogle.php via admin menu but not the configuration

[warefare]

someone please increase the edit time this is ridiculous short

alright here is what I've found out so far:
I think all ppl with that problem have called their db differently
my db is called fw_xxxx instead of zen_xxxx

It's "processing" the sql statements but it doesnt insert the data somehow!
Well my other theory is that it's a language problem but that wouldn't make much sense it's probably a db problem.

edit:

alright

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 'true', 'false'),'), (NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DIS' at line 1

that's what i got when i tried to upload the sql patch INSTEAD of inserting it manually

=> it's a sql error; i will post a solution later (hopefully)

[numinix]

As stated in a previous post, this is due to not properly defining the language in the configuration. If your configuration is not installed, then you haven't properly patched your database by copying and pasting the SQL statements.

[warefare]

As stated in a previous post, this is due to not properly defining the language in the configuration. If your configuration is not installed, then you haven't properly patched your database by copying and pasting the SQL statements.

the sql syntax is not correct i think
I have properly inserted the sql statements manually (it's not that difficult ^^)
so there is a problem in the code

that's the full line where the problem is supposed to be

(NULL, 'Show Default Currency', 'GOOGLE_FROOGLE_CURRENCY_DISPLAY', 'true', 'Display Currency', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),

[warefare]

#GOOGLE BASE FEEDER
#
#REMOVE #'s BELOW TO INSTALL UPC/ISBN SUPPORT:
#ALTER TABLE products ADD products_upc varchar(32) NULL default NULL after products_model; 
#ALTER TABLE products ADD products_isbn varchar(32) NULL default NULL after products_upc;

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Base Feeder Configuration'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, 

sort_order, visible) VALUES (NULL, 'Google Base Feeder Configuration', 'Set Google Base Options', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, 

configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'Google Base FTP Username', 'GOOGLE_FROOGLE_USERNAME', 'ftp_username', 'Enter your Google Base FTP username', 

@configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Google Base FTP Password', 'GOOGLE_FROOGLE_PASSWORD', 'ftp_password', 'Enter your Google Base FTP password', 

@configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Google Base Server', 'GOOGLE_FROOGLE_SERVER', 'uploads.google.com', 'Enter froogle server<br />default: 

hedwig.google.com', @configuration_group_id, 0, NOW(), NULL, NULL),
(NULL, 'Store Address', 'GOOGLE_BASE_ADDRESS', 'http://www.domain.com', 'Enter your website address', 

@configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Store Description', 'GOOGLE_BASE_DESCRIPTION', '', 'Enter a short description of your store', 

@configuration_group_id, 1, NOW(), NULL, NULL),

this is working when i remove the highlighted red ":"

the rest is not working yet <.< trying to find the error now