Urn based form template infopath

InfoPath uses the data in this cache to supply data to those controls. To make the data from a secondary data connection available to your users, even if their computers are not connected to a network, you can do one or both of the following:.

After configuring the secondary data connection to work while the user's computer is offline, you can also configure the form template to retrieve the latest data from the external data source. You can configure the form template to retrieve the latest data by limiting the availability of the existing data in the form to a specified number of days and then adding a button to get the latest data.

You can store the data from a secondary data connection in a form template by selecting the Store a copy of the data in the form template check box in the Data Connection Wizard when you create the secondary data connection. When you select this check box, InfoPath uses the data connection to retrieve data from the external data source. It then stores this data in the form template. When a user creates a form or opens an existing form based on your form template, a copy of the form template, along with the stored data, is downloaded to the user's computer.

If the user's computer is connected to a network when the form is created, InfoPath retrieves data from the external data connection whenever the form uses this data connection. If the user is not connected to a network when the form is created, InfoPath uses the data that is stored in the form template on the user's computer. Because the data was retrieved at the time that the data connection was created, the external data source may have been updated by the time a user creates a form based on this form template.

If you want your users to receive the latest data from an external data source when they create a new form or open an existing form based on your form template, you should design your form to use a secondary data connection when the form first opens. If you want your users to receive the latest data from an external data source, rather than using the data stored in a form template, select the Automatically retrieve data when form is opened check box in the Data Connection Wizard when you create the secondary data connection.

When a user creates a new form while connected to the network, InfoPath uses this secondary data connection to retrieve the latest data from the external data source. This data is stored in the cache. If the user opens an existing form that is saved on their computer, InfoPath checks if the computer is connected to a network.

If the computer is connected to a network, InfoPath retrieves the latest data from the external data source by using this data connection. If the user is working offline, InfoPath uses the data stored in the cache or in the form template.

Security Note: The data retrieved from a secondary data source is stored in the computer as plain text. If you are using a secondary data connection to retrieve sensitive data from an external data source, you may want to disable this feature to help protect the data from unauthorized use in case the computer is lost or stolen.

If you disable this feature, the data will be available only if the user is connected to the network. If an external data source is regularly updated, you can configure a form template to allow users to retrieve the latest data through the secondary data connection.

To do this, you can limit the availability of the data that is currently stored in the cache to a specified number of days, and then you can add a button to retrieve data from any external data sources by using all of the secondary data connections in the form.

Doing this helps ensure that users are working with the most recent data. Alternatively, you can limit the availability of data from a secondary data connection by setting an expiration date on how long that you want data to be stored on a user's computer. When you use this option, InfoPath makes the data from all secondary data connections available to the form for only the specified number of days. After that number of days has passed, the data will not appear in the form. You can then add a button to your form that users can click to retrieve data, by using a specific secondary data connection or all of the secondary data connections in the form.

The data will only be overwritten when the operating system uses this space to store something else. Before you add a secondary data connection to a Microsoft SQL Server database to your form template, you need the following information from your database administrator.

The authentication required by the database. The database can use either Microsoft Windows authentication or SQL Server authentication to determine how users can access the database. The name of the table that contains the data that you want to send to the form.

This is the primary table. If you plan to use more than one table in the database, you need the names of those other, child tables. You also need the names of the fields in the child tables that possess relationships to the fields in the primary table. Once you get this information, you can use the following procedure to create the data connection to a SQL database for offline use.

In the Server name box, type the name of the server where the database is stored. If the database determines who has access to the server based on the credentials used in a Microsoft Windows network, click Use Windows Authentication. If the database determines who has access to the server based on a specified user name and password that you get from the database administrator, click Use the following User Name and Password , and then type that user name and password in the User Name and Password boxes.

On the next page of the wizard, in the Select the database that contains the data you want list, click the database that you want to use, select the Connect to a specific table check box, click the name of the primary table, and then click Next. On the next page of the wizard, in the File Name box, type a name for the file that stores the data connection information. In the Add Table or Query dialog box, click the name of the child table, and then click Next.

InfoPath attempts to set the relationships by matching field names in both tables. If you do not want to use the suggested relationship, select the relationship, and then click Remove Relationship.

To add a relationship, click Add Relationship. In the Add Relationship dialog box, click the name of each related field in the respective column, and then click OK. If you want the data from this secondary data connection to be available even if a user's computer is not connected to a network, select the Store a copy of the data in the form template check box. When you select this check box, InfoPath queries the external data source and stores the results in the form template.

Security Note: Selecting this check box stores the query results in the form template. Error, cannot find template when opening a file. When opening a file sent to me, I first save the file locally and then opening either from Infopath or from the document, I get the error that it cannot find the template. It is saved as filename. Cannot see field data as I am typing in InfoPath Post a reply. Blank fields after query??????

Hi all, I need help! This is a tough question but I will try to explain. I have a computer user ID form that is used to track an employee's access to different systems. Here is the issue: If I want to modify an existing entry the form user will choose Modify from a main action page. Then the user is taken to another view and has to put the employees NT Logon in a query box and run the query to return the existing permissions system name, logon, date added, and date removed.

SO the Logon is entered and the button is pushed to run the query and the repeating table of the existing info is returned in a read only format all except for the date remove which can be added at this point if it applies. No Problem!

Now the issue is to have a new blank repeating table that did not get populated during the query phase of this operation so that additional permissions may be granted. How do I get these fields to stay blank? Or is there a way to clear them? I currently have them in another view but they get populated at the same time as the rest of the views don't they?

Search forums. Log in. Install the app. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Infopath URN Based form template cannot be found.

Thread starter Joe Estes Start date May 31, Joe Estes. Hi, I'm having a problem opening a infopath form from sharepoint services. In sharepoint all the necessary files are in the form library including the xml template.

When i click fill out this form in sharepoint, the form is supposed to openn in infopath. In infopath i get the error: This form is associated with a URN-based form template, which cannot be found on your computer. Kalyan Reddy. Hi, Try editing the template in the sharepoint and save it to the Local machine and open the template in design mode and then publish the same template to your form library overwrite the existing template.