Bug 1292860

Summary: Custom Attributes do not display correctly in reports
Product: Red Hat CloudForms Management Engine Reporter: Jesse P. Johnson <jesse.johnson>
Component: ReportingAssignee: Libor Pichler <lpichler>
Status: CLOSED ERRATA QA Contact: Jiri Stefanisin <jistefan>
Severity: high Docs Contact:
Priority: high    
Version: 5.5.0CC: awestbro, carnott, duboyd, jhardy, nachandr, nobody, obarenbo, pmukhedk, simaishi
Target Milestone: GA   
Target Release: 5.7.0   
Hardware: x86_64   
OS: Linux   
Whiteboard: report
Fixed In Version: 5.7.0.0 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-01-04 12:54:16 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Example poorly formated spreadsheet none

Description Jesse P. Johnson 2015-12-18 14:55:07 UTC
Created attachment 1107188 [details]
Example poorly formated spreadsheet

Description of problem:
Custom attributes are used to store data that is not normally provided by Cloudforms. These key/value pairs do not display correctly when used in reports. All custom attributes are displayed in the same columns and requires multiple rows. A report for 500 machines with 5 custom attributes will consume 2500 lines.

Version-Release number of selected component (if applicable):
5.4.0
5.5.0
5.6.0?

How reproducible:
Always

Steps to Reproduce:
1. Create custom attribute for VM in CFME
2. Populate custom attribute with data
3. Create report that displays "EVM Custom Attributes : {Name,Value}"
4. Generate report

Actual results:
Denormalized spreadsheet

Expected results:
Normalized spreadsheet with custom headers and other available formatting

Additional info:

Comment 2 Tim Wade 2016-01-08 23:33:43 UTC
*** Bug 1292859 has been marked as a duplicate of this bug. ***

Comment 3 Dustin Boyd 2016-02-23 17:30:31 UTC
Workaround - Spreadsheet filters on the CSV export to get useful data with the current formatting of the report.

Comment 8 errata-xmlrpc 2017-01-04 12:54:16 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://rhn.redhat.com/errata/RHBA-2017-0012.html

Comment 9 Yuri Rudman 2019-02-28 12:46:19 UTC
*** Bug 1323741 has been marked as a duplicate of this bug. ***