RE: Infopath Browser Form - Webservice return value

{\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\lang2052\f0\fs20 Hi Arduk,
\par
\par Sorry for keep you waiting.
\par
\par Yes, I've got one of the Form service team engineer who would like to have a look at this issue. If convenient, would you create a very simple sample packge that contains the webservice code and a simple Form which can repro the problem? You can also include a clear step to do it so that I can forward it to that engineer for some further testing. You can reach me at the following address:
\par
\par "stcheng" + "@" + "microsoft.com"
\par
\par Sincerely,
\par
\par Steven Cheng
\par
\par Microsoft MSDN Online Support Lead
\par
\par
\par Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
\par
\par ==================================================
\par Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.
\par
\par This posting is provided "AS IS" with no warranties, and confers no rights.
\par
\par \pard\li720 --------------------
\par From: =?Utf-8?B?YXJkdWs=?= <arduk@xxxxxxxxxxxxx>
\par References: <3E9B3FBB-5BAA-4987-955E-4E4BB5F83252@xxxxxxxxxxxxx> <3oNvXz1gIHA.1500@xxxxxxxxxxxxxxxxxxxxxx> <97501DE4-060C-4D5D-9717-279007BF99A7@xxxxxxxxxxxxx> <BqjU#nLhIHA.4672@xxxxxxxxxxxxxxxxxxxxxx> <Y$zcQyMiIHA.6844@xxxxxxxxxxxxxxxxxxxxxx>
\par Subject: RE: Infopath Browser Form - Webservice return value
\par Date: Tue, 1 Apr 2008 15:08:03 -0700
\par
\par
\par Hi Steven,
\par
\par Have you made any progress on this?
\par
\par thanks in advance
\par
\par ""Steven Cheng"" wrote:
\par
\par > Hi Arduk,
\par >
\par > Just inform you that I'm still doing research on this.
\par >
\par > Steven Cheng
\par > Microsoft MSDN Online Support Lead
\par >
\par > Delighting our customers is our #1 priority. We welcome your comments and
\par > suggestions about how we can improve the support we provide to you. Please
\par > feel free to let my manager know what you think of the level of service
\par > provided. You can send feedback directly to my manager at:
\par > msdnmg@xxxxxxxxxxxxxx
\par >
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par > --------------------
\par > From: stcheng@xxxxxxxxxxxxxxxxxxxx ("Steven Cheng")
\par > Organization: Microsoft
\par > Date: Thu, 13 Mar 2008 03:26:02 GMT
\par > Subject: RE: Infopath Browser Form - Webservice return value
\par >
\par > Thanks for your reply Arduk,
\par >
\par > So the problem seems quite related to the infopath form side. I'll do some
\par > further research and discuss with some other infopath and xls service
\par > engineers to see whether they have any ideas. I'll keep informing you of
\par > any update I get.
\par >
\par > Sincerely,
\par >
\par > Steven Cheng
\par >
\par > Microsoft MSDN Online Support Lead
\par >
\par >
\par > Delighting our customers is our #1 priority. We welcome your comments and
\par > suggestions about how we can improve the support we provide to you. Please
\par > feel free to let my manager know what you think of the level of service
\par > provided. You can send feedback directly to my manager at:
\par > msdnmg@xxxxxxxxxxxxxx
\par >
\par > ==================================================
\par >
\par > This posting is provided "AS IS" with no warranties, and confers no rights.
\par >
\par >
\par > --------------------
\par > From: =?Utf-8?B?YXJkdWs=?= <arduk@xxxxxxxxxxxxx>
\par > References: <3E9B3FBB-5BAA-4987-955E-4E4BB5F83252@xxxxxxxxxxxxx>
\par > <3oNvXz1gIHA.1500@xxxxxxxxxxxxxxxxxxxxxx>
\par > Subject: RE: Infopath Browser Form - Webservice return value
\par > Date: Tue, 11 Mar 2008 14:00:05 -0700
\par >
\par >
\par > Hi Steven, thanks for getting back to me.
\par >
\par > As mentioned in my first post, I can get the range, and reference
\par > individual
\par > values fine from the infopath form (without code) when it runs in the
\par > client,
\par > using the expression that I included in my original post (ie for a return
\par > value called AnyType, I am using an expression that ends with AnyType[1] to
\par > get the first value)
\par >
\par > The problem occurs when I try to create a browser compatible form - the
\par > compatibility checker returns the error which I quoted in my original post.
\par >
\par > So my questions are:
\par > Is this method of retrieving an array value not supported by Forms Services?
\par > If this is not supported by Forms Services, how do I reference the
\par > individual fields of the array which is returned by the web service
\par > (without
\par > code)?
\par > Is there a method of getting individual values that will work in both
\par > client, and Forms Services browser forms (again, without using code)?
\par >
\par > I have tried to do this using a simple range (ie one cell) but the problem
\par > is the same.
\par >
\par > Thanks in advance
\par >
\par > ""Steven Cheng"" wrote:
\par >
\par > > Hi Arduk,
\par > >
\par > > As for reading range and values through Excel service, here is a MSDN
\par > > reference which mentioned how to get rows and fields from results
\par > returned
\par > > by GetRangeA1 and other methods:
\par > >
\par > > #How to: Get Values from Ranges
\par > > http://msdn2.microsoft.com/en-us/library/ms500767.aspx
\par > >
\par > > for your scenario, have you tried simply call the webservice method to
\par > see
\par > > whether it can return the correct results? Also, I think you can try some
\par > > simpler data(for the excel *** on server) to see whether the problem
\par > also
\par > > specific to some data in the ***.
\par > >
\par > > Sincerely,
\par > >
\par > > Steven Cheng
\par > >
\par > > Microsoft MSDN Online Support Lead
\par > >
\par > >
\par > > Delighting our customers is our #1 priority. We welcome your comments and
\par > > suggestions about how we
\par > >
\par > > can improve the support we provide to you. Please feel free to let my
\par > > manager know what you think of
\par > >
\par > > the level of service provided. You can send feedback directly to my
\par > manager
\par > > at: msdnmg@xxxxxxxxxxxxxx
\par > >
\par > > ==================================================
\par > > Get notification to my posts through email? Please refer to
\par > >
\par > >
\par > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
\par > > ications.
\par > >
\par > > Note: The MSDN Managed Newsgroup support offering is for non-urgent
\par > issues
\par > > where an initial response
\par > >
\par > > from the community or a Microsoft Support
\par > > Engineer within 1 business day is acceptable. Please note that each
\par > follow
\par > > up response may take
\par > >
\par > > approximately 2 business days as the support
\par > > professional working with you may need further investigation to reach the
\par > > most efficient resolution.
\par > >
\par > > The offering is not appropriate for situations
\par > > that require urgent, real-time or phone-based interactions or complex
\par > > project analysis and dump
\par > >
\par > > analysis issues. Issues of this nature are best handled working with a
\par > > dedicated Microsoft Support
\par > >
\par > > Engineer by contacting Microsoft Customer Support Services (CSS) at
\par > >
\par > > http://msdn.microsoft.com/subscriptions/support/default.aspx.
\par > > ==================================================
\par > > This posting is provided "AS IS" with no warranties, and confers no
\par > rights.
\par > >
\par > > --------------------
\par > > From: =?Utf-8?B?YXJkdWs=?= <arduk@xxxxxxxxxxxxx>
\par > > Subject: Infopath Browser Form - Webservice return value
\par > > Date: Mon, 10 Mar 2008 21:30:00 -0700
\par > >
\par > >
\par > > I have an infopath form which I would like to browser enable. The form
\par > > retrieves some data from an Excel spread*** via an Excel Services
\par > > webservice (GetRangeA1).
\par > >
\par > > The form works fine when it runs in the client, however when I try to
\par > > deploy
\par > > it as a browser form the compatibility checker gives the following error:
\par > > "Unsupported Expression"
\par > > and the details are:
\par > > "The following expression could not be parsed because of a syntax error
\par > or
\par > > because it uses an undefined namespace prefix or unsupported function:
\par > >
\par > xsXDocument:GetDOM("GetPriceData")/dfs:myFields/dfs:dataFields/tns:getRangeA
\par > > 1Response/tns:GetRangeA1Result/tns:anyType[1]."
\par > >
\par > > The problem, I believe, is that the GetRangeA1 web service returns an
\par > array
\par > > of data, so in order to use a particular value, I am having to index into
\par > > the
\par > > array. I am doing this as shown above by referencing as "anyType[1]", to
\par > > get
\par > > the first array value.
\par > >
\par > > My questions are:
\par > > Is this method of retrieving an array value not supported by Forms
\par > Services?
\par > > If this is not supported by Forms Services, how do I reference the
\par > > individual fields of the array which is returned by the web service?
\par > > Is there a method of getting individual values that will work in both
\par > > client, and Forms Services browser forms?
\par > >
\par > > Thanks in advance for any assistance on this
\par > >
\par >
\par >
\par >
\par \pard
\par
\par }
Loading