How to create a database for the contents of folder containing 11000 mp3 files. - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software > Tips, Tricks & Tutorials
Click Here to Login
Reply
 
Thread Tools Display Modes
 
Old 08-31-2017, 09:09 AM   #1 (permalink)
Newb Techie
 
Join Date: Jul 2017
Location: India
Posts: 10
Default How to create a database for the contents of folder containing 11000 mp3 files.

Hi I am Rupesh from India and I have downloaded huge mp3 files from internet and I want to create a database of these files.



Recently I have seen a website which contains some important lectures and decided to download the site. Actually the website consists of up to 60000 mp3 files and in that I need 13000 files and all the files I need are contained in a separate directory I mean with in a web page and it's sub web pages. I have downloaded what I need ie., 11000 mp3 files of size 185 gb using offline browser called extreme picture finder and remaining 2000 files are not downloaded. The extreme picture finder downloaded these files fastly and accurately but for remaining 2000 files it is taking lot of time and so I have stopped the program. I want to download remaining 2000 files manually I mean not through any offline browser.



The website from which I have downloaded mp3 file's is very nicely organized. The website administrators arranged webpages nicely I mean suppose if we examine a webpage they have specified that all the sub pages under that webpage consists of say 50 directories and 1000 files etc.,. I want to create a database file similar to the above.



The extreme picture finder application in Windows downloaded the files to the folder e:/downloads/ with exact file system structure as source website. Is there any possibility to create a database of all the folders and files which are under this folder. I think that we can create a ms access database so that I can copy the resulted access database file called copied.mdb to my tab and open the file in android office applications like kingsoft etc.,.



Actually what I am expecting is suppose I open the database file in android application like kingsoft and examine the properties of a folder and suppose it shows that it contains 100 file's and then I will open the website address related to that directory in androids Firefox and if that web address shows that it contains 160 files then I will try to download remaining 60 file's. With 20 to 30 such attempts I can download all the remaining 2000 file's.



For Windows and Linux there are programs such as mediainfo,mediaconch which are somewhat useful for this particular need but in Windows I have found an application called playtime which will create an excel file of all the mp3 file's and their properties.



In Linux there's a command line tool called ls (list) with option -R (recursive). Is it possible to create a database using such command line utilities.



Please try to suggest a way to create a database like ms access or atleast any other sql database.





Regards,

Rupesh.
rupeshforu3 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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 On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Unable to create the folder 'new folder'" TheV3P Microsoft Windows and Software 2 03-13-2011 08:36 PM
Looking for widget/program to display the contents of my videos folder on desktop. eggcream Microsoft Windows and Software 0 09-28-2010 12:57 PM
Lag/Delay in Listing Folder Contents... any ideas? woodman650 Microsoft Windows and Software 10 01-22-2006 07:05 PM
safe to delete contents of temp folder?? jaksback Microsoft Windows and Software 12 06-05-2004 07:44 PM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 01:49 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.