Re: ups quickcost [repost]

This WebDNA talk-list message is from

1999

It keeps the original formatting. numero = 25095
interpreted = N
texte = Josh, thank you very much for trying to help.but the problem I'm having is that people keep repeating statements like From the UPSwebsite you should be able to find all the info needed to make create these Databases.I agree, I _should_ be able to do that... GRRRR ARRRGH... I have been ALL over the UPSsite, and the product codes elude my tiny brain. Could you PLEASE post yourshippingLookup.db to the list? so that it appears in the webcat archive? (oh, and topreserve my sanity as well)TIA-AaronJosh Tiger wrote:> Here is some webcat code that will generate a drop down menu of all UPS> products and prices for a desintation, drop off point, weight and package> type. In order for this code to work you will need a database of all country> codes. and a small Convertchars database which converts % to |. I find it is> easier to parse through a long string looking for | instead of %. I am not> really sure why I converted chars in the first place, but it works. You will> have to go in and modify certain parts which have hard coded values. This> code was designed to work in a checkout so some of the values are variables> being passed in a form. All the comment tags are placed there to prevent a> ton of white space from being generated. It also uses another small database> to convert UPS product codes into English words. I call this db> shippingLookup.db. From the UPS website you should be able to find all the> info needed to make create these Databases.>> Josh Tiger> Pop Art LLC>> [HIDEIF [shipToBill]=true][text show=f]destCountry=[LOOKUP> db=includes/UPS_country_codes.db&value=United> States&lookInField=CountryName_H&returnField=CountryCode_H¬Found=ERROR][/> TEXT][/HIDEIF][!]> [/!][SHOWIF [shipToBill]=true][text show=f]destCountry=[LOOKUP> db=includes/UPS_country_codes.db&value=[Country]&lookInField=CountryName_H&r> eturnField=CountryCode_H¬Found=ERROR][/TEXT][/SHOWIF][!]> [/!][text show=f]destZip=[HIDEIF> [shipToBill]=true][shipToZip][/HIDEIF][SHOWIF> [shipToBill]=true][ZIP][/SHOWIF][/text][!]> [/!][text show=f]residential=0[/text][!]> [/!][text show=f]weight=[totalWeight][/text][!]> [/!][text show=f]response=[middle> startafter=UPSOnLine&endbefore=][tcpconnect> host=www.ups.com&port=80][tcpsend]GET> /using/services/rave/qcostcgi.cgi?accept_UPS_license_agreement=yes&10_action> =4&14_origCountry=US&15_origPostal=90007&22_destCountry=[destCountry]&19_des> tPostal=[destZip]&49_residential=[residential]&47_rate_chart=Regular+Daily+P> ickup&48_container=00&13_product=GNDCOM&23_weight=[weight]&weight_std=lbs.> HTTP/1.0> [UnURL]%0D%0A%0D%0A[/UnURL][/tcpsend][/tcpconnect][/middle][/text][!]> [/!][math show=f]percentCount=0[/math][!]> [/!][text show=f]response2=[convertchars> db=includes/UPSconversions.db][response][/convertchars][/text][!]> [/!][math show=f]errorCheck=0[/math][!]>> [/!][ListWords Words=[response2]&Delimiters=;][!]> [/!][SHOWIF [word]~4][!]> [/!][Math show=f]errorCheck = errorCheck + 1[/math][!]> [/!][/SHOWIF][!]> [/!][/LISTWORDS][!]>> [/!][HIDEIF [errorCheck]=0][!]>> [/!]> Select One[!]> [/!][ListWords Words=[response2]&Delimiters=;][!]> [/!][SHOWIF [word]~4][!]> [/!][math show=f]productStart=0[/math][!]> [/!][math show=f]productEnd=0[/math][!]> [/!][math show=f]priceStart=0[/math][!]> [/!][math show=f]piceEnd=0[/math][!]> [/!][math show=f]percentCount=0[/math][!]> [/!][loop start=1&end=[countchars][word][/countchars]&advance=1][!]>> [/!][showif [GetChars start=[index]&end=[index]][word][/GetChars]=|][!]> [/!][math show=f]percentCount= percentCount + 1[/math][!]>> [/!][showif [math show=t]percentCount%12[/math]=1][!]> [/!][math show=f]productStart=[index]+1[/math][!]> [/!][/SHOWIF][!]>> [/!][showif [math show=t]percentCount%12[/math]=2][!]> [/!][math show=f]productEnd=[index]-1[/math][!]> [/!][/SHOWIF][!]>> [/!][showif [math show=t]percentCount%12[/math]=10][!]> [/!][math show=f]priceStart=[index]+1[/math][!]> [/!][/SHOWIF][!]>> [/!][showif [math show=t]percentCount%12[/math]=11][!]> [/!][math show=f]priceEnd=[index]-1[/math][!]> [/!][/SHOWIF][!]>> [/!][SHOWIF [math show=t]percentCount%12[/math]=0][!]> [/!][HIDEIF [getchars> start=[productStart]&end=[productEnd]][word][/getchars]=GNDCOM] VALUE=[getchars> start=[productStart]&end=[productEnd]][word][/getchars]|[getchars> start=[priceStart]&end=[priceEnd]][word][/getchars]>[LOOKUP> db=../shipping/shippingLookup.db&value=[getchars> start=[productStart]&end=[productEnd]][word][/getchars]&lookInField=productC> ode_h&returnField=product_h¬Found=TextIfNotFound] - $[getchars> start=[priceStart]&end=[priceEnd]][word][/getchars][/HIDEIF][!]>> [/!][/SHOWIF][!]>> [/!][/SHOWIF][!]> [/!][/LOOP][!]> [/!][/SHOWIF]> [/ListWords]> > [/HIDEIF]>
>> [SHOWIF [errorCheck]=0]> Sorry, but you have chosen an invalid shipping> address. Most likely you have entered a zip/postal code which does not match> the country.> Please click your browser's back button and make the necessary> corrections.> [/SHOWIF]> ----- Original Message -----> From: Aaron Lynch > To: WebCatalog Talk > Sent: Monday, December 06, 1999 9:18 AM> Subject: Re: ups quickcost [repost]>> > Where? Are you talking about> > http://www.ups.com/using/services/rave/rate.html ?> >> > my experience with webcat 3 is pretty limited, it> > seems like it would be a lot harder to parse useful> > info out of that result page, rather than using the> > webcat snippet. I can't believe UPS makes their rates> > this tough to comprehend...> >> > If that's not the script you refer to would you please> > post a URL?> >> > Thanks> > -aaron> >> > --- Nicolas Verhaeghe wrote:> > > > hi all,> > > >> > > > I'm trying to use the ups snippet to get prices> > > from> > > > ups, and when I> > > > RTFM for the> > > > thing it say to refer to the ups documentation.> > > Well,> > > > I can't find _any_> > > > documentation on it.> > > >> > > > I looks like you may need a UPS account and> > > download> > > > the internet tool suite.> > >> > > Actually there is a script at UPS that only gives> > > you the price of your> > > shipment to a destination according to the weight,> > > zip and country codes for> > > origin and destination, and the code of the UPS> > > product.> > >> > > No account necessary.> >> >> > =====> > -Aaron> >> > __________________________________________________> > Do You Yahoo!?> > Thousands of Stores. Millions of Products. All in one place.> > Yahoo! Shopping: http://shopping.yahoo.com> >> > -------------------------------------------------------------> > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging> Server.> > To end your Mail problems go to .> >> > This message is sent to you because you are subscribed to> > the mailing list .> > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to> > >>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to .>> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Associated Messages, from the most recent to the oldest:

