TM1 Data Directory Compare Tool

Ideas and tips for enhancing your TM1 application
Post Reply
Kyro
Community Contributor
Posts: 126
Joined: Tue Nov 03, 2009 7:46 pm
OLAP Product: MODLR - The CPM Cloud
Version: Always the latest.
Excel Version: 365
Location: Sydney, Australia
Contact:

TM1 Data Directory Compare Tool

Post by Kyro »

Morning All,

I've just thought I'd put out one of the tools I've made over the last while.
This tool takes the directories of both production and development servers and tells which files are missing from which directory.

Click here to download

I have also put it on my TM1 Tutorials Site.

Sorry, I posted here as I dont have access to post in the "Useful code, tips and tricks" forum.
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TM1 Data Directory Compare Tool

Post by Martin Ryan »

Is this still publicly available somewhere Ben? This link doesn't work anymore.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
bihints.com
Posts: 52
Joined: Tue May 20, 2008 8:56 am
OLAP Product: TM1
Version: 9.0.3
Excel Version: 2003
Contact:

Re: TM1 Data Directory Compare Tool

Post by bihints.com »

windows: http://winmerge.org/
linux: diff -qr dirA dirB
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 Data Directory Compare Tool

Post by jim wood »

I'm guessing that's a different more geenric open source tool that does the same thing??
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
bihints.com
Posts: 52
Joined: Tue May 20, 2008 8:56 am
OLAP Product: TM1
Version: 9.0.3
Excel Version: 2003
Contact:

Re: TM1 Data Directory Compare Tool

Post by bihints.com »

winmerge also displays differences between the files side by side, highlighting the chunks of code that differ.

or simpler, no installs required:
DOS: xcopy /L can list what files may need to be copied.
bash: rsync -anuve
Wim Gielis
MVP
Posts: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Data Directory Compare Tool

Post by Wim Gielis »

Hello

Updated code of Ben could be found here:

http://users.skynet.be/fa436118/wim/tm1 ... tories.htm

(direct link to a page on my website).

Needless to say, there are other and possibly better/easier methods, as suggested above.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TM1 Data Directory Compare Tool

Post by Martin Ryan »

Wow, that WinMerge is great! Thanks for the tip.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: TM1 Data Directory Compare Tool

Post by Harvey »

I have been using WinMerge for a few years now and can highly recommend it. It saves many hours of hair-pulling in a dev/staging/prod environment.

However, if you want to compare changes in dimensions, cubes, attributes, processes, etc, you're out of luck as these are stored in binary format on disk and WinMerge can only show (readable) differences in text files.

I'm working on a tool that does an even better job (ie, it doesn't just show file differences, it understands TM1 objects and how to compare them) and will announce on the forums when I have got it to beta stage.
Take your TM1 experience to the next level - TM1Innovators.net
Post Reply