My first "Open Source" script :D

[vass0922]

Yeah yeah its kinda cheesy, but figured hey.. maybe somebody can think of some improvements to be made!
Now the only thing is, this is kind of a "niche" thing considering its really only useful for MS Exchange GAL (Global Address List) exports...
However, who knows maybe somebody can learn some (poor LOL) vbscript from it
Anyways, I had to write this up fairly quick for work so its not the cleanest code ever written, and maybe kinda hard to follow.. however, if you have any suggestions feel free to speak up
I'm going to make it a link, so you'll have to right click on the link and "Save As...." or it'll execute locally...
THIS IS NOT A VIRUS lol
Most folks know me around here that I do a bit of programming.. I'm ASKING that people look at the code and make comments lol
I chose not to put the code into the forum, because it'd be a bit lengthy and would definately blow out the tables. DOH!
If you do happen to just click on it, have no fears a stupid input box will open up asking for a file, just hit ok or something and it''ll error out.
Right now this is kind of like the linux kernel at first release... very rudimentary (no error handling lol) but it works
There are more comments inside to help understand, if you have any questions feel free to ask

Email Yanker thingie
Again, please RIGHT click it, and click save as
You can open this freely in notepad (or Preferrably metapad )
Have Fun lol

--- edit ---
LOL duh, just LEFT clicked on it IE out of curiosity and for some weird reason Media Player opened

Hey Vass. I wish I could say "nice work", but when I choose save as it saves it as a file called "YankEmailAddr.mpeg" rolleyes:

Can we have a nicer linky, please??

Cheers
Mick

Edit: well I can open it in notepad despite the mpeg extension.

Looks cool. Can't use it for anything I do, though.

Can ya make something useful, vass??

J/K

Well I won't use this one at church in case it finds a dupe SMTP address Pastor may not be amused!!

But otherwise seems straight forw\ad enough. How do you kill it though??

Cheers
Mick

[ChoaticWhisper]

Quote:

Originally posted by mickwish
when I choose save as it saves it as a file called "YankEmailAddr.mpeg"

Same Here, I know just rename it to .vbs
Well I couldnt use it anyway, But nice of you to do something like this.

[krohnjw]

Saves fine for me guys...I'm using opera

[vass0922]

Go into task manager, and kill wscript.exe
WScript.exe is the interpreter it uses to run all vbs scripts!
The script itself doesn't find dupes, it simply strips out SMTP address from a Exchange export.
If you have access to Exchange, go up to Tools --> Directory Export.
Choose "Global Address List" as the source, home server and home site should be the default.
Once its exported into a .csv file (I believe the default export includes the columns for Email Address and Email Addresses, but I know it does not include SecondaryProxyAddress (which contains even more email addresses lol)
Once you have that exported, you run this script on it SHOULD lol strip out all SMTP addresses...
The reason we have to use it, is because we're setting up new X.400 connector with another site, and we have to find out where our GAL's may conflict. Our GAL has > 150k entries so not doing that manually
Also the one we're testing against has >50k entries.. hence the need for scripting lol

[vass0922]

Oh and Exchange won't allow you to have duplicates, it'll complain so you shouldn't have any worries Mick
It's just a pain when you put up a new X.400 connector to another site

[vass0922]

Ok due to some new requirements I'm pretty much re-vamping the whole thing
I'll put up a new link so people can see the differences and "new and improved" coughcough structure lol
The new method will be a bit cleaner, more efficient and will also allow me to output different columns as needed as long as they're in the original file. My new requirement was, they also wanted the display name and the ObjClass (which says if its a mailbox or custom recipient etc)
Will keep you updated