Newbie Questions

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Tue, 31 Mar 2009 13:28:58 GMT

Not a permissions issue. I can select any field in the document library using the default datasource in SharePoint, with the exception of the name of a file. This is the one field that I need though. Asking in a SharePoint forum, they have suggested that I need to get the onetIDIOFile text value, but that is where their help ended.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Fri, 20 Mar 2009 19:12:43 GMT

Could it be permission issue? Try to datamine SP logs. Check your permissions on all lookup lists related to your library.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Fri, 20 Mar 2009 18:34:47 GMT

okay, that's just wierd. If there are no items in the library it works, but it gives me all of the column info and that's what it lets me select. As soon as I put an item in the library, blank page and the data connection doesn't work anymore.

This is what I get with en empty library

- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">

- <s:Schema id="RowsetSchema">

- <s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">

- <s:AttributeType name="ows_DocIcon" rs:name="Type" rs:number="1">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_LinkFilename" rs:name="Name" rs:number="2">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Modified" rs:name="Modified" rs:number="3">

<s:datatype dt:type="datetime" dt:maxLength="8" />

</s:AttributeType>

- <s:AttributeType name="ows_Editor" rs:name="Modified By" rs:number="4">

<s:datatype dt:type="string" dt:lookup="true" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Revision" rs:name="Revision" rs:number="5">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Document_x0020_Type" rs:name="Document Type" rs:number="6">

<s:datatype dt:type="string" dt:lookup="true" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Discipline" rs:name="Discipline" rs:number="7">

<s:datatype dt:type="string" dt:lookup="true" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Req_x002e__x0020_Engr_x002e_" rs:name="Req. Engr." rs:number="8">

<s:datatype dt:type="string" dt:lookup="true" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Trans_x002e__x0020_No_x002e_" rs:name="Trans. No." rs:number="9">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Document_x0020_Status" rs:name="Document Status" rs:number="10">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Item_x0020__x0023_" rs:name="Item #" rs:number="11">

<s:datatype dt:type="string" dt:lookup="true" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_RFQ_x0020__x0023_" rs:name="RFQ #" rs:number="12">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Client_x0020_PO_x0020__x0023_" rs:name="Client PO #" rs:number="13">

<s:datatype dt:type="string" dt:maxLength="512" />

</s:AttributeType>

- <s:AttributeType name="ows_Vendor" rs:name="Vendor" rs:number="14">

<s:datatype dt:type="string" dt:lookup="true" dt:maxLength="512" />

</s:AttributeType>

</s:ElementType>

</s:Schema>

<rs:data />

</xml>

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Fri, 20 Mar 2009 17:42:57 GMT

I have no idea why it might happen. Try run "iisreset" comand on the server. With wrong parameters you have to get error page at least.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Fri, 20 Mar 2009 17:20:56 GMT

when I enter the link into a browser it shows a blank page.

when I enter it as the datasource, the error I get states that I need at least one item. (There are 4 items right now for testing.)

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Fri, 20 Mar 2009 17:09:31 GMT

What kind of message are you getting?

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Fri, 20 Mar 2009 16:55:29 GMT

For some reason, I'm not getting any results when I post this into a browser.

http://moss-dev/client%201/dem-001-01/_vti_bin/owssvr.dll?Cmd=Display&List={624C2E3B-7B90-4538-B767-DAD5842AC65D}&View={301C9016-55F8-4720-8CB9-CDBAA8AF7DBB}&XMLDATA=TRUE

Any thoughts on why that would be?

(I was getting some results yesterday, and I figured out how to get the field to update the way that I needed, now I'm not having any luck.)

Re: Selecting SharePoint data in a dropdown. But not the whole list.

SSCTAC — Fri, 20 Mar 2009 16:02:22 GMT

Thanks, this is great and worked for me. However, when I publish the data back to my Forms Library, the email field has these extra characters in the field.

140;#user@company.com

How do I get the 140;# to not show up?

Any ideas? Thanks!

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Fri, 20 Mar 2009 14:19:36 GMT

One more note. Another possibility I would consider is to redesign your library in the way where fields you want as drop down sources will be lookup ones from different lists. That setup will be much easier to implement and it'll return more precise data because search results stays the same in between crawls.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Thu, 19 Mar 2009 21:22:11 GMT

Well, I never did it by myself but if I would be tasked I'd tried the following:

1) Download this: http://techdhaan.wordpress.com/2008/05/09/sharepoint-search-web-service-query-tool/

2) In the query interface chose somthing ( I dont remember) about exclude duplicates.

3) connect responce xml from Search.asmx to your form.

4) Populate dropdowns with Search results.

Hope it will help. Let me know if you were successful.

P.S. To optimize it even more you could resend your updated query each time as new dropdown value is populated.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Thu, 19 Mar 2009 21:10:18 GMT

Got it. You need distinct values for certainn columns. Let me think about it.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Thu, 19 Mar 2009 20:33:08 GMT

Well I got it to work, but that's not what I needed. It does the exact same thing as connecting to the sharepoint datasource. I don't know how to explain without actually "showing" it to somebody what I'm trying to accomplish. Thanks for your help though.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Thu, 19 Mar 2009 18:50:28 GMT

nvm, I think I got it. Damn capitalization.

Re: Selecting SharePoint data in a dropdown. But not the whole list.

slingeronline — Thu, 19 Mar 2009 18:49:21 GMT

Sorry, it's been a while since I've been able to try. Unfortunately, it still doesn't work. I get an error when I try and enter the link into IE. Below is my link.

http://moss-dev/client%201/dem-001-01/_vti_bin/owssvr.dll?cmd=Display&List={6F68895B%2D8001%2D45D6%2DAD64%2DA86223E93727}&View={EF160A6D%2D51D5%2D401A%2DA93A%2DAE48FA11F985}&XMLData=True

not sure what I'm doing wrong here. The error message that I get is "cannot complete this action."

Re: Selecting SharePoint data in a dropdown. But not the whole list.

Alec Pojidaev — Thu, 12 Mar 2009 13:40:35 GMT

Well, if you able to navigate to constructed link and chosed "Access data from cpecified location" option it should work.

Below you will see example of resulting data you should be able to see in browser if your link is constructed properly.

<s:Schema id="RowsetSchema">

<s:ElementType name="row" content="eltOnly" rs:CommandTimeout="30">

<s:AttributeType name="ows_dwTitle" rs:name="dwTitle" rs:number="1">

<s:datatype dt:type="string" dt:maxLength="1073741823" /> </s:AttributeType>

</s:ElementType>

</s:Schema>

- <rs:data>

<z:row ows_dwTitle="Yellow Pages Association" />

<z:row ows_dwTitle="Test 1" />

<z:row ows_dwTitle="TEST AGAIN!" />

</rs:data>

</xml>