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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Lookup column output includes strange characters.

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :SharePoint
 
Hi all, I have a lookup column ("Priority"), that returns a number, which it looks-up from a different list (obviously). I have a workflow that emails the user when the list item is created, and in that email I have included the Priority field. However, the email is showing the contents of the Priority field along wth other characters - an example is: The column in the list says 3 The column in the email says 3;#3 What's going on? Why is it adding the additional characters to it? I'm not sure where it's coming from? This only seems to happen where a lookup column contains a number. Thanks in advance. Duncan


View Complete Post


More Related Resource Links

BDC Entity as a Data Source for a Lookup column

  
Is it possible to create a custom lookup field type to have a BDC entity as the data source?

wss2.0 update/delete/hide lookup column that does not display any values

  

Hi All,

I have a document library that contains a Category column that is a lookup field. This is a default column that is a required field when uploading documents to the document library. The Category column is empty and I am unable to amend, hide, make it not required or delete it.

I have gone to Modify settings and columns -> clicked on the Category field to edit, but there is no option to amend the content or delete it. I am only able to amend the Column name and Description.

Since then, I have amended the column name to eg. Category1 and created a new Category field as a lookup and linked it to the correct list.

The problem I am facing now, is that I cannot hide, delete or make the Category1 (old Category) field NOT required. Either I would like to update the original field to display the correct values or alternately hide, delete or make the column not required.

Please help.


Datasheet view lookup column issue

  

When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.

http://support.microsoft.com/kb/948952

Any ideas how to get this resolved?


MySqlDataReader - Reading special column characters

  

Hi.

I have a MySQL database, which contains columns with danish characters like ø æ and å.

When the MySqlDataReader tries to read this column name:

for (int i = 0; i < MysqlReader.FieldCount; i++)
{
       string Key = MysqlReader.GetName(i);

}


The result is not the expected character, but some kind of ASCII value of it. For an example, 'å' gets interpreted as 'Ã¥'.

What to do?


Thanks alot for your help :)




SQL Server Unicode Characters in a column

  
I have an ETL and it fails because of some Unicode Characters. The unicode characters are getting inserted from somewhere in the application and we are still trying to ascertain the source of the same.But till then I need to run a T-SQL Query and find out the rows( I know the column name ) that are causing this problem, modify the data to the correct format and then run the ETL. Would i need to use a cursor? can anyone please advise? It was a bit urgent thus any help would be great! Thanks Nimish

Problem while retrieving data from a lookup column from sharepoint linq.

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

How to tell repeater to wrap text after certain number of characters for a particular column ?

  
I have a column in my repeater which allows as many as 255 characters and causes the page contents pushed away to the right if any of the record has all 255 characters in that column. How can I tell it to wrap the text after 50 characters ?Thanks,

MOSS 2007: list column that lookup to multiple documents stored in doc library

  
Hi All, I'm trying to understand how to customise MOSS to achieve the following: I need to lookup from a list to multiple documents stored in a documetn library. Example: - List item 1 --------> Lookup to Doc 2                   --------> Lookup to Doc 5 - List item 2 --------> Lookup to Doc 3                   --------> Lookup to Doc 5                   --------> Lookup to Doc 8 - List item 3 --------> Lookup to Doc 1 How can I achieve this? is it possible that in the lookup I have a "search" option? Thanks all Vit

Paste data in a lookup column

  
Hi all, I am trying to create a Sharepoint list from a previous Excel file and I would like to use a lookup column, to allow users to pick values of “column B” from “column A”. The values are already entered in "column A", so now I would like to edit the list in datasheet view and copy/paste the values from my excel file into my “column B”. It works well when I copy/paste only one data, but when I try to paste several values in the same row (using a semicolon as delimiter), I get the error message “Cannot paste the copied data due to data types mismatches or invalid data.”, although the column is set to allow multiple values. I noticed that lookup columns allowing mulitple values store items with the item ID, as follows: ITEM NAME;#ITEM ID, but don’t display it in datasheet view or standard view, and I guess this is why I can’t copy and paste the data from my excel file since they don’t have the ID encoded, but is it possible to do it anyway? Thanks for your help.

Unable to load data into a LookUp column in sharepoint using sharepoint destination

  
I have loaded details of a customer on a list and was able to load the data with out any problem using sharepoint list destination. We have a lookup column called customerid looking at customer list  . This lookup column is in another list, called Customer Main, so I am trying to load additional data for customer in this customer Main  list which contains a lookup column called customerID. I was not able to load data into this cutsomerid, whereas rest of the data is coming into sharepoint with out any problem. How should I load data into a lookup column. Thanks  

