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:
playlistsInfo
The playlist information is saved in the Fieldtitle
For List names, fieldsid
As a listid
。
playlistMusics
The corresponding relationship of the music and playlist is saved, the fieldtitle
、artist
As music information,rid
For music resourcesid
Fieldplaylist_id
The owning playlist is correspondingid
。
musicResource
is the corresponding relationship between music information and files. Fieldfile
to the corresponding file name.format
to a file format.rid
For music resourcesid
。
So the workflow of the program is this:
- First
musicResource
read each piece of music from one by one rid
;
- Pass
rid
InplaylistMusics
Find 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.
- The
playlistsInfo
corresponding playlist name is then found in playlist_id
, as a sub-directory of the target music.
- 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)