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?
Related
Before formatting my TD2 I made a full backup.
Now I want to transfer my Shazam tagged songs list back.
Simple copy paste from the backup is not working.
Where Shazam is keeping the list of tagged songs?
How do I export that list?
__________
Update: found it!
Can someone please open this attached shazam.db (from shazam for wm 6.5 ) and return the song list , date and time in some other format? xls, cvs etc.
Thanks!
Update:
Shazam.db file in aplication data\shazam\folder is where all tags are stored.
Did you have any luck with this? I was hoping to do the same thing, but I hit a wall when I realized that I don't know how to access files on my Droid's internal storage. Would you mind pointing me in the right direction?
Found nothing so far.
Anyone?
Incorrect....
Either the htc hero has a different file structure or this information is inaccurate....
There is no such file path.
I whipped a quick app (attached below) that can back up the shazam database file to your SDCard (in folder "shazambackup") and restores it need be.
Also you can export the Tagged songs to xml (saved as "exports.xml" in the "shazambackup" folder).
Next i'll probably parse the xml to a more readable format. Maybe CSV? or just Plain Text? Any ideas are welcome!
Let me know if you have any issues. So far i've only tested it on my G1. Must also have a rooted phone for any of this to work.
Can you please open this shazam.db (from wp6.5) and return the song list , date and time in some other format? xls, cvs etc.
Thanks!
bump.
Anyone can help?
See first post.
You're dealing with mostly Android here, you may want to ask in a WM or phone specific forum.
(from... Evo/MIUI/Tapatalk)
kokenjr said:
I whipped a quick app (attached below) that can back up the shazam database file to your SDCard (in folder "shazambackup") and restores it need be.
Also you can export the Tagged songs to xml (saved as "exports.xml" in the "shazambackup" folder).
Next i'll probably parse the xml to a more readable format. Maybe CSV? or just Plain Text? Any ideas are welcome!
Let me know if you have any issues. So far i've only tested it on my G1. Must also have a rooted phone for any of this to work.
Click to expand...
Click to collapse
Does not work properly on Desire. Opens the app after installation but "backup" button does not create the backup file and "Export to XML" makes the app force close without exporting anything.
About the export feature - the CSV version would probably be the best.
Thanks!
p666nn said:
About the export feature - the CSV version would probably be the best.
Thanks!
Click to expand...
Click to collapse
Can you or someone please export attached shazam.db (zip) in any other usable format?
Thanks!
Bumb!
BUMP!!!!!!
CSV would be great
The app's export to xml feature also fails on HTC Evo 4G (GingerBread).
Solution with SQLite
Hi everybody,
I found a solution to export the list via SQLite. I had to find it for myself as I found nothing on the web, but I put it here, so perhaps somebody else is looking for such a solution as well.
This explanation is about how to get Shazam's data base file from your Android phone, access it on your computer and export a list of your tagged songs.
1. COPY FILE FROM PHONE
The data is stored in the file on your Android:
/data/data/com.shazam.android/databases/library.db
You have to copy this file to your Computer to work with it. Probably everybody does this in a different way. Mine was probably a bit more difficult than necessary, there should be simpler ways (e.g. with ssh / scp), but mine was: Opening the Android app "Terminal" and typing in the command:
Code:
cp /data/data/com.shazam.android/databases/library.db /sdcard
Then the file was copyed on the sdcard, which I could access to with my computer via USB cable.
Then you need a program which can open SQLite-Files. There is the command line tool (at least in Linux) "sqlite3", but also graphical tools for Linux/Windows/Mac like the "sqlitebrowser" (Link: sourceforge.net/projects/sqlitebrowser).
2. OUTPUT FROM DATA BASE:
In every of these tools, you can execute SQL-commands. For my output I chose:
Code:
SELECT a.name , t.title, t.subtitle, t.album, t.subgenre_name, tg.short_datetime, tg.location_name , tg.lat, tg.lon
FROM artist a, artist_track at, track t, tag tg
WHERE a.id = at.artist_id AND at.track_id = t._id AND tg.track_id = t._id ORDER BY tg.timestamp;
This command displays a list of the songs, ordered by their timestamp.
So with the command line tool "sqlite3" you just type in:
sqlite3 -line /tmp/library.db "SELECT a.name , t.title, t.subtitle, t.album, t.subgenre_name, tg.short_datetime, tg.location_name , tg.lat, tg.lon FROM artist a, artist_track at, track t, tag tg WHERE a.id = at.artist_id AND at.track_id = t._id AND tg.track_id = t._id ORDER BY tg.timestamp;"
Click to expand...
Click to collapse
The output is in lines, you could also let put this in a text file by e.g. adding to this command:
"[see above] > shazam-tracks.txt"
Click to expand...
Click to collapse
There is also a way to export the data into an html table (just the table, no complete html file), by changing "-line" for "-html". For further details on how to export everything to a different file format (CVS etc) have a look on the Manpage of sqlite3 (command "man sqlite3").
With the graphical tool "sqlitebrowser" it is imho only possible to show this list, not to export it to a textfile. After having opened the .db-file with the program, you chose the tab "Execute SQL" and put there the above SQL command ("SELECT [...]"). Voilà!
3. DETAILS:
What I do like this is combining the necessary data of the database. They are spread over several tables. There is a table "artist" with the list of the artists and their unique ids. Then there is the same for the tracks, "track". In the "artist_track" table there is listed, which artist's id belongs tho which track's id. Finally in the table "tag" there are additional data like the time stamp of the song and even it's geo data tag.
With the SQLite program you can easily watch all the data and add / remove data from the SQL command, as you wish.
So far, I hope, I could help somebody?
Greetings, spectas
spectas said:
Hi everybody,
I found a solution to export the list via SQLite. I had to find it for myself as I found nothing on the web, but I put it here, so perhaps somebody else is looking for such a solution as well.
This explanation is about how to get Shazam's data base file from your Android phone, access it on your computer and export a list of your tagged songs.
1. COPY FILE FROM PHONE
The data is stored in the file on your Android:
/data/data/com.shazam.android/databases/library.db
You have to copy this file to your Computer to work with it. Probably everybody does this in a different way. Mine was probably a bit more difficult than necessary, there should be simpler ways (e.g. with ssh / scp), but mine was: Opening the Android app "Terminal" and typing in the command:
Code:
cp /data/data/com.shazam.android/databases/library.db /sdcard
Then the file was copyed on the sdcard, which I could access to with my computer via USB cable.
Then you need a program which can open SQLite-Files. There is the command line tool (at least in Linux) "sqlite3", but also graphical tools for Linux/Windows/Mac like the "sqlitebrowser" (Link: sourceforge.net/projects/sqlitebrowser).
2. OUTPUT FROM DATA BASE:
In every of these tools, you can execute SQL-commands. For my output I chose:
Code:
SELECT a.name , t.title, t.subtitle, t.album, t.subgenre_name, tg.short_datetime, tg.location_name , tg.lat, tg.lon
FROM artist a, artist_track at, track t, tag tg
WHERE a.id = at.artist_id AND at.track_id = t._id AND tg.track_id = t._id ORDER BY tg.timestamp;
This command displays a list of the songs, ordered by their timestamp.
So with the command line tool "sqlite3" you just type in:
The output is in lines, you could also let put this in a text file by e.g. adding to this command:
There is also a way to export the data into an html table (just the table, no complete html file), by changing "-line" for "-html". For further details on how to export everything to a different file format (CVS etc) have a look on the Manpage of sqlite3 (command "man sqlite3").
With the graphical tool "sqlitebrowser" it is imho only possible to show this list, not to export it to a textfile. After having opened the .db-file with the program, you chose the tab "Execute SQL" and put there the above SQL command ("SELECT [...]"). Voilà!
3. DETAILS:
What I do like this is combining the necessary data of the database. They are spread over several tables. There is a table "artist" with the list of the artists and their unique ids. Then there is the same for the tracks, "track". In the "artist_track" table there is listed, which artist's id belongs tho which track's id. Finally in the table "tag" there are additional data like the time stamp of the song and even it's geo data tag.
With the SQLite program you can easily watch all the data and add / remove data from the SQL command, as you wish.
So far, I hope, I could help somebody?
Greetings, spectas
Click to expand...
Click to collapse
Thanks!!! It helped me since Shazam no longer gets past the setup screen!
I found that with SQliteExport you can use your same command above and export to a file of your choice, for example, xls or csv. Here's the link to the little program:
http://www.speqmath.com/tutorials/sqlite_export/index.html
Flyview said:
Thanks!!! It helped me since Shazam no longer gets past the setup screen!
I found that with SQliteExport you can use your same command above and export to a file of your choice, for example, xls or csv. Here's the link to the little program:
http://www.speqmath.com/tutorials/sqlite_export/index.html
Click to expand...
Click to collapse
Tried but cant do it. I need step by step instruction. Or better, can someone just export the db that I attached? (See OP - first post - shazam.db ?)
Thanks
K
Best solution for exporting from shazam database
Delete this one please
Hello I am new on the forum. I've learned a lot of things in this website, it's time to payback
I’ve got another solution to this issue….
1.-Download this plugin for Firefox.
addons.mozilla.org/es/firefox/addon/sqlite-manager
2.- In Firefox – Tools, select SQLite Manager
3.- In the new window select database – connect database – then open your db from shazam
4.- Then you’ll see two panels. on left panel select track and on right panel, select browse and search then you’ll be able to see all your tag info
5.- On the left panel select track – right click – export table, select csv on right panel then ok.
6.- Open your new saved database with any office (word, excel)
7.- That’s all
Shazam Tags
snakesight said:
Hello I am new on the forum. I've learned a lot of things in this website, it's time to payback
I’ve got another solution to this issue….
1.-Download this plugin for Firefox.
addons.mozilla.org/es/firefox/addon/sqlite-manager
2.- In Firefox – Tools, select SQLite Manager
3.- In the new window select database – connect database – then open your db from shazam
4.- Then you’ll see two panels. on left panel select track and on right panel, select browse and search then you’ll be able to see all your tag info
5.- On the left panel select track – right click – export table, select csv on right panel then ok.
6.- Open your new saved database with any office (word, excel)
7.- That’s all
Click to expand...
Click to collapse
This above works well nice one.
I was trying to do my own program before I saw this.I'm not a programmer but I stuck together a few bits of code I found and hopefully works you you. Use android app Root Browser Lite to copy file from data/data/com.shazam.android/databases/library.db to your sd card. Or use the app posted earlier which does this for you.
Put library.db file from you Shazam backup in the same folder as this program and run program and hit 'GetTags' and should get CSV and htm versions of your tags. No error checking or anything fancy in this program. Requires .NET 3.5. May only work on 32-bit machines. I'd like to enhance this and will if people find it useful.
How results should look.
Hi guys!
This is a quick tool I jotted together for myself in the past couple days and found it very useful. So I decided to clean it up and share it. Hope you will like it! Do comment and ask!
APK Batch Rename Tool
* for Windows and Linux for now.
APK Batch Rename Tool recursively crawls input folder and all of its subfolders looking for Android Package files (.apk's). It reads Label and Version info from apk's found and creates a copy for each apk under the output folder but using the Label and Version info acquired.
For example a com.example.hw.apk will make Hello World! 1.21.apk provided that the label inside the package was set to Hello World! and version is 1.21.
The old and the new apk files are 100% the same in terms of content and are unchanged. Only the new copies are given new filenames. Input files are left completely intact.
Why?
Have you ever wondered what are your 1500+ apk files with wierd names nested to different wierd folders on your harddrive? Have you ever wanted to find an app but you were unable to because it had some undescriptive javaish name that made no sense reflected no version and your apps were swept across a hundred junk folders anyway? Then APK Batch Rename is the tool for you! And me!
APK Batch Rename will set a human readable name for all your Android apps, and drop such a copy into a folder. You will finally be able to browse them, sort them alphabetically and be able to pick from versions available.
How?
1. Copy all your apk files (or folders with apk files in them) into the input folder. You may copy folders of any depth. APK Batch Rename Tool will recurse all subfolders of the input folder anyway.
2. Hit or click ApkBatchRename.bat . (For Linux users it's: apkbatchrename, or on a terminal enter: ./apkbatchrename ) Wait until it finishes the job.
3. Find your freshly named files in the output folder.
Simple as that!
Have fun! & Comment!
phsorx
great work, just like reading mp3 tag then rename to "song - artist.mp3"
thanks!
Cool. I use to do it manually. Time saver app.
Thanks.
This is awesome! Thank you very much, situation you described in first post is just like mine, I find your tool very useful!
Folks,
Let me join you crediting phsorx's job, that app is just great!
Thanks and congrats!
Very cool, Works well. Always wanted to do this but was too lazy to try aapt.
I just checked:
aapt said:
badging Print the label and icon for the app declared in APK.
Click to expand...
Click to collapse
Code:
> aapt d badging Talk.apk
[B]package: name='com.google.android.talk' [/B]versionCode='130' [B]versionName[/B]='1.3'
sdkVersion:'8'
targetSdkVersion:'8'
uses-permission: **truncated***
application: [B]label='Talk'[/B] icon='res/drawable-hdpi/ic_launcher_google_talk.png'
uses-feature:'android.hardware.touchscreen'
main
other-activities
search
other-receivers
supports-screens: 'small' 'normal' 'large'
locales: '--_--' 'es' 'es_US'
densities: '160' '240'
I'll definitely use your script but with a small change to show the package name as well as its valuable for when you need to uninstall the package.
i.e label_packagename(version).apk -> Talk_com.google.android.talk(1.3).apk
Attached a slightly modified batch file and screenshot
For single file one-off renames (right-click->open with->rename single) you can use the script here.
De jo! Honfitars. Hajra Magyarok!
Customizable naming planned in future version
britoso said:
Very cool, Works well. Always wanted to do this but was too lazy to try appt.
i.e label_packagename(version).apk -> Talk_com.google.android.talk(1.3).apk
Click to expand...
Click to collapse
Hi Britoso,
Yeah! That's a neat way to do it too!
Eventually I want to make naming and spacing fully customizable! Including what attributes to pick (name, label, versionName) to constitute the filename, and what separators (_,-,(,),space) should go where.
In the howto.txt I have a little road-map for the project. Will add customizable naming too.
Will keep you guys posted.
EOF
phsorx
Ps: Anyone who has another naming suggestion drop a post! I'd be interested.
great job...bravo..
thanks
Very nice tool, thanks for sharing this .
Using it with britoso's edited script.
Edit: I would appreciate it if a log of the conversion would be saved in a \logs\ subfolder, so I can check which files were not converted properly and see if I have to do those manually.
Handy ! Thanks...
deleted
For one-off renames you can use the below batch file.
1) create the below batch file in the same folder as apkrename.bat (its attached too)
Name: rename-single.bat (change this if you want)
content:
Code:
cd "C:\change_me\ApkRename\"
apkrename.bat %1 %~dp1
Change the path(change_me) as needed.
2)Associate it with apks by right clicking on the apk and choosing "choose default program", browse and select the batch file "rename-single.bat".
Uncheck "make this the default operation"
Screenshot and batch file attached. Enjoy.
update:
-12/8 uploaded a new version that fixed a bug involving long path names with spaces.
Also added a check for success and then delete the original apk. (backup your apks just in case).
Remember to set the path to the ApkRename folder in rename_single.bat once before using it.
Really gd job )
APK Batch Rename Tool for Linux is on the way
luvgirl12345 said:
would like a linux version...
Click to expand...
Click to collapse
Hi luvgirl12345,
The Linux port is on the way & will be posted here soon!
Actually, the Windows release is running on win32 ports of a few common Linux tools. And that's so, because I am lazy. Having Linux's much better support for shell scripting plus the same tool set always at hand, porting is a breeze.
Ciao,
phsorx
Sounds very useful, thank you!
Looks nice for massive apk renaming.
Found a similar tool called APKInfo some month ago which i am using for single apk files for a while now.
But finally something for batch renaming.
Thanks
your the man!, works like a charm. Thanks!
Any plans for making an Android version of this to run on our devices?
Future plans for an on-phone version of the APK Rename Tool
del4 said:
Any plans for making an Android version of this to run on our devices?
Click to expand...
Click to collapse
Yes! Certainly. Its in the plans.
But firstly there are a few things to be fixed on the desktop version first. See road map section of the howto.txt file in the archive. The most burning issue is the so called overwrite issue that I want to be sorted out next. Say you have two copies of the same app (same name, label, versionName) but one of them has a patch against it (because its been modded by a reverser) than one of the copies will overwrite the other (ApkRename 1.10).
Secondly on a mobile device's SD card there is usually less space than on a desktop's hard drive. This implies that APK Renamer will actually have to rename the files in place instead of creating a copy of each in a separate folder. Or at least it will need to figure out the empty space left on the device, and if its not enough to hold the copies, it should offer in-place renaming instead. Not a lot of logic to add but still...
Having all the outstanding questions be figured out on the desktop still, will allow me to implement a more established version for the phone right from start. But hold still its not going to take very long
Bests,
phsorx
*edit- For some reason, this thread got posted in Android Software and Hacking general instead of Android apps and games :-|
Hey everyone, its me again.
I have recently been using an app called Paw Server for Android. Though it may seem stupid, this app can really come in handy. The app itself is a utility for managing messages, contacts ect.. But what many people do not realise is that you can host your own website on it, wherever you go. Though this will only work over wifi, you can optionally do some port forwarding to make the site accessible over the internet.
To put a custom website on the server, do the following
1. Install PAW Server for android.
2. Mout your phone's SD-Card On your computer
3. This step has two options:
A Website:
Put your website files in /paw/html/ and make sure the index.html is in this directory. (If you need help creating a site, please visit http://cyanstatic.com)
A File explorer:
If creating a website is too much of a hassle, you can just put some files that you would like to access from your browser in /paw/html/. I Put a couple of songs and videos in the folder and had no trouble streaming the files to my browser.
4. Now open PAW and press the 'Start" Button.
Congratulations!
Your website/chosen files should now be accessible from your browser
i use swiftp, does pretty much that, though it is dedicates to do so, so i think it's a bit more comfortable
This is a great tool
Will give it a shot
doenis said:
i use swiftp, does pretty much that, though it is dedicates to do so, so i think it's a bit more comfortable
Click to expand...
Click to collapse
Really? So can swiftp run a web server or just file services?
Wow amazing!
Sent from my HTC Vision using XDA App
I used PAW Server to host a WIKI on my Nexus One
I used PAW Server to host a WIKI on my Nexus One....
And it almost worked!
tiddlywiki (google it, I'm new and can't do links) is a one page wiki written in, I can't really tell because the tiddlywiki page doesn't do much about talking about how it works.
But PAW serves the pages, and some of the read/browse functions seem to work -- but I was unable to figure out how to edit a page -- and that could just be my fault.
And installing the wiki was pretty easy. I downloaded the zip file to my pc, moved it into my dropbox directory, unpacked it into a directory called wiki, and then on my phone, I synced drop box, and I moved the wiki directory into the paws/html directory. And it served up the page just fine.
But I couldn't edit it.
Why does it ask for permissions to everything? ie Camera, Vibrate, etc....
This maybe unintentional with the manifest, but it looks awfully rogue when programs look for permission to things they don't use.
Very cool thanks for the share! Tough it doesn't make much sense serving via mobile, but i might give it a shot and see if I can use some DNS servers too, starting with dyndns.org
Check out Wifi Remote Access for Windows Mobile: You can do the same thing, but it also comes with a whole range of other stuff.
To edit it, you just need to go into program file, and add a folder inside public (I think) with all your website files. Then change Wifi Remote Access's default.html to redirect you there,instead of to /fs/
mik101 said:
Why does it ask for permissions to everything? ie Camera, Vibrate, etc....
This maybe unintentional with the manifest, but it looks awfully rogue when programs look for permission to things they don't use.
Click to expand...
Click to collapse
This is because it comes with a site on it for managing your phone, like take pictures from the browser and send sms.
With the server it is also possible to develop web applications that use the Android API.
That's also a reason (apart from the web interface mentioned by GlobaL_TroTTer) why there are so many permission requested.
Great find! This is going to be very beneficial to me if I ever misplace my phone around the house or at school. It also has several features that are invaluable IMHO.
Great App - but not working on Verizon network
PAW Server is a real gem... it works great in a LAN/WiFi environment.
Unfortunately, it appears that Verizon Wireless doesn't route ANY traffic that is not initiated by the phone/user.
So thi nice little personal web server is unreachable over the air.
Same for Telnet, FTP, etc.
If anyone has a working app (on a Verizon network) - reachable FROM the net - please let me know!!
Android Port Forward?
GlobaL_TroTTer said:
*Though this will only work over wifi, you can optionally do some port forwarding to make the site accessible over the internet.
Click to expand...
Click to collapse
I'm trying to access the server without connecting through wifi. Is this even possible?
Thanks
I've played around with PAW Server. I like the PHP Plugin. I created an offline UPC scanner web app (for retail inventory) in PHP/JS/WebSQL which synched with a remote server. It eventually turned into a Phonegap app.
Directory Permissions
Does anyone have a link to some documentation regarding "Directory Protection" part of PAW?
It mentioned that granting permissions to certain folders must follow the following format
relative-directory:auth-type:realm:users
with a sample of
/test:basic:Test Real:user
But I don't know what auth-types are available. I'd like to grant a certain folder read permissions to everybody.
I just have to say that setting up my own website with PAW was super easy (10 easy steps):
1) Install PAW and start up server: google PAW android
2) Find external IP: google "what's my IP"
3) Go to router (192.168.0.1 or 192.168.1.1 ) and enable port forwarding to your android for the port you used.
4) Set up PHP: Use browser to hit server(192.168.1.?), sign in, go to add-ons, setup PHP, transfer unzipped folder to /sdcard/paw/html/app/plugins/ and restart PAW server
5) create file (mypage.php) with contents(<html><head></head><body><?php echo '<p>Hello World again</p>'; ?> </body></html>) and place it in /sdcard/paw/html/app/
6) Navigate to [myexternalIP]:[myport]/app/mypage.php (note requires login) Unless you changed the port number it defaults to 8080
7) Register for a free domain: no-ip.com
8) Modify host to have "Port 80 Redirect" to the port you configured (typically 8080)
9) Fix permissions on certain folders so joe blow can hit my server <---- How to do this part????
10) Profit!
I'm trying to make my first android app with kivy...
I made a simple window with a textbox, a button and a list: the user type something in the textbox, press button and the list is refreshed showing the new item (textbox text)
it's very simple, but it's just a test.
I used sqlite+sqlalchemy for the db because i plan to grow the app in complexity and the kivy storage api does not fit my needs.
This program works on my computer (classic... hehe) but crashes when i package with buildozer and deploy on my phone.
The problem is that I'm creating the db with
Code:
engine = create_engine('sqlite:///test.db', echo=False)
but if it's ok for desktop, it is not for android...
where can i create the db?
doesn't the app lives in the /data/data/com.blah folder?
why can't i write there?
thanks all
How to use Kivy + Sqlite on android mobile?
I am stuck exactly as the same stage as you were in 2015.
Since no one has replied to your post, I am guessing that you must have either worked it out yourself or you must have got the solution from another forum.
I would like you to share it if you have the solution.
il_doc said:
I'm trying to make my first android app with kivy...
I made a simple window with a textbox, a button and a list: the user type something in the textbox, press button and the list is refreshed showing the new item (textbox text)
it's very simple, but it's just a test.
I used sqlite+sqlalchemy for the db because i plan to grow the app in complexity and the kivy storage api does not fit my needs.
This program works on my computer (classic... hehe) but crashes when i package with buildozer and deploy on my phone.
The problem is that I'm creating the db with
Code:
engine = create_engine('sqlite:///test.db', echo=False)
but if it's ok for desktop, it is not for android...
where can i create the db?
doesn't the app lives in the /data/data/com.blah folder?
why can't i write there?
thanks all
Click to expand...
Click to collapse
XDAdevelopers article
Send P2P messages, links, files, folders, notifications and the clipboard easily and securely.
• Connect: easily connect your devices using only your local network and only when you need it over the Internet*. Without the mandatory use of external servers. Without ads and tracking. Your data stays in your devices.
• Phone calls & SMS*: read and send SMS / MMS messages from your PC, mac, linux or tablet: there are free applications for all major operating systems. Send to PC a notification regarding a phone call and initiate phone calls from your computer. Auto forward SMS to PC.
• Files & folders: send to PC and mobile devices files and folders fast, accurate and without limitations. Take advantage of all the bandwidth of your network and safeguard your data plan and internet bandwidth.
• Remote file management*: download, rename, delete the files of a remote device.
• Notifications: Share the notifications between your devices. Read and reply* to the notifications of your phone from your computer.
• Clipboard: send the clipboard text from one device to another. Auto-sync* the clipboards between your devices. Auto-sync works on the Q version of Android using a private clipboard.
• Messages & Links: Send P2P messages and links to one or more devices even when they are offline. Once available they'll receive the pending messages!
• Remote control*: Remotely control a device. You can change the volume, lock the screen, restart the device and more.
• Voice calls: make unlimited*, end-to-end encrypted, voice calls for free.
• Android TV*: a simple and functional interface to send and receive files from your Android TV.
• Free browser plugins: there are free extensions for Firefox, Chrome and all Chromium based browsers.
• Safety: End-to-end encryption when you transfer files, send messages and share notifications and clipboard.
• Private network: Create your own hotspot with one click and keep your data out of the grid.
• Privacy policy: We don't collect any data from you when you use this application.
Android app
EasyJoin "Essential": Download it from the site: https://easyjoin.net/android_free.html
* EasyJoin "Pro": XDA thread.
EasyJoin "Go TV": XDA thread.
EasyJoin "Go": XDA thread.
Windows app
Download it from the site: https://easyjoin.net/windows.html.
Linux app
Download it from the site: https://easyjoin.net/linux.html.
macOS app
Download it from the site: https://easyjoin.net/mac.html.
Learn more at EasyJoin.net. If you have any issues read the FAQ to find a solution.
If you have installed the Windows app v1.0 you have to uninstall it and use the live version. If you want to move your current data (messages, trusted devices and configuration) you have to:
- open the directory "c:\users\your_user_name\appdata\local\apps\2.0"
- locate the "easyjoin.exe" file. In the same directory exist the directory "data".
- Copy and paste the "data" directory in the directory "easyjoin.live"
From v1.0.1 you have to follow the steps below to update the Windows version:
1. unzip the " easyjoin.portable-v*.zip" file
2. select all files in folder "easyjoin.portable*"
3. copy the selected files in the folder with the current installation of the program
Note: All your data (devices, messages, settings) are in the "data" folder. By following the above procedure you don't delete your data, you only update the program.
In the Windows version there is a button in the "Settings" menu to check for updates.
Great App.
Your app is very useful. I am using it on windows 10 and android devices. It's working very smooth.
Suggestions:
1. If possible you should add an option to select different sound for notifications.
2. You should add theme options in future updates.
3. In message section, Long pressing on message or file should select the message. Just like you can select message & It gives more options in whatsApp.
4. Are you planning to make an app for iOS in future?
Uninstall guide for Windows app.
You should add step by step uninstall guide for windows app. I am a very basic windows 10 user and I am not able to uninstall the app. I am not able to find directory. It would be great if you can help me with it. Thanks in advance!
VeProid7 said:
Your app is very useful. I am using it on windows 10 and android devices. It's working very smooth.
Suggestions:
1. If possible you should add an option to select different sound for notifications.
2. You should add theme options in future updates.
3. In message section, Long pressing on message or file should select the message. Just like you can select message & It gives more options in whatsApp.
4. Are you planning to make an app for iOS in future?
Uninstall guide for Windows app.
You should add step by step uninstall guide for windows app. I am a very basic windows 10 user and I am not able to uninstall the app. I am not able to find directory. It would be great if you can help me with it. Thanks in advance!
Click to expand...
Click to collapse
About uninstalling the windows version. All you have to do is delete the directory containing the program. Only, if you have enabled the "startup on boot", you have to disabled it in order to remove the key from the registry. Is a self contained app, if you exclude the Microsoft .NET Framework that you have installed separately, and all the files that it use are in the same folder/subfolder.
1,2 are in the todo list.
3. will be available in the next version.
4. Creating an iOs version is not in the current plan because I miss the hardware needed for development.
VeProid7 said:
3. In message section, Long pressing on message or file should select the message. Just like you can select message & It gives more options in whatsApp.
Click to expand...
Click to collapse
Available from version 1.0.10. You can send a message (text or file/image) to another application. You can also select multiple messages to forward to an other device or delete.
Awesome!
That's awesome and It was fast! Thanks a lot for quick update!
Just one suggestion about point 3. When you select text, there should be an option to copy it. Just like WhatsApp.
*About uninstalling windows version:
- I am not able to find the directory. Is it unzipped folder location for easyjoin.exe file? Deleting easyjoin.exe deletes the program, right?
- Also what's the location for that registry file?
*About future plans:
1.What are your plans about easyjoin?
2.There are only few good apps that does file sharing notification sharing for devices. Is it a fun project to provide a free app to users or You are planning to make premium version in future?
3.When did you think about making this app? Are you working on some other apps?
VeProid7 said:
- I am not able to find the directory. Is it unzipped folder location for easyjoin.exe file? Deleting easyjoin.exe deletes the program, right?
- Also what's the location for that registry file?
Click to expand...
Click to collapse
Is the folder containing the easyjoin.exe file. If you have enabled "startup on boot" open the app, uncheck the box and then delete the easyjoin folder. The registry file is the Windows one but don't worry about it, just follow the above instructions..
My plan at the moment is to create an easy-to-use application, improve the UI (the current user interface should be considered in alpha version), which does not need an external server to share files and notifications and do not overwhelm the user with advertising.
Android app update
There is a new file browser to select the files or folder to send to other devices.
You can use the file browser as stand alone app - there is a new icon in the app list.
Very good job. 'Till now I've used an app that use the ip addresss within the same network to make connection between phone and pc. But your app is faster and simpler.
Hi, i like it. Will you implement a Exit / run-in-background choice on Android?
That would be a great addition. But It will use some battery, right?
ks123 said:
Hi, i like it. Will you implement a Exit / run-in-background choice on Android?
Click to expand...
Click to collapse
Hello. The app continues to run in the background even when you exit. Is that what you are asking for or have I misunderstood?
Btw in my devices I have not noticed an increase in battery consumption leaving the app running in the background.
easyjoin said:
Hello. The app continues to run in the background even when you exit. Is that what you are asking for or have I misunderstood?
Btw in my devices I have not noticed an increase in battery consumption leaving the app running in the background.
Click to expand...
Click to collapse
The key word is "choice".
Sooner or later i always have to manage apps with services (freeze, take away receiver intent or uninstall if they refuse to play along) because no matter how small the impact (battery drain, CPU time, RAM) it just sums up.... (or because i hate not be in control...otherwise i would accept an iphone-approach).
So if it does not hurt your philosophy and you like the power of the user, pretty please provide a choice. Thanks for considering.
ks123 said:
The key word is "choice".
Sooner or later i always have to manage apps with services (freeze, take away receiver intent or uninstall if they refuse to play along) because no matter how small the impact (battery drain, CPU time, RAM) it just sums up.... (or because i hate not be in control...otherwise i would accept an iphone-approach).
So if it does not hurt your philosophy and you like the power of the user, pretty please provide a choice. Thanks for considering.
Click to expand...
Click to collapse
I misunderstood
It's already in the to do list.
I'm on windows 8.1, what am I supposed to do to install this program?
edit, it's ok once I kicked my antivirus a bit, I got it working
How to add something as a trusted device though?
techguyone said:
I'm on windows 8.1, what am I supposed to do to install this program?
Click to expand...
Click to collapse
If I am correct, You need to download that zip file. (Link for zip is in the main post or you can download it from easyjoin.net)
Unzip that downloaded file. Open the folder. There will be .exe file. Run it & Pin it to taskbar. So that you can open from there.
Link for windows: https://forum.xda-developers.com/attachment.php?attachmentid=4281040&d=1506182662
Edit: Open EasyJoin on both devices. The app will detect available device with It's default/given name. There will be a + button with device name. Click on it to add it as trusted device.
techguyone said:
I'm on windows 8.1, what am I supposed to do to install this program?
edit, it's ok once I kicked my antivirus a bit, I got it working
How to add something as a trusted device though?
Click to expand...
Click to collapse
VeProid7 was correct. Btw if you have issues with the Windows firewall you can use the vbscript file to open the port. You can execute the vbscript file directly from the folder or from the "Settings" window.
VeProid7 said:
Link for windows: https://forum.xda-developers.com/attachment.php?attachmentid=4281040&d=1506182662
Click to expand...
Click to collapse
You can find the link for the latest update of the Windows app in the main post. Usually i delete the previous attachments in order to preserve the disk space. The above link is not anymore available.