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


Top 5 Contributors of the Month
Sharad
Manish
Post New Web Links

Infopath field promotion issue with lookup

Posted By:      Posted Date: November 16, 2010    Points: 0   Category :SharePoint
 

Can anyone help.

 

I have code which generates a site (libraries, lists and data) and attaches a form library with my form on it.

Everything is working great form opens and saves at each stage of the process etc.

A note due to installing this form and lists etc in a subsite I create the lookup I need in code so I can link the relevent lists etc to each other.

I am now in the final stages of the development and want to promote out some of the form fields to sharepoint however when I do this and then try it on a different site collection to see if the whole solution will install the infopath promoted fields for lookup are always not clickable when viewing the content type.

 

This is really annoying and I can't be the first to run into this but I can't seem to find a solution to fix it.

 

Small edit,

 

The fields I am guessing are grey because I can't edit them as they are read only?

But my lookup on my deployed site are showing as Text fields rather than the Lookup I need so are only displaying the Id of the Lookup value instead of the name...

 

This is annoying.




View Complete Post


More Related Resource Links

Lookup field issue after restore

  
After restoring a site collection in MOSS 2007, lookup fields cannot link up with the parent list. May I know if this problem fixed in MOSS 2010? Besides, the list item GUID in MOSS 2007 are changed after restoring. Does this case still appear in MOSS 2010? Thanks!

Issue Adding a new Lookup Field to an existing List Instance

  
I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

Re: InfoPath 2010 dataconnection to SPList (LookUP field return id)

  

Hi,

I designed a form in infopath 2010, created a dataconnection to Sharepoint 2010 List, query and data fields include lookup field.

When i expand field tree (Secondry), i can see following data on mouse hover of the field.

MyXYZField (Field)

DataType (Lookup)

Default Type (None)

I then added a dropdown control on the form , using dropdown properties wizard configure MYXYZField as the source.

When i preview the form i only see dropdown filled with LookupID (1,2,3 etc) instead of the text of the dropdown.

 

I must be missing something here, please help.

 

Thanks.

 

 

 

 

 

 

 


how to add vailidation between library field and infopath

  

 i have a browser enable form with filed mails ids and cost i am promoting these filed, and it's saving in library  but i need a vailidation when if any when to submit  requets using mail and cost , at  time i need availidation that your mail id is already  exit , i create a receiving connection for mail id fields it received fileds how to i compare it

thanks


Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view

  

Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:

http://www.bizsupportonline.net/browserforms/filter-cascade-drop-down-infopath-sharepoint-browser-form-owssvr-dll.htm

http://www.sharepoint-tips.com/2007/01/infopath-form-services-implementing.html


While Printing an Infopath Form it Prints lot of Blank Spaces Before RichText Field

  

I had an infopath form with few rich text field. When i copy some content from somewhere and paste in the richtext Box then while Printing the form I get Lot of Blank Spaces Infront of the rich text box.

I tried creating teh print view too but still i get bunch of empty pages printed before by richtext box control.

Is there a way we can remove those blank spaces.....

I am not able to find out what is going wrong here....


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?


SSIS Lookup Transformation Issue

  
I am having a strange issue, In my data flow i have a Lookup Transformaton which will match on key columns of the fact and is followed by a condetional split that would deside if it should insert (old db destination) or go to update (oledb command) or ignore if no change. I have packages running for the last 1 year with the same logic. But in the recent packages I am experiencing a problem.  example: Key columns for join are - type_no (varchar 16) with all numeric values except one record wihh ' '(space) in it  and type_cd (decimal(18,0)) with values(0,1,2,3,4,5) It worked fine when I test the package. After couple of day running in schedule I get integrity violation and huge file with failed records which are supposed to be blocked at the condetional split as they are already in the fact. When i add a data viewer what i found is for all the llokup columns its having nulls (no match found). Workaround that is working for me for now is - I select full cash and say ok in the lookup transofrmation and again open it and set it back to no cash. Then it starts working as expected. Did anyone come accross this kind of issue? is the some standard that I have to follow to make sure this doesnot happen again  

How to read a column of a sharepoint list to a text string field of infopath form?

  
My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

  
I have created a detailed infopath form that is connecting to multiple sharepoint lists, some of which contain thousands of rows and dozens of columns.  To tailor for the data load i have enabled the form to only pull in data as needed and on some of the lists i have created 5 or 6 data connections to the same list, each only looking at a certain set of data, and as you make your way through the form selecting your options, the data is pulled in. If i preview this form from within Infopath or if i launch it using Infopath filler this works great, the data is pulled through in under a second.  However if i then publish the form to the browser and launch it through the browser, it now takes roughly 30 seconds to pull in the data. My question is therefore this,  Is there something i can do to speed up the way the data is pulled in when launched through the browser?  are there transport protocols i can alter or something like that? maybe config in central admin or infopath config? any help would be gratefully appreciated as if i can not get the form to pull the data in fast through the browser then the whole project is a waste of time as my management team will never go for the solution if it is slow and will get slower as more data is added. thanks

