Database Info

How can I export my Shazam tagged songs list?

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.

[APP] Instant Upload

This app is to be used to conveniently upload files to your FTP or SFTP server.
The app has a queuing functionality which can be enabled under settings.
Help text (from app):
Instant Up is used to quickly upload any type of file to your server.
FTP settings must be configured before use. To configure, choose Settings in the options menu.
Here is an example, to help you configure.
If you specify file type zip and path myZipFolder, all zip files will be uploaded to myZipFolder.
If you want all file types to be uploaded to the same server directory, specify * in the file type column. This rule will be used for all files not matching any of the other rules.
If no rule exists for the current file type you will be forwarded to an FTP browser to let you select a destination folder.
Start using Instant Up now by, for instance, downloading a file in the web browser and clicking on it in the Downloads section of the browser.
If queueing is enabled in settings, files will not be uploaded instantly, instead you are able to queue up all files that you need to upload. If all files in queue are matching some rule defined, the files will be uploaded to the correct folders depending on the rules. If some file does not match any rule, you will be asked for an upload folder and (NOTE) ALL files in queue will be uploaded to that folder.
Versions
2.2: Free version now supports SFTP as well, and it now has ads. Also fixed a bug of being able to add non-numbers in port field.
2.1.2: Fixed error when trying to upload non-file items
2.1.1
now supports sharing multiple files (e.g. from Gallery)
Fixed bug when trying to share other stuff than files
2.1: now supports sharing (from Gallery app for instance)
2.0.1: support for earlier OS:s (1-6 - 2.1) Prior to this only 2.2 was supported.
2.0: queueing, App2SD, bugfixes
1.0.1: bugfixes
1.0: initial version
QR and links
Since I was not allowed to add links to this forum, you just have to search for Instant Development in the Market.
Feedback
If you see any problems in the app or have any suggestions, please post here. If you like the app please rate and comment it in the market.

I like your sftp app, but could you please add public key authentication?

elmicha said:
I like your sftp app, but could you please add public key authentication?
Click to expand...
Click to collapse
Thanks.
How would you like that to work?

Like in AndFTP or Connectbot. The AndFTP method is a lot simpler than the Connectbot method. I would say that the simpler method is enough:
The user generates a public/private key pair with ssh-keygen or dropbearkey on his server. Then he appends the public key to his ~/.ssh/authorized_keys and copies the private key to the phone. The sftp client can now import that private key and use it.
Probably it would be easier if you would specify a fixed directory and filename where the user should store his private key, e.g. /sdcard/InstantUpload/id_dsa (or id_rsa). If there is a file with that filename, Instant Upload can import the key and store it internally, and then delete the file. That way you don't need a file selection dialog and the user doesn't need to hunt for the file with that dialog.

elmicha said:
Like in AndFTP or Connectbot. The AndFTP method is a lot simpler than the Connectbot method. I would say that the simpler method is enough:
The user generates a public/private key pair with ssh-keygen or dropbearkey on his server. Then he appends the public key to his ~/.ssh/authorized_keys and copies the private key to the phone. The sftp client can now import that private key and use it.
Probably it would be easier if you would specify a fixed directory and filename where the user should store his private key, e.g. /sdcard/InstantUpload/id_dsa (or id_rsa). If there is a file with that filename, Instant Upload can import the key and store it internally, and then delete the file. That way you don't need a file selection dialog and the user doesn't need to hunt for the file with that dialog.
Click to expand...
Click to collapse
Thank you for a very thorough description. I will have a look at it!

Good and thorough work, man. But for what reason? Most of Android file explorers already can interact with FTP.

Corias said:
Good and thorough work, man. But for what reason? Most of Android file explorers already can interact with FTP.
Click to expand...
Click to collapse
Thanks.
The only reason why I started to build this app was that I wanted something that in the fastest way possible let me download any file from the browser and directly upload it to an SFTP server.
I have searched for apps that supported this, but none of them could do this.
With the file explorers you have to do something like the following:
Download file from browser
Close browser
Open File Explorer
Browse to the folder containing the file
Find the file in the folder
Long click the file
Select upload action
Select destination folder
With this app only three steps are required:
Download file from browser
Click on file
Select application (Instant Upload)

