Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
Excel sheet is checked-in in the server and changed locally. SO is it possible to compare it ?
Solved! Go to Solution.
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.
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
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.
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.
@mrump Is it possible to provide those rule set procedure? I am new to customization of View set.
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