Re: ups quickcost [repost] (John Hill 1999) Re: ups quickcost [repost] (Aaron Lynch 1999) Re: ups quickcost [repost] (Aaron Lynch 1999) Re: ups quickcost [repost] (Aaron Lynch 1999) Re: ups quickcost [repost] (Nicolas Verhaeghe 1999) Re: ups quickcost [repost] (Josh Tiger 1999) Re: ups quickcost [repost] (Aaron Lynch 1999) Re: ups quickcost [repost] (Nicolas Verhaeghe 1999) Re: ups quickcost [repost] (Aaron Lynch 1999) Re: ups quickcost [repost] (Nicolas Verhaeghe 1999) ups quickcost [repost] (Aaron Lynch 1999)

Josh, thank you very much for trying to help.but the problem I'm having is that people keep repeating statements like From the UPSwebsite you should be able to find all the info needed to make create these Databases.I agree, I _should_ be able to do that... GRRRR ARRRGH... I have been ALL over the UPSsite, and the product codes elude my tiny brain. Could you PLEASE post yourshippingLookup.db to the list? so that it appears in the webcat archive? (oh, and topreserve my sanity as well)TIA-AaronJosh Tiger wrote:> Here is some webcat code that will generate a drop down menu of all UPS> products and prices for a desintation, drop off point, weight and package> type. In order for this code to work you will need a database of all country> codes. and a small Convertchars database which converts % to |. I find it is> easier to parse through a long string looking for | instead of %. I am not> really sure why I converted chars in the first place, but it works. You will> have to go in and modify certain parts which have hard coded values. This> code was designed to work in a checkout so some of the values are variables> being passed in a form. All the comment tags are placed there to prevent a> ton of white space from being generated. It also uses another small database> to convert UPS product codes into English words. I call this db> shippingLookup.db. From the UPS website you should be able to find all the> info needed to make create these Databases.>> Josh Tiger> Pop Art LLC>> [HIDEIF [shipToBill]=true][text show=f]destCountry=[LOOKUP> db=includes/UPS_country_codes.db&value=United> States&lookInField=CountryName_H&returnField=CountryCode_H¬Found=ERROR][/> TEXT][/HIDEIF][!]> [/!][SHOWIF [shipToBill]=true][text show=f]destCountry=[LOOKUP> db=includes/UPS_country_codes.db&value=[Country]&lookInField=CountryName_H&r> eturnField=CountryCode_H¬Found=ERROR][/TEXT][/SHOWIF][!]> [/!][text show=f]destZip=[HIDEIF> [shipToBill]=true][shipToZip][/HIDEIF][SHOWIF> [shipToBill]=true][ZIP][/SHOWIF][/text][!]> [/!][text show=f]residential=0[/text][!]> [/!][text show=f]weight=[totalWeight][/text][!]> [/!][text show=f]response=[middle> startafter=UPSOnLine&endbefore=][tcpconnect> host=www.ups.com&port=80][tcpsend]GET> /using/services/rave/qcostcgi.cgi?accept_UPS_license_agreement=yes&10_action> =4&14_origCountry=US&15_origPostal=90007&22_destCountry=[destCountry]&19_des> tPostal=[destZip]&49_residential=[residential]&47_rate_chart=Regular+Daily+P> ickup&48_container=00&13_product=GNDCOM&23_weight=[weight]&weight_std=lbs.> HTTP/1.0> [unurl]%0D%0A%0D%0A[/UnURL][/tcpsend][/tcpconnect][/middle][/text][!]> [/!][math show=f]percentCount=0[/math][!]> [/!][text show=f]response2=[convertchars> db=includes/UPSconversions.db][response][/convertchars][/text][!]> [/!][math show=f]errorCheck=0[/math][!]>> [/!][ListWords Words=[response2]&Delimiters=;][!]> [/!][SHOWIF [word]~4][!]> [/!][Math show=f]errorCheck = errorCheck + 1[/math][!]> [/!][/SHOWIF][!]> [/!][/LISTWORDS][!]>> [/!][HIDEIF [errorCheck]=0][!]>> [/!]> Select One[!]> [/!][ListWords Words=[response2]&Delimiters=;][!]> [/!][SHOWIF [word]~4][!]> [/!][math show=f]productStart=0[/math][!]> [/!][math show=f]productEnd=0[/math][!]> [/!][math show=f]priceStart=0[/math][!]> [/!][math show=f]piceEnd=0[/math][!]> [/!][math show=f]percentCount=0[/math][!]> [/!][loop start=1&end=[countchars][word][/countchars]&advance=1][!]>> [/!][showif [GetChars start=[index]&end=[index]][word][/GetChars]=|][!]> [/!][math show=f]percentCount= percentCount + 1[/math][!]>> [/!][showif [math show=t]percentCount%12[/math]=1][!]> [/!][math show=f]productStart=[index]+1[/math][!]> [/!][/SHOWIF][!]>> [/!][showif [math show=t]percentCount%12[/math]=2][!]> [/!][math show=f]productEnd=[index]-1[/math][!]> [/!][/SHOWIF][!]>> [/!][showif [math show=t]percentCount%12[/math]=10][!]> [/!][math show=f]priceStart=[index]+1[/math][!]> [/!][/SHOWIF][!]>> [/!][showif [math show=t]percentCount%12[/math]=11][!]> [/!][math show=f]priceEnd=[index]-1[/math][!]> [/!][/SHOWIF][!]>> [/!][SHOWIF [math show=t]percentCount%12[/math]=0][!]> [/!][HIDEIF [getchars> start=[productStart]&end=[productEnd]][word][/getchars]=GNDCOM] VALUE=[getchars> start=[productStart]&end=[productEnd]][word][/getchars]|[getchars> start=[priceStart]&end=[priceEnd]][word][/getchars]>[LOOKUP> db=../shipping/shippingLookup.db&value=[getchars> start=[productStart]&end=[productEnd]][word][/getchars]&lookInField=productC> ode_h&returnField=product_h¬Found=TextIfNotFound] - $[getchars> start=[priceStart]&end=[priceEnd]][word][/getchars][/HIDEIF][!]>> [/!][/SHOWIF][!]>> [/!][/SHOWIF][!]> [/!][/LOOP][!]> [/!][/SHOWIF]> [/ListWords]> > [/HIDEIF]>
>> [SHOWIF [errorCheck]=0]> Sorry, but you have chosen an invalid shipping> address. Most likely you have entered a zip/postal code which does not match> the country.> Please click your browser's back button and make the necessary> corrections.> [/SHOWIF]> ----- Original Message -----> From: Aaron Lynch > To: WebCatalog Talk > Sent: Monday, December 06, 1999 9:18 AM> Subject: Re: ups quickcost [repost]>> > Where? Are you talking about> > http://www.ups.com/using/services/rave/rate.html ?> >> > my experience with webcat 3 is pretty limited, it> > seems like it would be a lot harder to parse useful> > info out of that result page, rather than using the> > webcat snippet. I can't believe UPS makes their rates> > this tough to comprehend...> >> > If that's not the script you refer to would you please> > post a URL?> >> > Thanks> > -aaron> >> > --- Nicolas Verhaeghe wrote:> > > > hi all,> > > >> > > > I'm trying to use the ups snippet to get prices> > > from> > > > ups, and when I> > > > RTFM for the> > > > thing it say to refer to the ups documentation.> > > Well,> > > > I can't find _any_> > > > documentation on it.> > > >> > > > I looks like you may need a UPS account and> > > download> > > > the internet tool suite.> > >> > > Actually there is a script at UPS that only gives> > > you the price of your> > > shipment to a destination according to the weight,> > > zip and country codes for> > > origin and destination, and the code of the UPS> > > product.> > >> > > No account necessary.> >> >> > =====> > -Aaron> >> > __________________________________________________> > Do You Yahoo!?> > Thousands of Stores. Millions of Products. All in one place.> > Yahoo! Shopping: http://shopping.yahoo.com> >> > -------------------------------------------------------------> > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging> Server.> > To end your Mail problems go to .> >> > This message is sent to you because you are subscribed to> > the mailing list .> > To unsubscribe, E-mail to: > > To switch to the DIGEST mode, E-mail to> > >>> -------------------------------------------------------------> Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.> To end your Mail problems go to .>> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to -------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to  Aaron Lynch

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

TCPConnect, Form Post, Template Variable (2003) Grep support request for SMSI ... (2003) Car Database (2002) Not really WebCat (1997) New Command prefs ... (1997) [format xs] freeze (1997) time + (1998) Install problems on 3.08 (2000) OT: Anyone using WebCrossing and can answer a question? (2000) REPLACE & MAX/STARTAT parameters doesn't work? (2000) WebCat b13 CGI -shownext- (1997) Return records from another (1997) For those of you not on the WebCatalog Beta... (1997) Switching from merge to tab delimited..(v 2.x) (2000) What am I missing (1997) Separate SSL Server (1997) Loss in Form (1998) The Archives? (1999) Databases going to sleep (1998) [WebDNA] paypal (2009)