Web service

[Simon]

Hi,
I have an infopath form and want to create a web service that will extract
certain xml elements from the filled-out form and insert them into an SQL
table. Is this difficult to do? I cannot use the simple database connection
built into InfoPath as one of the form fields is a file attachment and when I
tried using this it wouldn't submit the form to the database. I also want to
submit to a Sharepoint form library and know how to do this, but not at the
same time as submitting to database.
I'm pretty new to both Infopath and web services so any assistance would be
much appreciated.
thanks,
Simon

 

[Adam Harding]

Simon

Create a new form from a dataconnection into the SQL database storing
everything in it apart from the file attachment, you could have a tick box
that reveals the file attachment when ticked that does go into the database
to indicate its presence.

Now add a new submit dataconnection to sharpoint and submit the whole form
AND the file attachment to sharepoint.

This means in your datasource you will have all your database fields listed
then a separate type of datafield call file attachment which is not bound to
the database but exits only in the form.

Mail me and i will show you an example.

It is easy to setup, i promise.

Cheers Adam

(e-mail address removed)

 

[Simon]

Adam,

thanks very much for replying. As it happened, I tried what you suggested
just before reading your post so quite frustrating but at least I got there
in the end.
From reading your posts seems like you know quite a bit about InfoPath, so
hope you don't mind if I ask any further questions if I get stuck again!
thanks again,
Simon

 

[Adam Harding]

Simon

Have minimal experience of Sharepoint but extensive experience of fairly
complicated stuff like repeating cascading lists, workflow and lateral
thinking to get around seemed infopath limitations.

Glad i could help.

For really complicated stuff, code, etc Ms Wong-A-Ton is truly inspired with
her answers.

Cheers Adam