[Q] Android inventory app data storage suggestions - Other Tools & General Discussion

Hello,
I'm attempting to make an inventory application. Basically, our company has several devices/equipment that we checkout to other people and our current paper system isn't working out. The devices will each have an NFC tag put on that uniquely identifies it, and the idea is that the Android application on our smartphones (provided by the company) will simply scan it to check in/out the device. It will record the date time, who checked it out, and other information, and we want more than one person to be able to check in/out items at a time.
My problem is figuring out a way to store this data. Our company already pays for a OneDrive for Business account and our initial idea was to simply store the data in an Excel spreadsheet and share it with the people who checkin/checkout the devices (only two people at the moment), then the app would download the spreadsheet, record the new data, and upload it again to OneDrive. Reading and writing the data is easy, but actually pulling the file from OneDrive is where we hit a road bump and now we need another plan.
Are there any free alternatives for data storage of this kind where I would be able to access it through the Android application and update it? We also thought of using Heroku, but through researching I found that directly connecting to the PostgreSQL database they provide within the application is not possible. Of course we want to keep this data secure and only accessible to the people actually checking in/out devices, but we do not need a huge amount of space to store this data. Any suggestions are greatly appreciated.

cyborg99 said:
Hello,
I'm attempting to make an inventory application. Basically, our company has several devices/equipment that we checkout to other people and our current paper system isn't working out. The devices will each have an NFC tag put on that uniquely identifies it, and the idea is that the Android application on our smartphones (provided by the company) will simply scan it to check in/out the device. It will record the date time, who checked it out, and other information, and we want more than one person to be able to check in/out items at a time.
My problem is figuring out a way to store this data. Our company already pays for a OneDrive for Business account and our initial idea was to simply store the data in an Excel spreadsheet and share it with the people who checkin/checkout the devices (only two people at the moment), then the app would download the spreadsheet, record the new data, and upload it again to OneDrive. Reading and writing the data is easy, but actually pulling the file from OneDrive is where we hit a road bump and now we need another plan.
Are there any free alternatives for data storage of this kind where I would be able to access it through the Android application and update it? We also thought of using Heroku, but through researching I found that directly connecting to the PostgreSQL database they provide within the application is not possible. Of course we want to keep this data secure and only accessible to the people actually checking in/out devices, but we do not need a huge amount of space to store this data. Any suggestions are greatly appreciated.
Click to expand...
Click to collapse
Heroku is a good option. You'll have to make an app to run API's that will talk to your app.

Related

Good For Enterprise

