Offsite users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kevin - 22 May 2006 19:14 GMT

I have a form that we want our offsite sales reps to fill out and send to us.
When they 'submit' the form, it should update a local database on their
computer (probably MS Access), AND send a file to our server where it can be
picked up and automatically added to our onsite database (preferrably MySQL,
but MS SQL Server if needed). Is there a way to do this with InfoPath, and
if so, how?

Reply to this Message

Ben Walters - 23 May 2006 04:49 GMT

Hey Kevin,
This is someting that InfoPath can do very well, there are a couple of
things to take into consideration however
1: You will need to ensure that all your off site staff have InfoPath 2003
Installed locally
2: You need to make sure they have access to the template you create for
caputring data. This template can be accessed through a number of avenues
including via a website or it can be installed locally on their machines via
an msi

As for the solution I would recommend that the form is submitted to a web
service this web service could then take the submitted form and save any
required data directly to your internal database storage system. This also
adds a layer of abstraction to protect your db from any security breaches.

If the user requires that the form be stored locally he or she could save a
copy of the form to their local HDD or alternatly maintain a local data store
like SQL express.

Hope this helps

Cheers
Ben Walters

> I have a form that we want our offsite sales reps to fill out and send to us.
> When they 'submit' the form, it should update a local database on their
> computer (probably MS Access), AND send a file to our server where it can be
> picked up and automatically added to our onsite database (preferrably MySQL,
> but MS SQL Server if needed). Is there a way to do this with InfoPath, and
> if so, how?

Reply to this Message

Bob C. - 23 May 2006 14:03 GMT

Ben,

Do you know of any samples of this (on MSDN perhaps)?

> Hey Kevin,
> This is someting that InfoPath can do very well, there are a couple of
[quoted text clipped - 26 lines]
> > but MS SQL Server if needed). Is there a way to do this with InfoPath, and
> > if so, how?

Reply to this Message

Ben Walters - 24 May 2006 01:04 GMT

Hey Bob,
I don't know of any articles in perticular but I'll try and put a sample up
on my blog in the next couple of weeks. Unless of course I find something
better before then

Cheers
Ben

> Ben,
>
[quoted text clipped - 30 lines]
> > > but MS SQL Server if needed). Is there a way to do this with InfoPath, and
> > > if so, how?

Reply to this Message

Bob C. - 24 May 2006 03:49 GMT

I'm sure with Beta2 out, there'll be plenty:)

> Hey Bob,
> I don't know of any articles in perticular but I'll try and put a sample up
[quoted text clipped - 38 lines]
> > > > but MS SQL Server if needed). Is there a way to do this with InfoPath, and
> > > > if so, how?

Reply to this Message