I have published a few InfoPath forms that have secondary data connections to a Site (their data connections into a data connection library) and then I saved the site as Site Template.My end goal is to create sites based upon the template. Idea is that I should have working forms that reads data from the site they reside. Everything works fine except the forms are reading data from the site that I used to create Site Template.
Any idea how can I change references without writing code? I was assuming that it will work automatically as we are creating site from same site template and structure is exactly same :(.
I can manually change links in manifest.xsf file but that is not the acceptable solution as I want to empower end user to create sites from the Site Teamplates and they would not like to publish each time they create the site.
Has anyone did this before? If yes please provide some pointers.
Due to the environment restrictions I can not use PowerShell, C#. I have provided SharePoint Designer, InfoPath Designer and admin access on a SharePoint 2007 site.
Thanks