Hi deandail, To point the link to your own site the format is: <link rel='alternate' type='text/html' href='http://ENTER-YOUR-URL'/>
(The important part is the rel='alternate') Viewing the response from the Google Base server will depend on how you're submitting the data. The php4 sample you mentioned uses libcurl, so I would use that to echo the result of the curl_exec(): $result = curl_exec($ch); /* Execute the HTTP command. */ curl_close($ch); echo '<pre>' . $result . '</pre>'; // result will contain the server's response Eric On Oct 2, 1:16 pm, deandail <[EMAIL PROTECTED]> wrote: > Thanks celebird, > > Maybe I don't understand how the ftp route works, but I didn't think > it did what I want. > > Specifically, we have around 18,000 products. Right now, I use a mySQL > query to download that into a csv file, which I upload manually to > Base once a month. There are two problems with that: > > 1) It takes me a fair amount of time to configure the file correctly, > and future holders of this position likely won't know how to do that. > > 2) (And the much bigger issue) We sell and receive product every day, > so by the end of the month our Base inventory is sadly out of date. We > see our bounce rates increase steadily over the course of the month as > people more often click on something in Base that we don't actually > have in our online store. > > 3) (not a problem per se, but to be noted) It takes Base a couple days > to make searchable an upload with several thousand products in it. > > So I could just upload the spreadsheet more often in order to make it > more accurate, say once a week instead of once a month, and I could > even automate that via FTP. But I don't want our full inventory to be > unsearchable for 2 days out of every week. > > What I want to do is insert new products and delete products that we > no longer have in stock each day without re-uploading the full > inventory. The insertions and deletes would only total around a dozen > or couple dozen changes a day. My understanding is that the FTP feed > needs to have the same name each time in order for it to be automated, > therefore overwriting the previous file. So if I have a feed where > I've uploaded all 18,000 items, and then I send a subsequent file with > just a few updates, it will overwrite the whole previous file, leaving > me with only those updated items in Base. > > Do I misunderstand how the ftp process works? Or is some version of > the API system what I need in order to do what I want? > > If the API is what I need, then here are the answers to your other > questions. > I am right now just doing single item entries until I figure out how > the process works. In the future I will use the batch feature to send > two separate requests: insert new items, delete sold items. > > The example code I started with can be found > herehttp://code.google.com/apis/base/samples/php/php-sample.html > > The two pieces of that sample that I have changed have been the > function to build the insert xml and here is my version of that piece > function buildInsertXML() { > $result = "<?xml version='1.0'?>" . "\n"; > $result .= "<entry xmlns='http://www.w3.org/2005/Atom'" . " > xmlns:g='http://base.google.com/ns/1.0'>" . "\n"; > $result .= "<category scheme='http://base.google.com/categories/ > itemtypes'" . " term='Products'/>" . "\n"; > $result .= "<title type='text'>" . $_POST['title'] . "</title>" . > "\n"; > $result .= "<g:item_type>Products</g:item_type>" . "\n"; > $result .= "<g:price>" . $_POST['price'] . "</g:price>" . "\n"; > $result .= "<id>" . $_POST['id'] . "</id>" . "\n"; > $result .= "<g:image_link>" . $_POST['image_link'] . "</ > g:image_link>" . "\n"; > $result .= "<link href='".$_POST['link']."'". "/>" . "\n"; > $result .= "<content>" . $_POST['description'] . "</content>" . "\n"; > $result .= "</entry>" . "\n"; > return $result; > > And then I've updated the form where a user manually inputs the > content for those fields, so that I can test and make sure I've got it > all formatted correctly before I switch to a batch setup. That piece > of code I've modified to this > /** > * Prints a small form allowing the user to insert a new > * recipe. > */ > function showRecipeInsertPane($token) { > global $cuisines; > print '<td valign="top" width="50%">' . "\n"; > print '<table width="100%">' . "\n"; > print '<tr><th colspan="2" style="text-align:center">Insert a new > recipe</th></tr>' . "\n"; > print '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">' . > "\n"; > print '<input type="hidden" name="action" value="insert">' . "\n"; > print '<input type="hidden" name="token" value="' . $token . '">' . > "\n"; > print '<tr><td align="right">Title:</td>' . "\n"; > print '<td><input type="text" name="title" class="half">' . '</td></ > tr>' . "\n"; > print '<tr><td align="right">Type</td>' . "\n"; > print '<td><input type="text" name="product_type" class="half">' . > '</td></tr>' . "\n"; > print '<tr><td align="right">Price</td>' . '<td><input type="number" > name="price"> ' . '</td></tr>' . "\n"; > print '<tr><td align="right">ID</td>' . '<td><input type="number" > name="id"> ' . '</td></tr>' . "\n"; > print '<tr><td align="right">Image Link</td>' . "\n"; > print '<td><input type="text" name="image_link"></td></tr>' . "\n"; > print '<tr><td align="right">link</td>' . "\n"; > print '<td><input type="text" name="link"></td></tr>' . "\n"; > print '<tr><td align="right">Description</td>' . "\n"; > print '<td><textarea class="full" name="description"></textarea></ > td></tr>' . "\n"; > print '<td> </td><td><input type="submit" value="Submit"></ > td>' . "\n"; > print '</form></tr></table>' . "\n"; > print '</td>' . "\n"; > > } > > In the first block, here is the one line that references the link > attribute > $result .= "<link href='".$_POST['link']."'". "/>" . "\n"; > and that url is currently being input by hand in the insert form. The > url is accepted, but doesn't attach itself to the item the same way it > does if I enter a link in the csv file. The item isn't linked to our > site. > > On Oct 2, 11:46 am, Celebird <[EMAIL PROTECTED]> wrote: > > > the google-base-api isn't needed to upload a feed-file; > > you can simply invoke ftp. > > > i believe tom's suggestion is not to use the google-base api > > at all, none of it -- so you don't need to deal with details > > like response to requests or creating proper link constructs. > > > rather, create a tab-delimited-file direct from sql > > and then simply use ftp to upload the file; and with > > google's scheduled-feed feature the ftp step can be > > skipped altogether; so, a tsv, csv, or xml-feed-file > > can be created without the google-base-api. > > > that said, are you doing direct per-item inserts > > or are you trying to use a batch-operations-feed? > > why is there a form to input a link-attribute? > > exactly which example code is being used? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Base Data API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Base-data-API?hl=en -~----------~----~----~----~------~----~------~--~---
