dbTalk Databases Forums  

D3 and XML

comp.databases.pick comp.databases.pick


Discuss D3 and XML in the comp.databases.pick forum.



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

Default D3 and XML - 10-28-2003 , 07:51 PM







Hi all:



I'm running D3NT 7.3.4 with Accuterm 2K clients.



I'm looking into some address verification utilities. Several vendors
offer some spendy solutions. Our US Postal Service offers a web-based
API address verification solution that uses XML. From what I can find
in the documentation it appears that they only want me to register for
use of their 'http connection dll'.



It seems to me that I can build the XML scripts in Pick and launch them
through Accuterm.



They designed this for use on a business website but I don't need it
on our website. I'd like to try to build this connection between D3,
the Accuterm client, and the client's web connection out to the
USPS's servers.



Has anyone done anything like this before? Am I dreamin'?



This is where I'm getting my info:



http://www.usps.com/webtools/technic....usps.com/web-
tools/technical.htm[/url]


--
Posted via http://dbforums.com

Reply With Quote
  #2  
Old   
Patrick Payne
 
Posts: n/a

Default Re: D3 and XML - 10-29-2003 , 10:33 AM






If the post office specs are essentially XML-RPC, go to

http://curl.haxx.se/ and download a windows version of Curl. You will
probably need the SSL version.

You then from pick write out your XML stream to a dos file.

Example
OPEN "DOS:C:/TMP" TO TMP FILE ELSE STOP
ID=SYSTEM(19)
XML='<XML>'
XML<-1>='<REQUEST>XXX</REQUEST>'
XML<-1>='</XML>'
WRITE XML ON TMP.FILE, UNIQUE.ID:'.XML'
CMND='!curl -d "@c:\tmp\':UNIQUE.ID:'.XML" http://required url'
EXECUTE CMND CAPTURING RESULT

This is really simple and I wrote it on the fly. But I use Curl all
the time to access both normal web sites and XML-RPC based functions.
In fact I currently use Curl and just post directly against the USPC
web page instead of using the API since when I was looking the API did
not support Address correction yet.

- Patrick


wdavidhicks <member10309 (AT) dbforums (DOT) com> wrote

Quote:
Hi all:



I'm running D3NT 7.3.4 with Accuterm 2K clients.



I'm looking into some address verification utilities. Several vendors
offer some spendy solutions. Our US Postal Service offers a web-based
API address verification solution that uses XML. From what I can find
in the documentation it appears that they only want me to register for
use of their 'http connection dll'.



It seems to me that I can build the XML scripts in Pick and launch them
through Accuterm.



They designed this for use on a business website but I don't need it
on our website. I'd like to try to build this connection between D3,
the Accuterm client, and the client's web connection out to the
USPS's servers.



Has anyone done anything like this before? Am I dreamin'?



This is where I'm getting my info:



http://www.usps.com/webtools/technic....usps.com/web-
tools/technical.htm[/url]

Reply With Quote
  #3  
Old   
Jeffrey Kaufman
 
Posts: n/a

Default Re: D3 and XML - 10-29-2003 , 11:04 AM



That is really cool, Patrick. Is there a Linux equivalent of curl?

Jeff

--

Jeffrey Kaufman
Key Data Systems Group
www.keydata.us
559-432-3832
559-432-4657 fax

Western Pacific Supply
www.westpacsupply.com
888-WestPac

"Patrick Payne" <patrickpayne (AT) yahoo (DOT) com> wrote

Quote:
If the post office specs are essentially XML-RPC, go to

http://curl.haxx.se/ and download a windows version of Curl. You will
probably need the SSL version.

You then from pick write out your XML stream to a dos file.

Example
OPEN "DOS:C:/TMP" TO TMP FILE ELSE STOP
ID=SYSTEM(19)
XML='<XML>'
XML<-1>='<REQUEST>XXX</REQUEST>'
XML<-1>='</XML>'
WRITE XML ON TMP.FILE, UNIQUE.ID:'.XML'
CMND='!curl -d "@c:\tmp\':UNIQUE.ID:'.XML" http://required url'
EXECUTE CMND CAPTURING RESULT

This is really simple and I wrote it on the fly. But I use Curl all
the time to access both normal web sites and XML-RPC based functions.
In fact I currently use Curl and just post directly against the USPC
web page instead of using the API since when I was looking the API did
not support Address correction yet.

- Patrick


wdavidhicks <member10309 (AT) dbforums (DOT) com> wrote

