WARNING: This is an Archive - Try the New TestMy.net
Home
 
Welcome, Guest. Please login or register.

 
  spcr
» Home » (1) Extracting data from online database, and (2) refining scheduled test
    
  Home    Help    Search    Login    Register  
 
News : Have an idea that will make testmy.net better?  Click here to post it!  We love to hear feedback, user feedback like yours have helped build testmy.net over the years.. true story wink May 23, 2012, 09:29:34 AM
old.testmy.net forums  |  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 2 Guests are viewing this topic. « previous next »
Pages 1 Go Down
Author
Topic: (1) Extracting data from online database, and (2) refining scheduled test  (Read 1609 times)
JimA.Fennessey
Earning Trust
*
Offline Offline

Posts: 3


View Profile
« on: December 17, 2006, 02: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 149 times.)
* UsingTestMyNet-061216-0820.doc (346.5 KB - downloaded 138 times.)
Logged
 
Coknuck
Global Moderator
TMN Sr. Veteran
*
Offline Offline

Gender: Male
Posts: 3381


Insightbb. KY 10Mbps/1Mbps


View Profile
« Reply #1 on: December 17, 2006, 09: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 this first Before posting speed problems  http://testmy.net/topic-2097 & http://testmy.net/forum/t-3924

Growing old is manditory, Growing up is optional
 
tommie gorman
Sophist Member
TMN Seasoned Veteran
*
Offline Offline

Gender: Male
Posts: 8605


"OLD GLORY"


View Profile
« Reply #2 on: December 17, 2006, 09: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 !!!

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

Gender: Male
Posts: 4646

yep... ima g33k


View Profile WWW
« Reply #3 on: December 20, 2006, 10: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, 07: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 134 times.)
Logged
 
Print  Pages 1 Go Up
old.testmy.net forums  |  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:  

    


 

 

 

© 2007 testmy.net - Contact - Legal - This is an older version: Try Bandwidth Speed Test v12