Need to update the InfoPath 2003 Promoted Columns from SharePoint Designer

[choudharyn]

Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.

I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.

A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,

If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If

But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!

Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.

Any help would be highly appreciated.
Thanks in advance.

 

[David Dean]

InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.

 

[choudharyn]

David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.

Any help!!
Thanks again.
Choudhary

InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.

I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.

A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,

If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If

But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!

Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.

Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -

- Show quoted text -

 

[David Dean]

You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.

Any help!!
Thanks again.
Choudhary

InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.

I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.

A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,

If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If

But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!

Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.

Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -

- Show quoted text -

 

[choudharyn]

Thanks again for your reply David.
I am now trying to use the Lists.asmx but when I try to connect to my
server at http://<myservername>/_vti_bin/Lists.asmx
I cannot see the list of operations but get an error mesage.

"InfoPath cannot find or cannot access the specified Web service
description."

The Show Detail section has this error:

"The file is not a valid XML file.
The file is not a valid XML document.
A document must contain exactly one root element.
Line 1, Position 0"

Any idea about this.

You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.

Any help!!
Thanks again.
Choudhary

InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.
I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.
A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,
If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If
But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!
Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.
Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[David Dean]

Did you append the ?WSDL argument to the URL?
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Thanks again for your reply David.
I am now trying to use the Lists.asmx but when I try to connect to my
server at http://<myservername>/_vti_bin/Lists.asmx
I cannot see the list of operations but get an error mesage.

"InfoPath cannot find or cannot access the specified Web service
description."

The Show Detail section has this error:

"The file is not a valid XML file.
The file is not a valid XML document.
A document must contain exactly one root element.
Line 1, Position 0"

Any idea about this.

You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.

Any help!!
Thanks again.
Choudhary

On Sep 5, 9:30 pm, David Dean <[email protected]>
wrote:
InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.

:
Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.

I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.

A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,

If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If

But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!

Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.

Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[choudharyn]

Yes I did.

Did you append the ?WSDL argument to the URL?
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Thanks again for your reply David.
I am now trying to use the Lists.asmx but when I try to connect to my
server at http://<myservername>/_vti_bin/Lists.asmx
I cannot see the list of operations but get an error mesage.

"InfoPath cannot find or cannot access the specified Web service
description."

The Show Detail section has this error:

"The file is not a valid XML file.
The file is not a valid XML document.
A document must contain exactly one root element.
Line 1, Position 0"

Any idea about this.

You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.
Any help!!
Thanks again.
Choudhary
On Sep 5, 9:30 pm, David Dean <[email protected]>
wrote:
InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.
I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.
A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,
If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If
But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!
Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.
Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[David Dean]

Is your site collection at the root of the web application? If not, you would
need to specify the url of the top-level site followed by the web service
url; e.g.

http://server/sites/mysite/_vti_bin/Lists.asmx?WSDL

Here's an article that describes an alternative way to retrieve SharePoint
list data:

http://blogs.msdn.com/infopath/arch...ing-form-data-from-sharepoint-list-views.aspx


--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Yes I did.

Did you append the ?WSDL argument to the URL?
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Thanks again for your reply David.
I am now trying to use the Lists.asmx but when I try to connect to my
server at http://<myservername>/_vti_bin/Lists.asmx
I cannot see the list of operations but get an error mesage.

"InfoPath cannot find or cannot access the specified Web service
description."

The Show Detail section has this error:

"The file is not a valid XML file.
The file is not a valid XML document.
A document must contain exactly one root element.
Line 1, Position 0"

Any idea about this.

On Sep 6, 11:42 am, David Dean <[email protected]>
wrote:
You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.

:
David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.

Any help!!
Thanks again.
Choudhary

On Sep 5, 9:30 pm, David Dean <[email protected]>
wrote:
InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.

:
Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.

I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.

A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,

If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If

But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!

Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.

Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[choudharyn]

Thanks David for your reply.
I figured that out and now I am able to connect to my server to see
the list of all available web services.
Now when I select the "GetListItem" , click next, I get a screen where
I need to set few parameters with the sample values.

Not sure how to do this. Moreover, I need to query my sharepoint list
which should return me a column value for the selected record (I have
a Document No as the primary key in the list as well as in the
InfoPath 2003 form.)

How do I do this.
Thanks again for all your help.
Choudhary.

Is your site collection at the root of the web application? If not, you would
need to specify the url of the top-level site followed by the web service
url; e.g.

http://server/sites/mysite/_vti_bin/Lists.asmx?WSDL

Here's an article that describes an alternative way to retrieve SharePoint
list data:

http://blogs.msdn.com/infopath/archive/2007/01/15/populating-form-dat...

--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.

Yes I did.

Did you append the ?WSDL argument to the URL?
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
Thanks again for your reply David.
I am now trying to use the Lists.asmx but when I try to connect to my
server at http://<myservername>/_vti_bin/Lists.asmx
I cannot see the list of operations but get an error mesage.
"InfoPath cannot find or cannot access the specified Web service
description."
The Show Detail section has this error:
"The file is not a valid XML file.
The file is not a valid XML document.
A document must contain exactly one root element.
Line 1, Position 0"
Any idea about this.
On Sep 6, 11:42 am, David Dean <[email protected]>
wrote:
You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.
Any help!!
Thanks again.
Choudhary
On Sep 5, 9:30 pm, David Dean <[email protected]>
wrote:
InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.
I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.
A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,
If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If
But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!
Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.
Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

 

[choudharyn]

Thanks David for all your help.
I really appreciate your prompt responses.

I was able to figure out my stuff through a web service for the second
alternative way.
Also thanks to Kit Kai's Blog post at the below url:

http://community.sgdotnet.org/blogs..._3A00_-Setting-up-the-Web-Services_2E00_.aspx

which also helped me to resolve my issue quickly.

Thaks again to both of you.
Choudhary

Thanks David for your reply.
I figured that out and now I am able to connect to my server to see
the list of all available web services.
Now when I select the "GetListItem" , click next, I get a screen where
I need to set few parameters with the sample values.

Not sure how to do this. Moreover, I need to query my sharepoint list
which should return me a column value for the selected record (I have
a Document No as the primary key in the list as well as in the
InfoPath 2003 form.)

How do I do this.
Thanks again for all your help.
Choudhary.

Is your site collection at the root of the web application? If not, you would
need to specify the url of the top-level site followed by the web service
url; e.g.

Here's an article that describes an alternative way to retrieve SharePoint
list data:

Yes I did.
On Sep 6, 3:40 pm, David Dean <[email protected]>
wrote:
Did you append the ?WSDL argument to the URL?
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
Thanks again for your reply David.
I am now trying to use the Lists.asmx but when I try to connect to my
server at http://<myservername>/_vti_bin/Lists.asmx
I cannot see the list of operations but get an error mesage.
"InfoPath cannot find or cannot access the specified Web service
description."
The Show Detail section has this error:
"The file is not a valid XML file.
The file is not a valid XML document.
A document must contain exactly one root element.
Line 1, Position 0"
Any idea about this.
On Sep 6, 11:42 am, David Dean <[email protected]>
wrote:
You would probably need to use the SharePoint Lists.asmx web service to get
the details of the list item corresponding to the URL of the document. This
assumes that you have enough information in your form to determine the url of
the XML file in the SharePoint list. There is an article on the InfoPath Team
Blog that discusses how to define a data connection that uses the Lists web
service.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
David,
Thanks for your reply.
But we just have InfoPath 2003 and have to live with that.
So in this scenario, how do you suggest my alternative approach to be
achieved.
How do I get the pointer of my Secondary Data Source to move to the
current record.
Any help!!
Thanks again.
Choudhary
On Sep 5, 9:30 pm, David Dean <[email protected]>
wrote:
InfoPath 2003 does not create promoted properties that are visible as columns
in the SharePoint list. You will probably need to use InfoPath 2007 to
republish the form template so that you can map the IsPublished element in
the form to a corresponding column on the form library. You may need to save
the form template in InfoPath 2003 compatibility mode so that InfoPath 2003
users can work with it.
--
David Dean
Sr. Member Technical Staff
Insource Technology Corp.
:
Hi,
Please help me in this crisis situation. SharePoint sometimes makes
things look so scarry that I start deviating from the thought that
MOSS has really picked up to a very competitive market.
I have a InfoPath 2003 form and have promoted several columns to a
Form Library in SharePoint 2007. One of the promoted columns is the
[IsPublished] field.
Another column, which I had directly created in the Form Library is
[PublishStatus].
I am also using SharePoint Designer 2007 for the workflow.
A web part on the portal is used to update the column [PublishStatus]
= "PUBLISHED".
Now I have a step in the workflow which triggers based on this
criteria,
If [PublishStatus] = "PUBLISHED" Then
Here I need to update the promoted column [IsPublished]
End If
But I cannot see the promoted columns in the Sharepoint designer
Workflow and hence not able to update the promoted column. Any idea or
help !!!!
Alternatively, I can think of getting the value of the
[PublishStatus] column in the OnLoad event of the InfoPath form. I
tried doing this by adding a Data Connection to "Receive" from the
SharePouint List. But this is always returning the value of the
[PublishStatus] column of the FIRST row in the Form Library. Whereas
my current row pointer may be anywhere as the Library may have more
than 500 documents. Hence the returned value is not correct. Is there
a way out to move the record pointer to the correctly point out to the
current row.
Any help would be highly appreciated.
Thanks in advance.- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -