Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556

    Get track metadata directly from CD


    Is there an API around that will allow me to read track titles via VBA directly off of a CD drive? There are some references to such ideas via Google, but some of the referenced URLs no longer exist or don't address the question.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,446
    I found this and tested 4 links in it and stopped there. You want to read sound file metadata, yes? Did you search on that?
    https://social.msdn.microsoft.com/Fo...orum=accessdev
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,188
    Programs out there to read track titles and artist

    Returns output like
    CDTEXT STARTS
    Title 0 Colorado
    Title 1 Think Of Me - Neil Young with Crazy Horse
    Title 2 She Showed Me Love - Neil Young with Crazy Horse
    Title 3 Olden Days - Neil Young with Crazy Horse
    Title 4 Help Me Lose My Mind - Neil Young with Crazy Horse
    Title 5 Green Is Blue - Neil Young with Crazy Horse
    Title 6 Shut It Down - Neil Young with Crazy Horse
    Title 7 Milky Way - Neil Young with Crazy Horse
    Title 8 Eternity - Neil Young with Crazy Horse
    Title 9 Rainbow Of Colors - Neil Young with Crazy Horse
    Title 10 I Do - Neil Young with Crazy Horse
    Artist 0 Neil Young with Crazy Horse
    CDTEXT ENDS

    is that any good to you?
    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?search_query=debug+access+vba



  4. #4
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556
    Yes, I could make that work for me if I'm reading directly off the CD. Essentially, I want to put a CD in an optical drive and run VBA code that will return the title of each track. Is such a program available? If so, is there an API I can obtain giving me VBA access?

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556
    Yes, and after some expired URLs and one down the Excel rabbit hole I moved on.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,188
    Well that program I searched for, downloaded and ran as a test will provide that output.? You supply the dive letter plus a parameter. I would write the output to a text file, then read that file.
    You then need to process that output to get the titles and artist from that output.?

    Are you prepared to do that, or do you want an easier solution?
    There might well be one, but you need to search more?

    Eg, this is for a Various Artists CD
    CDTEXT STARTS
    CDTEXT ENDS

    so nothing produced, despite their being 18 tracks on the CD? The isrc parameter also shows no data?, so a bit hit and miss really?

    In fact after a little further testing, I would not bother with this program?
    I put another Neil Young CD in and it produced no data.
    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?search_query=debug+access+vba



  7. #7
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556
    Yes, and after some expired URLs and one down the Excel rabbit hole I moved on.

  8. #8
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556
    Have a look at this link, as it could clear up a lot pertaining to CD-Text versus Metadata. With the age and mix of what I have, I think it would be more-or-less a waste of everyone's time to pursue this OP any further. Probably also answers why you had mixed results with "CDTEXT".

    https://theproaudiofiles.com/cd-text-metadata-artwork/

  9. #9
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,446
    I don't get what the issue would be about code being on an Excel site. It's the same VBA regardless as far as getting at the info is concerned.
    I used the Excel code from the 6th link and got a spreadsheet with what looks like the track titles for every mp3 file in a folder, plus a lot of other tag info. If the code can do that, it can be modified to retrieve only the title and do whatever you want with it.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  10. #10
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,188
    Quote Originally Posted by Micron View Post
    I don't get what the issue would be about code being on an Excel site. It's the same VBA regardless as far as getting at the info is concerned.
    I used the Excel code from the 6th link and got a spreadsheet with what looks like the track titles for every mp3 file in a folder, plus a lot of other tag info. If the code can do that, it can be modified to retrieve only the title and do whatever you want with it.
    @Micron,
    The O/P specifically wanted direct from the cda files on the CD though?
    Mp3 data is easy to come by in comparison.? I am sure isladogs posted something that read the all the file properties.?

    I think the problem is, not all CDs have CDtext data. I tried two others and nothing was returned.?

    I ripped my CD collection to mp3 many years ago, when we were still on dial up.
    Took a while, but I was out of work, so what the hell

    Nowadays it is so much easier.
    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?search_query=debug+access+vba



  11. #11
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,016
    My Extended File Properties database does indeed get file properties but it won't help in this case as CD tracks are just saved as Track01.cda etc.

    As already stated you need to rip the CD to extract the tracks in another suitable format such as MP3 or FLAC etc
    There are numerous apps that do this and grab the artist & title info once extracted.

    Once that is done, the file properties app will give you what you want

    NOTE:
    As a partial work round, You could easily add .cda files to the list of file types in the Media Player app I uploaded before.

    Code:
    .Filters.Add "Media Files", "*.cda, *.wmv,*.mp4,*.mp3,*.doc, *.docx, *.xls, *.xlsx, *.pdf"
    Click image for larger version. 

Name:	Capture.PNG 
Views:	19 
Size:	70.5 KB 
ID:	45776
    Once uploaded you can rename them manually
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

  12. #12
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    1,188
    @isladogs
    I found a program that would extract CDText as shown above. However if the CD has no CDText, nothing to retrieve?
    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?search_query=debug+access+vba



  13. #13
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    9,446
    I guess I was thinking of burned CD's that contained actual sound files. Sorry @GraeagleBill.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  14. #14
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556
    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.

  15. #15
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,556
    Not out of work, but retired long ago.......... same difference

Page 1 of 2 12 LastLast
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