Week 4: Inputting Data to the Database

Once I converted all the files to csv format. I could input my data using psftp (download server connect me to cmop servers). Moving along pretty well, had errors a couple of times before the script compile and ran. Therefore my mentor assisted me with the errors in my script. Looking it over and see what the errors were and what I need to do fix the errors. Using the Python .py files, along with postgres commands to compile each python file. Once they modify and compile, I input them in the database on cmop server. To make sure that it runs, I type out python read_csv_alt_toad.py in the command box. Feels great when you don’t have a more errors in your script, making more progress to the next step.