Automatically create InfoPath document in SharePoint library

[Kiran K]

Hi,

How can I automatically create an InfoPath document in a SharePoint Form
Library, when a new record is added to a table in a SQL database? The
InfoPath document should contain the data that was inserted into the table in
the SQL database.

I have designed an InfoPath Form Template, which I then published to the
SharePoint site. This allows users to create InfoPath documents in a
SharePoint Form Library. But in addition to this, we want to auto-create
InfoPath documents (based on the same Form Template) when a new record is
added to a table in a SQL database.

We are using InfoPath 2007, SharePoint Server 2007, and SQL Server 2005.

Thanks a lot. Any suggestions/ideas will be greatly appreciated.

Kiran

 

[Paresh]

Hi,

How can I automatically create an InfoPath document in a SharePoint Form
Library, when a new record is added to a table in a SQL database? The
InfoPath document should contain the data that was inserted into the table in
the SQL database.

I have designed an InfoPath Form Template, which I then published to the
SharePoint site. This allows users to create InfoPath documents in a
SharePoint Form Library. But in addition to this, we want to auto-create
InfoPath documents (based on the same Form Template) when a new record is
added to a table in a SQL database.

We are using InfoPath 2007, SharePoint Server 2007, and SQL Server 2005.

Thanks a lot. Any suggestions/ideas will be greatly appreciated.

Kiran

Hi Kiran,

I am not sure whether is it possible to create infopath document
depending on a new record insertion in one of the SQL tables, but you
can always have a feasibility of inserting database record using
infopath form and submitting this infopath form to the Sharepoint
library simultaneously.

Thanks,
Paresh

 

[kkakanur1]

Hi Paresh,

Thanks for your response. Yes. I am aware of the fact that you can
create a record in the database as well as create and submit a
corresponding InfoPath document to the SharePoint library. We are
currently doing that.

In addition to this, when a new record is inserted in the database we
want to be able to trigger a process that creates the corresponding
InfoPath document in the SharePoint library.

Is it possible to have a SQL stored procedure that kicks off when a
record is inserted in the SQL table, and then have this stored proc
run an .exe which creates the InfoPath doc?

Kiran