dou1003

Python script for text files to get GPS

Discussion created by dou1003 on Mar 6, 2014
Latest reply on Mar 7, 2014 by dou1003
Hello,

I am trying to automate a process. I get an email that has a request number, GPS points, and an email to respond to.

I currently convert that email to a text file and put it on a shared drive. Then I map the GPS points from the text file. I create a polygon from those GPS points. I create a map titled by the request number. Zoom to appropriate scale. Export to PDF to the shared drive and email to the person that requested it.

Are there any ways to automate this process?

I was thinking if I had multiple text files, is there a way to extract the request number, GPS points (can range from 3-6 Lat/Long), and email associated with each text files and combine them all into a table.

Any help is appreciated,
Thanks

If the end result was like this that would be great!
Lat Long Request Email Address
40.2354 -79.54545 request 1 email 1
40.3624 -79.70275 request 1 email 1
40.4894 -79.86005 request 1 email 1
40.6164 -80.01735 request 1 email 1
40.7434 -80.17465 request 1 email 1
40.8704 -80.33195 request 1 email 1
40.9974 -80.48925 request 1 email 1
41.1244 -80.64655 request 1 email 1
41.2514 -80.80385 request 1 email 1
41.3784 -80.96115 request 1 email 1
41.5054 -81.11845 request 2 email 2
41.6324 -81.27575 request 2 email 2
41.7594 -81.43305 request 2 email 2
41.8864 -81.59035 request 2 email 2
42.0134 -81.74765 request 2 email 2
42.1404 -81.90495 request 2 email 2
42.2674 -82.06225 request 2 email 2
42.3944 -82.21955 request 2 email 2
42.5214 -82.37685 request 2 email 2

Outcomes