SharePoint Integration

Re: Double Comma on Names Pulled from Sharepoint

tborja — Wed, 09 Jan 2013 21:29:44 GMT

Thanks for the tip! I was having this same issue when previewing the form in InfoPath. As soon as a I published it to SharePoint everything worked fine.

Re: Double Comma on Names Pulled from Sharepoint

poppyq — Fri, 04 Jan 2013 22:20:08 GMT

Actually, this issue was only present in an Infopath client form. Once I published it to SharePoint (web-enabled) the double commas disappeared. This was an acceptable solution for me as it was meant to be a web-enabled form.

Re: Double Comma on Names Pulled from Sharepoint

jtweetybird — Fri, 04 Jan 2013 21:02:33 GMT

Has this ever been resolved? I to am experiencing the same issue with the same view of the drop down already provided.

Re: Double Comma on Names Pulled from Sharepoint

poppyq — Thu, 13 Sep 2012 17:31:13 GMT

I'm having this happen. Here's a screenshot. I'm using a People column in SharePoint for presence, then pulling it into a dropdown list via a data connection and displaying the "DisplayName" field.

Re: Double Comma on Names Pulled from Sharepoint

Hilary Stoupa — Tue, 07 Aug 2012 21:07:14 GMT

Okay, so now in your form, drag the secondary data source data fields onto your form and preview it - I'd like to see a screenshot of the data with the extra comma.....

Re: Double Comma on Names Pulled from Sharepoint

Jen B — Tue, 07 Aug 2012 20:20:09 GMT

Oh the days I wonder where my brain is... absolutely amazing.

Okay, I actually followed your directions (correctly this time) and looks like the data from AD does only have one comma. A snippet of some of the data is below... I'm pulling over the ows_name information.

<z:row ows_Attachments="0" ows_LinkTitle="108MS\aking23" ows_email="45860;#alvin_d_king@uhc.com" ows_name="45860;#King, Alvin D" ows_group="1;#A&G" ows_active="1" />

<z:row ows_Attachments="0" ows_LinkTitle="129MS\mmaest2" ows_email="45895;#matilda.maestas@uhc.com" ows_name="45895;#Maestas, Matilda" ows_group="1;#A&G" ows_active="1" />

<z:row ows_Attachments="0" ows_LinkTitle="264MS\jbrune2" ows_email="33818;#jennifer_l_brune@uhc.com" ows_name="33818;#Brune, Jennifer L" ows_group="1;#A&G" ows_active="1" />

<z:row ows_Attachments="0" ows_LinkTitle="12MS\lbeach2" ows_email="274;#lisa_beach@uhc.com" ows_name="274;#Beach, Lisa R" ows_group="2;#Design-Curriculum"

So, I'm still lost as to why IP is adding another comma to it.

Re: Double Comma on Names Pulled from Sharepoint

Hilary Stoupa — Tue, 07 Aug 2012 15:09:02 GMT

I should have stated to replace the placeholders here as well:

http://yourserver/yourweb

with the actual URL to your SharePoint site where the list is. Did you do that?

Re: Double Comma on Names Pulled from Sharepoint

Jen B — Tue, 07 Aug 2012 14:35:12 GMT

Hi Hilary,

I found my GUID, e74ed205-13c1-45ae-8198-20890d6aef50, placed it in the URL you provided, and used that URL in my address bar. The result was an error stating IE couldn't display the page. Sorry, perhaps I misunderstood what I should do with the URL.

Thanks

Re: Double Comma on Names Pulled from Sharepoint

Hilary Stoupa — Fri, 03 Aug 2012 20:00:38 GMT

I've not seen anything like this before. I guess first what I'd do is verify the data is what I think it is in SharePoint - I'd take a look at it in the browser. Since you are using MOSS 2007, I'd use an owssvr.dll URL - they look like this:

http://yourserver/yourweb/_vti_bin/owssvr.dll?Cmd=Display&List={guid}&XMLDATA=TRUE&noredirect=true

With "guid" replaced with your list GUID - if you go to the list settings page, that's in the URL, and you can use an online decoder (like this one) to decode it. Then you'll be able to see the actual data in the list - what's it look like?

Re: Double Comma on Names Pulled from Sharepoint

Jen B — Fri, 03 Aug 2012 16:13:03 GMT

No takers, eh?

Double Comma on Names Pulled from Sharepoint

Jen B — Thu, 02 Aug 2012 15:31:47 GMT

Morning,
Okay, here's the setup... we're using IP 2010 and MOSS 2007. Our users need to be able to assign requests that come in to different people on different teams who then are notified of the assignment. We set this up by creating a sharepoint list where people are assigned to groups/teams. The names are grabbed by the person or group field in sharepoint so we can use the email in the active directory.

Everything works fine using filters on different dropdowns to get the correct list of names BUT an extra comma is added to the names (e.g. LastName,, FirstName). This then causes a problem because sharepoint/active directory can't find the user's email to send the notification.

Because we couldn't figure out what was happening to add the double comma, we created a workflow that goes to those fields on submission and finds the double comma and replaces with a single comma. It technically works, but the timing is causing problems due to the various times names are added. I've been playing with how to get the timing to work, but am wondering if finding a solution to the initial double comma issue would be more adventageous.

Has anyone out there run into this issue and found a solution? Or just have thoughts on where I could start looking to resolve the problem? The sharepoint list shows the names with just one comma, so there's something happening when the data is pulled into IP.

Thanks!

Jen