.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Why is GetListItems returning rubbish as field names?

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :SharePoint
Always wondered, why? I need to write a complex SSIS package that will copy all of the sharepoint lists into sql database (because M$ were too stupid to let users do rich reporting on the sharepoint server, you have to dupe the lists into another database to do reports on them) Problem is, if i query for list, i get something like this: <Field Type="User" DisplayName="??? ??????????" List="UserInfo" Required="FALSE" ShowField="ImnName" UserSelectionMode="PeopleOnly" UserSelectionScope="0" Group="??????????м?? ???????" ID="{888f100e-1488-4662-af86-413a05dc3506}" SourceID="{bfad9184-4660-4714-a773-b2803c9941f3}" StaticName="???_x0020_??????????" Name="_x0424__x0418__x041e__x0020__x04" Hidden="FALSE" Customization="" ReadOnly="FALSE" PITarget="" PrimaryPITarget="" PIAttribute="" PrimaryPIAttribute="" Aggregation="" Node="" ColName="int1" RowOrdinal="0" /> <Field Type="DateTime" DisplayName="?????? ?" Required="TRUE" Format="DateOnly" Group="??????????м?? ???????" ID="{635dd517-ab59-4cd3-91eb-54a1f679a07b}" SourceID="{bfad9184-4660-4714-a773-b2803c9941f3}" StaticN

View Complete Post

More Related Resource Links

Adv Search not returning calcuated field

I have a custom column associated with one of my content types, which I've set up as a Managed Property under Central Administration, and added to the Properties filter on my Adv Search page.  When I select this property in Adv Search, and specify a value that I now exists (on several documents), I get no results.  Non-calculated custom properties that I've set up work fine. Any ideas if there is some special config/requirement for search to return results based on caclulated column values? I set this up as follows: 1. Created the custom column on the content type 2. Created a managed property that maps to the crawled column "ows_MyCalculatedField" (in the mapped properties page this column showed up under Crawled Properties) 3. I reset the index and then ran a full crawl 4. I updated the Adv Search screen web part and added the column to the web part XML that defines what properties appear in the Properties picker list (the property shows up fine and I can select it and run a search) However, when i run the search for any value in the field, I get no results.  And I know there are documents that have the values I entered. Thanks

How to insert a name field on an InfoPath path that allows you to insert names from the AD directory

How can I set up a field on an Infopath form so that when I click on a "Check Names" button, (exactly the same way it works on a SharePoint point Name field), the name is checked against the AD directory? I am not trying to control user access to sections of the form - I am simply adding names to the form that is collecting data on a task - such as Delivery Lead, Designer, etc.

Assigning XML Tag Names Within ASP Web Service Returning Jagged Array



I am using an ASP webservice to return a jagged array.  I need to be able to define the tags names in the XML which is returned.  How do I do this?


