Thursday, March 27, 2014

NO data displayed in column

This is the most recent issue I came to know from one of my colleague. After moving a single file from source to destination the list went crazy.

Issue:
Column shows no data

Description
There was a requirement to move some files / items from List A to List B. And we used the most recommended way by using content and structure.


Background:

  • Source list: List A
  • Destination list: List B
  • Structure of both the list are same with same column name
  • Moved a single item from List A to List B
  • From List B opened a moved item
  • It showed blank / no data for some of the columns
  • Checked old items and found the same thing

Findings:

  • Total 3 columns affected Name, Manager’s name and status
  • List A and List B both has these 2 columns
  • List A contains all of these with “Single line of text” category.
  • While List B contains person or group for name and manager’s name and choice category for stats column
  • Also in List B found duplication of these columns with different category
  • And here is the catch, columns having the same name but with different category showed blank / no data

Resolution:




  • To make sure that the affected column shows wrong category, renamed one of the duplicated column
  • Found the same column showed up in all three forms (newform, dispform and editform)
  • Renamed it back to original one
  • Removed them directly from list settings

No comments:

Popular Posts

Disclaimer

The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.