locked
Exchange 2007 2nd GAL with just sister compaines contacts in RRS feed

  • Question

  • We are trying to create a 2nd GAL so we can add our sister companies contact details, we only need contact details not accounts as we are separate companies but part of the same group so email between.

     

    We can not seem to find a solution to this all searches seem to refer to creating new GAL with sister companies accounts which is not what we want.

     

    Has any body done this before or no how we can achieve it.

     

    We would like a best practice solution for exporting contact details from exchange 2003 also which will meat the required format for exchange 2007 importing.

     

    Again we could not find a way on how to import the .csv file in to a GAL either so any pointer on this would also be gratefully received.

     

    System:

    Windows 2008 sp1

    Exchange 2007 sp1

    Friday, May 1, 2009 8:13 AM

Answers

  • Hummm... that is quite difficult without some good knowledge of programming/scripting to sync every month. You could use Identity Integration Feature Pack (IIFP) which handles sync efficiently but as you told that you don't have connectivity so it doesn't work....

    Easier way I could think is remove all contacts from that OU and recreate all again with new CSV file every month but it may increase network load of Exchange server with Offline Address Book (OAB) differential update download when user comes to office on Monday and opens their Outlook which are configured in cache mode, after you carried out this activity during weekend... 

    BTW, OAB size ratio is around 1MB per 1000 users so in your case 2-3 MB differential update of OAB for 2-3K contacts which is average ok I think, but depends on where your users are located, I mean in local office or they are pulling OAB update from remote office also...


    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    • Proposed as answer by Amit Tank Wednesday, May 6, 2009 5:45 AM
    • Marked as answer by Mike Shen Friday, May 8, 2009 8:54 AM
    Friday, May 1, 2009 3:07 PM

All replies

  • GAL:
    Here is an article to create additional GAL in Exchange 2007. In cmdlet switch -IncludedRecipients pass the value Mailcontacts instead of AllRecipients so it will just pick up all contacts.
    Multiple Global Address List ( GAL ) in Exchange 2007

    Also while creating Contacts for another company, set the value of Company attribute to company name so while creating GAL you can pass it into ConditionalCompany parameter.

    Contacts Creation:
    Here is an article to import contacts from CSV file.
    Bulk create mail contacts based on a CSV file

    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    Friday, May 1, 2009 9:18 AM
  • HI.. thanks for the quick response.  I notice that you have placed a postfix 1 and 2 for each account that this mean we have to go through all our current accounts and contacts and add a postfix to them first?

    The document for importing contacts details from .csv file does not cover phone numbers lind line and mobile is this possible?

    sorry but not been using 2007 for long so still green.

    I would of thosuhgt that you create a new GAL say called 'sister'
    then import teh sister contacts from .csv file direct to this GAL

    Is this correct as I still a little unsure what to do
    Friday, May 1, 2009 11:42 AM
  • No, that is just test environment so I had created object in sequence so I don't have to remember names :)

    Yes, that article doesn't cover how to update detailed info for contacts, here is one which covers it...

    No it is not possible to create a gal and just import contacts from CSV to this GAL because GAL is a representation of mail enabled objects of Active Director so your contacts should be imported in AD/Exchange to display in new GAL based on conditions we defined while creating it.

    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    • Edited by Amit Tank Friday, May 1, 2009 2:05 PM
    Friday, May 1, 2009 1:36 PM
  • HI.. thanks for the prompt response, the link for importing fields does not include phone numbers or at lease i couldnt see it any where and contact with out phone is only half a job.

    Is there a simpler way of creating an address book in exchange so all outlook clients can see it and use it when needed (eg change the address book whne browsing for contacts)

    What i have inplace presently for our sister company is contacts in public folders but sr management want an address list that can be easier accessed through outlook

    Our sister company has around 2-3k users
    Friday, May 1, 2009 1:45 PM
  • Ooops sorry wrong link, I just corrected the same...

    Nop, I don't think so we have any other option because as I told GAL just picks up the objects from the Active Directory based on conditions we set while creating it...

    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    Friday, May 1, 2009 2:11 PM
  • Why not put up a forest trust and leverage the Availability Service/Inter Org Replication?

    Installing, configuring, and using the InterOrg Replication utility
    http://support.microsoft.com/default.aspx/kb/238573

    What does Exchange 2007 Availability Service do?
    http://msexchangeteam.com/archive/2006/10/23/429296.aspx


    I would be concerned that the GAL will get out dated etc so you will need to keep that up to date.

    Or am I missing the objective?


    BP - MCITP:EMA, MCTS
    Friday, May 1, 2009 2:21 PM
  • Hi.. their is no chance of getting exchange servers linked so replication is a NO NO.

    The point on keeping these up to date was another concern we have as not sure how this would be done when all we get from sister company is a export of the contacts in .csv file monthly.  and as all current and sister users/contacts are going to be in exchangeAD how can this be carried out easily as I guess at least once a month would be needed within such a large company where staff move to new department, leave etc.

    Do you have a link that shows how to import.csv file which includes phone number also or can you send me an example how this is done.

     

    again many thanks for your contineous help

    Friday, May 1, 2009 2:40 PM
  • Only thing I can think of:

    Name,email

    John Doe,jdoe@mail.com

     

    import-csv C:\contact.csv | foreach { New-MailContact -alias $_.name -Name $_.name -ExternalEmailAddress $_.email -OrganizationalUnit 'EXCH.ORG/Contact Users' }

    That would place them in a OU of Contact Users.


    BP - MCITP:EMA, MCTS
    Friday, May 1, 2009 2:43 PM
  • Here is the sample to Import contact and set other info like Telephone, Fax & Mobile...


    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    Friday, May 1, 2009 2:44 PM
  • Thanks for that, but what command would you use to up date the OU each month to ensure all changes are carried out eg leaver deleted, moves amanded etc...
    Friday, May 1, 2009 2:49 PM
  • Hummm... that is quite difficult without some good knowledge of programming/scripting to sync every month. You could use Identity Integration Feature Pack (IIFP) which handles sync efficiently but as you told that you don't have connectivity so it doesn't work....

    Easier way I could think is remove all contacts from that OU and recreate all again with new CSV file every month but it may increase network load of Exchange server with Offline Address Book (OAB) differential update download when user comes to office on Monday and opens their Outlook which are configured in cache mode, after you carried out this activity during weekend... 

    BTW, OAB size ratio is around 1MB per 1000 users so in your case 2-3 MB differential update of OAB for 2-3K contacts which is average ok I think, but depends on where your users are located, I mean in local office or they are pulling OAB update from remote office also...


    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    • Proposed as answer by Amit Tank Wednesday, May 6, 2009 5:45 AM
    • Marked as answer by Mike Shen Friday, May 8, 2009 8:54 AM
    Friday, May 1, 2009 3:07 PM
  • Hi.. that link for importing from .csv file links to a great little script for importing contact from the .csv file, so thanks for that,
    but this shows clearly that they importing them to a OU and creating mailboxes, what we need is just contacts sorry to be a pain but does any one no what will need changing to get it to create contacts and not mailboxes?

    Its friday and time to leave this behind until Tuesday brain hurts
    All have a great weekend am sure i will be replying again soon to help get this resolved fully
    Friday, May 1, 2009 3:14 PM
  • That script uses tow basic cmdlets New-MailContact and Set-Contact where first cmdlet creates a mail enabled contact and second cmdlet set additional information so script don't create mailboxes.... :)
    Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
    Friday, May 1, 2009 3:18 PM
  • Hi.. thats interesting i will have to take a better look when back in the office and see if i can identify the cmdlets i was just going on the comment he placed into the script which stated mailbox.

    thanks aging have a nice weekend
    Friday, May 1, 2009 7:04 PM