I noticed there isn't a post about epub books on the leo area so thought i mite share a link i found. thank patcat for the links
http://forum.xda-developers.com/showthread.php?t=635947
Converting different format ebooks
Use calibre to convert books, once done there will be a epub format file and a image file. rename the image to the epub name and do a copy of it. rename the copied file and add _thumb to it and then transfer it to the phone or memory card
Adding a cover - In Calibre, right click on the book that you wish to use press edit meta information and then edit meta data individually. There is a option for the program to search for a cover or manually add one. adding one yourself click the printer like book icon in the bottom right hand side and select the picture.
Converting them - select all the files in Calibre, right click - convert ebooks then convert individually. once done just open where you selected them to save to when you installed the program. any problems not finding them go to prefrences and it should be at the top just copy that and paste into my computer or somting.
Copying to SD Cards -
Create a " My Documents " folder
In there create a folder called " Reader "
In Reader Create two folders, once called " Books " and the other " Images "
Put the files into the folders, epub for books and images for their images
Use the Ebook Indexer on patcats post, it will first detect the books on the phone and then on the memory card.
Note the books on the link dont need converting just move to the correct folders. One last thing remember to thank patcat on his post .
sirec said:
I noticed there isn't a post about epub books on the leo area so thought i mite share a link i found. thank patcat for the links
http://forum.xda-developers.com/showthread.php?t=635947
Converting different format ebooks
Use calibre to convert books, once done there will be a epub format file and a image file. rename the image to the epub name and do a copy of it. rename the copied file and add _thumb to it and then transfer it to the phone or memory card
Adding a cover - In Calibre, right click on the book that you wish to use press edit meta information and then edit meta data individually. There is a option for the program to search for a cover or manually add one. adding one yourself click the printer like book icon in the bottom right hand side and select the picture.
Converting them - select all the files in Calibre, right click - convert ebooks then convert individually. once done just open where you selected them to save to when you installed the program. any problems not finding them go to prefrences and it should be at the top just copy that and paste into my computer or somting.
Copying to SD Cards -
Create a " My Documents " folder
In there create a folder called " Reader "
In Reader Create two folders, once called " Books " and the other " Images "
Put the files into the folders, epub for books and images for their images
Use the Ebook Indexer on patcats post, it will first detect the books on the phone and then on the memory card.
Note the books on the link dont need converting just move to the correct folders. One last thing remember to thank patcat on his post .
Click to expand...
Click to collapse
i got a problem with calibre converting pdf files to epub: turkish characters are gone after converting, there are only "?" instead of them... any idea?
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.
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
Dear Skyrocket Community,
I have music stored on my external SD and playlists associated with the music. Is there any way to keep the playlists intact when I switch over to a new rom? I am currently on stock rooted 2.3.6 but will flash Sky ICS once I have an answer to this. Thanks
Mike on XDA said:
Dear Skyrocket Community,
I have music stored on my external SD and playlists associated with the music. Is there any way to keep the playlists intact when I switch over to a new rom? I am currently on stock rooted 2.3.6 but will flash Sky ICS once I have an answer to this. Thanks
Click to expand...
Click to collapse
Generally speaking, the program you used to create playlist has 2 components you can safeguard with a well chosen backup program.
They are the apk that runs the music program, and the program's (user generated) data. Your playlists are in the second category, along with specific settings options you chose.
If you install (an identical or a compatible version of) the same program under a new rom flash, you can then optionally restore the related data you backed up. I would ignore the backed up program and reload it from the Play store, then restore data. This assumes a third party music program as opposed to a cooked in one, which might not be as flexible.
You should have a nandroid anyway, so it might be easy enough to experimentally:
back up the program and data for your music library
add a short new playlist, clear (music) program caches and data
uninstall and reinstall the program
restore the backed up data that includes the extra playlist
If successful, you will know that this worked in your current rom. If ICS changes that, your nandroid resets the whole experiment.
You want to import/export your playlist? That should be easy if you find the file the playlist is stored in. It may just be in simple txt. As a playlist is not actually music, its just a list that states what order you want your music to play in.
An example may be:
sdcard/external sd/music/bobseger_turnthepage.mp3
sdcard/external sd/music/kidrock_cowboy.mp3
etc.
etc.
Thats how most playlists are created and stored. Very simple, small file. Now this post may be completely usless to you as I dont know the file or if for certain thats the senerio. But it is the case in most music players for PC. And its extremely simple so it makes sense. Maybe I pointed you in the right direction to look. I hope so...I dont want to waste your time.
I already flashed the rom , but I have a Nandroid from before. Could I look at the files on my computer and possibly find the playlist and copy it to my SD card?
Sent from my soon to be rooted I727
MyBackup Pro from the market backs up "Music Playlist". I've never had any playlists to back up, so I can't comment on the feature. I can only tell you that it's there.
Sent from my SAMSUNG-SGH-I727 using Tapatalk 2
I just got a gear S3 but am finding it pretty hard to transfer music to it. I have thousands of songs on my phone but they are organized in folders, for instance:
/reggae/*.mp3
/hardrock/*.mp3
etc. etc.
I also have a folder called /favorites that has my top songs - around 100 or so, this is the folder I want to copy to the watch. I can't seem to find a way to select only this folder. When I go into the Gear app I just see a list of thousands of songs grouped by Track/Album/Artist. I can't possibly scroll through the entire list and choose my top 100 songs that are in my favorites. Nor can I go through the time consuming process of searching each song manually.
The whole thing seems rather retarded. Now, I am thinking I need to create a new folder called /s3, then duplicate all my favorites into that folder, then add a "S3_" prefix to all the files there, then transfer those to my phone, choose all files with S3_ prefix, transfer them, then delete it off my phone so I don't have duplicates on my phone. There must be an easier way?
You only need to swype from right to left and you will find a folders list into your mobile phone.
Easy
thanks, that works. I can start playing on my phone first and then control it on my watch so this way I will not upload anything to my watch and use the source as my phone.
So, I am able to use the bezel as well as the arrows to control the previous/next song as well as play/pause the current track. However, it would be nice if I can navigate songs on my phone and choose a specific song by folder directly from my watch. Is there such an app?
Right now I am using Poweramp on my Pixel XL and the watch controls it without issues, I am assuming it just sends a generic play/pause/prev/next command via Bluetooth which any music app understands. I am assuming the ability to navigate a folder structure to a specific song needs to have compatible apps on the phone as well as the watch.