We help IT Professionals succeed at work.

Need to output or directly import a set of template values to a registry with data from an access table.

bcrooks
bcrooks asked
on
333 Views
Last Modified: 2013-11-27
I am working with IPSwitch Imail 2006 and am working on a script to create new accounts.  The accounts are created properly, but do not set any of the parameters suchs mailbox size, return email address, calendar options, etc.  Every account has a registry entry on the server.  I have a template .reg with certain values that need to be changed, but not all of them.  I have an access table that has the data for the values that need to be changed.  Those registry entries then need to be imported into the registry. Here's the template:  

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Ipswitch\IMail\Domains\test.govst.edu\Users\STUDENTUSERID]
"MailAddr"="STUDENTEMAIL"
"Flags"=dword:00002080
"Type"=dword:00000000
"MaxSize"=dword:00a00000
"MaxMsgs"=dword:00000008
"LastNotify"=dword:00000000
"LastLogin"=dword:475d6537
"NumNotify"=dword:00000000
"SuspendUserAccount"=dword:00000000
"EnableAltWGSID"=dword:00000000
"AltWGSID"=""
"NumTries"=dword:00000000
"AttemptTime"=dword:00000000
"NumTimesSuspended"=dword:00000000
"ICalEnable"=dword:00000001
"SpellEnable"=dword:ffffffff
"NoOfSuggestions"=dword:ffffffff
"Depth"=dword:ffffffff
"Options"=dword:00000000
"SpellChecking"=dword:00000000
"PreviewSize"=dword:ffffffff
"Default_View"="MONTHLY"
"Entry_Granularity"=dword:0000003c
"Start_Day"=dword:00000000
"Start_Time"=dword:00000009
"End_Time"=dword:00000012
"TimeZone"="S GMT Standard Time"
"Max_No_Of_Events_To_Display"=dword:00000000
"Max_Tasks_To_Display"=dword:00000000
"Max_Notes_To_Display"=dword:00000000
"Def_Cal_Name"="Personal"
"Max_Daily_Recur_Count"=dword:0000016d
"Max_Weekly_Recur_Count"=dword:00000064
"Max_Monthly_Recur_Count"=dword:00000024
"Max_Yearly_Recur_Count"=dword:00000005
"Display_Completed_Tasks"=dword:00000000
"Hours_Clock"=dword:0000000c
"Max_No_Of_SearchResult_Per_Page"=dword:0000000a
"Max_Event_Title_Length"=dword:00000019
"Max_Task_Title_Length"=dword:0000000a
"Confim_On_Delete"=dword:00000000

Where is says "STUDENTUSERID" I need it to import the student user ID and "STUDENTEMAIL" needs to be the full email address, but with the user's alias, not Student ID number.  Both values are columns in an Access table.
Comment
Watch Question

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.