Somebytes SoftwareSomebytes Software Development

Use cases

On this page I collect possible user scenarios in connection with ExMixedFolders.

Importing customer data into an Exchange folder

A true story of an administrator of company XY, who could have really happened one way or the other:

Recently, a colleague from the customer service department came by with an Excel spreadsheet from a CRM system. The file should be read in a public folder from Exchange. After a short time, it turned out that the list is created weekly by the system. This work would then be carried out on a weekly basis in the future.  As I wanted to help, I googleed for a hopefully already working PowerShell script, which does such a task. The Internet brought a lot of things to light. Most of the examples referred to the New-MailContact cmdlet that creates objects in the AD. Unfortunately, however, the task was to read the contacts into a public contact folder.  After I couldn't present a suitable solution in a hurry, I asked Somebytes because I have been using ExMixedFolders for matching public folders for some time now. But here too I was told that a solution was in progress, but never finished. So a few days passed that I spent with other things.  After a few weeks I received an unsolicited email from Somebytes asking me if the solution was still interesting for me, because a new update of ExMixedFolders would make it possible to import Excel and CSV files from other systems. After I became curious, I tested the program. Unfortunately it was not possible to use the Excel file without any adaptations on my part, because it did not contain an ID and some fields had other names, but I was able to present an acceptable solution to the customer service.

Shared contacts in the office and on the road

A customer writes:

We are 6 people here in the office, everyone has an Exchange mailbox and we want to share our contacts on the road and in the office. We have different devices. The designer works with Mac and iPhone and we work with Windows and Android as mobile devices. Each of us has already set up our own mailbox on our end devices. Everyone should be able to change and add contacts. For private contacts, everyone uses their own private mailbox.

In this case, it is best to merge your respective contact folders using ExMixedFolders. It can be run on one of the Windows workstations or better, and if available and accessible, on the server because it is always running.

Proceed as follows if you want to synchronize the contacts of all users.

After installing ExMixedFolders, you will find a configurator in which you can either create an Exchange connection for each user or, in the case of Impersonation, configure a service user who accesses Exchange and the user's mailboxes on a proxy basis. 

After the connection to the exchange server is established, you can create a synchronization request for each user. You need 5 jobs for 6 users.

sync by starform

Creation of synchronization orders in star form.

Specify a user to be used in each job on the left-hand side. The contacts are then synchronized by each user (2-6) to this user (1) and are distributed back to all users.

To select the mailbox folder, select the appropriate Exchange connection or, in case of impersonation, type the SMTP address of the mailbox in the user field and then select the user's contact folder.  

You can then select "Save configuration and restart service" under Service and the process begins. If everything works properly, the configurator can be closed because the service works in the background.

Calendar synchronization and marking of authors in category colors

Ein Kunde fragt an:

I would like to achieve the same thing as this customer, but with the difference that these are calendars and their appointments should be color-coded, depending on which user has entered them.

To achieve this you can follow the same procedure. Then check the box in the configuration order. "categorize by author".

Kategorie nach Urheber

Now you only have to assign the desired color to the resulting categories. You can do this under Outlook in the main category list. If you don't want to do this for all users individually, you can also synchronize the categories via ExMixedFolders. ExMixedFolders offers a specially prepared job for this purpose in the menu under Synchronization jobs.