(1) Extracting data from online database, and (2) refining scheduled test - testmy.net resource / tool
Home
Welcome, Guest. Please login or register.
Did you miss your activation email?

 



donations help testmy.net pay for the very high cost to run the site. Any amount is greatly appreciated.
Click to read why...

  spcr
    
News : uglystupid2 Don't look stupid, make sure you keep up-to-date with our rules, please read rules, click here  police August 30, 2008, 01:46:35 AM
testmy.net Broadband  |  Main Forum  |  Got any ideas to make testmy.net better?  |  Topic: (1) Extracting data from online database, and (2) refining scheduled test Advanced search
  0 Members and 1 Guest are viewing this topic. « previous next »
Pages 1 Go Down
Author
Topic: (1) Extracting data from online database, and (2) refining scheduled test  (Read 3556 times)
JimA.Fennessey
Earning Trust
*
Offline Offline

Posts: 3


View Profile
« on: December 17, 2006, 03:10:31 PM »

Two items: 
First, I've been seeking a way to extract the results from the online database, so I can run analyses on them.  What I've done so far is highlight the 250 latest results, copy them to the clipboard, and then paste them into Excel.  Some manipulation is then needed to get things usable, but I've put together an XLS macro that does a nice job of cleaning things up and averaging the upload and download results in a pivot table.  Life would be simpler if I had a button on the screen to dump the results to a CSV file, and if the actual speeds were outputted as numeric instead of as strings.  I'm happy to share the Excel macro if anyone has a use for it ... I've attached it here.  The only trick is to highlight the line "Showing .." as well as the actual results, since the macro deletes that "showing" line.  (The attached .doc file refers to a slightly earlier edition of the macro, but shows how to highlight the results.)

Second, I'm wondering if there's a more convenient way to run the tests on a schedule, perhaps as an executable that can be scheduled with the OS scheduler?

I'm fairly new to the community (a couple of months), but it's a great service and a great group of activists.  Looking forward to more good stuff ahead!

Jim
 Smile

* TMNResults-MacroMaster-061217-1415.zip (19.03 KB - downloaded 87 times.)
* UsingTestMyNet-061216-0820.doc (346.5 KB - downloaded 86 times.)
Logged
Coknuck
Global Moderator
TMN Sr. Veteran
*
Offline Offline

Gender: Male
Posts: 4589


Insightbb. Kentucky 10Mbps/1Mbps


View Profile
« Reply #1 on: December 17, 2006, 10:19:18 PM »

JimA.Fennessey, If I understand you right are you asking about Automatic testing? If so go to the Misc.Tools at the top of the page and select Automatic Test.
Logged

Read these "3" topics first Before posting speed problems  http://testmy.net/topic-2097 & http://testmy.net/forum/t-3924 & http://www.testmy.net/t-4257
                     
"Life is not a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside, thoroughly used up, totally worn out and loudly proclaiming, WOW! What a ride!"
tommie gorman
Sophist Member
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 9732


"OLD GLORY"


View Profile
« Reply #2 on: December 17, 2006, 10:48:14 PM »

Welcome to the forum JimA.Fennessey  wave Welcome!
Mostly stopping to say hi.
So is what coknuck posted pretty much what you were looking for?
Logged

IF YOU DON'T STAND BEHIND OUR TROOPS, PLEASE, FEEL FREE TO STAND IN FRONT OF THEM !!!

"an old country hick from america"

Sprint EVDO Rev. A * AMD 64 3500+ 2.2 GHz cpu Ram 2GB/XP Home * TCP Optimizer
CA3LE
testmy.net Patriarch
Administrator
TMN Seasoned Veteran
*
Online Online

Gender: Male
Posts: 5086


yep... ima g33k


View Profile WWW
« Reply #3 on: December 20, 2006, 11:09:19 PM »

I haven't made any executables yet but I may be making something like that in the first or second quarter of '07 to go with some other upgrade on the way.

As for the CSV feature, I took care of that for you.. only took me about 45 minutes of scripting to add that feature.  You will see the button on the bottom of the results of your searches.  It says " Download all results as CSV" and I've tested it with a few queries and it's working perfect.  Let me know how that works out for you.

Thanks for the suggestion,
-D
Logged

JimA.Fennessey
Earning Trust
*
Offline Offline

Posts: 3


View Profile
« Reply #4 on: January 15, 2007, 08:17:14 PM »

Thanks, everyone, for the replies, and especially CA3LE for the CSV feature.  It works well, and helps me make better use of the numbers.  I've revised my earlier XLS macro to handle the new CSV files, and am attaching it to this post.     Looking forward to more refinements, especially something that could run the scheduled tests as a service so that they could be automated without logging anyone one. Very Happy

* TMNResults-MacroMaster-070115-2100-xls.zip (31.99 KB - downloaded 72 times.)
Logged
nas-optnw
Earning Trust
*
Offline Offline

Posts: 3



View Profile
« Reply #5 on: July 04, 2008, 07:31:25 PM »

Any update of when the CSV download is going to be fixed?  Thanks.
Logged
Print  Pages 1 Go Up
testmy.net Broadband  |  Main Forum  |  Got any ideas to make testmy.net better?  |  Topic: (1) Extracting data from online database, and (2) refining scheduled test « previous next »
Jump to:  

    
testmy.net's forum is proudly Powered by SMF | SMF © 2006-2007, Simple Machines LLC
Bookmark: Del.icio.us    StumbleUpon
 
 

 

© 1999-2008 testmy.net - Contact - Legal - Facts & FAQs
Page Loading Stats: This forum Page created in 0.101 seconds with 34 queries.