Have been developing an in-house warranty and RMA application. Runs in MS Access with data from tables in Sharepoint (Lists). For various stages of the program we track UPS shipping. Currently I have a button that opens a UPS link with the tracking number and a web window pops up with current status. Works fine using standard [login to view URL] controls.
NOW, I'm at the stage where I need to start Automating this more. And things happen once tracking shows as being delivered. However, setting them as delivered is manual right now based the pop up option.
I"d like to be able to "scrape" the delivery information out of the website, and save updates to a table by tracking number. Mainly looking to updated delivered date field as either the "estimated date" or the actual date of the package delivery. If it's in transit, the estimated date will work. Once it's delivered the final date would be the date we want. And a check box field updated to indicated "DELIVERED"
Just need the basis, I can incorporate into my application once I understand the logic. Having a hard time find the right tag, id, element, etc from the UPS site to isolate this information successfully.
IDEALLY would be nice to do for UPS, USPS, and FEDEX and based on tracking number know the difference. But 80% of the tracking numbers are UPS. So, I'm find with JUST ups at the moment.