[Project]Web [email protected] Monitor

Here you can find out about our Folding Team! Our goal: to understand protein folding, protein aggregation, and related diseases
Post Reply
TraceHagan
Legit Fanatic
Legit Fanatic
Posts: 164
Joined: Tue Jul 07, 2009 1:28 pm

[Project]Web [email protected] Monitor

Post by TraceHagan » Fri Dec 11, 2009 10:03 pm

Would you like to be able to monitor your clients from the internet?
Well, that's what this project will be.
It will be available through accounts on ExtremeFolding.com, after I write the scripts and programs.

I'll let you know progress through this forum post.

Please post ideas, etc. and I will let you know when the Alpha is up and ready to test.

I need to know what features you would like to see before I actually start programming.

Progress:
Overall progress

Code: Select all

Client Updater: 0%
Web Tables: 0%
Web Scripts: 0%
Specific Feature Progress:

Code: Select all

No Specific Features yet requested/chosen
Image

User avatar
DMB2000uk
Site Admin
Site Admin
Posts: 7095
Joined: Mon Jul 18, 2005 5:36 pm
Location: UK

Re: [Project]Web [email protected] Monitor

Post by DMB2000uk » Tue Dec 15, 2009 3:31 am

An automated fancypants stat sheet for next time :P

Dan
Image (<- Clickable)

TraceHagan
Legit Fanatic
Legit Fanatic
Posts: 164
Joined: Tue Jul 07, 2009 1:28 pm

Re: [Project]Web [email protected] Monitor

Post by TraceHagan » Tue Dec 15, 2009 10:20 am

If I we're to do it in excel, I would be able to do that. And then can't Google Docs import an Excel spreadsheet?
Image

User avatar
DMB2000uk
Site Admin
Site Admin
Posts: 7095
Joined: Mon Jul 18, 2005 5:36 pm
Location: UK

Re: [Project]Web [email protected] Monitor

Post by DMB2000uk » Tue Dec 15, 2009 10:29 am

Excel can pull the stats automatically from EOC in excel?

How would you do that?

Google doc's can import excel things, but I'm not sure how fancy they can translate advanced formulae/expressions.

Dan
Image (<- Clickable)

TraceHagan
Legit Fanatic
Legit Fanatic
Posts: 164
Joined: Tue Jul 07, 2009 1:28 pm

Re: [Project]Web [email protected] Monitor

Post by TraceHagan » Tue Dec 15, 2009 10:31 am

You can pull web data, so all you would need to do is create a PHP script or similar to parse the data, and then pull that into your excel document
Image

TraceHagan
Legit Fanatic
Legit Fanatic
Posts: 164
Joined: Tue Jul 07, 2009 1:28 pm

Re: [Project]Web [email protected] Monitor

Post by TraceHagan » Tue Dec 15, 2009 10:40 am

Code: Select all

=ImportHtml(URL, "list" | "table", index). This imports the data in a particular table or list from an HTML page. The arguments to the function are as follows:

URL - the url of the HTML page 
either "list" or "table" to indicate what type of structure to pull in from the webpage. If it's "list," the function looks for the contents of <UL>, <OL>, or <DL> tags; if it's "table," it just looks for <TABLE> tags. 
index - the 1-based index of the table or the list on the source web page. The indices are maintained separately so there might be both a list #1 and a table #1. 
Example: =ImportHtml("http://en.wikipedia.org/wiki/Demographics_of_India", "table",4). This function returns demographic information for the population of India. 
From: http://docs.google.com/support/bin/answ ... swer=75507
Image

Post Reply