Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › Exporting for googlebase

Exporting for googlebase

Thread began 7/15/2009 3:57 pm by sales356151 | Last modified 7/30/2009 10:18 am by Jason Byrnes | 1733 views | 3 replies |

7/15/2009 3:57 pm | #1 sales356151

Exporting for googlebase

Hi can anyone tell me if there is a way to generate a Excel sheet or something that googlebase will accept.

I have a client who wants to submit his products to googlebase through a excel file (Tab Deliminated) or something like that.

Can anyone point in right direction, exporting the product database from MySQL wont work as it needs to pull info from 2 tables and only include certain information.

Any advice would be a great help

thanks
Jamie

7/15/2009 11:47 pm | #2 CraigRBeta Tester

you say export from mySQL won't work as you need data from 2 tables, and only certain information.

Is it not possible to write a query to generate only the data you need ?

7/16/2009 12:07 pm | #3 tom250037Beta Tester

You should be able to write a query that joins the two tables (I am guessing products and options).
I have done this for a number of clients to import into google base. I usually export xml files though, as opposed to a csv.

Tom

7/30/2009 10:18 am | #4 Jason ByrnesWebAssist

You can use the MySQL GUI Tools Query browser.

In the Query Browser, you can create the join query to get the needed data and execute the query.

The go to File -> Export Result Set. There are options to export as a CSV or Xcell file as well as HTML, XML or PLIST files.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.