Skip to main content
1-Visitor
July 10, 2018
Question

Copy to Excel

  • July 10, 2018
  • 1 reply
  • 2383 views

Anyone know a good way to do this, how to copy and paste fields from Integrity item types to excel

1 reply

17-Peridot
July 10, 2018

Hi Jhm,

 

Your request is a bit short.

We dont copy any data to excel.  But we have "Export to Excel", or we have an Excel Integration Add-On.

The first is uni-directional, not configurable, it just works.

The second is bi-directional, and configureable using XML definitions.

There are also custom solutions available, for example how to upload Excel data into new documents

 

Hope this helps.

Volker 

jhm1-VisitorAuthor
1-Visitor
July 10, 2018

Hi Volker,

What I am trying to do, is copy the visible fields from an item type, into a spreadsheet.

 I want to compare the same fields on the same type that are on 2 different servers.

I am trying to find a way, that is better, less time consuming then typing manually.

 

Any suggestions, greatly appreciated

 

Thanks

John     

17-Peridot
July 10, 2018

Hi John,

 

what about:

 

im types --hostname=<server1>  --fields=visibleFields "Defect"  > defect_visible_fields_server1.txt

and

im types --hostname=<server2>  --fields=visibleFields "Defect" > defect_visible_fields_server2.txt

 

and then any diff tool would do.

 

We do have more sophisticated solutions, but this is a still working one.

 

Volker