dbTalk Databases Forums  

Correct syntax for UPS Web Viewer query?

comp.databases.filemaker comp.databases.filemaker


Discuss Correct syntax for UPS Web Viewer query? in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tim
 
Posts: n/a

Default Correct syntax for UPS Web Viewer query? - 01-19-2007 , 10:50 AM






Struggling a little bit getting the correct syntax for a Custom Web
Address so that the Web Viewer in 8.5 can pull tracking info from the
UPS site. The built-in FedEx syntax included in 8.5 is obviously
different than that of UPS, and the documentation in the Shipping DIY
PDF provided by Filemaker is kinda short on details about UPS as well,
since it uses DHL as an example.

Here's the syntax that I'm using now, where 'nameofdatabase' represents
the path to the appropriate layout, and 'trackingnumber' is the field
that contains the tracking number info within that layout.

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requ ester=UPSHome&tracknum=nameofdatabase::trackingnum ber&AgreeToTermsAndConditions=yes&ignore=&track.x= 25&track.y=16"

What I need to end up with is the result of a completed UPS tracking
query in a Web Viewer window, based on a tracking number entered in a
field in the same layout.

I suspect I'm leaving out a minor but important bit of syntax - can
anyone point it out for me?

Thanks in advance for any help anyone can provide.


Reply With Quote
  #2  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Correct syntax for UPS Web Viewer query? - 01-19-2007 , 11:16 AM






You need to separate that which is text from your fields. Try:

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requ ester=UPSHome&tracknum="
& nameofdatabase::trackingnumber &
"&AgreeToTermsAndConditions=yes&ignore=&track.x=25 &track.y=16"

Tim wrote:
Quote:
Struggling a little bit getting the correct syntax for a Custom Web
Address so that the Web Viewer in 8.5 can pull tracking info from the
UPS site. The built-in FedEx syntax included in 8.5 is obviously
different than that of UPS, and the documentation in the Shipping DIY
PDF provided by Filemaker is kinda short on details about UPS as well,
since it uses DHL as an example.

Here's the syntax that I'm using now, where 'nameofdatabase' represents
the path to the appropriate layout, and 'trackingnumber' is the field
that contains the tracking number info within that layout.

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requ ester=UPSHome&tracknum=nameofdatabase::trackingnum ber&AgreeToTermsAndConditions=yes&ignore=&track.x= 25&track.y=16"

What I need to end up with is the result of a completed UPS tracking
query in a Web Viewer window, based on a tracking number entered in a
field in the same layout.

I suspect I'm leaving out a minor but important bit of syntax - can
anyone point it out for me?

Thanks in advance for any help anyone can provide.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance


Reply With Quote
  #3  
Old   
Tim
 
Posts: n/a

Default Re: Correct syntax for UPS Web Viewer query? - 01-20-2007 , 09:41 AM



A little challenging to tell if you intended for there to be spaces or
carriage returns in the modified string, but I've tried various
iterations of this, and keep getting 'The specified table cannot be
found' errors.

Here's what I think you suggested:

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requ ester=UPSHome&tracknum=&
nameofdatabase::trackingnumber
&"&AgreeToTermsAndConditions=yes&ignore=&track.x=2 5&track.y=16"

Any other ideas?

Thanks again for any and all help, and apologies if this has been
covered elsewhere in the group - a search came up empty.

-tim


Howard Schlossberg wrote:
Quote:
You need to separate that which is text from your fields. Try:

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requ ester=UPSHome&tracknum="
& nameofdatabase::trackingnumber &
"&AgreeToTermsAndConditions=yes&ignore=&track.x=25 &track.y=16"

Tim wrote:
Struggling a little bit getting the correct syntax for a Custom Web
Address so that the Web Viewer in 8.5 can pull tracking info from the
UPS site. The built-in FedEx syntax included in 8.5 is obviously
different than that of UPS, and the documentation in the Shipping DIY
PDF provided by Filemaker is kinda short on details about UPS as well,
since it uses DHL as an example.

Here's the syntax that I'm using now, where 'nameofdatabase' represents
the path to the appropriate layout, and 'trackingnumber' is the field
that contains the tracking number info within that layout.

"http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requ ester=UPSHome&tracknum=nameofdatabase::trackingnum ber&AgreeToTermsAndConditions=yes&ignore=&track.x= 25&track.y=16"

What I need to end up with is the result of a completed UPS tracking
query in a Web Viewer window, based on a tracking number entered in a
field in the same layout.

