Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Jan 2007, 16:52
itsalltropical itsalltropical is offline
 
Join Date: Dec 2006
RSS rdb file format parse into DB table; use vBAdvanced and/or AboutToday to display

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.



Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by itsalltropical; 08 Jan 2007 at 16:57.
Reply With Quote
  #2  
Old 10 Jan 2007, 00:55
itsalltropical itsalltropical is offline
 
Join Date: Dec 2006
I've got the data down to three lines after the comments which start with a #. I just need the last line of data which has date, time and level. For some reason when I put the data within the php tags it is wrapping the last line. Can anyone help me?

At this point I'll even take just pulling the last line of data and displaying it within some text like "Lake Murray Level @ xxx on date time". Whatever is easiest. Display it, create a post in News forum, etc.

Here's the new URL with the reduced amount of data. I just need to post date time level (which in the example below is 357.30. Would like to automagically pull it twice a day.
USGS Lake Murray


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
vbAdvanced Addon for AboutToday CyberRanger vBulletin 3.5 Add-ons 72 17 Jul 2009 10:04



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:56.

Layout Options | Width: Wide Color: