LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-23-2016, 06:11 AM   #1
saran_rhca
LQ Newbie
 
Registered: Jan 2016
Posts: 7

Rep: Reputation: Disabled
FTP sites Status Checking


Hi Friends,

I have one problem. I have more than 1000 ftp sites stored in the excel file. Now I want to check which one is active or inactive.
It is very difficult to check one by one. Because is nearly more than 1000 sites. all are stored in one excel file.
So can any one please help me on this above scenario or any scripts for this ftp sites.

Thanks in Advance.
 
Old 03-23-2016, 06:26 AM   #2
zhjim
Senior Member
 
Registered: Oct 2004
Distribution: Debian Squeeze x86_64
Posts: 1,748
Blog Entries: 11

Rep: Reputation: 233Reputation: 233Reputation: 233
You could write a VBA script that tries to connect to mostly all of the 1000 sites. This way you would not have check them manualy from the excel file
 
Old 03-23-2016, 06:29 AM   #3
saran_rhca
LQ Newbie
 
Registered: Jan 2016
Posts: 7

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by zhjim View Post
You could write a VBA script that tries to connect to mostly all of the 1000 sites. This way you would not have check them manualy from the excel file
Hi

Thanks for the reply.

Can you give me the VBA script so that I will try.. Because I not familiar in programming.

Thanks
 
Old 03-23-2016, 09:11 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,327

Rep: Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881Reputation: 3881
Quote:
Originally Posted by saran_rhca View Post
Hi
Thanks for the reply.

Can you give me the VBA script so that I will try.. Because I not familiar in programming.
First, this is LINUXquestions....VBA is for Windows. Secondly, we are NOT going to write your scripts/programs for you...read the "Question Guidelines" link in my posting signature. We will HELP you, when you post what you have done/tried/written on your own, but will NOT do your work for you. Since you have "RHCA" in your user name, that means you should know how to write a script...since that was part of the 'certification' you have.

Exporting the Excel file to a CSV file is trivial...reading that CSV file and looping through it should also be fairly easy for someone with a 'certification' as well...especially given the thousands of samples scripts you could find already to help get you going.
 
Old 03-23-2016, 04:35 PM   #5
BW-userx
Senior Member
 
Registered: Sep 2013
Location: MID-SOUTH USA
Distribution: Void Linux / Slackware 14.2
Posts: 3,109

Rep: Reputation: 543Reputation: 543Reputation: 543Reputation: 543Reputation: 543Reputation: 543
would pinging the address be sufficient?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
checking network status ashishravande Linux - Newbie 3 06-15-2010 02:40 PM
Automatic block sites from checking url IKT Linux - Server 1 10-01-2009 02:11 AM
Checking device status neerukamra Linux - General 1 09-06-2004 02:12 AM
command(s) for checking ip status stupidloser Linux - Wireless Networking 5 08-10-2004 11:21 AM
checking the status of PPP0 pudhiyavan Linux - Networking 6 01-14-2004 03:47 AM


All times are GMT -5. The time now is 11:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration