Solved

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

Posted on 2013-06-04
8
296 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DNS on-premise and on-cloud 15 129
API Soap Calls 4 140
Using MS Code on my Mac 6 72
Adjust the position 3 70
Is your company's data protection keeping pace with virtualization? Here are 7 dynamic ways to adapt to rapid breakthroughs in technology.
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

730 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