iOS Cool Music Export tool usage instructions and principle Introduction (Provide download link and project source code)

Software download link

Music files downloaded from the cool music iOS version, when viewed through software such as Sync Assistant, find that music files are named after a string of numbers. Find the files by searching online and trying them out, and find that they are all audio files changed to the file name. As long as you modify the filename, you can play the same as normal music.

Previously wrote a simple Java program to implement the function, but did not provide packaged programs for everyone to use. A simple graphical interface has recently been specially written for download and use. If you have questions or suggestions for improvement, you can contact me (comments in the original text).

Can directly click this link to download the packaged EXE program to use.
Https://github.com/jzj1993/iOS-KwMusic-Export-Tools/raw/master/iOS-KwMusic-Export-Tools.exe

If it is not a Windows system, you can download the packaged Jar program (JRE is required on your computer).
Https://github.com/jzj1993/iOS-KwMusic-Export-Tools/raw/master/iOS-KwMusic-Export-Tools.jar

How to use 1, copy files

Start by using software such as Sync Assistant to export downloaded music files from your iOS device (iphone or ipad) to a folder on your computer. Typically in the Downloadingsave and music folders in the diagram.

Then find the database file cloud.db and copy it out.

Files that are copied to your computer.

2. Using the Music export tool

Download and double-click to open the Music export tool. If not, please install the JRE on the computer, the specific method can be Baidu search.

Select cloud.db the folder where the database files and music files are saved (note that all music files are placed under the selected folder and cannot be placed in its subfolders). Click Start processing, that is, start processing, after processing is complete.

After processing the finished music.

Using this program to organize the exported audio files, measured more than 700 music, only in less than two minutes to complete.

Software implementation

Readers who are interested in understanding the software implementation, have certain Java programming capabilities, and are interested in improving the software can continue to look down.

The implementation of the foreground graphical interface

The graphical interface uses the swing and AWT framework that comes with Java, and the GUI and interactive sections have the following source code:
Https://github.com/jzj1993/iOS-KwMusic-Export-Tools/blob/master/src/ClsMain.java

Database Operations Support Library

The essence of data processing is to read the information from the database file and modify the file name and movement accordingly. The operation of the database is using a sqlitejdbc-v037-nested.jar support package.

Implementation of the Background data section

copied from the phone cloud.db database file for sqlite database file. With sqlite Database Browser Open, see the inside and music is closely related to the main three data tables:

1. playlistsinfo holds playlist information, field title is the name of the list, field id for list id .

2. playlistMusicsSave the corresponding relationship of music and playlist, fieldtitle、artistAs music information,ridFor music resourcesidFieldplaylist_idCorresponds to the owning playlistid。

3. musicResourceis the music information and file correspondence, the fieldfileFor the corresponding file name,formatTo a file format,ridFor music resourcesid。

So the workflow of the program is this:

2. first from musicresource reads each music rid ;
4. rid in playlistmusics find playlist_id , may not be found, there may be more than one, because the same music may be in more than one list, here simply take the largest playlist_id , which should usually be relatively new to the playlist;
6. Then playlistsInfo find the playlist_id corresponding playlist name in, as a sub-folder of the target music;
8. Finally, rename the source file to "singer name – song name. Extension" and move to the destination folder.

The source code of the Data Processing section is as follows:
Https://github.com/jzj1993/iOS-KwMusic-Export-Tools/blob/master/src/Data.java

Full project download/ Fork me on GitHub:
Https://github.com/jzj1993/iOS-KwMusic-Export-Tools

Note: Because I do not have an iOS device now, there are two itools in this article from
Http://blog.sina.com.cn/s/blog_4d5428240101bs5x.html

This article by jzj1993 Original, reprint please indicate source: http://www.hainter.com/ios-kwmusic-export-tools

iOS Cool Music Export tool usage instructions and principle Introduction (Provide download link and project source code)