iOS Cool Music Export tool usage instructions and principles (provide download link and project source code)

Software download link

Cool music files downloaded on the iOS version. When viewed by software such as Sync Assistant. Discover music files are named after a string of numbers. Look through the web and try it yourself. Found that the files are audio files changed the name of the file. Just change back the file name and it will play like normal music.

Before writing a simple Java program to implement the function, but did not provide a packaged program for everyone to use.

Recently wrote a simple graphical interface for download and use. If you have questions or suggestions for improvement, you can contact me (comments in the original).

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

Assume that it is not a Windows system. The packaged Jar program can be downloaded (the JRE needs to be installed on the computer).

Https://github.com/jzj1993/iOS-KwMusic-Export-Tools/raw/master/iOS-KwMusic-Export-Tools.jar

Usage Note 1, copy file

Start by using software such as Sync Assistant to export downloaded music files from your iOS device (iphone or ipad) to a directory on your computer.

Generally in the Downloadingsave and music directories in the diagram.

Then locate 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. Assumptions cannot be performed. Please install the JRE on the computer, the detailed method can be Baidu search.

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

The music after processing.

Use this program to organize the exported audio files. It takes less than two minutes to complete more than 700 music.

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 a Java-brought swing and AWT framework, with the GUI and interactive parts of the source code such as the following:
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 change 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

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

1. playlistsInfoThe playlist information is saved in the FieldtitleFor List names, fieldsidAs a listid。

2. playlistMusicsThe corresponding relationship of the music and playlist is saved, the fieldtitle、artistAs music information,ridFor music resourcesidFieldplaylist_idThe owning playlist is correspondingid。

3. musicResourceis the corresponding relationship between music information and files. Fieldfileto the corresponding file name.formatto a file format.ridFor music resourcesid。

So the workflow of the program is this:

2. First musicResource read each piece of music from one by one rid ;
3. PassridInplaylistMusicsFind inplaylist_id。 may not be found, or there may be more than one. Since the same music may be in more than one list, it is easy to take the largestplaylist_id。 This should usually be relative to a newer playlist.
5. The playlistsInfo corresponding playlist name is then found in playlist_id , as a sub-directory of the target music.
7. Finally, rename the source file to "singer name – song name." and move it to the target directory.

The source code for 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: Since 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 is original by jzj1993. Reprint please indicate source: http://www.hainter.com/ios-kwmusic-export-tools

iOS Cool Music Export tool usage instructions and principles (provide download link and project source code)