[ReefBum]

I have a multi stage need, I know a little about programming but not much.


Part - 1

I sell satellite bandwidth, the usage data is sent to an ftp server by the NOC every 60 min. Each VSAT site has its own folder on the ftp server and the folder for each site is updated every 60 min. I need a way that this information can be automatically retreived from this ftp server and placed in a location on my own website using the same folder names.

i.e. I have a folder on my website named site_data this folder would have all the other folders for each VSAT system and these individual folders would be updated with any new data each hour from the NOC ftp server.

Any idea on where I should look to find a script for this?


This would not be neded if there was a script that could query the ftp server so that part 2 of my need could be handled directly from the ftp server. (This would save me tons of storage space on my own server)



Part - 2

I will need a web page with a script where the end user could put in his/her VSAT ID and this would pull up all the data from that site's folder. It would giva a list of each day as a link. If they click on one of these days it will then pull this information up into a graph showing the usage levels per hour for the day selected.


The NOC stores traffic logs on an ftp server with a folder for each site
that contains a text file for each day. This text file contains a line
for every hour of the day that the VSAT is connected for. An example is
shown below and the file is called USAZ0186/USAZ0186_20060207

USAZ0186 200602070000 200602070100 060 0015085220 0001320634
USAZ0186 200602070100 200602070200 060 0001714241 0000549140
USAZ0186 200602070200 200602070300 060 0000006608 0000006762
USAZ0186 200602070300 200602070400 060 0000006647 0000006652
USAZ0186 200602070400 200602070500 060 0000006974 0000006853
USAZ0186 200602070500 200602070600 060 0000006545 0000006518
USAZ0186 200602070600 200602070700 060 0000007265 0000007171
USAZ0186 200602070700 200602070800 060 0000006577 0000006775
USAZ0186 200602070800 200602070900 060 0000006433 0000006531
USAZ0186 200602070900 200602071000 060 0000051056 0000029182

The columns are as follows: SiteID, start time, end time, number of
minutes connected, bytes downloaded, bytes uploaded.

Please note that the dates on this system are one month behind, ie
January is month 00 and December is month 11.





Any help and any points in the right direction would be a great help to this guy that is still trying to learn this stuff.

ReefBum
reefbum@msn.com