Related
Are there any people also annoyed like me by the large default fontsize ?
I was used to Tytn small font in email, now the smallest setting on Vox is normal, which is too large for me.
Any solution or registry change possible for this ?
yep yep yep
there is s CSS file for die Font Size of SMS and Email ...
\windows\read_style.0409.css
there can you change something ...
here a excemple --> Font Size 7px
Hi dacoon. Thanks for this hint. I was searching for this for long time. Is it possible to tune this way also list of messages in inbox? There is only 5, resp.4 messages per page and too big font for me.
Thanks
No, sorry ... for this i found nothing ...
The CSS file is from ROM and is write protected. How to rewrite / edit it?
djaxdjax said:
The CSS file is from ROM and is write protected. How to rewrite / edit it?
Click to expand...
Click to collapse
I used Total Commander.
You can also transfer the css via Active Sync to the PC. Then remove the write protection and edit the file. Then save it to a different folder and copy it back to the device. That worked fine for me.
Palo_ said:
I used Total Commander.
Click to expand...
Click to collapse
Ya, thx, thats works . Now I go to customize my e-mail client.
Before:
After:
Look into attached txt file, search for "font-size".
djaxdjax said:
Ya, thx, thats works . Now I go to customize my e-mail client.
Click to expand...
Click to collapse
How did you get Total Commander to let you do this? I've been trying and had no luck so far. I've copied the file to a different directory on the phone and the PC, but I'm not having any luck overwriting the original file.
This is on the Cavalier though, but it shouldn't be any different.
Any help would be appreciated
Hi, In Total Commander you can switch into 2 window mode. You can copy and overwrite the css files from one windows to another. Similar as on PC.
djaxdjax said:
Hi, In Total Commander you can switch into 2 window mode. You can copy and overwrite the css files from one windows to another. Similar as on PC.
Click to expand...
Click to collapse
Thanks, but I've tried that.
* I have the new CSS on my memory card.
* Have teh second window set to \Windows
* Select the new css file and go file-copy
* the "copy/move " window comes up and I hit OK
* conirmation window "overwrite: \windows\... with \storage card\..." and I hit "Overwrite"
* "Confirm" windows pops up saying "Cannot ccopy or move file!"
Is there anything I should have done first?
Do you have your Mail application switched off? Look at Task manager. Or turn Off/On phone and try it to copy again.
I've tried that, and still no go. So I need to make some security change?
baralong said:
I've tried that, and still no go. So I need to make some security change?
Click to expand...
Click to collapse
All sorted now, I just needed to app unlock my phone.
Thanks.
Has anyone tried playing with the HTML templates to change the look entirely?
nice
Hi everyone nice tip!!!! But I have 2 question:
if u please post all the read_style files in windows cause I edited everything and I have sone problems.
Second question:
I see the 7pt in sms and email inbox but when I write a sms the font remains bigger than 7 is it possible to change the font when I write a new sms too? Thanx!
pict
here itis the problem
This font hacks look great. Does anyone know how to shrink the fonts being used in the message list view and the folder lists? I find I can only see 4 message headers at a time on Wm6 / Q9.. Horrible use of space. Same with folders list, font is massive. I'm assuming it is one of the dozens of .css files in that windows directory.
@zipreddictive: ... edit the compose_style.(langcode).css ...
@tommytuna: ... it's impossible ... or you found a developer to write a new app for this
Hi - I edited the compose style and now the new message fonts look good to. Still can't figure out how to get the message list to tighten up. Argghh.. So useless with 4 messages at a time when you can easily get 6-7 with tightening up that screen.
Hi,
This forum helped me to decide on getting an O2 Orbit 2, so thanks for that..
I have searched for this but haven;t found a solution but forgive me if I am repeating a thread.
I am trying to find a way to add a shortcut to the Today screen that directly opens up a new SMS. At the moment I have to go to messaging>SMS>Menu>New>SMS, which seems very convulted, having come from a standard phone.
Is there any way to do this at all?
new_orbit said:
Hi,
This forum helped me to decide on getting an O2 Orbit 2, so thanks for that..
I have searched for this but haven;t found a solution but forgive me if I am repeating a thread.
I am trying to find a way to add a shortcut to the Today screen that directly opens up a new SMS. At the moment I have to go to messaging>SMS>Menu>New>SMS, which seems very convulted, having come from a standard phone.
Is there any way to do this at all?
Click to expand...
Click to collapse
Try these. I'm not sure about a today plugin. But these cab's create a shortcut for you in \Windows called New SMS.lnk. You could always copy them to your start menu and uninstall the CAB if you dont want to lose a softkey.
http://forum.xda-developers.com/showpost.php?p=2287306&postcount=6
Ta
Dave
DaveShaw said:
Try these. I'm not sure about a today plugin. But these cab's create a shortcut for you in \Windows called New SMS.lnk. You could always copy them to your start menu and uninstall the CAB if you dont want to lose a softkey.
http://forum.xda-developers.com/showpost.php?p=2287306&postcount=6
Ta
Dave
Click to expand...
Click to collapse
Thanks. Tried them both and the left one just changed the name of the soft key but still pointed to the calendar and the right one changed it to got the route of the SMS directory not to a new SMS message. I uninstalled them but the right one still stays the same
Any way of getting it back to the contacts?
new_orbit said:
Thanks. Tried them both and the left one just changed the name of the soft key but still pointed to the calendar and the right one changed it to got the route of the SMS directory not to a new SMS message. I uninstalled them but the right one still stays the same
Any way of getting it back to the contacts?
Click to expand...
Click to collapse
Just un-install the CAB.
It might depend on the messaging software.
The shortcut should point to "\Windows\tmail.exe" -service "SMS"
Ta
Dave
DaveShaw said:
Just un-install the CAB.
It might depend on the messaging software.
The shortcut should point to "\Windows\tmail.exe" -service "SMS"
Ta
Dave
Click to expand...
Click to collapse
I did unistall the CAB and it didn't do anything, just removed itself from the Remove Programs bit. The shortcut is no longer there either, so I cannot check it.
Having looked at your CAB file presumably all I need to change it to calendar is find a registry editor and change the settings your CAB made back to "Calendar" and the correct shortcut?
new_orbit said:
I did unistall the CAB and it didn't do anything, just removed itself from the Remove Programs bit. The shortcut is no longer there either, so I cannot check it.
Having looked at your CAB file presumably all I need to change it to calendar is find a registry editor and change the settings your CAB made back to "Calendar" and the correct shortcut?
Click to expand...
Click to collapse
There is a "Softkey changer" app, or a program by schaps called "Advanced Config" both of those will save on the Reg hacking.
Ta
Dave
The Solution.....
Install the attachment...
You can place a shortcut to "NEW SMS" on your left or right softkey....
PS: Next time search or follow the link on my sign....
Sorted
Hi Guys,
Thanks to both of you for your quick replies and help. I have created a working New SMS on my today screen using the last app and the o2 shortcuts program that comes with the mobile.
Knew this was the right place to come!
PS: I did search and nothing useful came up...
PPS: I also couldn't have read your link on the sign as it is posted in the area that says to not post unless you are a developer or hardcore tecchie. I am neither and so didn't go there. Thanks for the help though.
Over a year later and the information in this thread has proved invaluable for me. Thanks.
The correct solution to directly compose a new SMS with a shortcut is the following:
tmail.exe -transport "SMS" -to ""
Works great on my Tilt2. However, I do think I used the syntax above posted by DaveShaw with a prior WinMo device and it worked. However, it does not work on my Tilt2.
You can also get a lot more complicated such as:
Creating new MMS with given recipients, subject, body and attachment:
tmail.exe -transport "MMS" -to "8005551212" -cc "8001234567" -bcc "[email protected]" -subject "simple subject" -body "simple MMS body" -attach "/My Documents/test.jpg"
Anyone know how to turn these into executables since my today launcher only accepts exe's?
If You haven't got a reply to that yet... You can make a simple mortscript (like runmms.mscr) with Run (tmail.exe etc...) and then have the mortsript dummy.exe renamed to the same runmms.exe which, when executed, results in the desired action.
I cannot for the life of me figure out where the setting is to change the text on your tf3d tabs. Out of the box my AT&T Fuze says "email" for the touchflo email tab, I would like it to say "Email".
Sorry if this has been posted already but I searched.
killer2001 said:
I cannot for the life of me figure out where the setting is to change the text on your tf3d tabs. Out of the box my AT&T Fuze says "email" for the touchflo email tab, I would like it to say "Email".
Sorry if this has been posted already but I searched.
Click to expand...
Click to collapse
It can be done by editing the 26948339_manila file in windows... If you have no clue what you are doing I suggest you get over you OCD as messing with this file in the wrong way can mess up tf3d.
Detailed instructions on how to accomplish this would be most appreciated... I couldn't find the file in the windows folder in my File Explorer (im assuming its hidden). What programs do I need to install and what steps need to be taken in order to successfully edit this value?
Thanks.
rymonday said:
It can be done by editing the 26948339_manila file in windows... If you have no clue what you are doing I suggest you get over you OCD as messing with this file in the wrong way can mess up tf3d.
Click to expand...
Click to collapse
It can also be done by editing 090661f7_manila, which is where the names for all the tabs are defined. Find the line that says:
<trans-unit id="IDS_EMAILTITLE">
and edit the line under it to say:
<source>Email</source> [instead of <source>email</source>]
and then re-start TF3D. Like rymonday said, though, you can really screw stuff up if you mess up an edit in one of these files so do so at your own risk!
Would I edit the manila file on my PC with Notepad? Then replace it on my phone and change the properties with Total Commander or is there another way?
Anyone want to chime in on how to properly edit this file?
killer2001 said:
Anyone want to chime in on how to properly edit this file?
Click to expand...
Click to collapse
* Disable TouchFLO from Settings>Today>Items
* Use Total Commander (http://forum.xda-developers.com/showthread.php?p=2286376) and find the "090661f7_manila" file. Change the attributes (remove Read Only flag - have to tap twice to get rid of the "ghosted" checkmark). Click OK to save the file changes.
* Then edit the file as ITNV posted (again, with Total Commander)
Find the line that says:
<trans-unit id="IDS_EMAILTITLE">
and edit the line under it to say:
<source>Email</source> [instead of <source>email</source>]
and then re-start TF3D.
Click to expand...
Click to collapse
Worked perfectly for me.
Thx guys!
Perfect! Thank you everyone!
I have been wanting to add folders for some time to my quicklinks. I researched and researched.
I came across this thread:
http://forum.xda-developers.com/showthread.php?t=576232
However it only dealt with a few categories.
So I have created new .lnk files and asscociated them with .png folder icons and created the necessary registry files.
This will work if you have 9, 12 or 16 Quick Links. For 20 Quick Links I think it will still work but you have to assign the Quick Links yourself.
Just unzip the attached file, read the read me and copy the Programs Folder to your phone and inport the enclosed registry entry too. Reset.
great idea! i wondered why 20 quicklinks are enough for all people here. i just have installed a few apps and games and my quicklink bar is full!
are you going to make the quicklinks for the 20 icon bar?
Great work, thanks.
fruchtfliege said:
great idea! i wondered why 20 quicklinks are enough for all people here. i just have installed a few apps and games and my quicklink bar is full!
are you going to make the quicklinks for the 20 icon bar?
Click to expand...
Click to collapse
If 25 links is enough for you? See this thread, from the same guy who created the 20 links on Home tab.
thanks, i've already seen the 25 link thread! i think it will be more flexible with folder links to group games etc. but maybe i'm going to use both tweaks:
normal links for most important apps and folder links for games, system information and so on...
tboy2000 said:
I have been wanting to add folders for some time to my quicklinks. I researched and researched.
I came across this thread:
http://forum.xda-developers.com/showthread.php?t=576232
However it only dealt with a few categories.
So I have created new .lnk files and asscociated them with .png folder icons and created the necessary registry files.
This will work if you have 9, 12 or 16 Quick Links. For 20 Quick Links I think it will still work but you have to assign the Quick Links yourself.
Just unzip the attached file, read the read me and copy the Programs Folder to your phone and inport the enclosed registry entry too. Reset.
Click to expand...
Click to collapse
Bit of a noob question but why can't you just create links to the default folders and then run these. I tried this but it always says fails to open "games application".
tboy2000 said:
I have been wanting to add folders for some time to my quicklinks. I researched and researched.
I came across this thread:
http://forum.xda-developers.com/showthread.php?t=576232
However it only dealt with a few categories.
So I have created new .lnk files and asscociated them with .png folder icons and created the necessary registry files.
This will work if you have 9, 12 or 16 Quick Links. For 20 Quick Links I think it will still work but you have to assign the Quick Links yourself.
Just unzip the attached file, read the read me and copy the Programs Folder to your phone and inport the enclosed registry entry too. Reset.
Click to expand...
Click to collapse
Just to add to my last, I have an HD with 2.5.1922011 Nrgz ROM but can't seem to import the registry settings. Have used TRE and it states that registry import was successful but to no avail. I have tried hand modifying the entries but still not working. Am I missing something???
Not working
Changed the registry to my portuguese ROM and nothing!
Maybe this only works on WWE roms because of the registry names. If importing the registry does not work for you, try just adding the folders manually to your quick links in the normal way you would add apps. just look fit the folder.link file in the list. let me know.
tboy2000 said:
Maybe this only works on WWE roms because of the registry names. If importing the registry does not work for you, try just adding the folders manually to your quick links in the normal way you would add apps. just look fit the folder.link file in the list. let me know.
Click to expand...
Click to collapse
Hi, in attach is an export of my regfile.
I have put in "sistema" the system.lnk and system.png and renamed it to Portuguese: sistema.lnk and sistema.png
Even so when i click in the home tab in icon (that shows your png file) it says,
" Its not possible to open the file "sistema". Or is not signed with a certificate or cannot find the components.
Thnaks
toyjeep said:
Hi, in attach is an export of my regfile.
I have put in "sistema" the system.lnk and system.png and renamed it to Portuguese: sistema.lnk and sistema.png
Even so when i click in the home tab in icon (that shows your png file) it says,
" Its not possible to open the file "sistema". Or is not signed with a certificate or cannot find the components.
Thnaks
Click to expand...
Click to collapse
This is exactly what happens to me and my ROM is WWE. I can link the folder but it will not open. Tried manually editing the registry but without success. There must be another step but for the life of me I can't figure it out and it's driving me crazy!! This should be simple but HTC make it extremely difficult.
sandymac said:
This is exactly what happens to me and my ROM is WWE. I can link the folder but it will not open. Tried manually editing the registry but without success. There must be another step but for the life of me I can't figure it out and it's driving me crazy!! This should be simple but HTC make it extremely difficult.
Click to expand...
Click to collapse
Bump. Has anyone actually succeeded in doing as instructed and managed to create quick links with folders?
16 Shortcuts...for 25!!
Hi,
i am newbie with my HD2. I did the steps for 16 Short cuts, but it didn't worked out as it should because i have 25 Quick links. Now i have nice folder icons in my Quick links but they don't work!!
Could some one help me with a more detailed how to!!!!
Thanks in adv.
foka
another approach
Hi!
I had the very same problem.
The recommendations given here, I use too, but I remembered a small program usually used for maintaining a directory organisation with PortableApps on the PC. It just uses its own name (like 'games.exe') extracts the '.exe' out of it and opens the reaining 'games' as a directory. I found this was a brute, but very useful solution to the problem. So finally I did that app for mobile devices on my own. It is written in C#. Prerequisites are compact framework 3.5.
In my opinion its only drawback is, that it uses the file-explorer as a platform to view the directory. I would like the HTC view with icons more, but I don't know, how to call the required code to do so.
Personally I have installed 4 instances of the program (240kb) on the storage-card and created the links to them in the startmenu-folder. This works fine with directlinks.
Note: Only subfolders in /windows/startmenu/programs are opened! For other needs the source code is easily changeable.
Here comes a short description:
----------------------------------------------------------------
Prerequisites: Microsoft Compact Framework 3.5.
Install and usage description:
MobDir.Cab installs the file MobDir.exe into your 'prorams' directory.
Since MobDir reads in its very own name to function, it is of utmost importance to RENAME MobDir.exe to a directory name, that fits for your environment!
MobDir starts a File-Explorer directly in a directory that resides in your /windows/start menu/programs
directory.
e.g.: There is a dir called 'games' in your 'programs' directory of 'start menu', that contains all the links to your games on the device. Rename MobDir.Exe accordingly into 'games.exe'. If the program is already installed in your 'start menu/programs' directory, there is not much more to do for you. Simply select games.exe in your directlinks. There you have a directory-icon labeled 'games' then which, when clicked, opens the file-explorer in your games directory. If games.exe resides on your starage card, you have to create a games.lnk into the 'start menu/programs' directory first.
Of course, if you have more subdirectories in your 'start menu/programs' folder, which is most likely the case ('apps', 'tools' for instance), just copy the file MobDir.Exe under these names to your device. In this example as apps.exe and tools.exe. The rest is the same as written beforehand.
Sounds more complicated as it is, just try it, it's simple.
Note: The way it works can be followed by watching the source code. It first reads in its own filename (e.g.: 'games.exe'). Then it extracts the '.exe' out of the name (leaving a 'games'). Right after it looks for your current localized '/windows/start menu/programs/' path and adds the string to it, which we extracted beforehand. So we have a path 'windows/start menu/programs/games'. Finally the file-explorer is called with that path as a parameter.
-----------------------------------------------------------
Here is the source-code:
Code:
using System;
namespace MobDir
{
static class Program
{
[MTAThread]
static void Main()
{
string cFileNameSelf="Use this Base-Code as a sample. Written in '2010 bei D.Bos";
try
{
//read out own filename and strip out ".EXE"
cFileNameSelf = AppDomain.CurrentDomain.FriendlyName.ToUpper().Replace(".EXE", "");
//start File-Explorer, given the path to /windows/startmenu/programs/ + <NameSelf>
System.Diagnostics.Process p = System.Diagnostics.Process.Start("fexplore.exe", ReadSpecialFolder("Programs") + "\\" + cFileNameSelf + "\\");
p.WaitForExit();
}
catch (System.Exception e)
{
System.Windows.Forms.MessageBox.Show("Problem with <" + cFileNameSelf + ">!\n" + e.Message);
}
}
public static string ReadSpecialFolder(string cVarName)
{
return Environment.GetFolderPath((Environment.SpecialFolder)Enum.Parse(typeof(Environment.SpecialFolder), cVarName, true));
}
}
}
-----------------------------------------------------------
And finally: The file MobDir.Cab is attached to this posting.
Hopefully you can make some use of it.
Dietmar
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.