Import Set Rows related list does not show source columns - why?

[thomaskennedy]

I'm trying to set up a human-readable view of import set activity, for troubleshooting.

So if I grant my user the [import_transformer] role he can see import sets, import set rows and so on. That's all fine.

But while the Import Set Rows related list shows the rows created for a given run, it does not show the source columns - they are not listed in Update Personalized List.

But if I open one of these rows, the form shows the source values I'm interested in.

What's going on here, and is it possible to create a human-readable list of import activity?

[Tony Chatfield1]

Hi, import tables are extended from sys_import_set_row and while the common (parent table) fields are visible from a sys_import_set_row list or form view, showing fields from the temp import tables would require that you update the related list and select individual fields from each table, once child table fields are added to the list individual users will be able to add remove them from their list view.
Right click on the related lists header\field names row and select Configure > List Layout

You could also add import table fields to a report, if you add sys_import_set_row to the list of sys tables that reporting is allowed on.

[thomaskennedy]

I switched to the global scope and configured the layout to add the columns I wanted. I also gave this a view name, so this would not be the default.

Can you help me understand what to do next? I'm not sure I'm following.

[Tony Chatfield1]

Hi, unfortunately your last comment\requirement is not clear, what exactly do you mean by 'Can you help me understand what to do next'. What exactly are you trying to do now that you have visibility of the child table fields?

[thomaskennedy]

My plan is to give the users [import_transformer] and a link that opens import sets deriving from the data source(s) for their application. This gives them a ready-made UI into their recent transforms, for basic troubleshooting purposes. But the inherited list columns are no good for this purpose, hence my question above.

Having added the columns I care about and saved this as a view (leaving Default alone), how do I get the UI (meaning, the import set rows related list) to use that view instead of the default, for my import sets?