Erin Toadlena's blog

Finished week seven continue working with my PHP script from last week, and by doing that I had more command functions to final__params.php. Charles had me add in function() and argument check to php script to make sure that the script is gathering data from the database server. 

From there I created a test file to print out the results from my PHP scripts, and by doing that I made ./test.bat. With this test file it has all the functions like the: variable, assetype, asset, request, station, and offering from final__params.php.

Started this week with Task List from my menotr's Charles and David. David came up to see how we're doing with the mySql and php scripts.

Here is the list of tasks that we need to work through, preferably over the next week. Let's focus on the query until it is done and then we can move on to the php.

SQL query:

After developing queries in postgres database - metabase from datanearhere and dataexplore, I had to understand the next step using PHP scripts.

Definition: PHP is a script language and interpreter that is freely available and used primarily on Linux Web servers. PHP, originally derived from Personal Home Page Tools, now stands for PHP: Hypertext Preprocessor, which the PHP FAQ describes as a "recursive acronym."

Within the couple of weeks, I’ve been working on my database in CMOP Server. Finally got my programming to work and print information from the database I had create from the beginning. Charles has guide me through the way to complete my project. Using the data from the Yukon River – Water quality data. Extracting the .xlsx file to .cvs file then inserting them to the database. Starting on new data – Site Data

Working with inserting data from the spreadsheet .csv files to the database, getting errors saying that there’s one field that repeats itself. You have to go back to the database to insert a new column and header, so the spreadsheets can insert the data through the program code and print out the data. After you have insert the new columns and header to the database, run your python script in the terminal window. If you get any Error: codes from the terminal, you’ll have to go back to your script to the line from the Error given.

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.

Continue extracting data from the PDF to CSV files, this coming week from the Data Water-quality PDF files. Reading all the articles from the first week, understand the data information collected from the Yukon River.

Upon arrive to OHSU – CMOP, meeting my Mentor Charlies Seaton and getting assigned to a Cubicle. Working in same Deportment as Carolina Johnson, another internship and roommate; even though we work in the same building not doing the same project.