Weather DB

Annotations:

• 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

   Annotations:

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

      Annotations:

      • 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

         Annotations:

         • 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

      Annotations:

      • Each file must be placed into the network folder