Hi Tom, Thanks for the suggestion. Definitely looks like you've got some cool products developed, and no doubt, that would be an easier route for me to go. However, since I've essentially automated myself out of a job so far (I manage a web store), this is the one last project I have that justifies my full-time status, so I'll take as long as it takes to learn to do it myself! :)
I think that what you've described is basically what I'm doing. I have the mySQL query set up so that it exports with all the information and formatting that I want. I'm using the API sample code to figure out how to upload automatically. Then I'll put those two things together and have the formatted mySQL output upload automatically. I want it completely automated so that whoever takes over my position after men (likely a high school kid) can just go to the php program and click the Submit button and the relevant updates will be sent automatically. (And, I haven't looked into it yet, but if I find a way to just set a cron job so no one even had to press Submit, that will be even cooler). In order to do that, I still need to understand how the link attribute works in the sample code, and why it's not taking it the way I expect. And I also need to know how to view the response to know if something isn't working right. I see that I'm not the only person in the group who has had a hard time with the link attribute, as this question has been asked several times before, but none of them was using php4, so the answers didn't seem to apply to me. Both of my questions seem less like a hole in my understanding and more like a hole in the documentation, unless I'm missing the information somewhere. Thanks for any help! Peace, DeAnna On Oct 2, 5:46 am, Tom Wilson <[EMAIL PROTECTED]> wrote: > If you new to PHP then the API may not be the best option, using PHP > look at maybe export the mySQL in a accepted format first (i.e. a data > feed). > > From there at least you can start to format a file which can be much > more straight forward which can be uploaded to Google Base. After > that, from there it can be automated to create and send the file > automatically. > > If your interested i offer this service (see my website below) > > Tom Wilson > Freelance Google Base Developer and Consultantwww.tomthedeveloper.com > > Google Base Tools -http://dev.tomthedeveloper.com/googlebase > Featured Project > :http://google-code-featured.blogspot.com/2008/02/google-base-competit... > > On Oct 1, 11:11 pm, deandail <[EMAIL PROTECTED]> wrote: > > > I'm really in over my head here, so I'm hoping someone can toss me a > > line. I don't know php at all, have been diving in and learning a lot > > about it in the last week as I try to create a program that will > > connect our mySQL database inventory to Base. Every time I correct one > > error, I seem to create another one. > > > I started with the php sample app and have been modifying it a bit at > > a time in order to get it to do what I want. There are two things I > > really need. > > > 1) On the API Demo page, it shows the text of the request that was > > sent and the response returned by Google. How can I see that response > > to my php request so that I can see what exactly is failing? > > > 2) The link attribute doesn't seem to like my product url's. The item > > is inserted, but the url remains the Base url > > (likehttp://base.google.com/base/a/3164105/D10047083153294548248) instead > > of my actual product link. Here's what the code looks like: > > > $result .= "<link href='".$_POST['link']."'". "/>" . "\n"; > > > And here's the part of the form where I'm inputting the link: > > > print '<tr><td align="right">link</td>' . "\n"; > > print '<td><input type="text" name="link"></td></tr>' . "\n"; > > > I really appreciate any help. > > Thanks, > > DeAnna --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