I suspect I'm leaving out a minor but important bit of syntax - can
anyone point it out for me?

Thanks in advance for any help anyone can provide.


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance


Reply With Quote
  #4  
Old   
NScheffey
 
Posts: n/a

Default Re: Correct syntax for UPS Web Viewer query? - 01-22-2007 , 01:03 PM



You are very close, you just need to fully separate the field name from
the URL, and concatenate the two. The basic form is "First part of URL"
& nameofdatabase::trackingnumber & "End of URL".
Here is the exact calculation I use:
"http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displ ayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumb er1="
&Books::Tracking_Number & "&track.x=0&track.y=0"

Hope that helps,
Nate


Reply With Quote
  #5  
Old   
Tim
 
Posts: n/a

Default Re: Correct syntax for UPS Web Viewer query? - 01-23-2007 , 08:55 PM



Yup, that fixed it. Thanks for your help.

Here's a corollary - I'd like to be able to enter multiple numbers in a
single FMP field that can flow into the large tracking number box on
the UPS site that's being queried in this Web Viewer - which is able to
accept up to 25 separate tracking numbers - but I don't know how to
separate them so they appear in the UPS tracking number box separated
by carriage returns, the way you're able to enter those numbers in the
web page manually. I've tried entering the tracking numbers in the
requisite FMP field separated by carriage returns, commas, and tabs,
but nothing seems to work.

Any ideas?

On Jan 22, 11:03 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:
Quote:
You are very close, you just need to fully separate the field name from
the URL, and concatenate the two. The basic form is "First part of URL"
& nameofdatabase::trackingnumber & "End of URL".
Here is the exact calculation I use:
"http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status..."
&Books::Tracking_Number & "&track.x=0&track.y=0"

Hope that helps,
Nate


Reply With Quote
  #6  
Old   
NScheffey
 
Posts: n/a

Default Re: Correct syntax for UPS Web Viewer query? - 01-24-2007 , 08:34 AM



Tim-
I'm not sure about putting tracking numbers into the box, but if all
you want to do is have the user enter multiple tracking numbers into a
field and track them all in one click, that can be achieved.

All of this is based on using a calculation to craft the correct URL
string. If you examine the UPS web address string you will see the
following:
"tracknums_displayed=1&TypeOfInquiryNumber=T&loc=e n_US&InquiryNumber1="
What you need to do is get the tracknums_displayed number to reflect
the number of tracking numbers you have, then append each tracking
number, making sure that the Inquiry# (where it currently says
Inquiry1) changes for each tracking number. This calculation will
generate a big long string which you will then view in a web viewer,
and it will contain all your tracking numbers.

The best bet for user entry would be to have the user enter the
tracking numbers into a field separated by carriage returns. This would
allow you to use the built-in Values functions (getValue and
ValueCount) in FileMaker to work with the data. So your calculation is
first going to find out how many tracking numbers the person entered.
Let's say your entry field is TrackingNumbers. The beginning of your
calculation would set some variable, let's say $numberCount, as
ValueCount(TrackingNumbers). This number would go into the URL after
the "tracknums_dsiplayed=" part. Then you would have a loop that used
the GetValue function to paste the appropriate string onto the URL,
increment a counter, and stop when the counter > $numberCount. Then
append the final part ("&track.x=0&track.y=0") to the end of the URL
and you are done.

Hope this helps,
Nate

On Jan 23, 9:55 pm, "Tim" <tim.pritch... (AT) gmail (DOT) com> wrote:
Quote:
Yup, that fixed it. Thanks for your help.

Here's a corollary - I'd like to be able to enter multiple numbers in a
single FMP field that can flow into the large tracking number box on
the UPS site that's being queried in this Web Viewer - which is able to
accept up to 25 separate tracking numbers - but I don't know how to
separate them so they appear in the UPS tracking number box separated
by carriage returns, the way you're able to enter those numbers in the
web page manually. I've tried entering the tracking numbers in the
requisite FMP field separated by carriage returns, commas, and tabs,
but nothing seems to work.

Any ideas?

On Jan 22, 11:03 am, "NScheffey" <NSchef... (AT) gmail (DOT) com> wrote:

You are very close, you just need to fully separate the field name from
the URL, and concatenate the two. The basic form is "First part of URL"
& nameofdatabase::trackingnumber & "End of URL".
Here is the exact calculation I use:
"http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status..."
&Books::Tracking_Number & "&track.x=0&track.y=0"

Hope that helps,
Nate


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.