Page 1 of 1
Tools to rename user folder in PA
Posted: Tue Jan 29, 2019 4:27 pm
by 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
Re: Tools to rename user folder in PA
Posted: Tue Jan 29, 2019 5:07 pm
by 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.
Re: Tools to rename user folder in PA
Posted: Tue Jan 29, 2019 6:45 pm
by kenship
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.