Hi all:



I'm running D3NT 7.3.4 with Accuterm 2K clients.



I'm looking into some address verification utilities. Several vendors
offer some spendy solutions. Our US Postal Service offers a web-based
API address verification solution that uses XML. From what I can find
in the documentation it appears that they only want me to register for
use of their 'http connection dll'.



It seems to me that I can build the XML scripts in Pick and launch them
through Accuterm.



They designed this for use on a business website but I don't need it
on our website. I'd like to try to build this connection between D3,
the Accuterm client, and the client's web connection out to the
USPS's servers.



Has anyone done anything like this before? Am I dreamin'?



This is where I'm getting my info:



http://www.usps.com/webtools/technic....usps.com/web-
tools/technical.htm[/url]



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

Default Re: D3 and XML - 10-29-2003 , 12:40 PM




Well, Curl does provide limited capabilities... I'd better use Internet
Explorer's OCX capabilities within a OLE container in the client side,
to be 100% in control of the application.



Cheers!


--
Posted via http://dbforums.com

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

Default Re: D3 and XML - 10-29-2003 , 02:29 PM



"Jeffrey Kaufman" <jeffreykaufman (AT) sbcglobal (DOT) net> wrote:

Quote:
That is really cool, Patrick. Is there a Linux equivalent of curl?

Jeff
I also have cURL doing some heavy work in a high profile site. I'm
_Very_ happy with it. There is a Linux version and that's the one I'm
using, but the Win32 version works just as well.

Yes, don't use AccuTerm for this application, go direct from D3. I
love AccuTerm and use it extensively, but I think it's way over-used
for applications where it shouldn't be. It's the along the lines of
"I know how to use this hammer so let's make all tasks look like a
nail."

Also, my next article for Spectrum compares XML-RPC to SOAP and I
agree that it's a great solution for Web Services without the overhead
of other protocols.

Tony
TG (AT) removethisNebula-RnD (DOT) com


Reply With Quote
  #6  
Old   
Patrick Payne
 
Posts: n/a

Default Re: D3 and XML - 10-29-2003 , 03:40 PM



There are versions for most platforms (linux, aix, freebsd, mac, etc).
In fact redhat 7.3 and above have it installed be default (I
believe).

- Patrick

"Jeffrey Kaufman" <jeffreykaufman (AT) sbcglobal (DOT) net> wrote

Quote:
That is really cool, Patrick. Is there a Linux equivalent of curl?

Jeff

--

Jeffrey Kaufman
Key Data Systems Group
www.keydata.us
559-432-3832
559-432-4657 fax

Western Pacific Supply
www.westpacsupply.com
888-WestPac

"Patrick Payne" <patrickpayne (AT) yahoo (DOT) com> wrote in message
news:b6da8ff0.0310290833.6b4f475 (AT) posting (DOT) google.com...
If the post office specs are essentially XML-RPC, go to

http://curl.haxx.se/ and download a windows version of Curl. You will
probably need the SSL version.

You then from pick write out your XML stream to a dos file.

Example
OPEN "DOS:C:/TMP" TO TMP FILE ELSE STOP
ID=SYSTEM(19)
XML='<XML>'
XML<-1>='<REQUEST>XXX</REQUEST>'
XML<-1>='</XML>'
WRITE XML ON TMP.FILE, UNIQUE.ID:'.XML'
CMND='!curl -d "@c:\tmp\':UNIQUE.ID:'.XML" http://required url'
EXECUTE CMND CAPTURING RESULT

This is really simple and I wrote it on the fly. But I use Curl all
the time to access both normal web sites and XML-RPC based functions.
In fact I currently use Curl and just post directly against the USPC
web page instead of using the API since when I was looking the API did
not support Address correction yet.

- Patrick


wdavidhicks <member10309 (AT) dbforums (DOT) com> wrote in message
news:<3534304.1067392305 (AT) dbforums (DOT) com>...
Hi all:



I'm running D3NT 7.3.4 with Accuterm 2K clients.



I'm looking into some address verification utilities. Several vendors
offer some spendy solutions. Our US Postal Service offers a web-based
API address verification solution that uses XML. From what I can find
in the documentation it appears that they only want me to register for
use of their 'http connection dll'.



It seems to me that I can build the XML scripts in Pick and launch them
through Accuterm.



They designed this for use on a business website but I don't need it
on our website. I'd like to try to build this connection between D3,
the Accuterm client, and the client's web connection out to the
USPS's servers.



