Tools to rename user folder in PA

Post Reply
kenship
Posts: 123
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Tools to rename user folder in PA

Post by kenship » Tue Jan 29, 2019 4:27 pm

Hi,

We are changing from Active Directory to Azure.

As a result the user folder created to store private view and subset are changed from:

Last Name" ,"First Name
To
First Name" "Last Name

I wonder if there's any quick tool that can help rename folder instead of copying and pasting for each of our PA user.

Kenneth

User avatar
gtonkin
MVP
Posts: 667
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: Tools to rename user folder in PA

Post by gtonkin » Tue Jan 29, 2019 5:07 pm

A fairly quick low-tech way may be to use the command prompt and Excel:
Open the command prompt, cd to your TM1 data folder then do:
DIR *. /b >directories.txt
- open the resulting txt file in Excel
- remove non-user folders, sort if necessary to aid checking
- add a formula in column B to transform column A into the new format i.e. combination of FIND and MID etc.
- in column C add a formula like ="move """&A2&""" """&B2&""""
- copy the formula down for all folders and recalculate if required
- copy the move statements in column C and paste into the command window
each line should fire doing the "rename"

p.s. you may want to try one line first to test
p.p.s obviously this will only reflect/work once the server is restarted and the relevant users are configured.

kenship
Posts: 123
Joined: Thu May 30, 2013 1:41 pm
OLAP Product: Cognos
Version: TM1 10.2
Excel Version: 2010

Re: Tools to rename user folder in PA

Post by kenship » Tue Jan 29, 2019 6:45 pm

Interesting. I will test.
gtonkin wrote:
Tue Jan 29, 2019 5:07 pm
A fairly quick low-tech way may be to use the command prompt and Excel:
Open the command prompt, cd to your TM1 data folder then do:
DIR *. /b >directories.txt
- open the resulting txt file in Excel
- remove non-user folders, sort if necessary to aid checking
- add a formula in column B to transform column A into the new format i.e. combination of FIND and MID etc.
- in column C add a formula like ="move """&A2&""" """&B2&""""
- copy the formula down for all folders and recalculate if required
- copy the move statements in column C and paste into the command window
each line should fire doing the "rename"

p.s. you may want to try one line first to test
p.p.s obviously this will only reflect/work once the server is restarted and the relevant users are configured.

Post Reply