Has anyone been able to get this working with Root? I install fine, enter my pin and it goes through but since I have root it doesnt sync. Im running liberty, any suggestions
matt1313 said:
Has anyone been able to get this working with Root? I install fine, enter my pin and it goes through but since I have root it doesnt sync. Im running liberty, any suggestions
Click to expand...
Click to collapse
Checking for root is configurable by your IT area. My account is not setup to check for root but I have had other problems. Can you easily unroot and reroot your device so Good would work except for the rare times that you actually need root? One problem I have had is the initial setup would never complete (stops at retrieving policies) unless I go back to stock eclair, get it working and back it up via Titanium backup, then upgrade to Froyo or GB, and then restore it. Mine continues to work via root though. The other problem I have had is if I ever restore to an earlier state (using the same PIN), it will stop syncing. I need a new PIN issued to get it working again.
I'm reading that IT admins can lock your phone camera, wipe SD card, etc.
What other kinds of things can they do once "Good for Enterprise" is installed on your personal phone?
Nate2 said:
I'm reading that IT admins can lock your phone camera, wipe SD card, etc.
What other kinds of things can they do once "Good for Enterprise" is installed on your personal phone?
Click to expand...
Click to collapse
I was involved in piloting "Good for Enterprise" for my company. I do know that the possible "controls" vary depending on the platform. Good for Enterprise on the IPhone will have much more control because the devices (hardware) and OS are very limited compared to Android. Keep that in mind as you read some of these items if they don't mention which platform. Also, the Good application would have to be granted root access to your phone "I believe" in order to do any of the items you mentioned. If you are running a custom ROM and have the "SuperUser" app, you would see if it had that access. I "think" it will be very hard for Good to implement some of those controls unless the Android OS provides an API for it because the underlying hardware can vary so much. I'm not a developer but I think that is correct.
Also, if you work for any decent sized company, they will be very concerned about the legal aspects of company provided software deleting (or even reading) personal information outside the "Good container". I mention the word container because Good provides encryption of everything within the app so it can not be read by anything outside the app (such as root explorer). I have successfully backed up and restored the encrypted data to another ROM but it is just bits to Titanium Backup or anything else. Feel free to PM me if you have any other questions on it that I might be able to answer. I know the admin for Good for our company that I could ask other questions.
I'm reading that the installation can detect jailbroken iPhones and rooted Android devices, and if the IT admins decide, they can configure it to refuse installation on such devices to prevent compromising Good's security/integrity of its resources.
(I'm not rooted, and don't plan to root my DroidX, so it is a moot point for me)
I heard from Verizon that IT admins can remotely control hardware components, including cameras, Bluetooth and IR ports, SD Cards, and more.
Things I'd like to know... can IT admins:
Track/monitor internet usage on the device?
Track/monitor GPS usage?
Copy non-Good related resources (e.g. files) from the device or SD card?
Lock the device?
Locate the device?
Wipe non-Good related resources?
Does the Good app send device System Logs to the IT folks?
Phone call logs?
App Permissions:
YOUR ACCOUNTS
ACT AS AN ACCOUNT AUTHENTICATOR Allows an application to use the account authenticator capabilities of the AccountManager, including creating accounts and getting and setting their passwords.
MANAGE THE ACCOUNTS LIST Allows an application to perform operations like adding, and removing accounts and deleting their password.
SERVICES THAT COST YOU MONEY
DIRECTLY CALL PHONE NUMBERS Allows the application to call phone numbers without your intervention. Malicious applications may cause unexpected calls on your phone bill. Note that this does not allow the application to call emergency numbers.
NETWORK COMMUNICATION
FULL INTERNET ACCESS Allows an application to create network sockets.
YOUR PERSONAL INFORMATION
READ CONTACT DATA Allows an application to read all of the contact (address) data stored on your device. Malicious applications can use this to send your data to other people.
READ SENSITIVE LOG DATA Allows an application to read from the system's various log files. This allows it to discover general information about what you are doing with the device, potentially including personal or private information.
WRITE CONTACT DATA Allows an application to modify the contact (address) data stored on your device. Malicious applications can use this to erase or modify your contact data.
PHONE CALLS
READ PHONE STATE AND IDENTITY Allows the application to access the phone features of the device. An application with this permission can determine the phone number and serial number of this phone, whether a call is active, the number that call is connected to and the like.
STORAGE
MODIFY/DELETE USB STORAGE CONTENTS
MODIFY/DELETE SD CARD CONTENTS Allows an application to write to the USB storage. Allows an application to write to the SD card.
SYSTEM TOOLS
RETRIEVE RUNNING APPLICATIONS Allows application to retrieve information about currently and recently running tasks. May allow malicious applications to discover private information about other applications.
PREVENT DEVICE FROM SLEEPING Allows an application to prevent the device from going to sleep.
YOUR ACCOUNTS
DISCOVER KNOWN ACCOUNTS Allows an application to get the list of accounts known by the device.
HARDWARE CONTROLS
CONTROL VIBRATOR Allows the application to control the vibrator.
NETWORK COMMUNICATION
VIEW NETWORK STATE Allows an application to view the state of all networks.
VIEW WI-FI STATE Allows an application to view the information about the state of Wi-Fi.
SYSTEM TOOLS
READ SYNC STATISTICS Allows an application to read the sync stats; e.g., the history of syncs that have occurred.
AUTOMATICALLY START AT BOOT Allows an application to have itself started as soon as the system has finished booting. This can make it take longer to start the device and allow the application to slow down the overall device by always running.
KILL BACKGROUND PROCESSES Allows an application to kill background processes of other applications, even if memory isn't low.
Sent from my unrooted DroidX using XDA App
I've been using EVO CM7 nightlies for quite a while now and never had issues with Good for Enterprise. With last 3 versions of nightlies, Good hasn't worked. When trying to reinstall Good, it says there is no phone network when trying to register. When looking at Device Info in Good setup screen, it doesn't have a phone number. Tried clearing, data, all cache, etc.
Is anyone else having this issue? It's like CM7 is not sending the phone string to Good when calling it.
A coworker also uses CM7 (not nightlies) and has no issues with Good on EVO. The phone number shows up in Good device info on his EVO.
I had the same problem, but I'm luckily an admin at our company on the good software. After messing around with it... this is what I had to do.
1. Uninstall Good from your phone on CM7 (Must be uninstalled at first for this to work....)
2. Reboot into Recovery and make a Nandroid Backup
3. Wipe the both Caches and Data, Install a Sense Rom
4. Install Good Mobile and have you admin resend you the email to enroll your phone
5. After entering the code and entering a password.. the Good will try to pull emails... kill the good app before this.
6. With Titinium Backup, backup Good and its Data.
7. Reboot into recovery.
8. Wipe the both Caches and the Data... Recover your previous CM7 Nandroid backup.
9. In CM7 launch Titanium backup and restore Good Mobile and its Data.
Worked after that... this way Good would communicate with the phone during the enrollment... which for some reason with CM7 it doesn't work... and just complains about not being connected to your mobile network.
Coincidentally I've just put up another post relating to IMSI numbers which was prompted by Good refusing to activate as some devices are reporting the same 1st 6 digits of their IMSI rather than the full 15 that Good uses to authenticate the license relative to the specific SIM card the license is for. Has anyone else come across this issue with Good?
matt1313 said:
Has anyone been able to get this working with Root? I install fine, enter my pin and it goes through but since I have root it doesnt sync. Im running liberty, any suggestions
Click to expand...
Click to collapse
Mine quit syncing after the first day. I had to upgrade my personal unlimited data plan to a corporate/enterprise data plan for an additional $15/month with Verizon, and reinstall Good.
Sent from my unrooted DroidX using XDA App
Sievers said:
I had the same problem, but I'm luckily an admin at our company on the good software. After messing around with it... this is what I had to do.
1. Uninstall Good from your phone on CM7 (Must be uninstalled at first for this to work....)
2. Reboot into Recovery and make a Nandroid Backup
3. Wipe the both Caches and Data, Install a Sense Rom
4. Install Good Mobile and have you admin resend you the email to enroll your phone
5. After entering the code and entering a password.. the Good will try to pull emails... kill the good app before this.
6. With Titinium Backup, backup Good and its Data.
7. Reboot into recovery.
8. Wipe the both Caches and the Data... Recover your previous CM7 Nandroid backup.
9. In CM7 launch Titanium backup and restore Good Mobile and its Data.
Worked after that... this way Good would communicate with the phone during the enrollment... which for some reason with CM7 it doesn't work... and just complains about not being connected to your mobile network.
Click to expand...
Click to collapse
I previously had a similar problem that I mentioned above - on custom FROYO ROMs it would stop at retrieving policies but flashing to stock eclair, I could finish the setup (and let all current emails come in) and then backup via TB, flash to custom FROYO, then restore and it would be all set. However, when I recently reinstalled Good on Continuum 5.5, I decided to try to let it complete the setup and it did with no problem. I only tried that since my IT admin setup "self-service" for me. I can access a link where I can send a new PIN for my account since it can easily stop syncing. The PIN goes to your corporate email so it is safe to allow.
@Nate2 - sorry I didn't see your post previously. Yes, there are Good policies that can be setup to detect "jailbroken" IPhones, etc. At my company, Good on Android is still not a standard offering because corporate policies are limited to what they can do on Android due to the numerous OS and hardware combinations. However, I have been pushing simply putting trust in the Good encryption (AES 256 if I remember right). Looking at the permissions of the app makes it look at first glance like it can do anything. However, I don't think it is as extensive as it seems. The only "data" outside the Good container that can be read by the app "to my knowledge" is the contact info. This is because your IT administrator can allow Good to sync corporate contact info (in Good) to your phone's contact info. This allows you to easily see who is calling (rather than a phone #) if it is one of your corporate contacts. Although it can access (modify/delete) SD contents, it doesn't say "Read". I don't think I am "reading" too much into that... For internet access, I know Good is working on adding in internet access (from inside the Good container) so browser access is allowed. I am "guessing" this is mostly for IPhones, etc. where the IT admin could stop internet access outside the Good container. That way they could control internet access on a "corporate" device. This is speculation on my part, though. I do think it can send device logs which is required "I think" to detect root access. Look over all the permissions listed keeping in mind READ access to system logs and contact info only and it seems to fit. Therefore, I think they probably can detect that you enabled/disabled GPS but I "doubt" they can detect where you went since I don't "think" that goes in system logs that they pull. If you still have any question, send me a PM since I don't frequently check this thread.
Thanks RichMD.
I once worked in a large company where a sysadmin was fired for accessing the corporate e-mail of an employee (his ex-girlfriend). She reported the incident to HR. Possible access to additional sensitive resources on the phone makes these kinds of incidents worse, and that's why we should be cautious.
Sent from my unrooted DroidX using XDA App

