csv exports should work the same for Java UI and uCMDB Browser

Idea ID 2749200

csv exports should work the same for Java UI and uCMDB Browser

Reports that include grouping are exported differently from Java UI than from the uCMDB Browser.

Support confirmed that current Browser behavior is implemented that way. It won't copy and paste data of 1st level into each line of 2nd level (aka how applet ui works right now).

The idea suggested is that the browser should produces the exports the same way as the Java UI.

Regards,

Benoit

20 Comments
Super Contributor.
Super Contributor.

Here is an example of the behavior that @bnadon is describing.

Lets says that the first level of a report would produce Red, Yellow and Green. Then, the second level of each item would produce different fruits for each color. When exporting this report in CSV, then we would get the following output

Using the Java UI:

 

"Color","Fruit"
"Red","Apple"
"Red","Strawberry"
"Red","Cherry"
"Yellow","Banana"
"Green","Melon"
"Green","Lime"

 

 

Using uCMDB Browser:

 

"Color","Fruit"
"Red","Apple"
,"Strawberry"
,"Cherry"
"Yellow","Banana"
"Green","Melon"
,"Lime"

 

 

Notice that the color appears only the first time, then an empty value is placed. This type of output is impossible to parse using any type of pivot table tool such as Excel, Power BI, Cognos, etc.

 

Valued Contributor.. Valued Contributor..
Valued Contributor..

I actually have the same problem and opened a case for that.

Before:

[Node]:Display Label,[IpAddress]:Display Label
001ge3t9nr,31.232.2.131
,75.33.195.68
,141.131.122.159
,166.130.72.162
,222.120.51.235
001pbp8myh,21.149.67.250
,31.72.21.241
,197.225.157.41
,224.161.255.247
,252.5.65.255
001whtkg2a,72.177.163.94
,115.57.224.52
,116.223.249.66
,135.49.108.95
,182.147.106.111
001wmpxzy9,2.187.121.83
,28.233.221.57
,75.125.230.230
,170.51.85.21
,200.117.225.198
002jg4tva6,1.18.152.124
,8.152.116.140
,34.218.51.96
,102.85.150.24
,231.107.170.124
00138oc8n3,5.46.112.113
,19.96.105.66
,105.123.195.15
,139.246.178.168
,190.138.246.226

 

I got the following hint:

  1. login to JMX and call operation `setGlobalSettingValue`;
  2. input
    - name = ucmdb_browser.merge_folded_cis
    - value = false
  3. restart server
  4. test if it works. If not, add ucmdb_browser.merge_folded_cis=false in `ucmdb_server\conf\settings.override.properties`
  5. restart server and test again

After switching the setting to false the export is repeating the node name, but is also blanking every second node.

After:

[Node] : Display Label,[IpAddress] : Display Label
001ge3t9nr,31.232.2.131
001ge3t9nr,75.33.195.68
001ge3t9nr,141.131.122.159
001ge3t9nr,166.130.72.162
001ge3t9nr,222.120.51.235
,
,
,
,
,
001whtkg2a,72.177.163.94
001whtkg2a,115.57.224.52
001whtkg2a,116.223.249.66
001whtkg2a,135.49.108.95
001whtkg2a,182.147.106.111
,
,
,
,
,
002jg4tva6,1.18.152.124
002jg4tva6,8.152.116.140
002jg4tva6,34.218.51.96
002jg4tva6,102.85.150.24
002jg4tva6,231.107.170.124
,
,
,
,
,

 

case is routed to RnD: SD02588601 --- CSV export differs in Browser and Admin UI if view contains a hierarchy

Valued Contributor.. Valued Contributor..
Valued Contributor..

I actually have the same problem and opened a case for that.

Before:

[Node]:Display Label,[IpAddress]:Display Label
001ge3t9nr,31.232.2.131
,75.33.195.68
,141.131.122.159
,166.130.72.162
,222.120.51.235
001pbp8myh,21.149.67.250
,31.72.21.241
,197.225.157.41
,224.161.255.247
,252.5.65.255
001whtkg2a,72.177.163.94
,115.57.224.52
,116.223.249.66
,135.49.108.95
,182.147.106.111
001wmpxzy9,2.187.121.83
,28.233.221.57
,75.125.230.230
,170.51.85.21
,200.117.225.198
002jg4tva6,1.18.152.124
,8.152.116.140
,34.218.51.96
,102.85.150.24
,231.107.170.124
00138oc8n3,5.46.112.113
,19.96.105.66
,105.123.195.15
,139.246.178.168
,190.138.246.226

I got the following hint:

  1. login to JMX and call operation `setGlobalSettingValue`
  2. input
    - name = ucmdb_browser.merge_folded_cis
    - value = false
  3. restart server
  4. test if it works. If not, add ucmdb_browser.merge_folded_cis=false in `ucmdb_server\conf\settings.override.properties`
  5. restart server and test again

After switching the setting to false the export is repeating the node name, but is also blanking every second node.

After:

[Node] : Display Label,[IpAddress] : Display Label
001ge3t9nr,31.232.2.131
001ge3t9nr,75.33.195.68
001ge3t9nr,141.131.122.159
001ge3t9nr,166.130.72.162
001ge3t9nr,222.120.51.235
,
,
,
,
,
001whtkg2a,72.177.163.94
001whtkg2a,115.57.224.52
001whtkg2a,116.223.249.66
001whtkg2a,135.49.108.95
001whtkg2a,182.147.106.111
,
,
,
,
,
002jg4tva6,1.18.152.124
002jg4tva6,8.152.116.140
002jg4tva6,34.218.51.96
002jg4tva6,102.85.150.24
002jg4tva6,231.107.170.124
,
,
,
,
,

 

The case was routed to RnD and the feedback is that it works as designed and we should create an enhancment request, but the priority won't be high because the CMS UI behavior supposed to be an enhancement to old Applet way.

I thought that the CMS UI should be a replacement to the applet. No development effort is put into fixing the applet bugs.

Micro Focus Expert
Micro Focus Expert
Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Micro Focus Expert
Micro Focus Expert
Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Acclaimed Contributor.
Acclaimed Contributor.

I do believe this is a bug, not a feature request. MicroFocus, please fix!

Micro Focus Expert
Micro Focus Expert
Status changed to: Accepted

We agree this is a defect and it will be addressed in our next development cycle.  I've accepted it here just for completeness

Respected Contributor.. Respected Contributor..
Respected Contributor..

Hello,

I think that the structure as mantioned above is not a bug.

There is a parameter called "Merge cells for folded CIs" (ucmdb_browser.merge_folded_cis) which changes the structure of the export just the way you want it to.

We have changed the Parameter to "false" and with this value every row contains the value of the folded CIs.

Greetings,

Maike

 

 

 

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.