<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Infopath Issue with Promoted Properties</title><link>https://www.infopathdev.com:443/forums/thread/83367.aspx</link><pubDate>Wed, 10 Oct 2012 09:59:09 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:83367</guid><dc:creator>mitalshah30</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/83367.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=83367</wfw:commentRss><description>&lt;p&gt;Hi All,&lt;/p&gt;&lt;p&gt;I am having trouble with infopath promoted properties&lt;/p&gt;&lt;p&gt;I&amp;#39;ve created infopath form based on schema file.&lt;/p&gt;&lt;p&gt; lets say sample xml file looks like below.&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;lt;ns0:CargoBooking&lt;/span&gt;&lt;span&gt; xmlns:ns0&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;strong&gt;&lt;a href="http://xxx.xxx.xxx/CargoBooking"&gt;http://xxx.xxx.xxx/CargoBooking&lt;/a&gt;&lt;/strong&gt;&lt;span&gt;&lt;/span&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;ns1:Booking xmlns:ns1&lt;span&gt;=&lt;/span&gt;&lt;strong&gt;&lt;a href="http://xxx.xxx.xxx/Booking"&gt;http://xxx.xxx.xxx/Booking&lt;/a&gt;&lt;/strong&gt;&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;ns1:BookingRef&amp;gt;1243&amp;lt;/ns1:BookingRef&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/ns1:Booking&amp;gt;&lt;/p&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;p&gt;&lt;span&gt;&lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;ns0:&lt;/span&gt;CargoBooking&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;I am Promoting bookingRef number.&lt;/p&gt;&lt;p&gt;If i create form directly from Library it will promote property, but my solution is integrated with biztalk so if biztalk puts the document, property promotion won&amp;#39;t work. &lt;/p&gt;&lt;p&gt;and input file from biztalk looks like&lt;/p&gt;&lt;p&gt;&lt;span&gt;&amp;lt;ns1:CargoBooking&lt;/span&gt;&lt;span&gt; xmlns:ns1&lt;/span&gt;&lt;span&gt;=&lt;/span&gt;&lt;strong&gt;&lt;a href="http://xxx.xxx.xxx/CargoBooking"&gt;http://xxx.xxx.xxx/CargoBooking&lt;/a&gt;&lt;/strong&gt;&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&amp;lt;ns2:Booking xmlns:ns2&lt;span&gt;=&lt;/span&gt;&lt;strong&gt;&lt;a href="http://xxx.xxx.xxx/Booking"&gt;http://xxx.xxx.xxx/Booking&lt;/a&gt;&lt;/strong&gt;&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;ns2:BookingRef&amp;gt;1243&amp;lt;/ns2:BookingRef&amp;gt;&lt;/p&gt;&lt;p&gt;&amp;lt;/ns2:Booking&amp;gt;&lt;/p&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;div&gt;&lt;p&gt;&lt;span&gt;&lt;/span&gt;&lt;span&gt;&amp;lt;/&lt;/span&gt;&lt;span&gt;ns1:&lt;/span&gt;CargoBooking&lt;span&gt;&amp;gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;Reason behind infopath not promoting property is, Infopath wants exact namesapace variable name, which i think not feasible. from my point of view above both files are same.&lt;/p&gt;&lt;p&gt;Solution tried:&lt;/p&gt;&lt;p&gt;I have opened manifest.xsf file and what i see is, it uses hard coded namespace variable name  for promoted properties like below.&lt;span style="font-size:small;"&gt;&lt;/span&gt;&lt;/p&gt;&lt;p&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;lt;xsf:field&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;name&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;=&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;Booking Ref&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;columnName&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;=&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;{17EA8575-1E9D-4F04-B558-52F12F4C3882}&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;node&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;=&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;/ns0:CargoBooking/ns1:BookingRef&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;type&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;=&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;xsd:string&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;quot;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;gt;&amp;lt;/&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;xsf:field&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&amp;gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/p&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;span style="font-size:small;"&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;p&gt;as per &lt;a href="http://msdn.microsoft.com/en-us/library/office/bb264892(v=office.12).aspx"&gt;http://msdn.microsoft.com/en-us/library/office/bb264892(v=office.12).aspx&lt;/a&gt; artical, node is xpath expression. so i have tried to change it as &amp;quot;/*[local-name()=&amp;#39;CargoBooking&amp;#39; and namespace-uri()=&amp;#39;http://xxx.xxx.com/CargoBooking&amp;#39;/*[local-name()=&amp;#39;BookingRef&amp;#39; and namespace-uri()=&amp;#39;http://xxx.xxx.com/Booking&amp;#39;]&amp;quot; which is valid xpath expression but infopath is not allowing me to republish the form  with changed values. It gives me error saying &amp;quot;Column name BookingRef must be removed or modified from form&amp;#39;s promoted property&amp;quot;.&lt;/p&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;p&gt;Can anybody suggest me any alternate solution as this is very critical problem for our project. I have given very basic example above, our infopath forms have almost 30-35 namespaces and realigning all namespaces according to infopath forms just for sake of promoted properties is very tedious task.&lt;/p&gt;&lt;p&gt;Any help would be appreciated,&lt;/p&gt;&lt;p&gt;Thanks,&lt;/p&gt;&lt;p&gt;Mital&lt;/p&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;</description></item></channel></rss>