Field value not being populated to promoted column in Form Library

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Clayden - 04 Sep 2007 15:42 GMT

In Infopath 2007 I am designing a form template for use in a Sharepoint Form
Library. In the Dataconnection wizard I am giving the File Name as a field
value that the form will capture (lets say it is PCName, for example).
During publishing, I Add a column for this same field value and give it a
more descriptive name for it to be promoted as a column in Sharepoint (lets
say this is My Column, for example).

Everything publishes fine.

However, in the Form Library in Sharepoint, 2 things are happening. Firstly,
the obligatory Name column has inherited the PCName value (this seems to be
controlled at a List Content Type admin level). Secondly, and where my
problem lies, is that there is no populated value for PCName in My Column
even though the column has been promoted succesfully as a column. It is
supposed to be populated by the PCName field value that was defined earlier
in Infopath.
How is this happening, since no other values or columns are being "dropped"
in the Form Library?

Any help gratefully received.

Reply to this Message

David Dean - 06 Sep 2007 03:44 GMT

The Name column will always contain the filename of the XML document. This
has nothing to do with promotion, but is based on the value of the filename
expression used to submit the document (assuming you're using the SharePoint
submit adapter).

If the value from your PCName element is not being promoted to the
SharePoint list column, look at the advanced settings for the library to make
sure the template URL is the absolute URL of the form template .XSN file. If
the library allows multiple content types, check the template URL of the
content type. You may need to use the Relink Documents view to relink the
content types of any forms that already exist in the library. The template
URL in each form document must match the template URL of the assocuated
content type.

Signature

David Dean
Sr. Member Technical Staff
Insource Technology Corp.

> In Infopath 2007 I am designing a form template for use in a Sharepoint Form
> Library. In the Dataconnection wizard I am giving the File Name as a field
[quoted text clipped - 16 lines]
>
> Any help gratefully received.

Reply to this Message

Rob Clayden - 06 Sep 2007 10:24 GMT

Hi David,

OK this is looking promising but I have encountered 2 problems now. I went
to the advanced settings for the library and found that the url was
incorrect, but it is greyed out so I cannot edit it!
Also when I tried the relink of content types I get an error but maybe this
is related to the first problem (i.e. if the url is wrong how can it relink?).

How do I reset the url in advanced settings? Everything else seems to work
fine.

Rgds,

Rob Clayden

> The Name column will always contain the filename of the XML document. This
> has nothing to do with promotion, but is based on the value of the filename
[quoted text clipped - 30 lines]
> >
> > Any help gratefully received.

Reply to this Message

David Dean - 06 Sep 2007 12:16 GMT

The url in Advanced settings for the library is disabled because the library
is marked with "Allow management of content types". You need to click the
appropriate content type further down on the Settings page and then choose
the Advanced settings for that content type to set the template URL.

When a library has multiple content types, SharePoint determines the content
type of the form by matching the URL of the processing instruction inside the
form XML document with the template URL of the content type. If it can't find
an exact match, it assigns the default content type for the library, which
may be incorrect.

Signature

David Dean
Sr. Member Technical Staff
Insource Technology Corp.

> Hi David,
>
[quoted text clipped - 45 lines]
> > >
> > > Any help gratefully received.

Reply to this Message