Infopath 2010 Browser Based Form Vs Infopath 2010 Filler Based Form Issue

  
I have created a detailed infopath form that is connecting to multiple sharepoint lists, some of which contain thousands of rows and dozens of columns.  To tailor for the data load i have enabled the form to only pull in data as needed and on some of the lists i have created 5 or 6 data connections to the same list, each only looking at a certain set of data, and as you make your way through the form selecting your options, the data is pulled in. If i preview this form from within Infopath or if i launch it using Infopath filler this works great, the data is pulled through in under a second.  However if i then publish the form to the browser and launch it through the browser, it now takes roughly 30 seconds to pull in the data. My question is therefore this,  Is there something i can do to speed up the way the data is pulled in when launched through the browser?  are there transport protocols i can alter or something like that? maybe config in central admin or infopath config? any help would be gratefully appreciated as if i can not get the form to pull the data in fast through the browser then the whole project is a waste of time as my management team will never go for the solution if it is slow and will get slower as more data is added. thanks

How do you update a Lookup Field from CAML by Name rather than ID

  
Hi, I have the following batch update in my code: xml += "<Method ID='" + currentID + "' Cmd='Update'>"; xml +=   "<Field Name='ID'>" + ID + "</Field>"; xml +=   "<Field Name='FileRef'>" + fileRef + "</Field>"; xml +=   "<Field Name='Title'>" + doc.NewFileName + "</Field>"; xml += "<Field Name='Keywords'>" + doc.Keywords + "</Field>"; xml +=   "<Field Name='Select_x0020_Type'>" + ((doc.TypeName == "General") ? 1 : 2) + "</Field>"; xml +=   "<Field Name='Population'>" + "Demography" + "</Field>"; xml += "</Method>"; The Population field is a lookup. It works if I put the ID of the ListItem in there, but not if I put the name - I need to put the name in. Can anyone help? Thanks. John.  

Filter Infopath Form View issue

  
Hi every body I want to Filter Infopath Form view based on the Document Library Name , or url . for example i have two document library : users and Moderators . I need if user open the form in users document library , the form opens with Users View and if user opens the form in Moderators document lib the form open with the Moderator view . what should i do ? I tried to insert a text box in my form and set it's default value to use sharepointlisturl function. but i think the sharepointlisturl function only use when the form hosted from the lists , not document libraries. when my form hosted from document library the text box is empty. i don't know what to do !

DataView WebPart with lookup and person field

  
Hi I want to insert a dataview webpart, using REST, referring to a list with look-up fields and people fields. The results I receive are the ID's instead of the values. How can I get back the corresponding values? TIA Sjokke

External Lists and Infopath forms issue with Secondary Data Sources

  
I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

infopath 2007 Expected value type: end-of-string ! calculated field

  
Hello I am using infopath since there is no field with type date and time in InfoPath 2007. I created three fields one for date one, for hours, and one for minutes then I created forth field that concatenate the values of the three fields this field will be used as column in form template library used by my form. All seems good so far but when I tried to concatenate those fields go the following error Expected value type: end-of-string how can I solve this ? my xpath looks like ../my:calmomoDate../my:cbmomoHours:../my:cbmomoMunites Thanks  Momo

WSS Lists - Lookup field information missing in Excel 2010

  
Hi, I've got this xls workbook which contains a two-way synchronized SharePoint list. This WSS list contains columns which are related to other lists: for instance the list we're using is a list of assignments, where an assignment is related to an accounting period. Our server also has another list with all accounting periods. Both lists are related since the assignment list as an accounting period column of lookup type which uses the accounting period list as a source. In previous versions of Excel, the output is that the accounting period field is a combobox populated with all availalble accounting periods. Thanks to that, the user can easily link an assignment to an accounting period by selecting a value in this combobox and synchronizing. This works great with Excel 2003 and 2007, however in 2010 (same workbook, consuming the same lists) related information doesn't appear. The combobox is empty and as a consequence the user gets a data validation error since the value in the cell isn't among available values. Is there something special I should do to enable this feature in Excel 2010? Regards, Carl 
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