Code and Example XML follow.




        orderListId = new string[100];
        orderListTime = new string[100];
        orderListEmail = new string[100];
        orderListStatus = new string[100];
        orderListSubtotal = new string[100];

        int orderCount = 0;
        foreach (DataRow drRow in dtResult.Rows)
            orderListId[orderCount] = (drRow["SubmittedFormId"].ToString());
            orderListTime[orderCount] = (drRow["SubmitTime"].ToString());
            orderListEmail[orderCount] = (drRow[&quo

Report Builder returning #Error value in empty fields and working with Date field


Hey guys,

I am trying to build a report using the date field from CRM and only wanting to return the date I am using this expression "=Fields!new_date.Value.ToShortDateString()" but when there is an empty fiel I get #Error. How do I solve this?

Also is there anyway to return the date field with the actual month showing instead of the numerical value? i.e. instead of 1/31/2010 Have it show January 31, 2010 (Doesn't have to be exactly in that format, but want the name value for the month.)

SPQuery returning error "One or more field types are not installed properly. Go to the list settings



SPQuery is not working properly, its throwing following exception.

"One or more field types are not installed properly. Go to the list settings page to delete these fields."

Please check the code snippet below:

SPSite spsite = new SPSite("siteurl");

SPWeb site = spsite.OpenWeb();

SPList list = site.Lists["listname"];

SPQuery query = new SPQuery();

query.Query = "<Where><Eq><FieldRef Name='ServiceLevel'/><Value Type='String'>345</Value></Eq></Where>";

SPListItemCollection items = list.GetItems(query);

Resolve AD names to Display names in SharepointDesigner Workflow emails for multiple user field



Is there a way I can resolve multiple users in a "People and Group" field to thier display name rather than Ad name in sharepoint when doing a designer workflow . The workflows job is send the mail to the business owners and request request that a certain permission be granted to User A, UserB, User C,...and so on.

SPD activities Linktitle action to my understanding only resolves a single user.





how to automaticly put user names in a template field



I am using the helpdesk template from microsoft, and when users are requesting a service request I would like to have their name automatically apear in customer field, is there a way to do this?

server windows 2003 r2

sharepoint services 3.0


Eric Hendrickson

Creating a list with non-english field names in Sharepoint 2010 from visual studio


Hi experts,

I created a sharepoint list instance in visual studio 2010 with English field names and not-english display-names.

when I deploy the solution and browse to the list I get non-readable field names. I tried to add
"xml version="1.0" encoding="utf-8" "
to the schema.xml file but didn't change anything. any clue?

Search and Destroy,,,

ItemAdded Event not always returning SharePoint field information when InfoPath form submitted


 (SharePoint 2007)

I am struggling with an issue related to InfoPath and use of the ItemAdded event handler.  I have created an InfoPath form that contains several fields that are being published to SharePoint fields in a Forms Library.  When I submit a new form, the SharePoint data is being correctly updated.  ian see it in the list.  However, I am trying to write an ItemAdded event handler that performs specific logic based on the value of one of the InfoPath/SharePoint fields for the form being added to the library.  The logic appears to work correctly the first time through.  I can sucessfully read the value from the field and then execute my logic.  However, subsequent submissions appear to not be able to read the values.  It is like they don't exist or are null.  I am thinking that it has something to do with threading but I cannot find a work around for this problem.  The interesting thing is that the same exact logic works correctly when the ItemAdded event handler is tied to a standard Document Library.  Any word documents that are being added always read the values correctly. 


Does anybody know what might be causing this or a possible way around this issue? 



Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Returning a DataSet From a Web Services: Step-by-Step

This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.


This Example Shows how to create a webservice which returns a DataSet and a Client Which displays the DataSet in a Grid.

calculation, field and map traverse adjustment, and coordinate transformation

Free Pocket PC land surveying software -- COGO calculation, field and map traverse adjustment, and coordinate transformation -- for students and professionals.

Dropdown Event (Template Field)



I have grid view control that includes a dropdown control in a template field.

I wish to execute some code when the value is changed in the dropdown list.  Can't figure out how to capture this event though?

Any suggestions?

How to take value of bound field of grid in a variable or in a textbox.


How to take value of bound field of grid in a variable or in a textbox.

 I m using this code in .aspx page for grid.

<asp:GridView ID="Grd_Mprocess" runat="server" AutoGenerateColumns="False"

                      Width="100%" AllowPaging="True"


                      AllowSorting="True" PageSize="5"  >

                 <RowStyle CssClass="odd" />


<asp:BoundField HeaderText="DOC_TYPE_PK" DataField="DOC_TYPE_PK"  Visible="true" >


  <asp:TemplateField HeaderText="DOC TYPE ID" Visible="true">  &nbs

Creating A Stored Procedure Which Searches Team Names



I'm have on my web page a text search box which I want users to type in there favourite football team and this will display a gridview of the teams with the replica shirts I offer.

This is where I thought about creating a stored procedure to carry out this task.

I looked online for ideas but I not found anything as yet.

If anyone done anything similar to my request please let me know.

I need help about nvarchar field



how can specified nvarchar data type without N''?

adding XML 'records' with a key field


I have a vb.net Sub that is successfully adding 'records' to my XML file:

Private Sub btnSubmit_Click(ByVal sender As System.Object, _
    ByVal e As System.EventArgs) Handles btnSubmit.Click             'for adding an XML 'record'
        Using ds As New DataSet()
            Dim dr As DataRow = ds.Tables(0).NewRow()
            dr("subject") = txtNewEvent.Text
            dr("year") = DateTime.Now.ToString("MM/dd/yy")
            txtNewEvent.Text = ""

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend