Results 1 to 2 of 2

Thread: Bulk change file extension using DB Browser for SQLite?

  1. #1

    Default Bulk change file extension using DB Browser for SQLite?

    I have well over a thousand video files that I have that I've spent a lot of time curating in Mezzmo.

    Up until 2 years ago, my .mp4 files were getting the extension .m4v (no judging, please). Functionally, no difference except for the extension.

    We have some new TVs in the family that can actually see a usb device with a NTFS file system so it's easy to share files for viewing with Mom & Dad. However they don't acknowledge .m4v files. You can rename them and they work fine. I thought problem solved.

    Unfortunately, after a while I realized that at home when I pull up Mezzmo on the TV, it is not showing me the older .m4v files. The profile that is uses in Media Devices is 'Generic Device (NTSC)'. It doesn't need to transcode any of these files, it can play 4k .mp4 and .mkv files just fine from Mezzmo or a thumb drive. I did notice that when I am browsing Mezzmo on the TV (a Samsung 8 series 4k) I am seeing the file names complete with extensions as opposed to the Title.

    If there is an easy fix to this with a new profile, that would be fine. However, what I would like to do is change all of the .m4v file extensions to .mp4. THAT is the easy part. What I would then need to do is use DB Browser for SQLite to update all of the entries that have .m4v files to have the correct .mp4 extensions. My SQL skills are to the point that if I see a script, I can figure out how it works. Coming up with one from scratch? That's dangerous to the database. I've tried working on a copy of the database and I'm hitting walls. Plus, I have no idea if I'm even looking at all of the fields that I need to.

    Any suggestions?

  2. #2
    Join Date
    Sep 2009
    Posts
    2,680

    Default

    Hi,
    you can use the Maintenance tools in Mezzmo to update the extensions http://www.mezzmo.com/wiki/doku.php?...ntenance_tools

    The Maintenance tools do a search and replace so if you put the .m4v in the original path field and the .mp4 in the new path then it will change all the .m4v to .mp4 without any need to use sql.

    Display titles are used to show the title of the videos http://www.mezzmo.com/wiki/doku.php?id=display_titles so if you are seeing the filename instead of a nice title then this could mean that Mezzmo has not done a lookup on the file for metadata yet due to the file extension changing, if you change the extensions using Maintenance tools to match the files on disk then the existing metadata should match up and you will get your nice titles.

    Mezzmo Android: Install it on your tablet, smartphone, Android TV or Amazon Fire to browse and stream files from your Mezzmo library to all your devices. Full details at http://www.conceiva.com/products/mez...mo_android.asp
    Mezzmo for Kodi Add-on: Install it into Kodi to stream files from your Mezzmo library directly in Kodi. Full details at http://www.mezzmo.com/wiki/doku.php?...odi_user_guide
    Mezzmo for Roku App: Install it onto your Roku to stream files from your Mezzmo library. Full details at http://www.mezzmo.com/wiki/doku.php?...oku_user_guide
    Wiki: User Guides & Reference Manual at http://www.mezzmo.com/wiki
    Facebook: http://www.facebook.com/Mezzmo.DLNA.Server
    Twitter: https://twitter.com/conceiva_mezzmo
    Web: http://www.mezzmo.com

Similar Threads

  1. Way to automatically pre-transcode files based on file extension type?
    By jeffreybc55 in forum Mezzmo Questions and Support
    Replies: 3
    Last Post: 03-09-2016, 08:52 AM
  2. Change video file extension to appease PS4 media player
    By RedBeard1701 in forum Mezzmo Questions and Support
    Replies: 1
    Last Post: 06-27-2015, 02:48 PM
  3. Tutorial: Installing the DownloadStudio extension in Chrome web browser
    By Peter in forum DownloadStudio FAQs & How To Guides
    Replies: 0
    Last Post: 02-02-2015, 10:15 AM
  4. Unable to download video files in bulk
    By aloha in forum DownloadStudio Wish List and Feedback
    Replies: 4
    Last Post: 10-11-2010, 07:53 AM
  5. Remove ".dstudio" File Extension
    By Rob in Buffalo in forum DownloadStudio Questions and Support
    Replies: 1
    Last Post: 09-14-2009, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •