Solved

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

Posted on 2013-06-04
8
297 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Steve Terp was featured in a video created by CRN about how "Channel Is Crucial To Market Disruption". Click on View source to see the video and article
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.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

729 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