Related
Before formatting my TD2 I made a full backup.
Now I want to transfer my Shazam tagged songs list back.
Simple copy paste from the backup is not working.
Where Shazam is keeping the list of tagged songs?
How do I export that list?
__________
Update: found it!
Can someone please open this attached shazam.db (from shazam for wm 6.5 ) and return the song list , date and time in some other format? xls, cvs etc.
Thanks!
Update:
Shazam.db file in aplication data\shazam\folder is where all tags are stored.
Did you have any luck with this? I was hoping to do the same thing, but I hit a wall when I realized that I don't know how to access files on my Droid's internal storage. Would you mind pointing me in the right direction?
Found nothing so far.
Anyone?
Incorrect....
Either the htc hero has a different file structure or this information is inaccurate....
There is no such file path.
I whipped a quick app (attached below) that can back up the shazam database file to your SDCard (in folder "shazambackup") and restores it need be.
Also you can export the Tagged songs to xml (saved as "exports.xml" in the "shazambackup" folder).
Next i'll probably parse the xml to a more readable format. Maybe CSV? or just Plain Text? Any ideas are welcome!
Let me know if you have any issues. So far i've only tested it on my G1. Must also have a rooted phone for any of this to work.
Can you please open this shazam.db (from wp6.5) and return the song list , date and time in some other format? xls, cvs etc.
Thanks!
bump.
Anyone can help?
See first post.
You're dealing with mostly Android here, you may want to ask in a WM or phone specific forum.
(from... Evo/MIUI/Tapatalk)
kokenjr said:
I whipped a quick app (attached below) that can back up the shazam database file to your SDCard (in folder "shazambackup") and restores it need be.
Also you can export the Tagged songs to xml (saved as "exports.xml" in the "shazambackup" folder).
Next i'll probably parse the xml to a more readable format. Maybe CSV? or just Plain Text? Any ideas are welcome!
Let me know if you have any issues. So far i've only tested it on my G1. Must also have a rooted phone for any of this to work.
Click to expand...
Click to collapse
Does not work properly on Desire. Opens the app after installation but "backup" button does not create the backup file and "Export to XML" makes the app force close without exporting anything.
About the export feature - the CSV version would probably be the best.
Thanks!
p666nn said:
About the export feature - the CSV version would probably be the best.
Thanks!
Click to expand...
Click to collapse
Can you or someone please export attached shazam.db (zip) in any other usable format?
Thanks!
Bumb!
BUMP!!!!!!
CSV would be great
The app's export to xml feature also fails on HTC Evo 4G (GingerBread).
Solution with SQLite
Hi everybody,
I found a solution to export the list via SQLite. I had to find it for myself as I found nothing on the web, but I put it here, so perhaps somebody else is looking for such a solution as well.
This explanation is about how to get Shazam's data base file from your Android phone, access it on your computer and export a list of your tagged songs.
1. COPY FILE FROM PHONE
The data is stored in the file on your Android:
/data/data/com.shazam.android/databases/library.db
You have to copy this file to your Computer to work with it. Probably everybody does this in a different way. Mine was probably a bit more difficult than necessary, there should be simpler ways (e.g. with ssh / scp), but mine was: Opening the Android app "Terminal" and typing in the command:
Code:
cp /data/data/com.shazam.android/databases/library.db /sdcard
Then the file was copyed on the sdcard, which I could access to with my computer via USB cable.
Then you need a program which can open SQLite-Files. There is the command line tool (at least in Linux) "sqlite3", but also graphical tools for Linux/Windows/Mac like the "sqlitebrowser" (Link: sourceforge.net/projects/sqlitebrowser).
2. OUTPUT FROM DATA BASE:
In every of these tools, you can execute SQL-commands. For my output I chose:
Code:
SELECT a.name , t.title, t.subtitle, t.album, t.subgenre_name, tg.short_datetime, tg.location_name , tg.lat, tg.lon
FROM artist a, artist_track at, track t, tag tg
WHERE a.id = at.artist_id AND at.track_id = t._id AND tg.track_id = t._id ORDER BY tg.timestamp;
This command displays a list of the songs, ordered by their timestamp.
So with the command line tool "sqlite3" you just type in:
sqlite3 -line /tmp/library.db "SELECT a.name , t.title, t.subtitle, t.album, t.subgenre_name, tg.short_datetime, tg.location_name , tg.lat, tg.lon FROM artist a, artist_track at, track t, tag tg WHERE a.id = at.artist_id AND at.track_id = t._id AND tg.track_id = t._id ORDER BY tg.timestamp;"
Click to expand...
Click to collapse
The output is in lines, you could also let put this in a text file by e.g. adding to this command:
"[see above] > shazam-tracks.txt"
Click to expand...
Click to collapse
There is also a way to export the data into an html table (just the table, no complete html file), by changing "-line" for "-html". For further details on how to export everything to a different file format (CVS etc) have a look on the Manpage of sqlite3 (command "man sqlite3").
With the graphical tool "sqlitebrowser" it is imho only possible to show this list, not to export it to a textfile. After having opened the .db-file with the program, you chose the tab "Execute SQL" and put there the above SQL command ("SELECT [...]"). Voilà!
3. DETAILS:
What I do like this is combining the necessary data of the database. They are spread over several tables. There is a table "artist" with the list of the artists and their unique ids. Then there is the same for the tracks, "track". In the "artist_track" table there is listed, which artist's id belongs tho which track's id. Finally in the table "tag" there are additional data like the time stamp of the song and even it's geo data tag.
With the SQLite program you can easily watch all the data and add / remove data from the SQL command, as you wish.
So far, I hope, I could help somebody?
Greetings, spectas
spectas said:
Hi everybody,
I found a solution to export the list via SQLite. I had to find it for myself as I found nothing on the web, but I put it here, so perhaps somebody else is looking for such a solution as well.
This explanation is about how to get Shazam's data base file from your Android phone, access it on your computer and export a list of your tagged songs.
1. COPY FILE FROM PHONE
The data is stored in the file on your Android:
/data/data/com.shazam.android/databases/library.db
You have to copy this file to your Computer to work with it. Probably everybody does this in a different way. Mine was probably a bit more difficult than necessary, there should be simpler ways (e.g. with ssh / scp), but mine was: Opening the Android app "Terminal" and typing in the command:
Code:
cp /data/data/com.shazam.android/databases/library.db /sdcard
Then the file was copyed on the sdcard, which I could access to with my computer via USB cable.
Then you need a program which can open SQLite-Files. There is the command line tool (at least in Linux) "sqlite3", but also graphical tools for Linux/Windows/Mac like the "sqlitebrowser" (Link: sourceforge.net/projects/sqlitebrowser).
2. OUTPUT FROM DATA BASE:
In every of these tools, you can execute SQL-commands. For my output I chose:
Code:
SELECT a.name , t.title, t.subtitle, t.album, t.subgenre_name, tg.short_datetime, tg.location_name , tg.lat, tg.lon
FROM artist a, artist_track at, track t, tag tg
WHERE a.id = at.artist_id AND at.track_id = t._id AND tg.track_id = t._id ORDER BY tg.timestamp;
This command displays a list of the songs, ordered by their timestamp.
So with the command line tool "sqlite3" you just type in:
The output is in lines, you could also let put this in a text file by e.g. adding to this command:
There is also a way to export the data into an html table (just the table, no complete html file), by changing "-line" for "-html". For further details on how to export everything to a different file format (CVS etc) have a look on the Manpage of sqlite3 (command "man sqlite3").
With the graphical tool "sqlitebrowser" it is imho only possible to show this list, not to export it to a textfile. After having opened the .db-file with the program, you chose the tab "Execute SQL" and put there the above SQL command ("SELECT [...]"). Voilà!
3. DETAILS:
What I do like this is combining the necessary data of the database. They are spread over several tables. There is a table "artist" with the list of the artists and their unique ids. Then there is the same for the tracks, "track". In the "artist_track" table there is listed, which artist's id belongs tho which track's id. Finally in the table "tag" there are additional data like the time stamp of the song and even it's geo data tag.
With the SQLite program you can easily watch all the data and add / remove data from the SQL command, as you wish.
So far, I hope, I could help somebody?
Greetings, spectas
Click to expand...
Click to collapse
Thanks!!! It helped me since Shazam no longer gets past the setup screen!
I found that with SQliteExport you can use your same command above and export to a file of your choice, for example, xls or csv. Here's the link to the little program:
http://www.speqmath.com/tutorials/sqlite_export/index.html
Flyview said:
Thanks!!! It helped me since Shazam no longer gets past the setup screen!
I found that with SQliteExport you can use your same command above and export to a file of your choice, for example, xls or csv. Here's the link to the little program:
http://www.speqmath.com/tutorials/sqlite_export/index.html
Click to expand...
Click to collapse
Tried but cant do it. I need step by step instruction. Or better, can someone just export the db that I attached? (See OP - first post - shazam.db ?)
Thanks
K
Best solution for exporting from shazam database
Delete this one please
Hello I am new on the forum. I've learned a lot of things in this website, it's time to payback
I’ve got another solution to this issue….
1.-Download this plugin for Firefox.
addons.mozilla.org/es/firefox/addon/sqlite-manager
2.- In Firefox – Tools, select SQLite Manager
3.- In the new window select database – connect database – then open your db from shazam
4.- Then you’ll see two panels. on left panel select track and on right panel, select browse and search then you’ll be able to see all your tag info
5.- On the left panel select track – right click – export table, select csv on right panel then ok.
6.- Open your new saved database with any office (word, excel)
7.- That’s all
Shazam Tags
snakesight said:
Hello I am new on the forum. I've learned a lot of things in this website, it's time to payback
I’ve got another solution to this issue….
1.-Download this plugin for Firefox.
addons.mozilla.org/es/firefox/addon/sqlite-manager
2.- In Firefox – Tools, select SQLite Manager
3.- In the new window select database – connect database – then open your db from shazam
4.- Then you’ll see two panels. on left panel select track and on right panel, select browse and search then you’ll be able to see all your tag info
5.- On the left panel select track – right click – export table, select csv on right panel then ok.
6.- Open your new saved database with any office (word, excel)
7.- That’s all
Click to expand...
Click to collapse
This above works well nice one.
I was trying to do my own program before I saw this.I'm not a programmer but I stuck together a few bits of code I found and hopefully works you you. Use android app Root Browser Lite to copy file from data/data/com.shazam.android/databases/library.db to your sd card. Or use the app posted earlier which does this for you.
Put library.db file from you Shazam backup in the same folder as this program and run program and hit 'GetTags' and should get CSV and htm versions of your tags. No error checking or anything fancy in this program. Requires .NET 3.5. May only work on 32-bit machines. I'd like to enhance this and will if people find it useful.
How results should look.
Whenever I install new rom, I have to lose all my precious playlists. What's the location of playlist files?
Export Android Created Playlists To PC
hi i have managed to find a way to extract phone made playlist to pc but i am not a programmer and I was wondering if anyone here can automate it
url are not permitted here so my blog is kundaistreet at blogspot
diddy47 said:
hi i have managed to find a way to extract phone made playlist to pc but i am not a programmer and I was wondering if anyone here can automate it
url are not permitted here so my blog is kundaistreet at blogspot
Click to expand...
Click to collapse
So this PlayQ can you import and export (backup/restore) playlists? If so, that's probably what the OP is looking for. Not a way to use his Android playlists on his PC. Although I doubt he wants to buy this Merdian Player in order to export playlists. I suspect it's just data somewhere, but where would be the question.
Has anyone worked out where these are stored?
I have been googling forever and all I read is people
a) Saying where music is stored
b) Saying where m3u files etc... are stored.
It's obvious that the playlists are stored in a database somewhere I just want to know where it is so I can look at it and see what sort of information is stored for songs and playlists.
Android Playlist/s Backup Tutorial
Hi everyone,while playing around with the instructions given by diddy47 on the blog site kundaistreet,I discovered how to backup your playlist on your sd card using a combination of 3 apps from the android market and part of the instructions given by diddy47. Apps required are Androzip,Meridian Player and SDMount,they are all free apps and no purchase required to download.This process seems long but its unreal simple,(1)Dowload all apps as stated above,(2)Go to your android stock player and create a playlist of your liking, if you already have a playlist made then on to the next step,(3)As diddy47 described in first part of post, "desregard the part about export to pc",
"In Meridian Player
•Long press on the playlists you want to export to PC, a pop up menu appears
•Select export to playQ
•choose the appropriate name
•choose audio type
•Export as many playlists as you like using procedure above.Navigate to folder PlayQueues using Androzip,it would be stored on your sd card.
Inside will be all your playlist that you exported to playQ in .mpq format not .m3u" Select any of the created playlist/s created and change the file extention name to "m3u", please note all that is being changed are the words and or numbers after the (dot.) (4)Exit Androzip, proceed by making SDMount a widget on your home screen,select, it would refresh saying in the notification bar "Your SD card has been scanned and remounted, SD Media Remounted" 'please note if you unmount your SD through the settings menu you will have to remove your SD card and put it back into device'.(5)Revert to stock media player,go to playlist and there you should find the name of your playlist/s made.You may see 2 of the same named playlist/s but that proves that it was backed up on the sd card.
Thank you for this opportunity, all credit goes out to kundaistreet for the blog site and diddy47 for his tutorial.
any alternative ?
thx for the solution but , its sad but true , this is a basic function i think it should be here already instead of making us looking for this for hours thru the web.
but isnt there any easier method ? dont want that much of apps just for a simple task (exporing playlist)
Here is what I had to do
I have a Samsung Epic 4g backed up with ClockworkMod, and lost the playlist after installing new ROM. Here is what I had to do to get my playlist back.
Extracted my data.img backup to my PC with unyaffs found here:
Code:
jiggawatt.org/badc0de/android/index.html
I knew my playlist name, so I scanned the extracted files and found it here:
C:\Temp\extraced data.img\data\com.android.providers.media\databases\external-99773e78.db
I then used SQLiteStudio to open external-99773e78.db.
Code:
sqlitestudio.one.pl
Ran the below SQL to generate my playlist.
Code:
select
_data
from
(
select name, _data, play_order
from
(
select
am._data
,ap.name
,apm.play_order
from audio_playlists ap
join audio_playlists_map apm on
ap._id = apm.playlist_id
join audio_meta am on
apm.audio_id = am._id
where ap._data is null
)
union
select name, '#EXTM3U ' || name as _data, -1 as play_order
from
(
select ap.name
from audio_playlists ap
where ap._data is null
)
order by 1,3
)
Exported the result set to a text editor (used PSPad), and created m3u's by copy/paste method. Then moved the m3u files to my SD card. When Android did its media scan it pick up the playlist, but for some reason I can't maintain the play list order. Playlist order was not a priority for me, so I stopped here.
If anyone tries something similar and maintains their playlist order, please post a reply
Thanks
You can backup playlists to .m3u8 files via BlueMuze
Full disclosure: it's my app, but the playlist backup feature is in the free unlimited trial.
Hopefully that's not too promotional -- not trying to run afoul of forum rules here, but I think it's what you're looking for.
alostpacket said:
You can backup playlists to .m3u8 files via BlueMuze
Full disclosure: it's my app, but the playlist backup feature is in the free unlimited trial.
Hopefully that's not too promotional -- not trying to run afoul of forum rules here, but I think it's what you're looking for.
Click to expand...
Click to collapse
That's the proper way to do it. I just ran into a user who decided to pimp his app in a competing app's very first post.
What you did, in my opinion, is just fine; honest and transparent.
Bluemuze is perfect!
1) backup the playlist.
2) open with notepad++
3) replace /sdcard/ with C:\*path to copy of MP3 folder *
4) rename file to .m3u
Done! Very very simple to do.
s0larus said:
Bluemuze is perfect!
1) backup the playlist.
2) open with notepad++
3) replace /sdcard/ with C:\*path to copy of MP3 folder *
4) rename file to .m3u
Done! Very very simple to do.
Click to expand...
Click to collapse
Or use Meridian Player (best media player I've come across) to create a "playQ" playlist. this is an independent file as opposed to a database. there are a few steps involved but you can copy the "play Q" file (which has a .mpq extension) to your computer. this file can then be converted to a .m3u file fairly simply. Use Notepad++ to open the .mpq file.
01. Delete all characters before the first instance of "localAudio id"
02. Replace all (" /><) with (\r\n) without the parenthesis. \r\n moves the text to the next line, make sure to select extended mode
03. replace all (LocalAudio id="/mnt/sdcard/Music/) with (D:\Music\) or wherever the music is
04. replace (&) with (&) - there seems to be an error with the & symbol
05. delete "\Items><\PlayQ>" at the end
Here is a link to the original post from where I got the information. I did have a different experience then what is shown here, but very useful:
http://kundaistreet.blogspot.com/2010/12/export-android-created-playlists-to-pc.html
+1 to alostpacket!
alostpacket said:
You can backup playlists to .m3u8 files via BlueMuze
Full disclosure: it's my app, but the playlist backup feature is in the free unlimited trial.
Hopefully that's not too promotional -- not trying to run afoul of forum rules here, but I think it's what you're looking for.
Click to expand...
Click to collapse
Hey alostpacket! Your app seems perfect for me, only I'm running ICS on my G2 and using the default app Apollo for my music and BlueMuze isn't picking up the playlists I've created. Also BlueMuze crashes whenever I try to view my music from within it. Any advice?
I've found a playlist backup app on the play store
here's link : bit . ly/O9wb8q (can't post links)
Press thanks if I helped you!
import playlist m3u
So let me understand this correcty. There is no way to import playlists from my pc (m3u) and then play them? I have to create on android and back it up????
philipjacobs said:
So let me understand this correcty. There is no way to import playlists from my pc (m3u) and then play them? I have to create on android and back it up????
Click to expand...
Click to collapse
You can find the answer in this thread. Read it:
http://forum.xda-developers.com/showthread.php?p=38841993#post38841993
Or if you want to share your list of songs from your favorite playlists, you can use this app:
https://play.google.com/store/apps/details?id=com.sendmyplaylist
I actually figured out another way. It's a pain but it works fine for me. Thanks!
I managed to download the ebook reader from this link
zune://navigate/?appID=b90a5d54-601d-e011-9264-00237de2db9e
but now I cannot find a way to side load my books. if anyone has any idea please help. if you want I can also upload the xap file.
thank you
Update:
the program is located under Applications/Data/B90A5D54-601D-E011-9264-00237DE2DB9E
I then went to Data/isolatedStore and found the 2 books that came with the program, but when I copy my books they do not appear when I launch the program. Then I downloaded a free book from kobo, through the software, and a new folder "Digital Editions" was created with the book I downloaded.
I copied my books in that folder but still nothing. BUT, when I changed the title of one of my books to the title to the one I downloaded, it appeared in the software under the photo and title of the downloaded book, but opened my book. a small victory but not enough...
BTW it was a epub book, not pdf, I still haven't managed to open pdfs, although this program supports pdf.
in IsolatedStore, there is a file EBookstorage.xml and a EBooksettings.xml that I havent managed to copy to my computer to check what is inside; I believe that the solution lies in there. But maybe not...
for every book there is a corresponding image file, so maybe the only thing needed is the image file of the book cover...
I am using this app on a HD2 NODO rooted (Thanks Yuki) without any other problems.
if anyone can help, I would appreciate it. it will be great to have just one app to read both epub and pdf.
managed to sideload books
jardan said:
I managed to download the ebook reader from this link
zune://navigate/?appID=b90a5d54-601d-e011-9264-00237de2db9e
but now I cannot find a way to side load my books. if anyone has any idea please help. if you want I can also upload the xap file.
thank you
Update:
the program is located under Applications/Data/B90A5D54-601D-E011-9264-00237DE2DB9E
I then went to Data/isolatedStore and found the 2 books that came with the program, but when I copy my books they do not appear when I launch the program. Then I downloaded a free book from kobo, through the software, and a new folder "Digital Editions" was created with the book I downloaded.
I copied my books in that folder but still nothing. BUT, when I changed the title of one of my books to the title to the one I downloaded, it appeared in the software under the photo and title of the downloaded book, but opened my book. a small victory but not enough...
BTW it was a epub book, not pdf, I still haven't managed to open pdfs, although this program supports pdf.
in IsolatedStore, there is a file EBookstorage.xml and a EBooksettings.xml that I havent managed to copy to my computer to check what is inside; I believe that the solution lies in there. But maybe not...
for every book there is a corresponding image file, so maybe the only thing needed is the image file of the book cover...
I am using this app on a HD2 NODO rooted (Thanks Yuki) without any other problems.
if anyone can help, I would appreciate it. it will be great to have just one app to read both epub and pdf.
Click to expand...
Click to collapse
the app uses epub.
you need the epub and the cover image
name the books accordingly.
use isostorespy to access the isolated storage. on the root of the applications youll find the epubs(marked as unknown file, as well as some jpegs of cover art. you also find an xml file - bookstorage.xml
copy bookstorage.xml to pc and add entries for your new book. the epub and cover art must be dumped in the app iso storage root.
edit the xml to include your books... this what i did to mine
<?xml version="1.0" encoding="utf-8"?>
<Books>
<Book>
<ID>6</ID>
<Title>Passion</Title>
<Author>Lauren Kate</Author>
<BookmarkPath>6Bookmark.xml</BookmarkPath>
<ScrapPath>6Scrap.xml</ScrapPath>
<Category>99</Category>
<PurchaseType>0</PurchaseType>
<EPubSize>0</EPubSize>
<KoboContentType>0</KoboContentType>
<KoboContentID>00000006</KoboContentID>
<KoboUserID></KoboUserID>
<KoboUserKey></KoboUserKey>
<ACSMFilePath></ACSMFilePath>
<Publisher>Lauren Kate Books</Publisher>
<CoverImage>Passion.jpg</CoverImage>
<Description></Description>
<FilePath>\Applications\Data\b90a5d54-601d-e011-9264-00237de2db9e\Data\IsolatedStore\Passion.epub</FilePath>
<ISBN>00000006</ISBN>
<ReadStatus>Close</ReadStatus>
<TotalPage>0</TotalPage>
<CurrentReadPage>0</CurrentReadPage>
<LastReadTime>0</LastReadTime>
<IsFavorite>False</IsFavorite>
<ImageUrl />
</Book>
the part above should be merged with the bookstorage.xml
if you notice
id = 6 (because this is the 6th book i add. in the beginning there will be 2 default books so youll start by adding book no3 = id=3
bookmarkpath = (id#)Bookmark.xml ---> example if id is 3 = 3Bookmark.xml
ScrapPath = (id#)Scrap.xml -----> example if id is 3 = 3Scrap.xml
author, publisher and title is self explanatory......
other values leave blank or default as pasted above
this is ****ing unorganized... gonna make a video later... and i hope i can finish coding the uploader soon so that we dont have to do all the ****e above. pardon my french....
thanks. I just saw your answer, sorry for that. I will try it tomorrow. If you finished coding, please tell me. I am really interested in having this program working properly.
thanks
Samsung ebook
I know this is an old thread, but could you post the samsung ebook .xap?
Sounds a lot of effort - try Bookviser
Sent from my HD7 using Board Express
Hi....
I am not sure this is the right forum for this but I would like to know if anyone solved or can tell me how to put my epub books so they show in HTC's Reader.
I live in China and have a little bit of problem to get paperback books I want to read. I got lots of epub books but the reader only shows some of them and not even the same ones that been showing before.
Is there any directory in the phone I should put them? Tried to put some in the directory system/etc because I found the original books there but still not luck.
Would really like to know how to do it. I know epub works so can't be that most be some other thing that I need to do.
Anyway all suggestions and help would be appreciated.
Rainbow86
Put your epub files on your SD card in a directory called "Digital Editions". They will then show up in the HTC Reader application
Rumball said:
Put your epub files on your SD card in a directory called "Digital Editions". They will then show up in the HTC Reader application
Click to expand...
Click to collapse
Mine are in a folder called "eBooks" and the reader app imported them no problem.
Unsure as to if it does a scan of the SD card or if the files need to be in a specifically named folder (either "digital editions" or "eBooks" or perhaps others also)
I have this problem. Let Someone please help
Windows Mobile also makes it possible.
Rumball said:
Put your epub files on your SD card in a directory called "Digital Editions". They will then show up in the HTC Reader application
Click to expand...
Click to collapse
i tried adding various books on my sd card to both the digital edition and the ebooks but the reader didnt read, instead message no application found to open this file?
Is there any way to open an .msg file? Our main website for my job uses .msg files. I download the files to my tablet but it will not open them. Is there a way around this or something to convert these files into something I can open on my tablet?
Thank in advance!
Convert it to a text file or pdf file then open it. Google how to convert msg files.
Or Google android .msg viewer and look at the top several hits. I can't recommend one as I don't do. Msg files but the first hit is a free application with decent ratings so it's worth a try.