-
Notifications
You must be signed in to change notification settings - Fork 0
/
infoNewBusiness.txt
90 lines (66 loc) · 3.55 KB
/
infoNewBusiness.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
Similar online copy of this document is here:
https://docs.google.com/document/d/1jyk39k5V_YD1i2quBNK0H1Jv8hTa--PhmqRjOSAdlhA/edit#
Installation:
Download some BEXAR_TXT_08112014.ZIP type files into ~/Downloads
Install PyCharm
git clone https://github.com/DaleEMoore/newBusiness1.git
python3 newBusiness1.py
Select the BEXAR_TXT_08112014.ZIP type files in ~/Downloads
Look at output in newBusiness1.py.csv.
New businesses come in via ZIP as TXT files and look something like this (but without the hyphen-space separator lines):
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
General Information
Document Number: 20140486141 Book Type: ASSUMED NAMES
Filed Date: 8/14/2014 Filing Time: 2:06:19 PM
Instrument Type: ABANDONMENT Comment:
# of Pages: 2
Business Owner
FIT THERAPY OF TEXAS OR FIT THERAPY OF TEXAS LLC
FIT THERAPY OF TEXAS OR FIT THERAPY OF TEXAS LLC
Property Address
Address 1: .
Address 2: 1842 DEER TRAIL
City: FLORESVILLE
State: TX
Zip: 78114-
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Overview
Select ZIP file from Downloads
Pull out TXT file(s)
Process each TXT file extracting data and exporting into LibreOffice Database.
Best Prospects TODO might be https://docs.google.com/document/d/1jyk39k5V_YD1i2quBNK0H1Jv8hTa--PhmqRjOSAdlhA/edit#.
TODO
As of Tuesday 9 May 2017 12:34 PM CST, look up the phone number.
As of Monday 27 March 2017 11:22 AM CST, wait a while giving Caleb the information that now includes addresses and he
can import to http://maps.google.com to see where they are. I’ve suggested he drop by the prospects easily between
his home and Moore Works on Thursdays and Fridays to gather the “low hanging fruit.” Let’s see how that goes for a
while then implement other solutions.
Wait on scrapy for phone lookup! Get mileage from an address so we can find the closest prospects to visit.
https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=google+api+to+get+mileage+between+two+addresses&*
Or feed the data to Google Maps to see clusters and distances.
https://support.google.com/mymaps/answer/3024836?hl=en
https://www.google.com/maps/d/edit?mid=1dvTRQZ9iYHFINC8ab8bLN3a5hSo&ll=34.66996596774281%2C-86.61222844999998&z=6
Ron Locke reminds me on Friday 24 March 2017 that his calls into the BEXAR County DBA, assumed names, list from SA
Business Journal put him off making any sales calls because those people are called by EVERYONE. He thinks a drop-
in visit is a better thing (what Caleb has been asking to do for some time.)
Improve this so that I get contact phone numbers from the Internet.
Do the "TODO; lookup phone numbers for this entity" manually researching the best approach to automation.
Make some calls on the mining I've already done manually.
Logs
Fri 15 Aug 2014 5:44 PM CST
Created
Wed 2 Jul 2015 4:42 PM CST
DaleHome.QnD can't run this because Tkinter won't install.
Tkinter is python2
tkinter is python3
python3's tkinter seems to work OK, convert to python3.
But what if the zipfile library only works with python2?
And what about dateutil?
tkinter fails on ""
ZipFile failing on "TypeError: pwd: expected bytes, got <class 'str'>"
I'm not sure how, but it's running now.
I went back to python2. Tkinter works now.
My previous bug where there is no "property address" failed and I downloaded the latest code with the fix.
It's working now with python2.
Tuesday 16 February 2016 8:14 PM CST
Caleb will be contacting some and doing some cold-call-sales.