Bug 1630381

Summary:	[6.4 beta] Export CSV on Subscriptions sometimes misses quotation marks on subscription name
Product:	Red Hat Satellite	Reporter:	Pavel Moravec <pmoravec>
Component:	Subscription Management	Assignee:	satellite6-bugs <satellite6-bugs>
Status:	CLOSED WONTFIX	QA Contact:	jcallaha
Severity:	medium	Docs Contact:
Priority:	medium
Version:	6.4	Keywords:	Triaged
Target Milestone:	Unspecified
Target Release:	Unused
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2019-11-04 14:02:51 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:

Description Pavel Moravec 2018-09-18 13:32:13 UTC

Description of problem:
When I export Subscriptions to CSV, some (in my case one) subscription lacks quotation mark around subscription name. That breaks columns when further processing the CSV file.

Particular example:

Pool Id,Subscription Id,Name,Candlepin Id,Organization Id,Sockets,Cores,Start Date,End Date,Available,Quantity,Account Number,Contract Number,Support Level,RAM,Stacking Id,Multi Entitlement,Type,Product Id,Unmapped Guest,Virt Only,Requires Virt Who,Upstream
25,16,Tools,4028c9816302d9c2016302fac38f001f,1,,,2018-04-26 17:22:58 UTC,2048-04-18 17:22:58 UTC,-1,-1,,,,,,,NORMAL,713524461974,false,false,false,false
43,12,"Red Hat Enterprise Linux Server with Smart Management, Premium (Physical or Virtual Nodes)",4028c981653d983e01653e7f27cd03a5,1,2,,2019-08-14 04:00:00 UTC,2020-08-13 23:59:59 UTC,5,5,6113849,11651257,Premium,,RH00008,true,NORMAL,RH00008,false,false,false,true
44,10,Red Hat Satellite Infrastructure Subscription,4028c981653d983e01653e7f27e703a9,1,128,,2018-01-26 05:00:00 UTC,2019-01-25 23:59:59 UTC,0,1,6113849,11528762,Premium,,,,NORMAL,MCT3718,false,false,false,true
45,12,"Red Hat Enterprise Linux Server with Smart Management, Premium (Physical or Virtual Nodes)",4028c981653d983e01653e7f280803ad,1,2,,2018-08-14 04:00:00 UTC,2019-08-13 23:59:59 UTC,5,5,6113849,11651144,Premium,,RH00008,true,NORMAL,RH00008,false,false,false,true
46,11,"Red Hat Enterprise Linux Server, Premium (1-2 sockets) (Unlimited guests) with Smart Management",4028c981653d983e01653e7f287d03b1,1,2,,2018-08-14 04:00:00 UTC,2019-08-13 23:59:59 UTC,3,5,6113849,11651146,Premium,,,,NORMAL,RH0149450,false,false,true,true
48,13,"Red Hat Virtualization (2-sockets), Standard",4028c981653d983e01653e7f289e03bc,1,2,,2018-08-14 04:00:00 UTC,2019-08-13 23:59:59 UTC,5,5,6113849,11651145,Standard,,RV0236407,true,NORMAL,RV0236407,false,false,false,true


See the Red Hat Satellite Infrastructure Subscription one.


Version-Release number of selected component (if applicable):
foreman-1.18.0.4-1.el7sat.noarch
Sat 6.4 beta


How reproducible:
100% on the Sat 6.4 test drive


Steps to Reproduce:
?? in general, not sure
1. attach many subscriptions to your manifest, incl. Red Hat Satellite Infrastructure Subscription one.
2. In webui, Content -> Subscriptions -> Export as CSV
3. Check all subscription names are wrapped inside quotation marks


Actual results:
no quotation marks around Red Hat Satellite Infrastructure Subscription subscription name


Expected results:
quotation marks around any sub name


Additional info:

Comment 1 Pavel Moravec 2018-09-18 13:39:01 UTC

Curiously, same problem is seen for exporting host groups (where no hostgroup, regardless of having space in name or not, is wrapped by quotation mark). Let me know if I shall file separate bug for that or if both BZs have same denominator / cause and can be handled in this BZ.

Comment 2 Pavel Moravec 2018-09-18 13:41:45 UTC

(also reproducible via hammer:

hammer --csv subscription list --organization-label Default_Organization 
hammer --csv hostgroup list

)

Comment 4 Bryan Kearney 2019-11-04 14:02:51 UTC

Thank you for your interest in Satellite 6. We have evaluated this request, and while we recognize that it is a valid request, we do not expect this to be implemented in the product in the foreseeable future. This is due to other priorities for the product, and not a reflection on the request itself. We are therefore closing this out as WONTFIX. If you have any concerns about this, please do not reopen. Instead, feel free to contact Red Hat Technical Support. Thank you.