SyncIt Beta: Sync your app data between tablet and phone

I wanted to share this app with fellow transformer users since I believe it is a great idea and would really help anybody that owns both an android tablet and phone. I believe the main idea behind this app is to keep your application data in sync between android devices (i.e. Angry Birds progress), but also will sync any files you want. The app is designed sync data from a specific folder location up to dropbox and down to any other device to the same folder location (and vice versa). One of the issues with syncing app data is that you have to know what files are necessary to keep the data in sync. Also, I’m pretty sure both devices will need to be rooted in order to read/write from the data partition. Unfortunately, I couldn’t get it to work both ways between devices, as you can see my comments in the thread. I could get it to upload from my TF to dropbox, and download to my phone, but any changes on my phone would not make it back to the TF, and then my phone would eventually get overwritten with the old data on my tablet. There is definitely a lot of room for improvement. I’m hoping to get more people interested in it, and more people testing it out. Let me know if anyone here can get it to work successfully.
http://forum.xda-developers.com/showthread.php?t=1148612

[REQUEST] MP3 Quality/Bitrate Modifier

Okay. Allow me to elaborate on what exactly it is I am asking. And before anyone says, "make it yourself", let me just say "been there, read that".
Now, I've had conversations with many Android users who have large music collections and have purchased devices that have dropped SD Card support. Yes, I do have a Meenova, but I also have a Nexus 5 and the battery life goes pretty quickly when I'm listening to music in the car. Data packages aren't cheap. Even if you have a Straight Talk Unlimited Plan (like myself), you aren't actually receiving unlimited data.
I am simply asking that someone create a tool to alter the bitrate of the tracks on my Android Device. I'd pay for an app like that. There are a couple of apps on the Play Store that perform this task, but they are lacking in features. There is no batch editing tool and conversions stop after closing out the apps that I have tried. I could use the program on my computer, but then I have to leave my device at the computer in order to copy converted tracks back over to my device.
Anyway, I'd appreciate it if someone took the time to read this post.
Duckie1217 said:
Okay. Allow me to elaborate on what exactly it is I am asking. And before anyone says, "make it yourself", let me just say "been there, read that".
Now, I've had conversations with many Android users who have large music collections and have purchased devices that have dropped SD Card support. Yes, I do have a Meenova, but I also have a Nexus 5 and the battery life goes pretty quickly when I'm listening to music in the car. Data packages aren't cheap. Even if you have a Straight Talk Unlimited Plan (like myself), you aren't actually receiving unlimited data.
I am simply asking that someone create a tool to alter the bitrate of the tracks on my Android Device. I'd pay for an app like that. There are a couple of apps on the Play Store that perform this task, but they are lacking in features. There is no batch editing tool and conversions stop after closing out the apps that I have tried. I could use the program on my computer, but then I have to leave my device at the computer in order to copy converted tracks back over to my device.
Anyway, I'd appreciate it if someone took the time to read this post.
Click to expand...
Click to collapse
use any audio convertor desktop application . The app will allow to change the bitrate and also other stuffs.

