List Settings - Multiple field names still there in some cases

[RDmitchell]

SHA: 341f613
instance: seeddemostaging
browser: chrome, incognito
files: covered-buildings-sample.csv & portfolio-manager-sample.csv (standard sample files)
org; LBNL 300 (created new for this test)

Folder with sample file, including VIDEO showing this behavior (video for #1103 but shows this problem also)
https://drive.google.com/open?id=0B3fTKpZ9Dx7LUGdROTJZVlRyN0U

There are a few issues

PROBLEM # 1: List Settings shows field name and display name, should only show field name

• Video timestep 7:26
  
• Video timestep 7:46
  

PROBLEM # 2: List Settings sometimes shows duplicate fields (not sure why just a few show up)
Video timestep 7:55

[RDmitchell]

see also #1087

[nllong]

this appears to be due to existing column mappings. We need a way to clean up column mappings because the existing databases have a bunch of cruft. #1200

[RDmitchell]

Moving to V 2.1

[RDmitchell]

testing on seeddev right before the 2.0 release, testing a lot of files in one org, ended up seeing a LOT of the same fields in the Tax Lot Settings list

When I delete the inventory and import a new file, using the same mapping, another "Owner State" field shows up in this Settings list.

[RDmitchell]

There are two issues for this, this one and #1087. I am going to close 1087 and leave this one open, but 1087 has relevant info and can be used as a reference for this issue also.

Also, just as an update as to where things are with this for the 2.0 release, here is another example in that release version, using the covered-building-sample.csv standard test file.

instance: seeddev
SHA: 3daf0f8 (marked release 2.0)
browser: chrome incognito
org: LBNL 302 Org
File: covered-building-list.csv (standard sample file)

*Mapping as shown in #1217

• Inventory, View by Tax Lot List Settings -- I want to display the data in the Property Type field in the Inventory list, so I look in List Settings to select that field. However, there are two options with that name. If I select the one that is as I mapped it, no data is displayed. So I select both of them to see which one will display the data.
  
• looking at the View by Tax Lot, the one that looks like the field name, ie, property_type, is the one that displays the data.
  

[RDmitchell]

This is not particularly fatal but it will be one of the annoying things that users will have to spend time sorting out when they import data. And the question is when new data is imported, even if it is mapped the same, will the same field display the data -- hopefully the answer is yes, but this should be tested.

[RDmitchell]

A lot of these issues have been cleaned up with the latest work on mapping. I am closing this issue and will open others if there are still any lingering problems.