Author |
Topic |
|
candude
VP-CART New User
Canada
77 Posts |
Posted - April 06 2004 : 07:59:33
|
Here is a froogle script I wrote not so long time ago..
Just upload it to ya site, run, save it as a txt file and feed it to Froogle.. Enjoy..
SCRIPT IS FREEWARE AND COMES AS IS... --------------- <html><body><pre> product_url name description price image_url category <% strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=c:\YOURDBLOCATIONHERE\shopping450.mdb" Set objConn = Server.CreateObject("ADODB.Connection") objConn.open strconn Set oRs = Server.CreateObject ("ADODB.RecordSet") Set oRs2 = Server.CreateObject ("ADODB.RecordSet") oRs.open "select catalogid, cname, cdescription, cprice, keywords, cimageurl from products where cstock > 0", objConn,3 while not oRs.eof
description = replace(oRs("cdescription"), chr(10), "") description = replace(description, chr(13), "") description = replace(description, chr(34), "ft.")
oRs2.open "select intcategoryid from prodcategories where intcatalogid = "&oRs("catalogid"), objConn, 3
'Enter your category name here (ie. Books, Music & Video > Video) category = "Books, Music & Video > Video"
oRs2.close
response.write "http://www.YOURSITE.com/shopquery.asp?catalogid="&oRs("catalogid")&" "&oRs("keywords")&" pattern "&oRs("cname")&" "&description&" "&oRs("cprice")&" http://www.YOURSITE.com/"&oRs("cimageurl")&" "&category&chr(13)&chr(10)
oRs.movenext wend oRs.close objConn.close %> </pre></body></html>
|
|
MiniMe
Starting Member
24 Posts |
Posted - April 14 2004 : 00:14:30
|
Thanks for sharing!
Just a quick question. I'm by no means an advanced programmer so forgive me if this is a dumb question:
My site is hosted with a hosting company so I don't know the absolute path of the site. Where you have: DBQ=c:\YOURDBLOCATIONHERE\shopping450.mdb
Can I use the Server.MapPath method?
Thanks again!
|
|
|
candude
VP-CART New User
Canada
77 Posts |
Posted - April 16 2004 : 06:28:00
|
Mini,
Why do not you use the same DB config string that you have in the shop$config.asp file???
Just open your file and copy location string from "xdblocation". Unless of course you have it on SQL Server....
Good luck!
I either want less corruption or more chance to participate in it. |
|
|
revrat
Starting Member
47 Posts |
Posted - April 24 2004 : 16:43:03
|
works great but it does not produce a delimited file for me. Have I done something wrong?
|
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
Posted - April 24 2004 : 17:56:51
|
if you want a full-blown froogle-feed generator (for vpasp v4.5 and v5; both versions included), try:
http://bigyellowzone.com/shopdisplayproducts.asp?product=froogle
billions of options on it, and easy to run/install; just upload the files to your site, add the new screen to your admin menu, and then press a button to generate the files.
options include things like upc, using different category options, different values for offerid's allowed, instock flags, etc etc etc.
the options are done in 2 ways; there's a config file where you can change your default options. and the feed-generator admin screen itself has all the options available in its form as text fields, poplists etc. also gives you the count of products in your database grouped by stockflag, hideflag etc so you can compare that against how many products end up in your feed file (feed-file record count also shown on the results page, along with the link to the feed file that's been generated).
database connection isn't specified in the config options; it just uses your standard vpasp connection string that's already setup in your admin pages.
Also strips-out/translates relevant characters that the froogle people don't accept, and organises your category field with the froogle-style "a>b" structure.
Simon Barnaby Freelance Developer Java-E UK [email protected]
Edited by - devshb on April 24 2004 18:24:52
Edited by - devshb on August 20 2004 13:34:55 |
|
|
revrat
Starting Member
47 Posts |
Posted - April 25 2004 : 11:34:20
|
Thanks
I actually figured out my problem and made some other changes but I might check out that script. I like the Invoice script I got last month from Sambru.
|
|
|
JBE
Starting Member
1 Posts |
Posted - April 26 2004 : 20:24:08
|
We went for the full version. Works great and very easy to use. It dramatically increased our Froogle presence. We were especially pleased with the tech support.
|
|
|
devshb
Senior Member
United Kingdom
1904 Posts |
|
|
Topic |
|