Link to home
Start Free TrialLog in
Avatar of TUN-IT
TUN-IT

asked on

Importing excel list into Client Access Macro

Hello -

I wondered if someone could assist.  I'm very much a beginner in programming but need to create a simple script/macro to enable passwords for a large list of profiles later this month, and rather than do them all individually, I'd like to create a macro that runs through the excel list of profiles and enables them.  

Any ideas?

Thanks!
Avatar of Theo Kouwenhoven
Theo Kouwenhoven
Flag of Netherlands image

Hi TUN-IT,

If you only have to enable them, there are 2 easy options.
1. Create a CL with a line for every user (eventually generate it with Excel and upload or copy-paste) like
   CHGUSRPRF USRPRF(userid-1)    STATUS(*ENABLED)
   CHGUSRPRF USRPRF(userid-2)    STATUS(*ENABLED)
      etc.
-or-
2. Use the OS/400 benefits to do that
   - Type WRKUSRPRF
   - put option 2 infront of every user you like to enable
   - Type  STATUS(*ENABLED) on the command line
  - Press enter
Now all with 2 indicated profiles will be changed.

Regards,
Murph


Avatar of TUN-IT
TUN-IT

ASKER

Hi Murphey,

Option 2 is out for me as I have restricted access on this box and can only use the command "Password", then F4, then I type in the username and have the option to type E for Enable, R for Reset, etc.  I don't have authority to use the CHGUSRPRF or WRKUSRPRF command.

I apologize for sounding so clueless but I just don't understand how to bring an Excel list into an AS/400 macro.  
DO you have experience in writing Excel macro's?
Avatar of TUN-IT

ASKER

No, I don't.  Is it a simple menu function?
You can record a Macro with Client access.... look to the contents
and copy and paste it in the same file for each user.

or ask some guys from IT to solve it for you....
it's not such a thing like copy and paste from Excel to As/400

Avatar of TUN-IT

ASKER

I am IT, I just don't know how to create a Macro. I've already asked other members of my team and no one here has ever had to create one.  
You are IT and have no Access to that box?
do you program any language?
Avatar of TUN-IT

ASKER

I have access to the box but it is restricted.  The box houses multiple LPARs that house data for 6 different properties, and I only manage 3 of those 6.  
have you CL programming experience?
Avatar of TUN-IT

ASKER

No, I don't.  I've only ever used basic commands in the AS/400 - as well as the custom applications my company has built.  
Oke then we do it step by step.
- first do what you heve do to enable a user-ID
- type password +F4, fill user-ID and  'E' end press enter
Now you are back on the command line, press F9 to see your last command,
please note it down (copy past) and let me know what it is (was)

Murph


Avatar of TUN-IT

ASKER

PASSWORD PASSWORD(UTUXXXXX1) SETENB(E)
ASKER CERTIFIED SOLUTION
Avatar of Theo Kouwenhoven
Theo Kouwenhoven
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TUN-IT

ASKER

This was EXACTLY what I needed.  I had to mail merge my list in excel to word in order to fill in the profile names, but this saved me HOURS of work.  THANK YOU MURPHEY2!