Making app with kivy + sqlite - Frameworks

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

Related

How to determine Window Class?

May I know how to determine the Window Class of an application in Windows Mobile? The application of my interest is Skyscape softwares. Thanks.
http://forum.xda-developers.com/showpost.php?p=2380011&postcount=48
I found this the other day, it works great, just assign it to a hardware button and while you have the program who's calss name you want to know open, just push the button you mapped it to. Works like a charm
cyberdon83 said:
http://forum.xda-developers.com/showpost.php?p=2380011&postcount=48
I found this the other day, it works great, just assign it to a hardware button and while you have the program who's calss name you want to know open, just push the button you mapped it to. Works like a charm
Click to expand...
Click to collapse
I have an app which autoclose if any other program is launched so the app indicated is no worth in this case. Do you know a solution to discover that program's window class?
kibiwi said:
I have an app which autoclose if any other program is launched so the app indicated is no worth in this case. Do you know a solution to discover that program's window class?
Click to expand...
Click to collapse
I suggest Dotfred's TaskMgr (http://www.dotfred.net/TaskMgr.htm) to find the window class. It's very reliable.
In the Processes page, tap-and-hold the process that you want to find the window. A menu will appear... select Details.
This Details page will show the process' Modules, Threads, Windows and Heaps. Select the Windows tab and browse to the window that you want to find the window class.
I use this method to create my personal scripts in MortScript.

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] Merge 2 Whatsapp Backups

Hey Guys,
I read a bit through this forum and i see you guys know a lot so I wanted to ask for help here .
Soo like the titel says i want to merge 2 Whatsapp Chatbackups together because i have 1 Chatbackup from my old Smartphone and one from my new One...I googled first and tried some methods i found there. First i tried SQlite Browser but it didnt work because my databases are like this: "msgstore.db.crypt7 or msgstore.db.crypt5 but they are supposed to be like this msgstore.db" correct me if im wrong ;p...so i tried WhatsappXtract and Sqlite Admin but it didnt work aswell...I tried to convert from crypt 7 and crypt 5 to crypt with Whatcrypt but it always failed. My Idea now is to 1. decrypt my Msgstores from msgstore.db.crypt7 to msgstore.db
2. To use this Instruction :
HOW TO MERGE SQLITE DATABASE FILES WITH SQLite Compare: 1. Open the old database file in SQLite Database Browser. Open the table messages in Browse Data. Press the Button " > " as often as necessary to get to the last page. Scroll down to the last message. Now write down the number (_id) of that last message, e.g. 65422 2. Now open the new database file in SQLite Database Browser. Open the table messages in Browse Data. Click on the first entry (which has most fields with value "-1"). Click on Delete Record. Have a look at the now first entry and write down the number (_id) of that first message, e.g. 12 Now Click on Execute SQL and execute the following SQL statement: UPDATE messages set _id = (65422 + 1 + _id - 12) (replace 65422 by your last message _id in the old database and 12 by your first message _id in the new database) 3. Now all messages in the new database have the correct _id`s. Click on Save. Close all windows of SQLite Database Browser. 4. Download & Install SQLite Compare. Open SQLite Compare. 5. File - Compare For example: Left file: msgstore-2012-06-01.1.plain.db Right file: msgstore-2012-06-07.1.plain.db (Make sure to have a backup of both files!) x Compare schema and data x Compare BLOB fields OK 6. Double Click on table "messages" in the result window OR left click on table "messages" and hit button "Edit selected difference..." 7. A new window opens, "Table messages" Click on blue button "R" (it`s located after "Refresh Comparison", "L" and before "≠", "=") 8. Now on the right side all messages are shown that aren`t included in the left file. Now you can select multiple messages (first left click on the first message to select, then scroll down to the last message to select and press SHIFT + left click on the last message to select). I noticed that you can`t handle too many messages at once as it produces an error. Just try. I succeeded with about 1000-1500 messages. Now click on the button with the arrow from right to left: ← Now the selected messages are copied from the right database to the left database. 9. Repeat the steps in (8.) until all the messages are copied from the right file to the left file. 10. Maybe you also need to to this for the table chat_list if there are some new chat contacts in the newer backup file. 11. Now the left file (e.g. msgstore-2012-06-01.1.plain.db) contains all the messages from the prior file msgstore-2012-06-01.1.plain.db and the newer file msgstore-2012-06-07.1.plain.db. (No saving necessary as the tool automatically applies the changes to the file after pressing the ← button).
Now i wonder if this would work and how do i do my first Step?
Sorry if this is a totally Wrong Thread im a Newbie
Thanks to everyone who read this!:good: <3
Btw if anyone knows how to merge 2 Whatsapp Backups easier just tell me ^^
Got interesting will try to find a way out..
Thankyou this never came in my mind.
Zeuscluts said:
Got interesting will try to find a way out..
Thankyou this never came in my mind.
Click to expand...
Click to collapse
Okay Thanks man

[APP] EasyJoin - A Decentralized and Secure Communication System

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.

Categories

Resources