Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a table for folder structure for MP3 files
Message
De
01/11/2020 16:03:06
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01676894
Message ID:
01676915
Vues:
44
>I don't believe that needs to be an online database to get song data. The data is in the song file. It's probably called ID3 or something. Of course, you can write a program to extract the ID3 data and put it into a database.

Yupp, that was the state of things envisioned - music ripping/downloading never interested me before. Thx for the additional info on ID3. Interesting stuff!

@Dmitry: I'd probably use one or more of the tools already on the market, chaining them together via Run and some analysis later to fill database. Reading up on things touched sites spiking CPU, elevating blocked site count in PiHole and was done via Linux machine, so safer from typical malware vectors.
I realize you have much less regard for tightening your security via VM usage - but using "free" windows exe inside your biz network might be unwise. At least isolate in a VM, better on own clunker HW in a subnet cut off from your biz stuff.

https://opensource.com/article/17/2/open-music-tagging
https://www.makeuseof.com/tag/how-to-rip-a-cd-automatically-correctly-name-the-files-windows/

did not smell totally fishy, but keep a vigilant (paranoid) mindset IAC.

thomas

>ID3
>ID3 is a metadata container most often used in conjunction with the MP3 audio file format. It allows information such as the title, artist, album, track number, and other information about the file to be stored in the file itself. There are two unrelated versions of ID3: ID3v1 and ID3v2. ID3v1 takes the form of a 128-byte segment at the end of an MP3 file containing a fixed set of data fields. ID3v1.1 is a slight modification which adds a "track number" field at the expense of a slight shortening of the "comment" field. ID3v2 is structurally very different from ID3v1, consisting of an extensible set of "frames" located at the start of the file, each with a frame identifier and one piece of data. 83 types of frames are declared in the ID3v2.4 specification, and applications can also define their own types. There are standard frames for containing cover art, BPM, copyright and license, lyrics, and arbitrary text and URL data, as well as other things.Wikipedia
>
>
>
>>Yupp, as the title is shown in the car it must be encoded on CD as well. Have never really looked into that, but probably lots of tools exist that can automatically set correct (song)file names. For the rest there HAS to be some online database to scrape ;-)
>>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform