Export playlists from Sony Music App - Sony Xperia XZ2 Compact Questions & Answers

I would like to transfer (export) playlists I've made using the Sony Music app, to a new (non-Sony) device.
The playlists are all referencing files in my downloads, which I'll transfer to the new phone as well.
I don't know the format of these files, such as .M3U, .PLS, .XML etc, but if I search for a playlist name with my phone connected to my PC via USB (Internal Storage) - no results are found. I was hoping I could transfer playlist files to the new phone.
Anyone know a way of doing this please?

No?

It can be done... I just copied the Music Center database from my FIIO DAP to my Samsung phone, but it does require effort to change entries in the database to make it work. The database is in SQLite format.
If you're copying the same audio files from phone A to phone B in the same directory structure, it is less of a hassle.
On the source phone there should be a database file - [root]\MusicCenter\metadata.db. Make sure you completely close the Music Center app, then copy this file somewhere on your PC.
Create a temporary playlist on the new device with a couple random tracks and copy it to your PC.
Using something like DB Browser for SQLite, open the database from the new device. Go to Browse Data and select the "storage" table. Copy the data from the "system_storage_uuid" and "app_local_storage_id" fields into a text editor.
Select the "playlist_members" table and note the "storage_uuid" field (it should match one of the entries from the "storage" table).
Close that database file and open the one from your original phone. Change the entries in the "storage" table to match those in the database from the new device. Then select the "playlist_members" table and update the "storage_uuid" for each entry to match as well -- there is a search/replace option in DB Browser for SQLite that can change them all at once. Write the changes and copy the updated database to your new device.
YMMV... but this worked for me.

Related

Xplore

This is not my app. I have used this app since my symbian days and I think it's the best file browser for android period.
X-plore is dual-pane file manager with tree view, LAN/FTP/Root/Clouds and more.
Highlights:
* Dual-pane tree view
* Root, FTP, SMB, Sqlite, Picasa, Zip, Rar explorer
* Cloud storage access: Google Drive™, Dropbox, SugarSync, Box.net, SkyDrive, Webdav, Yandex.disk
* Favorite folders
* Built-in viewers for images, video, audio, text
* Hex viewer
* Fast Image viewer with zoom and slide to previous/next images in folder
* Thumbnails for images and video as well as for various file types (depending on associated application)
* Multi-selection - always available, yet not disturbing
* View APK files as ZIP
* Share - send files by Bluetooth, email, or whatever the device supports, from any location
* Configurable buttons and key shortcuts
* Seamless work with Zip (as if it was normal folder)
X-plore allows you to see inside of your Android phone or tablet.
This is a dual-pane explorer, which means that there're two folders shown at same time, and common operation such as copying files are done from one pane to another.
And X-plore shows folder hierarchy in a tree view. This offers clear orientation on where in file system you currently are, and fast switching to other location.
Currently selected folder and files are highlighed, while other folders/files have slighly darker background.
You may explore internals of the device, and if you're power user and have your device rooted, you can make changes to system data - backup files, remove unwanted applications, etc.
If you're standard user, you may choose to hide internal memory from view and be sure not to mess with system.
You can comfortably see contents of your external memories, either be it built-in high capacity memory, external memory card, or possibly USB memory stick attached to your tablet. All these memory types are listed in main level, you don't need to search for their folders on the device.
Access to FTP and FTPS (secure FTP) servers is supported.
Multiple servers may be configured. All standard file operations can be done on FTP server.
X-plore can display shared folders on other computers in LAN (local area network).
The system allows access to shared folders on computers connected to LAN, or even remote server if it supports SMB protocol.
X-plore can access various web storage "Cloud" servers, and access their files.
You need to have account in supported web service, then you can access your files stored online through X-plore.
Main operations are related to managing files and folders - viewing, copying, moving, deleting, compressing to Zip, extracting, renaming, sharing, and more.
Picasa albums
X-plore can list images in Picasa albums, download them, create albums, upload and delete photos, edit captions.
SQLite database viewer
X-plore can show SQLite database files (those with .db extension) as expandable list of tables, each table containing list of rows and columns with database entries.
Main interaction is done by touch screen, clicking on folders or files to open files, or long-click to open context menu which contains options which can be done on particular clicked item, or multiple selected items.
Multi-selection allows to do operation on more files at once. Files can be selected by clicking check box. It is also possible to select all files in a folder, or clear selection, by clicking parent folder's check box.
Opening file may mean to use one of built-in viewer for most popular file types: images, audio, video and text.
Or you may configure X-plore to use system application for opening files, in which case system-predefined application that can open particular file is launched.
Archives (currently supported are Zip and Rar) are displayed as other folders. You may open them, see contents, and do standard operations that you'd do on files - rename, delete, copy from/to, etc.
Additional interaction is possible by button bar, which is between two panes, and is fully configurable. You may put buttons of your desired operations here, and change ordering.
https://play.google.com/store/apps/details?id=com.lonelycatgames.Xplore
Sent from my A100 using xda premium
Sounds awesome gonna have to check it out!
sent from my sexy-a$$-iconia tab
I believe a review on Best File Managers for Android should be done... Yes, we have OI File Manager, ES File Explorer, Root Explorer as main apps, but this one should be included as a well-known file explorer!