Has anyone done anything like this before? Am I dreamin'?



This is where I'm getting my info:



http://www.usps.com/webtools/technic....usps.com/web-
tools/technical.htm[/url]

Reply With Quote
  #7  
Old   
wdavidhicks
 
Posts: n/a

Default Re: D3 and XML - 10-29-2003 , 05:36 PM




That is VERY cool, Patrick. Thanks!



Now if I can only get RD to give me another temporary activation on my
test server.


--
Posted via http://dbforums.com

Reply With Quote
  #8  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: D3 and XML - 10-29-2003 , 07:01 PM



Yes, but it's best to get the most recent version of the code. It's
updated frequently, and while any given release is good for almost all
sites it's good to know that they're constantly tweeking it, adding
features, and making it more efficient.

Tony

patrickpayne (AT) yahoo (DOT) com (Patrick Payne) wrote:

Quote:
There are versions for most platforms (linux, aix, freebsd, mac, etc).
In fact redhat 7.3 and above have it installed be default (I
believe).

- Patrick

"Jeffrey Kaufman" <jeffreykaufman (AT) sbcglobal (DOT) net> wrote

That is really cool, Patrick. Is there a Linux equivalent of curl?

Jeff

--

Jeffrey Kaufman
Key Data Systems Group
www.keydata.us
559-432-3832
559-432-4657 fax

Western Pacific Supply
www.westpacsupply.com
888-WestPac

"Patrick Payne" <patrickpayne (AT) yahoo (DOT) com> wrote in message
news:b6da8ff0.0310290833.6b4f475 (AT) posting (DOT) google.com...
If the post office specs are essentially XML-RPC, go to

http://curl.haxx.se/ and download a windows version of Curl. You will
probably need the SSL version.

You then from pick write out your XML stream to a dos file.

Example
OPEN "DOS:C:/TMP" TO TMP FILE ELSE STOP
ID=SYSTEM(19)
XML='<XML>'
XML<-1>='<REQUEST>XXX</REQUEST>'
XML<-1>='</XML>'
WRITE XML ON TMP.FILE, UNIQUE.ID:'.XML'
CMND='!curl -d "@c:\tmp\':UNIQUE.ID:'.XML" http://required url'
EXECUTE CMND CAPTURING RESULT

This is really simple and I wrote it on the fly. But I use Curl all
the time to access both normal web sites and XML-RPC based functions.
In fact I currently use Curl and just post directly against the USPC
web page instead of using the API since when I was looking the API did
not support Address correction yet.

- Patrick


wdavidhicks <member10309 (AT) dbforums (DOT) com> wrote in message
news:<3534304.1067392305 (AT) dbforums (DOT) com>...
Hi all:



I'm running D3NT 7.3.4 with Accuterm 2K clients.



I'm looking into some address verification utilities. Several vendors
offer some spendy solutions. Our US Postal Service offers a web-based
API address verification solution that uses XML. From what I can find
in the documentation it appears that they only want me to register for
use of their 'http connection dll'.



It seems to me that I can build the XML scripts in Pick and launch them
through Accuterm.



They designed this for use on a business website but I don't need it
on our website. I'd like to try to build this connection between D3,
the Accuterm client, and the client's web connection out to the
USPS's servers.



Has anyone done anything like this before? Am I dreamin'?



This is where I'm getting my info:



http://www.usps.com/webtools/technic....usps.com/web-
tools/technical.htm[/url]


Reply With Quote
  #9  
Old   
Frank Winans
 
Posts: n/a

Default Re: D3 and XML - 10-30-2003 , 09:41 AM



"TG" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote [stuff]

You mis-spelled sneakermail.
And "TG" -- how am I to zoom to your CDP posts each day if you
keep changing your From: name?


Reply With Quote
  #10  
Old   
Kevin Powick
 
Posts: n/a

Default Re: D3 and XML - 10-30-2003 , 11:54 AM



In article <bnrbe8$pkg (AT) library1 (DOT) airnews.net>, fwinans (AT) airmail (DOT) net
says...
Quote:
"TG" <g6q3x9lu53001 (AT) sneakemail (DOT) com.invalid> wrote [stuff]

You mis-spelled sneakermail.
it's not misspelled. Check out http://www.sneakemail.com.

Quote:
And "TG" -- how am I to zoom to your CDP posts each day if you
keep changing your From: name?
Agreed.

--
Kevin Powick


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.