Tools to rename user folder in PA

[kenship]

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

[gtonkin]

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]

Interesting. I will test.

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.