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.
John Harvey -----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/01ed01ca1526$76f92360$64eb6a...@[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.
