cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Is it possible to compare excel sheet in PTC integrity 10.6 ?

spatel-9
1-Newbie

Is it possible to compare excel sheet in PTC integrity 10.6 ?

Excel sheet  is checked-in  in the server  and changed locally. SO is it possible to compare it ?

1 ACCEPTED SOLUTION

Accepted Solutions
tdalon
4-Participant
(To:spatel-9)

In this case to configure the Diff Tool in Integrity to BeyondCompare follow:

To use an external diff software like beyond compare, you can set this in the MKS client in File -> Edit Preferences -> Configuration Management -> Diff and Merge tools. In the Custom Command field you can configure your own diff application. In the case of Beyond Compare 3.x the command is

  "<your path to BC3>\bcomp.exe" /fv="Text Compare" /title1="{1}" /title2="{2}" "{3}" "{4}" 

You can also use BC as Merge Tool. The command is:

  "D:\PortableApps\BeyondCompare3Portable\BCompare.exe" /title1="{1}" /title2="{2}" "{5}" "{6}" /savetarget="{7}"

Then look how to compare Excel files in BeyondCompare for example Beyond Compare Technical Support.

View solution in original post

7 REPLIES 7
KaelLizak
14-Alexandrite
(To:spatel-9)

Hello Sanket Patel‌,

If it's a binary file, it's not possible out-of-the-box.  If it's a text file, it is possible.

Typically, Excel files are binary files.  .xslx files, for instance, are a zipped directory structure containing xml files.  Even though xml files could be compared (one by one), the zipped structure of the container file means it's a binary, and so can't be meaningfully compared by Integrity Lifecycle Manager.

Regards,
Kael


Kind Regards,
Kael Lizak

Senior Technical Support Engineer
PTC Integrity Lifecycle Manager
tdalon
4-Participant
(To:spatel-9)

As Kael said: Integrity does not support it out-of-the-box with its native Diff Viewer tool.

You could use a customized Diff Tool that open a different tool for XLS file.

We do this for example for Simulink .mdl files: we use a specific tool, for other ASCII files we use BeyondCompare.

mrump
14-Alexandrite
(To:tdalon)

Beyond Compare in Version 2 or higher also supports the comparison of Office File Formats like WORD or EXCEL.

There are rules-set you can Import, that convert the e.g. Excel sheet into a temp text representation that can be compared with the Standard Beyond Compare UI.

It's not perfect but it gives at least a hint about the differences.

spatel-9
1-Newbie
(To:mrump)

@mrump‌ Is it possible to provide those rule  set procedure? I am new to customization of View set.

tdalon
4-Participant
(To:spatel-9)

In this case to configure the Diff Tool in Integrity to BeyondCompare follow:

To use an external diff software like beyond compare, you can set this in the MKS client in File -> Edit Preferences -> Configuration Management -> Diff and Merge tools. In the Custom Command field you can configure your own diff application. In the case of Beyond Compare 3.x the command is

  "<your path to BC3>\bcomp.exe" /fv="Text Compare" /title1="{1}" /title2="{2}" "{3}" "{4}" 

You can also use BC as Merge Tool. The command is:

  "D:\PortableApps\BeyondCompare3Portable\BCompare.exe" /title1="{1}" /title2="{2}" "{5}" "{6}" /savetarget="{7}"

Then look how to compare Excel files in BeyondCompare for example Beyond Compare Technical Support.

can any one help What is the preference command for Beyond comapre 4 (Version 4.0.7 (build 19761)) in PTC integrity 10.5 (10.5.0.5479) ?

just check this url, hope it is helpful for you.

https://www.scootersoftware.com/support.php?zz=kb_vcs#mksintegrity

 

Top Tags