Related Items field display names

[Sonoma]

Hi.

Is there is way to display a Related Items title/display name differently?


e.g.

Title -> Main Tile

DRUG -> Drug

Column1 -> Column Name

Column2 - > Field Two


I tried modifying the View XML but nothing changed. I tried DisplayName="New Name" and Title="New Name" as discribed here https://msdn.microsoft.com/en-us/librar ... e.15).aspx.

These did not work.

Any suggestions?



Thank you.

[Dmitry Kozlov]

Hi,

You can change titles in the settings of the original list. Or do you need different titles in different views?

[Sonoma]

Since our data statisticians pull the data into SAS they prefer the column names to be a certain way. Short, no spaces.

Users can't decipher all the columns. SAS people live in code.

They enjoy making simple difficult.

e.g.

Chart 1 -> MC1

Column 99 -> TC99


I do my best to help both worlds.

[Sonoma]

Thinking more on it this maybe the way to go since the internal name should remain the same. Thanks.

[Sonoma]

Ignore my last post. When I export the list to excel or csv it exprts the friendly name.


e.g

I changed DRUG to Drug Name and changed STUDY to Study Name.

These columns exported to csv as the friendly name Study Name and Drug Name and not the internal name.

I will keep trying til I find a simple solution. Thanks.

[Dmitry Kozlov]

Hi,

You can export list data with the help of PowerShell script and insert internal names of fields instead of titles into column headers:

http://porchcode.blogspot.ru/2013/04/ex ... o-csv.html

Replace

$hash.add($fld.Title, $_[$fld.Title])

with

$hash.add($fld.InternalName, $_[$fld.Title])

[Sonoma]

Thank you. This is a good solution.It exports fine. I will tweak it to export just the list the user is requesting.

If anyone uses this I needed to use these lines to the beginning of the script.

Add-PSSnapin Microsoft.Sharepoint.Powershell
Set-ExecutionPolicy -ExecutionPolicy "Unrestricted" -Force



However I did notice a quirk when renaming the fields. I was able to repeat it.

I changed a field name from DTEND to "Date End". Works as it should. But it renames the internal name to "xqkb".

another column internal name changed from DTSTART changed to "FLM2"

They export as these aswel. Is this common SP behavior?

[Dmitry Kozlov]

Hi,

I've never encountered such behaviour. As I know, internal names never change since the fields was created.