[GUIDE] Enable Podcast directory in Marketplace (in markets without prior support)

I've been searching for a solution to this problem for awhile now, and I finally found one. Using Windows Phone Device Manager I was peering through the files on the phone and found 3 xml files that hold the key to adding podcasts to markets that do not have support already.
These two xml files are located in the \My Documents\Zune\PimentoCache\Keepers folder
Downloaded_TunerConfig.xml
LKG_TunerConfig.xml
And the last one is located in the root of the Windows folder
TunerConfigDefault.xml
Now all you have to do is find your specific market (Canada in my case) and add the line pod="1" to the string, so:
<market id="en-CA" mkt="1" zpass="1" sdjloc="1" sdjmkt="1" music="1" xbox="1" ratings="ESRB" catalog="en-CA" mtax="1" atax="1"/>
becomes:
<market id="en-CA" mkt="1" zpass="1" sdjloc="1" sdjmkt="1" pod="1" music="1" xbox="1" ratings="ESRB" catalog="en-CA" mtax="1" atax="1"/>
And as simple as that, podcasts appear!
I used WPDM to transfer the files, but it was a bit finicky when the file already exists, I've found that by uploading the files with the extensions changed slightly (ie. .xml1) and then changing the file name, it replaces the old file.

[SUGGESTION] X PLORE the best file manager apps that i used on my i9001

THE BEST THING IS THIS IS A FREE APP... NO NEED TO PAY!!"!
ANOTHER AMAZING THING IS YOU CAN USE IT AS A ROOT FILE MANAGER(just you need to set it in your setting)
Highlights:
* Dual-pane tree view
* Root, FTP, SMB, Sqlite, Picasa, Zip, Rar
explorer
* Cloud storage access: Google Drive™,
Dropbox, SugarSync, Box.net, SkyDrive,
Webdav, Yandex.disk, Dump Truck
* Favorite folders
* Built-in viewers for images, video, audio,
text
* Hex viewer
* Fast Image viewer with zoom and slide to
previous/next images in folder
* Thumbnails for images and video as well as
for various file types (depending on
associated application)
* Multi-selection - always available, yet not
disturbing
* View APK files as ZIP
* Share - send files by Bluetooth, email, or
whatever the device supports, from any
location
* Configurable buttons and key shortcuts
* Seamless work with Zip (as if it was
normal folder)
X-plore allows you to see inside of your
Android phone or tablet.
This is a dual-pane explorer, which means
that there're two folders shown at same time,
and common operation such as copying files
are done from one pane to another.
And X-plore shows folder hierarchy in a tree
view. This offers clear orientation on where in
file system you currently are, and fast
switching to other location.
Currently selected folder and files are
highlighted, while other folders/files have
slightly darker background.
You may explore internals of the device, and
if you're power user and have your device
rooted, you can make changes to system
data - backup files, remove unwanted
applications, etc.
If you're standard user, you may choose to
hide internal memory from view and be sure
not to mess with system.
You can comfortably see contents of your
external memories, either be it built-in high
capacity memory, external memory card, or
possibly USB memory stick attached to your
tablet. All these memory types are listed in
main level, you don't need to search for their
folders on the device.
Access to FTP and FTPS (secure FTP)
servers is supported.
Multiple servers may be configured. All
standard file operations can be done on FTP
server.
X-plore can display shared folders on other
computers in LAN (local area network).
The system allows access to shared folders
on computers connected to LAN, or even
remote server if it supports SMB protocol.
X-plore can access various web storage
"Cloud" servers, and access their files.
You need to have account in supported web
service, then you can access your files stored
online through X-plore.
Main operations are related to managing files
and folders - viewing, copying, moving,
deleting, compressing to Zip, extracting,
renaming, sharing, and more.
Picasa albums
X-plore can list images in Picasa albums,
download them, create albums, upload and
delete photos, edit captions.
SQLite database viewer
X-plore can show SQLite database files
(those with .db extension) as expandable list
of tables, each table containing list of rows
and columns with database entries.
Main interaction is done by touch screen,
clicking on folders or files to open files, or
long-click to open context menu which
contains options which can be done on
particular clicked item, or multiple selected
items.
Multi-selection allows to do operation on
more files at once. Files can be selected by
clicking check box. It is also possible to
select all files in a folder, or clear selection,
by clicking parent folder's check box.
Opening file may mean to use one of built-in
viewer for most popular file types: images,
audio, video and text.
Or you may configure X-plore to use system
application for opening files, in which case
system-predefined application that can open
particular file is launched.
Archives (currently supported are Zip and
Rar) are displayed as other folders. You may
open them, see contents, and do standard
operations that you'd do on files - rename,
delete, copy from/to, etc.
Additional interaction is possible by button
bar, which is between two panes, and is fully
configurable. You may put buttons of your
desired operations here, and change ordering.
Googleplay linkhttps://play.google.com/store/apps/...m_medium=organic&utm_term=x+plore+google+play
Sent from my GT-I9001 using xda premium
Wrong place mate, just put it in the themes and apps section next time
mrjraider said:
Wrong place mate, just put it in the themes and apps section next time
Click to expand...
Click to collapse
I am new here... Next time i don't reaply this mistack... Thanks
Sent from my GT-I9001 using xda premium

