[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2013-06-04
8
Medium Priority
?
303 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
  • 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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 43

Accepted Solution

by:
Rob earned 2000 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

The decision to migrate to the cloud is not a simple one—many factors, such a cost, ease of use, and ongoing maintenance come into play. The goal is always for cloud platforms to make storage and backups more seamless and effective. Here’s a look at…
Are you a startup company? Being a startup, you may be using shared hosting, or maybe even dedicated hosting. But have you ever given a thought to using cloud computing now? Yes, don’t be surprised, it is possible for startups to opt for cloud compu…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

607 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