Bug 1477341 - UI CSV Export of facts does not include nested values
Summary: UI CSV Export of facts does not include nested values
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Satellite
Classification: Red Hat
Component: Fact
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
high
medium vote
Target Milestone: Unspecified
Assignee: Sebastian Gräßl
QA Contact: Perry Gagne
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-08-01 20:28 UTC by Perry Gagne
Modified: 2019-09-26 16:13 UTC (History)
5 users (show)

Fixed In Version: foreman-1.15.4.10-1
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-02-21 17:30:01 UTC
Target Upstream Version:


Attachments (Terms of Use)
Screen shot of facts page with nested valuies (134.25 KB, image/png)
2017-08-01 20:28 UTC, Perry Gagne
no flags Details


Links
System ID Priority Status Summary Last Updated
Foreman Issue Tracker 20541 None None None 2017-08-09 13:55:17 UTC

Description Perry Gagne 2017-08-01 20:28:01 UTC
Created attachment 1307775 [details]
Screen shot of facts page with nested valuies

Description of problem:
When using UI CSV export of facts. The values of columns with nested fields is empty for example: 
```
ronda-grams.lab.eng.rdu2.redhat.com,dmi,,Redhat,2017-07-20 18:29:07 UTC
```
See attached screen shot for page. 
Although it is shown as empty on the ui page, we probably should show something in the CSV. 

For example, we could build a json-like dict by traversing down the tree:
```
 ronda-grams.lab.eng.rdu2.redhat.com,{"dmi::bios::version": "0.5.1", "dmi::bios::rom_size":"64 KB", ...},...
```


Version-Release number of selected component (if applicable): 6.3.0

Comment 3 Tomer Brisker 2017-08-09 13:55:15 UTC
Created redmine issue http://projects.theforeman.org/issues/20541 from this bug

Comment 4 pm-sat@redhat.com 2017-10-17 08:13:52 UTC
Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/20541 has been resolved.

Comment 7 Perry Gagne 2017-11-07 20:15:35 UTC
Verified fix in 6.3.0 snap 24.

When exports nested facts appear as follows:

Host,Fact Name,Value,Origin,Updated At
saul-provitt.lab.eng.rdu2.redhat.com,dmi::system::uuid,063ae797-7b9e-460b-9f10-804932e23906,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,proc_cpuinfo::common::cpuid_level,4,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,distribution::name,Red Hat Enterprise Linux Server,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,dmi::memory::type,RAM,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,proc_cpuinfo::common::siblings,1,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,dmi::processor::family,Other,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,dmi::chassis::manufacturer,Bochs,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,virt::host_type,kvm,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,lscpu::l1i_cache,32K,Redhat,2017-11-01 20:04:58 UTC
saul-provitt.lab.eng.rdu2.redhat.com,dmi::chassis::security_status,Unknown,Redhat,2017-11-01 20:04:58 UTC

Comment 8 Bryan Kearney 2018-02-21 17:30:01 UTC
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA.

For information on the advisory, and where to find the updated files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2018:0336


Note You need to log in before you can comment on or make changes to this bug.