[Q] thumbdata3 file 1.5 gb Need Help

Hay guys
I am facing some strange issues on my galaxy nexus 4.2.2 unrooted
I have notice that in my phone there is a file name THUMBDATA3-1763508120 in DCIM--->thumbnail folder of size 1.5 GB.
And even after deleting this file no space of my sdcard is released . Means my SDCARD is still showing the same space as before .
and after some time it recreate again with same size when i use camera for some time.
One more thing in my phone I have 9.35 GB of data content but SDCARD is showing 11.5 GB of space out of 13.3 GB
This may help , please confirm
Using a disk space analyzer, I was surprised to see that my Android tablet had 1.03GB of photos. This was odd to me, because I knew there were only a couple of photos on the device.
I pinpointed the problem to thumbnails. These are tiny copies of photos used by some apps to more quickly display pictures. Specifically, the 1GB was being taken up by a thumbnail index file, and I didn't need to lose that 1GB to a function I don't use on the tablet. I erased the file as follows:
1. Open a file manager on Android. I use File Manager from Rhythm Software.
2. Ensure that it can display system or hidden files. This is an option somewhere under Settings. In File Manager, tap Menu > Settings > Show Hidden Files.
3. Navigate to \mnt\sdcard\DCIM\ .thumbnails. By the way, DCIM is the standard name for the folder that holds photographs, and is the standard for pretty much any device, whether smartphone or camera; it is short for "digital camera IMages." Another BTW: when a folder name is prefixed with a period, then it is a hidden folder in Android (such as .thumbnails).
4. Select and erase the file that's about 1GB and contains the word 'thumbdata." The exact file name will vary.
After I did this, image viewing apps like Gallery operated just fine, with no apparent slowdown from the loss of this file.
In this way I freed up 1GB on my Android v4 tablet, 1GB on my Android v4 phone, and 750MB on an older Android v2 phone.
Keeping the 1GB Free
Because .thumbdata is a system file, Android recreates it. Indeed, you may find more than one copy in the .thumbnails folder, if you have reinstalled Android or similarly redid the system in some way.
To keep Android from creating the 1GB file anew, we need to create a dummy file that fools Android. In short, we create a text file with a text editor, and then move it to the thumbnails folder. Here are the steps to doing this:
1. Use File Manager to determine the exact name of the thumbnail index file. On one of my Android devices, the name is .thumbdata3--1967290299. Write it down.
2. Start a text editor or word processor on the Android, and then create a new text file.
3. Use the Save As command to save the file in the DCIM folder. (We move it to the .thumbnails folder in a later step.) Save it with the same name at that index file, such as ".thumbdata3--1967290299". Now, depending on the text editor's capabilities, it might not allow the "." prefix or a blank extension. Thus, you might end up with thumbdata3--1967290299.txt as the file name. We fix this in a later step.
4. Exit the text editor, and then switch to File Manager. Now, it is important you use a file manager like Rhythm Software's File Manager app, because it does what some others cannot: it can (a) rename file extensions and (b) access hidden folders.
5. In File Manager, navigate to the \DCIM\ .thumbnails folder. If the thumbdata3 file is there again, erase it again.
6. Move up a level to the \DCIM folder, and then right-click the thumbdata3--1967290299.txt file name. ("Right click" means hold your finger down on the name until a menu appears.)
7. From the menu, choose Rename, and then rename thumbdata3--1967290299.txt to .thumbdata3--1967290299 -- (a) add the dot (.) to the start of the file name, and (b) erase the ".txt" from the end of the file name.
8. Click OK (or Rename) to finish renaming.
9. Right click the file name, and then choose Move (or Cut).
10. Navigate down to the .thumbnails folder, and then tap Paste.
The dummy file will now prevent Android from creating the huge index file.
simplymonis said:
Hay guys
I am facing some strange issues on my galaxy nexus 4.2.2 unrooted
I have notice that in my phone there is a file name THUMBDATA3-1763508120 in DCIM--->thumbnail folder of size 1.5 GB.
And even after deleting this file no space of my sdcard is released . Means my SDCARD is still showing the same space as before .
and after some time it recreate again with same size when i use camera for some time.
One more thing in my phone I have 9.35 GB of data content but SDCARD is showing 11.5 GB of space out of 13.3 GB
Click to expand...
Click to collapse
I just answered this in another post but check it
I have root on my device, so I did the following.
Using Root explorer I went to the folder /DCIM/.thumbnails (hidden) and deleted the huge file. Then with the "+" I chose "New file" and named it the same as the previous .thumbdata3-.... it created a file that is 0 Bytes and then I went and used the camera and the apps, so far the file stays the same size, so maybe that trick will work for others too. Good luck.

