Weather DB

Anmerkungen:

• Data source: http://cdo.ncdc.noaa.gov/qclcd_ascii/ XLS macro: \\ecdcfscl4vs6\corp6_share\ESB\CIA\Resources\Extract_Files_Website.xlsm

1. 2. Parse the Data and extract

   Anmerkungen:

   • MS DOS Command
   1. 4. Put data into Access DB

      Anmerkungen:

      • Source: \\ecdcfscl4vs6\corp6_share\ESB\CIA\Weather\NWS_Wx.accdb Each text file must be placed into corresponding table (Daily, Hrly, Monthly) Each table must then be exported in mysql \\ecdcfscl4vs6\corp6_share\ESB\CIA\Resources\Steps_On_New_DB.docx shows steps to append tables
      1. 5. ODBC database to MySQL

         Anmerkungen:

         • May have to create a current or append table to only append current changes rather than entire DB, must discuss  http://cdo.ncdc.noaa.gov/qclcd_ascii/ ftp://ftp.ncdc.noaa.gov/pub/ http://cdo.ncdc.noaa.gov/qclcd_ascii/QCLCD201308.zip Methods to create new DB 1. Create DB in MYSQL http://10.15.120.128/phpmyadmin  2. Click on Database then fill in the "Create Database" Field Box 3. Set up ODBC Connection - 4. Make sure that ODBC MYSQL Driver exist or must be created 5. Make sure that IP address is correct and does not need to be updated, else you will have to update IP 6. Prefill, and test connection 7. Steps to export into MYSQL from DB a. select ODBC connection b. In the Export Windows Prefill - Fill in Table which will host the new data c. Complete ODBC steps d. Wait for DB to append to MYSQL
   2. 3. Daily, Hourly, Monthly

      Anmerkungen:

      • Each file must be placed into the network folder