Page 2 of 2 FirstFirst 12
Results 16 to 26 of 26
  1. #16
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Hi Bill.


    MP3 files contain a large number of extended file properties which provide exactly what you want....and more besides
    Try any MP3 in my Extended File Properties app (see link in post #11).
    Then compare with the file properties associated with any CDA file

    Attached are example reports from that app for a randomly chosen MP3 file and a CDA file
    Note the differences in the properties each contains

    Hope that helps
    Attached Files Attached Files
    Last edited by isladogs; 07-17-2021 at 03:52 PM. Reason: Added screenshot
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #17
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    Quote Originally Posted by GraeagleBill View Post
    Colin, if I'm understanding you, maybe there's hope yet. What is actually happening here is that I'm in the process of loading my entire CD library into an NAS from which I can play either via my Cataloging app or the PLEX media server on our TV. Since I'm used to using Sound Forge (I've transferred a boat-load of 12" vinyl treating them like master copies over the years) I load in the CD's "track-at-a-time) and save as mp3 files. Your post suggests to me that unbeknown to me that the file properties of those mp3 files include titles? If that's the case, my cataloging app will take care of the issue with a few lines of code.
    They include a lot more than that, bit rate, genre etc.

    I use Audiograbber to rip my CD's these days, and Tag & Rename for tidying up the data if needed.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #18
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,789
    the file properties of those mp3 files include titles?
    So I'm back to being confused. It seems we are talking about files on a drive and not cda data. I mentioned that I retrieved the titles from a set of sound files in a folder using the "Excel" code yet that's not what's needed either?
    I'll leave you guys to it and wish you luck.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #19
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    No Micron,
    I think the o/p has discovered by this thread that accessing his mp3 files wil do what he wanted?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #20
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Title not shown in Extended File Properties. I think the problem now is HOW I READ IN the CDs. When I load in a CD track-by-track into Sound Forge, it's using a high bit rate on a WAV formatted file, then saved to disc as Sound Forge MP3. I think with all that function, I'm losing the title date I'd like to obtain.

    Welshgasman uses an app entitled "Audiograbber". I see it online, so I'll play with that and see if that's a suitable substitute for what I've been doing with Sound Forge. (Sound Forge is a audio wave form editor for those that might not be familiar)

    Well, so much for "Audiograbber", see error I get trying to install
    Click image for larger version. 

Name:	AudioGrabber.jpg 
Views:	9 
Size:	57.5 KB 
ID:	45782

  6. #21
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    Most of the programs like AudioGrabber, look at onlne DBs like Gracenote to get all the data?
    If the CD is not there, then you manually enter the data yourself, and submit it to the DB.
    After verification, it is there for others to use. A sort of community project.

    FWIW here is the program that I found that would read CDText in the format I displayed (if it exists).
    Plus a link as to how to use it.

    HTH

    https://community.metabrainz.org/t/h...udio-cd/149137

    Edit: That is the version I have, worked fine for me?
    Attached Files Attached Files
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #22
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    I used WMP to rip a CD. Colin's app only displays "Track 1" as the title, whereas it should be "Track1 - Allegro vivace".

    I downloaded MediaTools and ran without parameters in anticipation of revealing the help text, but there's nothing revealed so I'm in mystery about that.

    Windows didn't tell much about its security issue when I attempted to install AudioGrabber, but WMP didn't have any issues with the ripping process. I can't help but wonder if WMP is getting the CD-Text that's required for Colin's app to capture the entire title of the tracks.

    I ripped the CD again using Easy CD-DA Extractor and then ran its "Metadata Editor", the title data is exactly like Colin's app shows.

    I guess it's possible that symphonic music doesn't include such descriptions as tempo, etc. I'll experiment with a CD that contains song titles to see if that thought has any merit.

  8. #23
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    I'm sure in the past you could rip CDs directly from Windows File Explorer but it seems to be no longer possible.
    Anyway, ripping a CD from WMP is still possible as stated but there are various options about the metadata that is saved:

    Click image for larger version. 

Name:	Capture.jpg 
Views:	9 
Size:	73.2 KB 
ID:	45784

    The file name will depend on the options ticked e.g.

    Click image for larger version. 

Name:	Capture2.PNG 
Views:	9 
Size:	43.9 KB 
ID:	45785

    When imported into the Access Media Player app, the displayed name will be whatever the file name is depending on those options

    Click image for larger version. 

Name:	Capture3.PNG 
Views:	9 
Size:	8.8 KB 
ID:	45786

    So with careful selection of what is included in the file name, you should be able to get the title in the file name and therefore in the Access media player
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  9. #24
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,789
    I have a tag editor. Haven't used it in a while. Let me know if you want to know what it is. On my phone now.

  10. #25
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Thanks for the offer. But with further testing, I've come to the conclusion that the CD's themselves do not contain the title data of interest, at least with classical music. Most of the players are single song oriented. As such, symphony movement tempos and the like don't really fit into that arena. It appears that one needs the GraceNote services to obtain such information. Often times, like with Groove, one is accessing the title details via GraceNote transparently.

    I've taken up a lot of people's time with this OP, I think it's time to call it quits.

  11. #26
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    One final thought...............

    Have I failed to properly distinguish the difference between what's in "Metadata" versus what's in "CD-Data"? Is Colin's app reading something other than what the "rippers" are looking at?

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print a table's "LastUpdated" metadata in a report
    By Carbontrader in forum Reports
    Replies: 3
    Last Post: 03-05-2018, 04:22 AM
  2. Go Directly to a Form Record from a Report
    By stacynh in forum Forms
    Replies: 7
    Last Post: 05-15-2017, 07:54 AM
  3. How to get Metadata from .wav file into Access ?
    By edmscan in forum Programming
    Replies: 3
    Last Post: 12-31-2016, 01:21 PM
  4. read metadata from video files
    By user in forum Access
    Replies: 1
    Last Post: 07-07-2011, 05:05 AM
  5. Report only returns 1 record unless run directly
    By teresamichele in forum Reports
    Replies: 3
    Last Post: 12-17-2010, 12:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums