It hit me today. The Texas Taxroll Scrubber from my Python1 Midterm is the path forward for my Python2 final project. I was contacted by a Salesforce Recruiter looking for someone that can help another company transfer files from their old CRM and into their new salesforce platform. Shortly after reading that message, I received another call from my old company wanting some data scrubbed. This lead me into thinking that Gaper Taxroll Scrubber is a perfect opportunity to work my way out of the job. Build the scrubber. Make it so others can use it.
The scope of the project is building I\O, GUI's, Tests and adding a lot more functionality. The only real constraint right now is time and knowledge.
Not gonna lie. Git hub took me a while to figure out. Pushing and pulling from the command line to both github and du's git got a little screwy. After spending a day going back and forth, I found my groove. Pycharm is great for looking at changes. Then merging branches. It's actually brilliant once you get good at it.
Now that the project has been decided. It is time to get to knocking out tasks. First up, make the powerpoint for the project presentation. Oh, powerpoint, it's been a while... (Update, power point isn't too bad once you figure out where they moved all the buttons.)
Scope of the project is most likely going to be massive and get complicated. With the hopes that I have a finished product that I can use for actual work. More bits on the code with follow as I dive deeper into coding.
Any good power point requires that the presenter doesn't read off the slides. So for practice for the presentation and your own curiosity if you are reading this blog.
Standard Intro Slide
The Texas Tax roll scrubber started back when I worked for Foss Resources. I had to parse through mineral owner data and then scrub it to upload to salesforce. After getting tired of reorganizing name orders and separating addresses, I decided to dabble in VBA code to automate the process. Later on in this blog I will show some of that old code. Anyhow, in Python 1 I got the opportunity to pick my own project. So naturally, the texas taxroll scrubber go put into python. It was a great start for learning the fundamentals of python. But due to time constraints and knowledge the project was more of a nice demonstration of the powers of python.
This project lets me work on real time data. I was contacted by Foss to help scrub some more data. The time constraints with school call for one solution. Finish writing the Texas Tax Roll scrubber. Make it more dynamic so that it can be used for different tax roll files. Make the program user friendly, so that I can send it back to them and not have to ever scrub a taxroll file again. Or maybe I should? I also got linkedin'd by a salesforce recruiter looking for me to help them move from one CRM and back into salesforce. Can you imagine the amount of data that is out there that is not in the correct form? There's a real need for this product.
This slide is pretty self explanitory
The Tkinter package is perfect. I've played around with it a bit. But even more so this afternoon. Which makes me realize that I probably should add a post per day... Instead of just updating this one. Eitherway... Tkinter, it's work the look. The processes for importing data used to require a cmd prompt and hard coding. Now the program just opens up your import window. The code is a lot cleaner too!
The Blog. Ahh, the end of this post. But on a final note. I did find my other blog, which I abandoned for a while. I might just have to pick it back up... seeing as the boat is almost done.
http://denvergaper.blogspot.com/ After having submitted the project proposal it's time to start looking a certain steps of the code. The first was getting good at tkinter. The following youtube video is a bit long but it really helped walk through the steps getting the GUI working. I feel as though being able to bring a good user interface to the python code will really help get this code being used by others that don't necessarily know how to use python.
https://www.youtube.com/watch?v=YXPyB4XeYLA
Below is an example of code being used to edit the pop up window. More reports to come as weeding through this process expands.
After going through the 5 hour tutorial on tkinter. I think I finally have a good enough understanding to start going through and using it as a display. It'll be a good opportunity to work with classes, and certainly will help make the code run better for non python users. A lot of practice on just working tkinter has resulted in not so much code for the project, but a better understanding of how to do it, which will make writing the code a lot faster. Now unfortunately back to the Math Midterm
Comments
Post a Comment