On Tue, Aug 4, 2009 at 12:10 PM, John<[email protected]> wrote: > Is the data in xml or html? If xml, you can either use the xmltocursor, or > the xmlparser. If html, you can just use vfp and parse the dom. ------------------------------------
HTML it looks real pretty yet has a lot of <element> tags in it. > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Stephen Russell > Sent: Tuesday, August 04, 2009 11:58 AM > To: ProFox Email List > Subject: How would you read a tracking notice from UPS (email) > > This is a drop ship B2B arrangement. > > My client wants me to pull the messages from a mail account and scrape > off data for me to know how to update the website they have. > > So the message inbound is in HTML from UPS. > > I was going to use West Wind to open the mailbox and read all the > unread messages. > > Once I have that message object would you in VFP load up an xml parcer > or would you treat the entire html as a string? > > --------------------------- > This message was <snip> > ________________________________________ > Scheduled Delivery: 09-July-2009 > Shipment Detail > ________________________________________ > Ship To: > CLTCD > HAMPTON INN - CONCORD > 612 DICKENS PLACE NE > CONCORD > NC > 280252413 > US > Number of Packages 1 > UPS Service: GROUND > Weight: 25.0 LBS > > Tracking Number: 1ZAW53320351172959 > > Bill of Lading Number: 33602 > Purchase Order Number: 84179 > Click here to track if UPS has received your shipment or visit > http://www.ups.com/WebTracking/track?loc=en_US on the Internet. > ________________________________________ > > I need to scrape the PO # to identify what order it is that I am going > to satisfy, as well as the tracking # and expected delivery date. > > I am using VFP7 at the customer site this is all sitting in use with > AccPac data. > > -- > Stephen Russell > Sr. Production Systems Programmer > SQL Server DBA > Web and Winform Development > Independent Contractor > Memphis TN > > 901.246-0159 > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
