This is a newer version of a previous question I posted. Basically, there is an excel sheet containing a list of IP's. Each ip takes you to a powerbar reading, which provides ampage readings we need to collect. Currently, we have to open every one in IE, log in (same user and password for all ip's) then make a note of the amp reading and type that in the excel sheet.
After much searching I found out that if I was to enter ftp://user: [email protected]/data.txt in a web browser it will open the text document and display information like so:
I assume it would be easy to import said txt into excel and only take the highlighted text from above into the spreadsheet? Which is all I really need. Also, I would need to compact the data. As you can see there are 6 entries for today, I only need one per day.
The issue is though, how do I get that data.txt from the ftp into excel? And how would I get in another 100 more?
Currently, if I go to Data/From Text and paste in the line ftp://user: [email protected]/data.txt it does nothing. If I go to Get source from web, and try it, it will ask for a username/password but providing the correct password/username does nothing but bring up the log in window again.
Is there anyway of mass importing this data? I feel I am so close to cracking this. All help is greatly appreciated.
After much searching I found out that if I was to enter ftp://user: [email protected]/data.txt in a web browser it will open the text document and display information like so:
Code:
Network Management Card AOS v3.7.0
Rack PDU APP v3.7.0
Date Time Name Contact Location System IP
23.08.2012 20:29:08 Test Test Test 199.99.99.99
Metered Rack PDU
Date Time I IMax IMin
23.08.2012 20:25:32 2.6 2.6 2.5
23.08.2012 20:15:32 2.6 2.6 2.5
23.08.2012 20:05:32 2.6 2.6 2.5
23.08.2012 19:55:32 2.6 2.6 2.5
23.08.2012 19:45:32 2.6 2.6 2.5
23.08.2012 19:35:32 2.6 2.6 2.5I assume it would be easy to import said txt into excel and only take the highlighted text from above into the spreadsheet? Which is all I really need. Also, I would need to compact the data. As you can see there are 6 entries for today, I only need one per day.
The issue is though, how do I get that data.txt from the ftp into excel? And how would I get in another 100 more?
Currently, if I go to Data/From Text and paste in the line ftp://user: [email protected]/data.txt it does nothing. If I go to Get source from web, and try it, it will ask for a username/password but providing the correct password/username does nothing but bring up the log in window again.
Is there anyway of mass importing this data? I feel I am so close to cracking this. All help is greatly appreciated.
