TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker and becoming a Supporting Member. For more info: Support TMC

USB Music Playlist Workaround

Discussion in 'Model 3: User Interface' started by GPinzone, Sep 3, 2018.

  1. GPinzone

    GPinzone Member

    Joined:
    Sep 3, 2018
    Messages:
    192
    Location:
    Ronkonkoma, NY
    The Tesla USB music playback options leave much to be desired. There is no way to impose a playback order for all the songs on the USB stick other than alphabetically by song title. The directions below will modify all your music file titles by prepending a three-digit base 36 number. This allows for 46,656 ordered tracks.

    What you will need:

    Tag&Rename Mp3 tag editor Tag&Rename - edit tag in mp3, wma, mp4 files, automatic discogs and freedb import
    Microsoft Excel (and knowledge of how to sort rows)

    1. Copy all the music files you wish to store on the USB drive to a folder on your hard drive. It’s important to make a COPY since the song title metadata on the files will be modified. You do NOT want to do this with your originals. You may organize your files in folders (and subfolders), but this will not have any effect on how the Tesla media player will perform.

    2. Open Tag&Rename and browse to the directory containing your copied music files.

    3. Click View, Expand All Folders.

    4. Click on a file and press Control-A to select all files.

    5. Press F12 or select Tools, Export/Import Tags from the menu. Click on the “Export” tab, if necessary. Note the location where the Excel file will be generated. Click the “Go” button. All the files in the directory should have their metadata exported to the Excel file.

    6. Open the Excel file generated in the previous step. Verify the “Title” field is the third column.

    7. Sort your songs in Excel using any criteria you like. For example, sort by artist, then album, then track number. If you want to shuffle the rows, use this tutorial here: Randomize a List in Excel Delete the random number column when you are done.

    8. Go to the first blank column (End, Right arrow, Right arrow). In the second row (Down arrow), enter the following formula in that cell:

    =BASE(ROW()-2,36,3)&" "&C2

    The result should be the first song’s track title prepended with “000 “.

    9. Highlight the cell, press Control+Shift+End to jump to the bottom of the list. Press Control+D to fill down the range. The column should contain all the song titles prepended with a sequential number in base 36.

    10. Scroll to the top of the column and select the entire column. Copy the column and Paste Values to the blank column to the right. If you do it correctly, the new column will not contain formulas. It will be the hard-coded title text.

    11. Highlight the formula column and press the “Delete” key. It should now be gone. The hard-coded title column should remain. Copy the header cell from the original Title column to the new one. Cut the entire new title column, and paste it over the original Title column.

    12. Save the Excel file and close it.

    13. Switch back to Tag&Rename. Press F12 or select Tools, Export/Import Tags from the menu. Click on the “Import (From XLS/XLSX Only)” tab. Verify the “Import tags to all files which record exists in XLS file” is selected. Click the “Go” button. Click the “Yes” button when the confirmation dialog appears. This will take a while even on a fast hard drive. (Do not panic if Windows says the program has stopped. Do NOT cancel it. Allow it to continue.)

    14. Verify the title tags have been updated in Tag&Rename.

    15. Copy the entire music folder contents to a USB drive and plug it into your Tesla.

    16. Choose “Songs” under the USB options. All your songs will play in the order you chose in Excel.


    DONE!
     
    • Helpful x 3
    • Like x 1
  2. MikeATL

    MikeATL Member

    Joined:
    Aug 7, 2018
    Messages:
    348
    Location:
    Atlanta, Georgia, United States
    OMG..... we’re driving a car that’s got technology from the year 2030 and managing mp3’s like it’s 2000! This is madness!

    If Tesla would just build WinAmp into their Software, we’d be all set !
     
    • Like x 1
    • Funny x 1
    • Love x 1
  3. GPinzone

    GPinzone Member

    Joined:
    Sep 3, 2018
    Messages:
    192
    Location:
    Ronkonkoma, NY
    Yes, I agree, but it's better than nothing. Now I just hope that the media player remembers the last song played!
     
  4. RoccoX

    RoccoX Member

    Joined:
    Jul 9, 2018
    Messages:
    10
    Location:
    New York
    Hey GPinzone I had thought order could be done via title, track number, or the file name? I am guessing I am wrong on the file name?
     
  5. GPinzone

    GPinzone Member

    Joined:
    Sep 3, 2018
    Messages:
    192
    Location:
    Ronkonkoma, NY
    AFAIK, there is no way to control playing all the tracks unless it's by song title.

    The audio player switches to Bluetooth when I re-enter the car. Switching to USB does not make it start where it left off. :mad:

    Anyone know how to get around that problem?
     
  6. marusan

    marusan Member

    Joined:
    May 15, 2018
    Messages:
    94
    Location:
    Silicon Valley, CA
    This is, by no means, unique to the Tesla media player -- I had to use this same hack to play music in track order on my VW nav system (which supported SD cards for removable media).

    The problem is that the player is looking only at artist, genre, album, and title. It's ignoring lots of other useful MP3 tags such as track ID (which is really how you want these sorted), disc number (for multi-disc albums), release year, etc. I was fairly surprised to see how minimal the USB support is, but also not that surprised given the emphasis on streaming music. Solution? Just use your phone over Bluetooth.
     
  7. GPinzone

    GPinzone Member

    Joined:
    Sep 3, 2018
    Messages:
    192
    Location:
    Ronkonkoma, NY
    What I've done with my old car is to upload all my music into Google Play. Then I can stream it from my phone. It works, but it uses data. Otherwise I have to load my music onto the phone.
     
  8. Knightshade

    Knightshade Active Member

    Joined:
    Jul 31, 2017
    Messages:
    2,402
    Location:
    NC
    Solutions that use cell data and/or require accepting significantly lower audio quality (which is what all the alternatives to USB media offered in the model 3 involve) aren't really solutions.
     
  9. GPinzone

    GPinzone Member

    Joined:
    Sep 3, 2018
    Messages:
    192
    Location:
    Ronkonkoma, NY
    I think I figured out how to allow the USB audio to remember its last location. The audio system will choose Bluetooth streaming from your phone over USB audio even if USB audio was the last thing playing. The workaround is to disable all Bluetooth "Media audio" from your phone's Bluetooth setup for your Tesla's configuration.

    On your Android phone while your Model 3 is on and Bluetooth is connected: go to Settings, Connections, Bluetooth, click on the gear icon for Telsa Model 3 (or what you named the connection), and turn off "Media audio."
     
  10. Megapsychotron

    Joined:
    Aug 1, 2018
    Messages:
    39
    Location:
    bakersfield
    #10 Megapsychotron, Sep 24, 2018
    Last edited: Sep 24, 2018
    Thanks for the tip; partial success for me, I think. In my case, it doesn't resume. It does appear to eliminate the need for recaching the drive contents when I get in the car, so that is a improvement. Still takes about 3 seconds for USB option to become available and to show up under "Recent."
     
  11. S3XY

    S3XY Active Member

    Joined:
    Nov 24, 2015
    Messages:
    1,248
    Location:
    Buffalo, NY
    #11 S3XY, Sep 24, 2018
    Last edited: Sep 24, 2018
    I'm hopeful that the reason they haven't been improving the media player in recent updates is because they have totally re-written it in version 9.0 which should drop "soon".
     
  12. Megapsychotron

    Joined:
    Aug 1, 2018
    Messages:
    39
    Location:
    bakersfield
    Tracks and albums can be organized in their folders by adding their numerical place in their filenames. Look at my post "Lessons learned about USB audio"
     
  13. MikeATL

    MikeATL Member

    Joined:
    Aug 7, 2018
    Messages:
    348
    Location:
    Atlanta, Georgia, United States
    I’m not going to get too excited that change is coming so soon, but I’m hoping you’re right that they’re basically starting over.

    As a mass market vehicle, they are going to need to appeal to people who are less impressed that it’s a Tesla and want want solid well rounded features.
     
  14. sduck

    sduck Member

    Joined:
    Nov 6, 2017
    Messages:
    192
    Location:
    Nashville TN
    Hmmmm? Really? Not my experience. In folder view, once you are looking at the individual files in the folder, they are organized alphabetically, and not using the file names, but rather with the names from the tags, which almost always makes them out of normal order. I've bugged tesla support about this numerous times, supposedly it will get fixed eventually.
     
  15. Megapsychotron

    Joined:
    Aug 1, 2018
    Messages:
    39
    Location:
    bakersfield
    I checked to see what you mean, and I see that you are correct when browsing through the folders. But I'm wondering if there is any particular reason you're browsing music this way? I browse my music through artist, and then albums, and if the filenames are numbered, everything is alphabetical.
     
  16. sduck

    sduck Member

    Joined:
    Nov 6, 2017
    Messages:
    192
    Location:
    Nashville TN
    Largely because I have numerous compilation folder/albums. If I only had regular commercially available albums I'd be fine.
     
  17. Sotto Voce

    Sotto Voce Member

    Joined:
    Dec 1, 2015
    Messages:
    18
    Location:
    Columbus, OH
    I had this problem with my MS some time ago, when the firmware was updated and changed the music interface (same time they removed the vertical alpha display along the right side, before putting it back) and now I have it with the M3. Too bad for me that I like to listen to FLAC and MP3 files of my home music library. Defines me as old, I realize. Found a work-around by using free (donations encouraged) MP3Tag software, for both my FLAC and MP3 thumb drives. It allows the manipulation of the metadata to put two digit track numbers in front of the track names, so that in the Tesla folder view, the tracks are listed in numerical order rather than alpha order. While it would be far better for Tesla to improve the interface and the navigating of music sources and songs, this has worked for me in the meantime.

    Within MP3Tag, select the directory of your music files on your thumb drive (or your source if you want to go that far), then select all the folders/files (or just select one folder if you want to test). Select Configure tab, select Tag to Tag, Select Title field, and then enter this string to accomplish the adding of two digit track number in front of title $num(%track%, 2) - %title%

    That's it. Takes some time to accomplish the task, depending on the number of albums and songs you have on the drive. Hope this can work for you until Tesla advances its interface.
     

Share This Page

  • About Us

    Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.
  • Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


    SUPPORT TMC