[Q] How can I access the hidden "Application Data" in my Google Drive?

I found this page[1], which describes a hidden folder in Google Drive that is used by apps to store hidden data that other apps cannot access. How can I access this data myself? If there is no official way to do this (which seems likely), how about an unofficial way? I'm okay if such a method requires a rooted device, such as to get keys or something from an app's data. (Perhaps there's an Xposed module that can intercept these API calls to obtain the required authentication data in a universal manner?)
The reason I don't think there's an official way is because of this page[2] about the Saved Games API, namely this part:
Read/Write isolation
All Saved Games are stored in your players' Google Drive Application Data Folder. This folder can only be read and written by your game - it cannot be viewed or modified by other developers’ games, so there is additional protection against data corruption. In addition, Saved Games are insulated from direct tampering by players so they cannot modify individual Saved Games.
Click to expand...
Click to collapse
I'd like to be able to "tamper" (as Google calls it) with that save data anyway, as it's my own save data after all. Most likely this method would let me access that as well.
Could someone point me in the right direction please? Thank you!
Links:
(Since I haven't made 10 posts yet, it won't let me post external links. It says this is to prevent spam, so considering I'm not spamming, I assume this workaround won't be against the rules, as my use of links isn't the type it's aimed at preventing.)
[1] bit.ly/1GmjZOY
[2] bit.ly/1NLJKdU

Privacy concern with a dubious app

Any help will be much appreciated.
I have to install an app which I don't trust, but which requires too many permissions, which obviously I am not keen on giving the app. For reasons beyond my control, I can't name the app (it's a work thing).
My idea is to create a new user on the phone, (OnePlus2) and install the app for that user only. Would this stop it from being able to access the data under my own user, and restrict it to only read the data available for the new user for which it is installed?
It requires permission to: (just incase this info helps)
Draw over other apps
Take pictures and videos
Find accounts on the device
Approximate location, precise location
Read SMS/MMS, Send & View SMS/MMS
Modify or delete contents of USB storage
Read contents of USB storage
Read phone status and Identity
Any other solution I should look at? Or will this work just fine?
Cheers!
No way I would install that. Not on a device I use. Unless I had full control over the source code for the apks. I could see some uses.
But to answer your question, I think that should work. I don't have much experience with the details of extra users on the device bit you can look it up on the Google developer site.
That should be enough.
For good measure, I Tried Doing this on my Moto G4 Plus. I created a new user and installed Drupe and Textra. And here is what happened.
1. The New User did not have access to my contacts, call records or SMS
2. The old user could not see these two apps.
since the gallery is tied to photos on the Moto, the users could not see each other's photos.
UPDATE: I just saw an app on another thread that may work for you. - https://forum.xda-developers.com/android/apps-games/closed-beta-test-incoming-companion-app-t3366295

Categories

Resources