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.

MurpheyApplication 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


0
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.  
0
MurpheyApplication ConsultantCommented:
DO you have experience in writing Excel macro's?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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

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


0
TUN-ITAuthor Commented:
PASSWORD PASSWORD(UTUXXXXX1) SETENB(E)
0
MurpheyApplication 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

0

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!
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.