Skip to main content
jhm1-Visitor
1-Visitor
Jul 10, 2018 7:30 PM UTC
Question

Copy to Excel

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

5 replies

VolkerEckardt17-Peridot
17-Peridot
Jul 10, 2018 8:25 PM UTC

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 

Translate
jhm1-VisitorAuthor
1-Visitor
Jul 10, 2018 9:30 PM UTC

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     

Translate
VolkerEckardt17-Peridot
17-Peridot
Jul 10, 2018 9:39 PM UTC

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

 

Translate
    Terms & ConditionsAccessibility statement