Exporting / Importing File names from https to Excel / Word

[jaidev.anand]

Hi Experts,

I need some assistance...

Could you please advise if I can  Export/Import Hyperlinks from an https site / file names to excel / word / notepad via Command Line. There are over 60000 links that get added to the https daily, but I need only 500-600 of them.

Each link / File name has a unique identifier which has a 8 digit serial number like: 36614191 (File name example: 20121008-0650-36614191-in.wav). If this is possible. Could you please advise on how it can be done..

Any help will be much much appreciated!

Thanks in advance!

[foxidrive]

Do you have to log into this site with username and password?
And do you want just a list of the filenames, in a text document?  A CSV file is possible too.

If the site is accessible, can you share a link as we'd need the HTML page or file list to see how it needs to be parsed.
Or save the HTML page in your web browser and upload it somewhere.

[jaidev.anand]

Yes, I need to login using a user name and password.

A CSV file with the files names would be an icing on the cake.

Actually, it is all I need - file names that have the 8 digit unique number, as I mentioned in my initial request.

Thanks for you efforts.
 

[foxidrive]

If you can save the HTML page as an example and upload it somewhere for us, then we can write a batch file.

[jaidev.anand]

Sure, I'll share it later today, as. I'm away at the moment.

Thanks!

[jaidev.anand]

Just to add on the 8 digit number will be same for atleast 2 file names, but there can be 4-6 files with the same 8 digit number.  In other words, if I need to extract 500 file names I will roughly have 200 8 digit number IDs, and these would change daily.
Thanks!

[jaidev.anand]

Yes, I need to login using a user name and password.

A CSV file with the files names would be an icing on the cake.

Actually, it is all I need - file names that have the 8 digit unique number, as I mentioned in my initial request.

Thanks for you efforts.

Dear Foxidrive,

Here's a link with a snapshot: http://imgmax.com/photos/20121024135105037100766.PNG.

Hope you could help me out by looking at this...

Thanks,

[foxidrive]

It may be a pretty straight forward task but we don't have all the information to proceed.

A) are all the 8 digit numbers of files that you need - in a text file with one 8 digit number per line?

B) can you go to the FILE menu and select Save page as (or similar)  in your browser window and save the information about the files on the screen - and then attach the page here.  It will be useful in testing the batch file.

[jaidev.anand]

It may be a pretty straight forward task but we don't have all the information to proceed.

A) are all the 8 digit numbers of files that you need - in a text file with one 8 digit number per line?

B) can you go to the FILE menu and select Save page as (or similar)  in your browser window and save the information about the files on the screen - and then attach the page here.  It will be useful in testing the batch file.

A) are all the 8 digit numbers of files that you need - in a text file with one 8 digit number per line? - Yes, they are in an Excel file.

B) can you go to the FILE menu and select Save page as (or similar)  in your browser window and save the information about the files on the screen - and then attach the page here.  It will be useful in testing the batch file. - Unfortunatley, that may not be available due to some restrictions.

Thanks

[foxidrive]

When you ask someone to make you dinner but don't provide any ingredients, how do you expect them to proceed?

With the information you have provided: this will find the files given a list of serial numbers.

Code: [Select]

@echo off
del "output file.txt" 2>nul
for /f "delims=" %%a in (listofserialnumbers.txt) do (
find "%%a" < "list of files.txt" >>"output file.txt"
)


[jaidev.anand]

When you ask someone to make you dinner but don't provide any ingredients, how do you expect them to proceed?

With the information you have provided: this will find the files given a list of serial numbers.

Code: [Select]

@echo off
del "output file.txt" 2>nul
for /f "delims=" %%a in (listofserialnumbers.txt) do (
find "%%a" < "list of files.txt" >>"output file.txt"
)


Extremely sorry, but what I meant was that I don't have access to it right now. I'm waiting for my superior to come. Sorry if I was misunderstood!   

I do understand your point, and will keep it in mind. Thanks for all your help!

I am assuming that I can comeback if I have any questions despite the above.

Thanks much!

[foxidrive]

Yes, I and a number of others monitor these threads.

I assume you can export the Excel file of serial numbers to a flat text file in this format

54378129
33378912
34565432
56349809

[jaidev.anand]

Yes, I and a number of others monitor these threads.

I assume you can export the Excel file of serial numbers to a flat text file in this format

54378129
33378912
34565432
56349809

Thanks a ton!

Yes, I can do that quite easily.

One more question as I'm a complete newbie to Command Prompt.

Just wondering, what would my process be: Do I need to simply paste this code in Command Prompt after I do the following?

Step 1: Create a Text file with the serial numbers
Step 2: Log in to the https link


Please advise.

[foxidrive]

Just wondering, what would my process be: Do I need to simply paste this code in Command Prompt after I do the following?

No, you would paste the script into a text editor and save it as a filename.bat and be careful not to use a system command as the filename.

Then:

Step 1: Create a Text file with the serial numbers as a certain filename
Step 2: Log in to the https link
Step 3: save the web page as text with the list of all the files, and save it as a certain filename.
Step 4: put all the files together and run the batch file, which will create a filelist of the files containing the 8 digit serial numbers.

[jaidev.anand]

No, you would paste the script into a text editor and save it as a filename.bat and be careful not to use a system command as the filename.

Then:

Step 1: Create a Text file with the serial numbers as a certain filename
Step 2: Log in to the https link
Step 3: save the web page as text with the list of all the files, and save it as a certain filename.
Step 4: put all the files together and run the batch file, which will create a filelist of the files containing the 8 digit serial numbers.

Superb! Thank you. I'll attempt this and will seek further assistance (if required).

I really value your inputs and thanks for your understanding as well as paitence with this request. I'm sure it will be immensely helpful and will save a lot of time.

Thanks again:)