(1) Extracting data from online database, and (2) refining scheduled test - testmy.net resource / tool
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
Home
Download Test
Test Your Download Speed
Test Download AND Upload
Upload Test
Test Your Upload Speed
Test Upload AND Download
Community Forum
Community Forum Home
» Log-In
» Register
Internal Search
Google Powered Search
Computer & Net Guides
ISP Discussion
Forum Sitemap
Member List
Forum Stats
Forum Help and Info
Calendar & Birthdays
Database Stats
Host Stats
Member Stats
Share Score
Misc Tools
Conversion Calc.
Speed Chart
Conversion Table
Create a Test
Share Score
Automatic Test
Forum Archive
RSS and Blog Feeds
Score Database
trace/ping/whois/DNS
Wallpapers
Tweak Guide
!! Forum Search !!
!! Google Search !!
TMN Detailed Sitemap
News
News Home
Join
Theme
See Theme List
America the Beautiful
Blacken
Dark Blood Red
Blue
Blue Black Box
Blue Gray
Brown
Christmas
Dark Blue
ekaf
GL Series (default)
Gray Shades
Original Feel
Green
Greenhouse
Greenhouse Gray
Halloween Theme
Orange
Purple Darkness
Red/pink
Red 'n Black
TurkeyDay!
» Neuron (Default)
Neuron Black
Rise (New!)
Click to read why...
News
:
Is blue NOT your favorite color? Well why not customize testmy.net to your liking?! We offer over 25 theme variations, there is sure to be at least one that suits your personal style,
choose one here
November 22, 2008, 02:52:51 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
Recommended Tests
Test PC
Performance:
Click here to run a free Performance Scan
Test PC
Stability:
Click here to run a free Registry Scan
Note: The links above are sponsored links
0 Members and 1 Guest are viewing this topic.
« previous
next »
Topic Tools
Search this topic
Pages
1
Author
Topic: (1) Extracting data from online database, and (2) refining scheduled test (Read 4462 times)
JimA.Fennessey
Earning Trust
Offline
Posts: 3
(1) Extracting data from online database, and (2) refining scheduled test
«
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
TMNResults-MacroMaster-061217-1415.zip
(19.03 KB - downloaded 102 times.)
UsingTestMyNet-061216-0820.doc
(346.5 KB - downloaded 98 times.)
Logged
Coknuck
Dalai Lama of the South
Global Moderator
TMN Sr. Veteran
Offline
Gender:
Posts: 4852
Kentucky,Insightbb. 10Mbps/1Mbps
Re: (1) Extracting data from online database, and (2) refining scheduled test
«
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
Online
Gender:
Posts: 10133
"OLD GLORY"
Re: (1) Extracting data from online database, and (2) refining scheduled test
«
Reply #2 on:
December 17, 2006, 10:48:14 PM »
Welcome to the forum JimA.Fennessey
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
Offline
Gender:
Posts: 5087
yep... ima g33k
Re: (1) Extracting data from online database, and (2) refining scheduled test
«
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
Posts: 3
Re: (1) Extracting data from online database, and (2) refining scheduled test
«
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.
TMNResults-MacroMaster-070115-2100-xls.zip
(31.99 KB - downloaded 87 times.)
Logged
nas-optnw
Earning Trust
Offline
Posts: 3
Re: (1) Extracting data from online database, and (2) refining scheduled test
«
Reply #5 on:
July 04, 2008, 07:31:25 PM »
Any update of when the CSV download is going to be fixed? Thanks.
Logged
Pages
1
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:
Please select a destination:
-----------------------------
Main Forum
-----------------------------
=> General Discussion
=> New Members
=> PC Security
===> Antivirus & Firewalls
===> Spyware & Malware
===> Viruses & Scams
===> Security Threats
=> Show off your scores!
=> Make it Faster...
=> HELP!
===> HELP! With Other Stuff
===> HELP! With Tests
===> HELP! With Forum
===> Programming and Website Help
=====> HTML
=====> PHP
=====> PERL
=====> Server Help
===> Networking and Hardware
===> Overclocking
===> Linux Help
=> News
===> testmy.net News and Updates
=> Online Gaming Discussion
===> Requests
===> America's Army
===> Battlefield
===> Call Of Duty 4
===> Counter-Strike 1.6
===> Counter-Strike : Source
===> Day of Defeat : Source
===> Diablo
===> F.E.A.R
===> Ghost Recon
===> Halo 2
===> Lineage 2
===> Quake
===> Rainbow Six 3
===> World of Warcraft
===> Tribes 2
===> Unreal Tournament
=> Graphics, Sigs and Pictures
===> Test Board
=> Guides
=> Got any ideas to make testmy.net better?
=> Off Topic Discussion
===> Politics & More
-----------------------------
Provider Discussion and Reviews
-----------------------------
=> Add a Provider
=> All Dial-up
=> North American Providers (Including Canada)
===> Canadian Providers
=====> teksavvy.com Canada
=====> xplornet.com Canada
=====> Persona Internet
=====> Rogers Communications
=====> Shaw Communications
=====> Sympatico (Bell Canada)
===> Adelphia Communications
===> ALLTEL Communications
===> AOL
===> AT&T
=====> SBC Global
=====> BellSouth
===> Cable One
===> Cavalier Telephone cavtel.net
===> cebridge.net
===> CenturyTel
===> Charter Communications
===> Clearwire
===> Comcast Cable Communications
===> Country Cablevision
===> Covad communications
===> Cox Communications
===> DMAX Puerto Rico
===> EarthLink
===> EMBARQ
===> Frontier Online
===> HughesNet (DIRECWAY)
=====> DW4000 Information
=====> DW6000 Information
=====> DW7000 Information
===> Insight Broadband
===> Mediacom Communications
===> Midcontinent Communications
===> mycingular.net
===> Namesco/NDO (ndo.com)
===> onelinkpr.net Puerto Rico
===> Optimum Online
===> Qwest Communications
===> RCN
===> RoadRunner (Time Warner Cable)
===> seidata.com
===> sigecom.net
===> SkyWay USA
===> Speakeasy
===> Sprint Nextel Corporation
===> Starband
===> Suddenlink
===> SureWest Communications
=====> SureWest Communications FIOS
===> SusCom - Susquehanna Communications
===> TDS - Telephone and Data Systems, Inc
===> Transedge.com
===> Verizon Online
===> Verizon Online FIOS
===> Wave Broadband
===> Wide Open West
===> Wildblue Communications, Inc
=> World Providers (Non-North American)
===> African Providers
===> Asian and Middle Eastern Providers
=====> Asian Providers
=====> Centennial
=====> Digitel
=====> PLDT myDSL
=====> Sify Broadband
=====> Streamyx
=====> Smart Bro (Wi-fi)
===> Australian Providers
=====> Digiplus
=====> Optusnet
=====> Telstra Bigpond
===> UK and European Providers
=====> Bredbandsbolaget
=======> Bredbandsbolaget Fiber
=======> Bredbandsbolaget ADSL, VDSL
=====> Virgin.net (old NTL)
=====> Tiscali
===> Central/South American Providers
-----------------------------
Miscellaneous
-----------------------------
=> Archives
===> Announcements
=> Public Polls
===> Not on index
Print
Advanced search
Loading...
testmy.net's forum is proudly
Powered by SMF
|
SMF © 2006-2007, Simple Machines LLC
© 1999-2008 testmy.net -
Contact
-
Legal
-
Facts & FAQs
Page Loading Stats: This forum Page created in 0.094 seconds with 34 queries.