Solved

How to create app that will store data to be exported to Excel

Posted on 2013-06-04
8
298 Views
Last Modified: 2013-06-06
Hi all.

We want to be able to have our field agents use some kind of "app" that they would have on their phones or iPads. They work offsite. They would need to choose data from 3 drop down boxes, we would then need to get that data and import it into an Excel spreadsheet we use for forecasting.

Any idea how we could do this?

Thank you in advance.
0
Comment
Question by:Sim1980
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 43

Expert Comment

by:Rob
ID: 39224143
Would they have constant internet access on these devices?  
If so it would be easy enough to have a mobile / tablet friendly website.  Your website can take these inputs and put them in a database or excel spreadsheet.

If not, you'd need to look at developing your own app that can sync the data when they're back online.  Not as hard as it sounds as you can develop this as a webpage and use a converter such as http://phonegap.com/ to create an app for that devices platform.  For Apple (iOS) you'll need a mac at some point to digitally sign the app and also submit it to Apple.
0
 

Author Comment

by:Sim1980
ID: 39224230
Hi tagit. Thank you for the reply.

Yes they would have constant access to the internet.

My confusion is where will the website keep the inputs, in the hosted web server? If so, would I need to write some vba in Excel to pull the data from this web server table?
0
 
LVL 43

Expert Comment

by:Rob
ID: 39224318
You can put the inputs anywhere, I suggest a database on your hosted web server.
You can then link your spreadsheet to this data easily and without vba
0
Threat Trends for MSPs to Watch

See the findings.
Despite its humble beginnings, phishing has come a long way since those first crudely constructed emails. Today, phishing sites can appear and disappear in the length of a coffee break, and it takes more than a little know-how to keep your clients secure.

 
LVL 43

Accepted Solution

by:
Rob earned 500 total points
ID: 39224327
I would do it by setting up an ODBC data source that points to the database on your web server.
You would also need a simple server script such as asp or php to handle the inputs and insert them into your database.
Not sure on the environment of your app but would your users need a login given the site would be publicly available?
0
 

Author Comment

by:Sim1980
ID: 39224346
We have a web host package that is Linux, so the table is mySQL. That being said I guess we'll use php.

Yes they will need a login. Would that mean the first page they see would be a login page and if successful then go to the data entry form. Right?
0
 
LVL 43

Expert Comment

by:Rob
ID: 39224486
Sounds like a good setup with php etc.
That's right about the login, you can use sessions with php.
Need help with any of this?
0
 

Author Comment

by:Sim1980
ID: 39225162
Thanks tagit!

But I think I should post that as another question, to be fair.

The question I should ask is how to do sessions in php?
0
 
LVL 43

Expert Comment

by:Rob
ID: 39225487
No problem
As for the sessions, You'd be better off searching experts exchange, I guarantee its been answered before, maybe even an article written on it. :-)
You can also find great help, tutorials and examples at php.net
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Big data transfers via information superhighways require special attention and protection. Learn more about the IT-regulations of the country where your server is located. Analyze cloud providers and their encryption systems for safe data transit. S…
Moving applications to the cloud or switching services to cloud-based ones, is a stressful job.  Here's how you can make it easier.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question