Way to modify the "URL" of sharepoint library in Data Connection

[Ram]

Hi All,

Sharepoint server is hardcoded in the form data connection properties
=============================================

Currently, when developing a form, we connect it to a specific (dev)
Sharepoint site. Therefore, when the form is sent from dev to staging to
production, someone has to edit the form and change the reference to the
correct Sharepoint site at each stage. Is there any way to update these
references in a consistent manner during deployment (may be by having a
config file similar to web.config or ....)

Similarly are there way in which if i can specify where to publish this form
in sharepoint location will it do (an msi for ex).

Thx in advance,
Ram

 

[Patrick Halstead [InfoPath MVP]]

If the issue is with references in your form's code, you will want to refer
to the Solution.URI. I think Matthew Blain posted on this previously.
If the issue is with xml forms, then you can use the relink feature in
SharePoint.

This is something that should be improved in a future release of InfoPath
since it is confusing.

 

[Ram]

Thx Patrick for your reply.

my issue is that some mechanism used to edit the data connections (either
with a tool, but not wirh Infopath) before publishing to sharepoint.

Ram

 

[Patrick Halstead [InfoPath MVP]]

Hi Ram,
Can you explain a tad bit more? You say "some mechanism used to edit the
data connections ...". What is that mechanism?
Patrick

 

[Steve van Dongen [MSFT]]

"What is that mechanism?" is his question. He's asking for a tool to
modify the sharepoint library URL at deployment time instead of at
runtime.

Basically you need to unpack the XSN, modify the URLs in manifest.xsf,
and repackage the XSN. The setup tool for the PO_WebService SDK
sample does this. If you want, install the SDK and take a look at
setup.hta and the associated JS files in the setup tool in C:\Program
Files\Microsoft Office 2003 Developer Resources\Microsoft Office
InfoPath 2003 SDK\Samples\PO_WebService\setup.

Regards,
Steve

 

[Ram]

Hi Patrick,

I am looking for something like config file, in which i can modify the
URL (sharepoint document library) of the data connection.

I am looking for some way, may be by using APIs in which I can load
infopath xsn template, modify its data connection property.

Thx & Best Regards
Ram
=============

 

[Patrick Halstead [InfoPath MVP]]

Hi Ram,
Well, isn't it just better not to have to config it? If you use the
Solution.URI, you should not need to modify it. Where do you currently have
the URL in your code? How are you using it? Maybe you don't need to config
at publish time.
Patrick

Hi Patrick,

I am looking for something like config file, in which i can modify the
URL (sharepoint document library) of the data connection.

I am looking for some way, may be by using APIs in which I can load
infopath xsn template, modify its data connection property.

Thx & Best Regards
Ram
=============

"Patrick Halstead [InfoPath MVP]" <patrick.halstead_AT_InfoPathDev.com>

 

[Patrick Halstead [InfoPath MVP]]

Hi Steve,
Thanks for the clarification. Obviously it's better not to have to do this,
but the link to the setup.hta is a good one.
Ciao!