Lookup column in the list

  
I have one list on SharePoint. I want to create another list and one of the columns should pick up values from the other list. However, when I create a new column and select the type as "Lookup (information already on this site) and select my old list in "Get Information from" , I don't see all the columns of the old list but a selected few. Why is that and how can I make sure that in my lookup column in the new list, I see all the columns as I need information from the other columns?

Trouble importing strange column format report from Excel 2007 to SQL 08

  
Hi, I'm not sure whether this belongs in this section or the SSIS one so hopefully I've got it right!  Hoping someone will be able to help with a problem I'm having importing a report with header and detail rows from our antiquated POS system into SQL 2008 tables.  The reports export in Excel 2007 format and for each header row there can be one or more detail rows starting from column B.  As such I've tried several things such as openrowset, an Access 12.0 OLE DB source in SSIS and even COM automation of Excel to try and write a conditional split which will hold the header details in variables then write them to rows alongside the detail rows.  I've pasted a small sample of the data here as I wasn't able to attach it: 01/07/2010 @ 11:18 Page: 1 RECEIVING: Voucher Journal Sort: VC|Str|Vou Date|Vou #|Document SID Filter: Voucher Date: 01/06/2010@12:00a..30/06/2010@11:59p Include Item detail: DCS|Item#|Desc1|Attr|Material|Size|Qty VC Str Vou Date Vou # Qty ABC 001 15/06/2010 12345 38 E NN 66 200148 XXXXXXXX RED SHAD E NN 66 200149 YYYYYYYYY BLACK GO E PP 60 200154 ZZZZZZZZZ BLACK CDE 002 16/06/2010 13839 8 F SA 35 217500 XXXXXXXX Natural F SA FL 218674 YYYYYYYYY Chalk F SA WE 221462 ZZZZZZZZZ White FGH 001 21/06/2010 13905 3 F SH 85 126260 XXXXXXXX Navy IJK 001 23/06/2010 13914 3 E AA 61 250005 YYYYYY

Copy of dispForm.aspx and lookup column

  
Hello, we have created in SPD 2010 a new Dispform. This new dispformuser.aspx is the new default form for viewing list entries. We want to hide some elements with jquery. We are using some lookup columns in our list. When we open an entry in the new form, the lookup-columns looks like <a href="http://s-sharepoint-02.kkrn.local/_layouts/listform.aspx?PageType=4&ListId={1D8EE013-E164-482F-861E-9CACB2EBF6B5}&ID=1&RootFolder=*">Marien-Hospital</a> The form is not customized at the moment, it is only a copy at the moment. Any other colums are ok. Editform and newform seems to be ok, also the lookup columns. Maybe somebody can help us with this behaviour.  thank you Regards Marc

3 Column Listview output - is it possible

  
hi all, i am looking to create a 3 column listview output that looks like this.  Basically its an alphabetic list of one field but it needs to output like newspaper columns.  Is it possible to do this with simply css?  Or will i have to programmaticaly break up the dataset into 3 and actually make 3 listviews?     aaaaaaabaaacaaadaaaeaaaf   aaagaaahaaaiaaajaaalaaam aaanaaaoaaapaaaqaaar

Strange characters exporting a blob file using bcp

  
Hi, I am trying to insert and export a binary file into SQL 2005. I need that word, pdf and txt file work. I can't use file path and this is the only choice I have. I am using this way: 1) Create a file test.txt and write "hello" into it. 2) CREATE TABLE [dbo].[myfiles]( [file] [varbinary](max) NOT NULL) ON Primary 3) INSERT INTO [myfiles]([file]) SELECT BulkColumn FROM OPENROWSET ( BULK 'C:\test.txt', SINGLE_BLOB) AS BinFile 4) declare @SQLcommand nvarchar(4000) set @SQLcommand =       'bcp "SELECT top 1 [file] FROM myfiles" queryout "c: \temp\test.txt" -T -n -SMYPC' exec xp_cmdshell @SQLcommand When I open file c:\temp\test.txt I can see strange characters before "hello" Trying to insert a word file says me that the file is corrupted. How can I solve this ? Thanks.

restrictions on additional columns available for addition with Lookup column?

  
Can a choice column be added as an additional field when creating a Lookup column? I was able to do this in the beta version but have been unable to in RTM. The column does not appear in the list of availabe columns to add as additional fields.
Categories: 
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