New version out. The free version now supports SFTP as well.

Since the market link leads here I assume you did the Spotify Controller app.
I just installed the server on Win7 x64 and...there is a LOT wrong with it.
I actually package software for a living, unless you protest I will probably try to put together a PROPER package for the current version of the server software.
Honestly, using a zip file means everything gets tagged as a download from the internet, which means every batch files prompts (or more usually, just flat out fails when called from a batch files). Using a vbscript to create shortcuts is ok, but the shorcut didn't have the working directory set. It points to the controller.bat in the main directory, which calls controller.bat in the server subdirectory, which is redundant and asking for trouble. The batch files it calls will almost never work on Win7 (even 32 bit) and surprised it works in XP, because it calls %~dp0java but the JRE by default doesn't add itself to the PATH variable so the server fails to start 100% of the time (this can be fixed by finding the path to java.exe and setting the shortcut to call java.exe and then the command line (don't forget to set the working directory to the /server folder or it will vomit). So both those batch files are unnecessary and break easily.
I had to go through the install.bat and change the paths from %~dp0 to hardcoded, again you could probably come up with just about anything OTHER than a batch file and it would work, as opposed to the way it is now which...doesn't...
Also for us US users new to the party the example URI in the installer isn't available in the US so no matter what it's broken, I found a Green Day song (Jesus of Suburbia) that works and appears to be available everywhere.
http://open.spotify.com/track/10lT3pp9QERGOWiIzLx4We
The server is nice, and fast, and for what it is (and the price) works well. Especially for "party mode" of just switching between playlists or "ohhh I really wanna listen to song x right now!"
But the installer as it is...is so broken as to be virtually useless. The only downside to me making a package for this is that everytime you update the software I'd either have to do it again or use something free like, I believe nullsofts installer.

I would highly recommend learning the Nullsoft installer btw, it is free, and can do a LOT better job than batch files. As far as I know (I use a several thousand dollar software suite at work not nullsoft so I'm not too good with nullsoft) it can even do things like execute a command and wait for feedback.

alcaron said:
I would highly recommend learning the Nullsoft installer btw, it is free, and can do a LOT better job than batch files. As far as I know (I use a several thousand dollar software suite at work not nullsoft so I'm not too good with nullsoft) it can even do things like execute a command and wait for feedback.
Click to expand...
Click to collapse
Thank you for your feedback. The packaging thing has been nagging me for a while now.
I know my packaging is poor and I would be very grateful for any help!
I have tried things like Nullsoft before, and I did not do very well.
Is there any chance that you could create a package for Spotify Controller and instruct me on how to keep that package updated when I release future versions?

I'm actually working on a couple scripts right now, because as nice as MSI's are, there isn't a really good free editor, but at least I can maybe give you some scripts that will make it a little more fault tolerant.

This should create your shortcuts.
Code:
Option Explicit
Dim oFSO, oWsh, link, javaLoc, instDir, shstart, shstop, t1, t2
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oWsh = CreateObject("WScript.Shell")
instDir = "C:\Program Files\SpotCon"
t1 = "C:\Program Files (x86)\Java\jre6\bin\java.exe"
t2 = "C:\Program Files\Java\jre6\bin\java.exe"
If oFSO.FileExists(t1) Then
javaLoc = t1
ElseIf oFSO.FileExists(t2) Then
javaLoc = t2
End If
Set shstart = oWsh.CreateShortcut("C:\Users\alcaron\Desktop\Start Server.lnk")
shstart.Arguments = "-jar start.jar jetty.port=1258"
shstart.Description = "Spotify Controller"
shstart.IconLocation = instDir + "\resources\icon.ico,0"
shstart.TargetPath = javaLoc
shstart.WorkingDirectory = "C:\Program Files\SpotCon\server"
shstart.Save
Set shstop = oWsh.CreateShortcut("C:\Users\alcaron\Desktop\Stop Server.lnk")
shstop.Arguments = "/F /fi " + CHR(34) + "IMAGENAME eq java.exe" + Chr(34)
shstop.Description = "Spotify Killer"
shstop.IconLocation = instDir + "\resources\icon_kill.ico,0"
shstop.TargetPath = "C:\Windows\System32\taskkill.exe"
shstop.WorkingDirectory = "C:\Windows\System32"
shstop.Save

The spotifyOpenUri.bat needs to be updated to somehow tell where spotify is installed to. It SHOULD be as simple ad swapping between %programfiles(x86)% and %programfiles%
I hate microsoft for introducing the (x86) directory...whomever did that should be banned from touching computers.
spotify.bat also needs the same modification.
The install.bat is the one that has the most problems. More on that in a second.
Also you can take a zip file capture of your directory and use nullsoft installer to generate an install from that zip file, that gets you around the "tagged as from the internet" issue AND gives you an installer. But it isn't going to give you a shortcut without using a script I don't think.

alcaron said:
The install.bat is the one that has the most problems. More on that in a second.
Click to expand...
Click to collapse
Looking forward to further instructions

alcaron said:
This should create your shortcuts.
Code:
Option Explicit
Dim oFSO, oWsh, link, javaLoc, instDir, shstart, shstop, t1, t2
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oWsh = CreateObject("WScript.Shell")
instDir = "C:\Program Files\SpotCon"
t1 = "C:\Program Files (x86)\Java\jre6\bin\java.exe"
t2 = "C:\Program Files\Java\jre6\bin\java.exe"
If oFSO.FileExists(t1) Then
javaLoc = t1
ElseIf oFSO.FileExists(t2) Then
javaLoc = t2
End If
Set shstart = oWsh.CreateShortcut("C:\Users\alcaron\Desktop\Start Server.lnk")
shstart.Arguments = "-jar start.jar jetty.port=1258"
shstart.Description = "Spotify Controller"
shstart.IconLocation = instDir + "\resources\icon.ico,0"
shstart.TargetPath = javaLoc
shstart.WorkingDirectory = "C:\Program Files\SpotCon\server"
shstart.Save
Set shstop = oWsh.CreateShortcut("C:\Users\alcaron\Desktop\Stop Server.lnk")
shstop.Arguments = "/F /fi " + CHR(34) + "IMAGENAME eq java.exe" + Chr(34)
shstop.Description = "Spotify Killer"
shstop.IconLocation = instDir + "\resources\icon_kill.ico,0"
shstop.TargetPath = "C:\Windows\System32\taskkill.exe"
shstop.WorkingDirectory = "C:\Windows\System32"
shstop.Save
Click to expand...
Click to collapse
I downloaded Nullsoft (http://nsis.sourceforge.net/Main_Page) and tried your code above, but it didn't work at all to compile :-(

Unable to queue up multiple files to sftp from Gallery, only takes 1 file.
Downloaded Instant Upload this evening. Using SFTP to upload from the gallery in my HTC Desire Android phone. Seems to be able to only upload one jpg at a time when I select all. Hope you can get multiple file selections working eventually.
Austin Hook Milk River, Alberta, Canada

AustinHook said:
Downloaded Instant Upload this evening. Using SFTP to upload from the gallery in my HTC Desire Android phone. Seems to be able to only upload one jpg at a time when I select all. Hope you can get multiple file selections working eventually.
Austin Hook Milk River, Alberta, Canada
Click to expand...
Click to collapse
it works,you just have to enable queueing

First-thanks for the app, I'll put my app thoughts in a separate reply.
RE: Packaging apps
I too, in a former existence, was an app packager. It really isn't that hard, at a basic level, but can get some interesting complexities as you progress.
I still use my old Wise Studio to cleanup and customize my own installers/tweaks, etc. It's not great for 7/Vista, but so long as the app is simple it's ok.
There's a free MSI Creator/Editor out there called InstEd - check it out on insted dot com.
Check it out - the "advanced" version is $29.99. I haven't done much with it yet, but for free it's hard to beat.
If you guys want to swap MSI's and VBScripts on this-maybe we should spin up another thread just for the packaging piece.
Oh and I'll vouch for Alcaron's ideas about paths/shortcuts/vbs...you definitely have to be careful about assuming anything. I tend to do a LOT of validation in my scripts and try to fail out gracefully (and log it!), especially if I don't know where the package will be deployed. I log darn near every single line of my scripts - I like to know exactly where it fails.
---------- Post added at 04:28 PM ---------- Previous post was at 04:11 PM ----------
I'm likin' the app so far-makes using my SFTP server much more convenient!
Some ideas for features/mods:
I like the "use queue/add to queue" functionality, but it seems the queue will only process if I then open the app and start the processing. I guess what I'm looking for is a background processing - so I add a file to the queue, and the queue processes in the background so I can then go add more files to it. Along with this idea, maybe a setting (to with enabling queue) where the queue delays starting for a couple minutes.
The rules are a creative approach -I wouldn't have thought of that. Perhaps you can add a "Target Folder" option, with folders that the user pre-defines (similar to how rules are predefined). So when a file is selected for sending with Instant Upload, if you have any Target Folders defined it will popup a list. Otherwise it just goes to the default config.
Just some ideas-bounce them around the users and see what some other people think. They may come up with some interesting twists.
Thanks for the app!

ddback said:
First-thanks for the app, I'll put my app thoughts in a separate reply.
RE: Packaging apps
I too, in a former existence, was an app packager. It really isn't that hard, at a basic level, but can get some interesting complexities as you progress.
I still use my old Wise Studio to cleanup and customize my own installers/tweaks, etc. It's not great for 7/Vista, but so long as the app is simple it's ok.
There's a free MSI Creator/Editor out there called InstEd - check it out on insted dot com.
Check it out - the "advanced" version is $29.99. I haven't done much with it yet, but for free it's hard to beat.
If you guys want to swap MSI's and VBScripts on this-maybe we should spin up another thread just for the packaging piece.
Oh and I'll vouch for Alcaron's ideas about paths/shortcuts/vbs...you definitely have to be careful about assuming anything. I tend to do a LOT of validation in my scripts and try to fail out gracefully (and log it!), especially if I don't know where the package will be deployed. I log darn near every single line of my scripts - I like to know exactly where it fails.
---------- Post added at 04:28 PM ---------- Previous post was at 04:11 PM ----------
I'm likin' the app so far-makes using my SFTP server much more convenient!
Some ideas for features/mods:
I like the "use queue/add to queue" functionality, but it seems the queue will only process if I then open the app and start the processing. I guess what I'm looking for is a background processing - so I add a file to the queue, and the queue processes in the background so I can then go add more files to it. Along with this idea, maybe a setting (to with enabling queue) where the queue delays starting for a couple minutes.
The rules are a creative approach -I wouldn't have thought of that. Perhaps you can add a "Target Folder" option, with folders that the user pre-defines (similar to how rules are predefined). So when a file is selected for sending with Instant Upload, if you have any Target Folders defined it will popup a list. Otherwise it just goes to the default config.
Just some ideas-bounce them around the users and see what some other people think. They may come up with some interesting twists.
Thanks for the app!
Click to expand...
Click to collapse
Interesting with the first part about MSI, is there any chance you could try and make one for the Spotify Controller Server? That would be just awesome!!
Anywho, that discussion should really continue in the Spotify Controller thread, http://forum.xda-developers.com/showthread.php?t=952704 (or a new thread).
About the Instant Upload feature requests. I like the way you are thinking, and I have been thinking in that direction for a while as well. At least with the predefined folders. The background work would mean a bit more work, as I guess I would have to create a service, and I am not sure many people would use such a feature. Do you?

[Q] terminal command "touch ./*" doesn't work; only when I specify a single file

[Q] terminal command "touch ./*" doesn't work; only when I specify a single file
Here's a background of my problem. I copied an audio book from my computer to my phone (galaxy s2 i777 with AOKP jellybean). I import it into BeyondPod to play, but it tries to play the files by date rather than alphanumeric order. Apparently when the files are copied over it isn't done in any kind of order, so the modified dates are all out of order.
I figured an easy solution would be to use a terminal app and just do a
touch ./*
in the proper directories. However, when I try that I get the error
touch: usage: touch [-alm] [-t time_t] <file>
If I specify a single file, or even use wildcards that only match a single file, then touch works properly. Is there an easy way to get it to touch every file without doing each one manually? I tried using two different terminal apps, "Android terminal emulator" and "Terminal IDE", and both had the same problem.
I don't need to use touch of course, any solution wold work so that sorting by modified date matches the alphanumeric order.

bjgood said:
Here's a background of my problem. I copied an audio book from my computer to my phone (galaxy s2 i777 with AOKP jellybean). I import it into BeyondPod to play, but it tries to play the files by date rather than alphanumeric order. Apparently when the files are copied over it isn't done in any kind of order, so the modified dates are all out of order.
I figured an easy solution would be to use a terminal app and just do a
touch ./*
in the proper directories. However, when I try that I get the error
touch: usage: touch [-alm] [-t time_t] <file>
If I specify a single file, or even use wildcards that only match a single file, then touch works properly. Is there an easy way to get it to touch every file without doing each one manually? I tried using two different terminal apps, "Android terminal emulator" and "Terminal IDE", and both had the same problem.
I don't need to use touch of course, any solution wold work so that sorting by modified date matches the alphanumeric order.
Click to expand...
Click to collapse
I was able to work around this by using
find . -exec touch -m {} \;
in case anyone else has this same problem (good luck searching for "touch" relating to cell phones though)

[Q] Sync folder with Foldersync Profile

I would like some more experienced opinions/ideas with a profile I created on Tasker. First of all, I'm on a rooted Verizon Galaxy S4 - SCH-I545 running Goldfinger ROM. I've been using Taker for several months. The new profile that I just created is where, whenever I have Firefox or Chrome download a file, they download to /storage/sdcard0/Download/. I can't change where they download to. Now I have Foldersync that I have sync the files between the location /storage/sdcard0/Download/ and /storage/extSdCard/Downloads/ and then remove the file from the original download path storage/sdcard0/Download/. Now, in Tasker, the profile is:
Context: Event: File Modified --> /storage/sdcard0/Download/
Task: Foldersync: Sync folder pair now. Foldersync's folder pair is /storage/sdcard0/Download/ and /storage/extSdCard/Downloads/.
My problem is this:
Sometimes my download only takes a second and then it syncs. But if the file takes longer than a few seconds, it tries to sync while it's downloading so it moves the partially downloaded file, thus corrupting the file. I know that I can set up Tasker to wait any X number of seconds or minutes before syncing but it's different for every download. Can anyone think of any variables that I can program for this task that will sync the downloaded file(s) but NOT UNTIL the download completes?
I love Tasker but I don't understand enough of programming to come up with Variables or to even understand them.
Edit: If anyone knows how to go about changing the default download path of Chrome and Firefox mobile to /storage/extSdCard/Downloads/ that would be perfect too. Then I wouldn't need this Tasker profile.

Note
Now I know it would make sense to use Foldersync to do a daily sync but a lot of files I download are flashable zips that I want on the extsdcard right then and there so I can go right into recovery and flash it. But what I've been having to do is use ROM Toolbox to manually move the file from internal to external sdcard before booting into recovery. It's a hassle and really annoying though.

Command
Might it be possible to create a script with an app like Scripter to do this task? Maybe even something along the lines like this: When a file is being downloaded with Chrome or Firefox it creates a temp file. Would the creation/removal of that temp file be enough of an event, either with Tasker or an automated script, to trigger the Foldersync task or execute a mv command for the file that was downloaded?

Maybe try Event > UI > Notification > Download Complete
Or something to that effect. After Chrome downloads a file it says download complete in the notification tray. I would imagine some playing around would make it work.

vlamnire said:
Maybe try Event > UI > Notification > Download Complete
Or something to that effect. After Chrome downloads a file it says download complete in the notification tray. I would imagine some playing around would make it work.
Click to expand...
Click to collapse
Thanks for the input. I figured out a different way to do this. I'm using this app to symlink the two download folders. Now I don't even need to use Foldersync or Tasker. Thanks for your help!

Tasker: Help With Task To Daily Download File

Hey Guys -
I hope I've got this in the correct category. If not, please let me know or move...
I love Tasker! I consider myself an intermediate user as I'm no expert, but have made many scripts to automate various tasks - many of them in great detail. There's one that I'm trying to create which I need your assistance with and/or suggestions for the best method, please...
I already have a Profile set up so that when I enter my car the following happens:
- Bluetooth is enabled
- My phone connects to my car's bluetooth
- My morning radio show starts to play in Poweramp
This is great, but I'm having to manually download and copy the MP3 to my phone daily. The functionality I want to add is:
- Every x hours / minutes, my phone connects to an FTP server
- It checks a specific folder for an MP3 file (See Note below)
- If it exists, it downloads & deletes it. If not there, it disconnects and stops the task
- Once downloaded, it moves it to a specified folder located off the root
- The next time I get in my car, I want it to start playing the new file instead of the last one played if possible. I don't care if Poweramp is used as long as it has resume support if there's no new file
Note
Here's a catch - I'll have to use wildcards for both the folder and file name as both have the date of broadcast in their name. Fortunatly, there are other parts of their name which do not change. One option is that I can use wildcards on my FTP server so that each day's folder (+ files) download to a specific folder on the FTP site. This way, I could have the task check for any folder + files to download and not have to be more specific. Also, the only reason I have the "delete" option in there is so that once it downloads, it doesn't try to download it again on the next run.
So what do you suggest? I just bought and downloaded the Tasker plugin "SSHFTPDownUploader," so am going to play with it. If you have any other ideas - even those which may not use Tasker, let me know.
Thanks!

bzowk said:
Hey Guys -
I hope I've got this in the correct category. If not, please let me know or move...
I love Tasker! I consider myself an intermediate user as I'm no expert, but have made many scripts to automate various tasks - many of them in great detail. There's one that I'm trying to create which I need your assistance with and/or suggestions for the best method, please...
I already have a Profile set up so that when I enter my car the following happens:
- Bluetooth is enabled
- My phone connects to my car's bluetooth
- My morning radio show starts to play in Poweramp
This is great, but I'm having to manually download and copy the MP3 to my phone daily. The functionality I want to add is:
- Every x hours / minutes, my phone connects to an FTP server
- It checks a specific folder for an MP3 file (See Note below)
- If it exists, it downloads & deletes it. If not there, it disconnects and stops the task
- Once downloaded, it moves it to a specified folder located off the root
- The next time I get in my car, I want it to start playing the new file instead of the last one played if possible. I don't care if Poweramp is used as long as it has resume support if there's no new file
Note
Here's a catch - I'll have to use wildcards for both the folder and file name as both have the date of broadcast in their name. Fortunatly, there are other parts of their name which do not change. One option is that I can use wildcards on my FTP server so that each day's folder (+ files) download to a specific folder on the FTP site. This way, I could have the task check for any folder + files to download and not have to be more specific. Also, the only reason I have the "delete" option in there is so that once it downloads, it doesn't try to download it again on the next run.
So what do you suggest? I just bought and downloaded the Tasker plugin "SSHFTPDownUploader," so am going to play with it. If you have any other ideas - even those which may not use Tasker, let me know.
Thanks!
Click to expand...
Click to collapse
How does tasker know when you get info your car?
Sent from Galaxy Note 3 SM-N9005