RSS rdb file format parse into DB table; use vBAdvanced and/or AboutToday to display

[itsalltropical]

Need to input the following RSS feed which is in rdb format, hopefully into a database table in vBulletin. Then create a module to display the latest reading on my cmps_index page and maybe at the bottom of all my pages. I am a newbie so I understand the concept; just don't know how to start & finish

I would need step by step instructions since I am so green, i.e
Go to adminCP or MySQL to create table, etc.
Use this code to load table;
Go to cmps and add module, etc.
Use RSS or AboutToday or this code to go get the data every hour or maybe just twice a day.

There are comment lines before the data that start with #. The first row of the data defines the columns. After that is the real data. I would want to load rows into the database that are unique by Date & Time. Each read is usually an hour apart. Then, again my module would display the latest reading with Date, Time and Level.

Here is a paste of the data coming in. URL is: USGS Level @ Lake Murray, SC I don't know how to make this box bigger Maybe a Moderator/Member would teach a newbie how? PM is OK.

PHP Code:

# ---------------------------------- WARNING ----------------------------------------# The data you have obtained from this automated U.S. Geological Survey database# have not received Director's approval and as such are provisional and subject to# revision. The data are released on the condition that neither the USGS nor the# United States Government may be held liable for any damages resulting from its use.# Additional info: http://waterdata.usgs.gov/sc/nwis/help/?provisional## File-format description: http://waterdata.usgs.gov/nwis/?tab_delimited_format_info# Automated-retrieval info: http://waterdata.usgs.gov/nwis/?automated_retrieval_info## Contact: gs-w_support_nwisweb@usgs.gov# retrieved: 2007-01-08 11:21:12 EST## Data for the following site(s) are contained in this file# USGS 02168500 LAKE MURRAY NEAR COLUMBIA, SC# -----------------------------------------------------------------------------------## Data provided for site 02168500# DD parameter Description# 13 00065 Gage height, feet#agency_cd    site_no    datetime    13_00065    13_00065_cd5s    15s    16s    14s    14sUSGS    02168500    2007-01-07 00:00    357.00    USGS    02168500    2007-01-07 01:00    356.98    USGS    02168500    2007-01-07 02:00    357.00    USGS    02168500    2007-01-07 03:00    357.01    USGS    02168500    2007-01-07 04:00    357.02    USGS    02168500    2007-01-07 05:00    357.02    USGS    02168500    2007-01-07 06:00    357.03    USGS    02168500    2007-01-07 07:00    357.06    USGS    02168500    2007-01-07 08:00    357.04    USGS    02168500    2007-01-07 09:00    357.06    USGS    02168500    2007-01-07 10:00    357.07    USGS    02168500    2007-01-07 11:00    357.09    USGS    02168500    2007-01-07 12:00    357.07    USGS    02168500    2007-01-07 13:00    357.11    USGS    02168500    2007-01-07 14:00    357.13    USGS    02168500    2007-01-07 15:00    357.12    USGS    02168500    2007-01-07 16:00    357.13    USGS    02168500    2007-01-07 17:00    357.15    USGS    02168500    2007-01-07 18:00    357.16    USGS    02168500    2007-01-07 19:00    357.16    USGS    02168500    2007-01-07 20:00    357.18    USGS    02168500    2007-01-07 21:00    357.20    USGS    02168500    2007-01-07 22:00    357.21    USGS    02168500    2007-01-07 23:00    357.23    USGS    02168500    2007-01-08 00:00    357.22    USGS    02168500    2007-01-08 01:00    357.25    USGS    02168500    2007-01-08 02:00    357.23    USGS    02168500    2007-01-08 03:00    357.24    USGS    02168500    2007-01-08 04:00    357.29    USGS    02168500    2007-01-08 05:00    357.29    USGS    02168500    2007-01-08 06:00    357.34    USGS    02168500    2007-01-08 07:00    357.36    USGS    02168500    2007-01-08 08:00    357.38