79d957f398
Added Email address. Updated filter logic to grab all the accounts that aren't @gll accounts. Added print output to mark username changes. Added logic to filter accounts with no address book entries. Hardcoded "United States" to "USA". Rest of countries are first 3 characters of name. Added print output when user has no addressbook.
master
Dan Dembinski
2021-03-05 09:48:48 -05:00
788521ae99
Clean up. Updated requirements.txt
Dan Dembinski
2021-02-19 13:43:47 -05:00
c0710262a1
Added xls output.
Dan Dembinski
2021-02-19 11:34:47 -05:00
f6457a7223
Cleaned up some spacing/formatting. Modified main query to join in the State and Country tables.
Dan Dembinski
2021-02-17 14:24:56 -05:00
4b3fcb84e6
Finished setting up necessary tables. Pulling active user information. Pulling Address book information for each user..Currently filtering out all but userID 1 for testing purposes.
Dan Dembinski
2021-02-17 13:02:10 -05:00
7dfd82f738
Initial commit. Connects to db. Setup UserAddress table. Test queries and filters. Also setup requirements.txt
Dan Dembinski
2021-02-16 12:06:29 -05:00
Dan Dembinski