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!
TUN-ITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Theo KouwenhovenApplication ConsultantCommented:
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


TUN-ITAuthor Commented:
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.  
Theo KouwenhovenApplication ConsultantCommented:
DO you have experience in writing Excel macro's?
HTML5 and CSS3 Fundamentals

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

TUN-ITAuthor Commented:
No, I don't.  Is it a simple menu function?
Theo KouwenhovenApplication ConsultantCommented:
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

TUN-ITAuthor Commented:
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.  
Theo KouwenhovenApplication ConsultantCommented:
You are IT and have no Access to that box?
Theo KouwenhovenApplication ConsultantCommented:
do you program any language?
TUN-ITAuthor Commented:
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.  
Theo KouwenhovenApplication ConsultantCommented:
have you CL programming experience?
TUN-ITAuthor Commented:
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.  
Theo KouwenhovenApplication ConsultantCommented:
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


TUN-ITAuthor Commented:
PASSWORD PASSWORD(UTUXXXXX1) SETENB(E)
Theo KouwenhovenApplication ConsultantCommented:
Make a text document named e.g. myMacro.MAC
include the lines from the Snippet in it.
When you are ready, you can execute that with the Client Access Macro.



Regards,
Murph

I assumed you use Client Access???
Description=
[wait app]
"PASSWORD PASSWORD(UTUXXXXX1) SETENB(E)
[Field+]
[ENTER]
[wait app]
"PASSWORD PASSWORD(UTUXXXXX2) SETENB(E)
[Field+]
[ENTER]
[wait app]
"PASSWORD PASSWORD(UTUXXXXX3) SETENB(E)
[Field+]
[ENTER]
etc etc etc 

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TUN-ITAuthor Commented:
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!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
IBM System i

From novice to tech pro — start learning today.