Huawwei Health: Export Data from IOS

Trying to export my health data(motion/gps) from my IOS phone to Strava
1) For some reason my data has/is not syncing with the cloud(it stopped 6 months ago) I've re-enabled the cloud sync option in the app, but it still wont sync. Requesting data from Huawei and then converting the data and importing into Strava worked fine, using the to converter the Hitrack to TCX then importing was easy. I have linked my Strava account to Huawei Health app but unfortunatly this only syncs NEW workouts not the old data.
1) I have access to the IOS app and files, it's the wear.db (SQL lite database) that has all the right up to date data but stored in a database (mine is 1.3GB) , is there a way for this to be converted to the .json file(this is what you get when you request your data from Huawei).
2) Is there a way to convert the health data .db file to something that can be used in Strava? Either a batch converter or for individual activities.So essentially the SQL db to motion path detail data.json file that can then be used with the https://github.com/aricooperdavis/Huawei-TCX-Converter
3) I did find, https://github.com/tommyblue/huawei-health-to-gpx conveter that can convert .db files (individual hitrack files to gpx) but for the life of me can't figure out how to install(golang files?)
Has anyone figure out a good solution yet, or can help with the above?
ok so I figured this out!!
1) Browse your Health data on your phone using filza and or Apps manager, it's under your document data, not the app data so may take a while to locate, should be under the documents folder. If using filza you can enable WebDAV and then simply login via a browser then download the file onto your desktop
2) Locate the wear_133.db file, or the largest most recent file, mine was 1.3GB
3) Transfer to your PC.
4) Open with a SQL Browser, I used https://sqlitebrowser.org/
5) Go to file export data table to JSON, select the wear_xxxMotionPathDetail Table
6) You should have a file call MotionPathDetail.json file(can take a while to save)
7) Go to https://github.com/CTHRU/Hitrava and download the latest build
8) Edit the following line to match your filename.
python Hitrava.py --json "motion path detail data.json" --from_date 2019-10-03 --output_dir my_output_dir/json
change the date to date earlier than your first activity.
9) Open a CMD prompt to the folder where Hitrava is, paste the JSON file you have from step 6
10) Run, and wait, you should now have an output folder in the same directory with ALL of your latest walks/runs etc.. in .tcx format
11) Open Strava/other apps and then add activity, import the .tvx files
If your lazy use https://tapiriik.com/ and sync your Strava account to a dropbox with all your .tcx files in a folder.
Tested and working!

Categories

Resources