Can I use infopath for the purpose mentioned below??

[Senthil]

Hi all,
We are having a VB application on SQL. But we need to collect
information from persons who will be offline to verify data and insert
new data. Generally they will be entering the data in Excel spread
sheets which can be uploaded to the database using the application
after some validations. But is it possible using Infopath, so that I
can give them a report on the available data so fascilitating them to
verify data at the site(when they are offline) and key in the data. I
need to validate the data entered based on some rules. And is it
possible to have a dump of the existing data in SQL so that I can
check and see if they are entering correct information....
Please advice.

Regards
Senthil

 

[Dean]

yes this is possible. IP provides an excellent tool for validating user
input. You can use rules that are created when designing the form using
declarative statements, script that runs behind the form, or managed code
written in VS.Net. You can use IP to collect data and then upload the data
to a database when the user is reconnected to the network.

Get the IP SDK which contains the following example, as well as several
others..
"The Data Submission developer sample form demonstrates some of the ways in
which a custom data submission process can be implemented in a Microsoft
Office InfoPath form. Submitting a form is different from saving it:
submitting involves sending it to a server process, and saving simply
involves persisting it to disk.

One way to submit a form is to use a Microsoft Active Server Page (ASP) to
process it; another is to use an XML Web service. Although the Data
Submission developer sample form uses custom scripting code to implement
both kinds of data submission, InfoPath provides built-in support for the
data submission process that does not require using scripting code"

 

[Senthil]

Hi Dean
Thanks for the response. I hope I can build in Infopath and
access MDB. But I want to provide some reports so that based on that
they will be adding or updating data. So that they can verify the
existing data and make updates on missing info. But the access reports
seems to be ordninary for this purpose. Is there any reports that can
be done in infopath(something similar to datagrids in .Net) so that
they can straight away update or enter new data??

Thanks
Senthil