Author Topic: this one is for the code/scripting monkeys out there!  (Read 258 times)

Offline Sol75

  • Nickel Member
  • ***
  • Posts: 773
this one is for the code/scripting monkeys out there!
« on: May 12, 2011, 03:11:05 PM »
Need some serious scripting help, I need to populate approximately 1000 users in active directory's email addresses.

Basically I need to pull the last name, first name, out of AD, and then populate the email addresses of all users as follows:

14firstnamelastname@domain.com

(the 14 will be edited for specific OU's as this designation will change depending on the OU they are in)
Any help would be highly appreciated!

free beer if we ever meet up in RL to anyone who can answer this for me!

thanks in advance,
Matt
80th FS "Headhunters"

S.A.P.P Secret Association of P-38 Pile-its
In-Game as Castiel
Recently Touched By The Noodle! ALL HAIL THE FLYING SPAGHETTI MONSTER!
Pastafarian for life

Offline Gaidin

  • Silver Member
  • ****
  • Posts: 1191
Re: this one is for the code/scripting monkeys out there!
« Reply #1 on: May 12, 2011, 03:30:21 PM »
I will look through my scripts when I get back to the office.

Couple questions, you are pulling the FN/LN out of the AD user list, but where are you inserting the addresses?

Are you using this to create the addresses in exchange or just populate the email field of the user properties?

The scripts I used when we moved from mailto over to exchange pulled the info out and put in format csv file, then I used another to inport into exchange and create the address, this also populated the fields in the affected user properties.
Death is but a doorway to life, only those who fear life fear its opening.

Ingame: 68Gaidin

Proud Member of the CM Team
FSO - Admin

Offline Sol75

  • Nickel Member
  • ***
  • Posts: 773
Re: this one is for the code/scripting monkeys out there!
« Reply #2 on: May 12, 2011, 03:33:38 PM »
the address is simply getting inserted into the email fieldf of user properties.  Nothign needs to be touched in exchange, jsut need this field to be populated.
I dont mind exporting to a csv, then importing from csv, as long as I can import in teh format for the email address I listed above, and populate it into the email address field in user properties.

80th FS "Headhunters"

S.A.P.P Secret Association of P-38 Pile-its
In-Game as Castiel
Recently Touched By The Noodle! ALL HAIL THE FLYING SPAGHETTI MONSTER!
Pastafarian for life

Offline 2bighorn

  • Gold Member
  • *****
  • Posts: 2829
Re: this one is for the code/scripting monkeys out there!
« Reply #3 on: May 12, 2011, 04:28:32 PM »
the address is simply getting inserted into the email fieldf of user properties.  Nothign needs to be touched in exchange, jsut need this field to be populated.
I dont mind exporting to a csv, then importing from csv, as long as I can import in teh format for the email address I listed above, and populate it into the email address field in user properties.

Use 'CSVDE' command to export and import AD data from/to comma delimited format. Nerds...

Offline dedalos

  • Plutonium Member
  • *******
  • Posts: 8052
Re: this one is for the code/scripting monkeys out there!
« Reply #4 on: May 12, 2011, 04:52:09 PM »
Use 'CSVDE' command to export and import AD data from/to comma delimited format. Nerds...

He is alive!!!  :O
Quote from: 2bighorn on December 15, 2010 at 03:46:18 PM
Dedalos pretty much ruined DA.

Offline 2bighorn

  • Gold Member
  • *****
  • Posts: 2829
Re: this one is for the code/scripting monkeys out there!
« Reply #5 on: May 12, 2011, 04:57:30 PM »
He is alive!!!  :O

Oh, you're back  :O