Möglichkeiten Kontakt-Einträge zu synchronisieren

Hello Reiner,

Our apologies for replying in English.

Could you please confirm what type of data source you use in RDM? You will most likely need to use the Devolutions.PowerShell module to connect to your entries, and you can retrieve the information for your other systems. You can refer to https://docs.devolutions.net/kb/devolutions-powershell/remote-desktop-manager/rdm-powershell-core-module/ for more details.

Best regards,

Hello Richard,

so, I do my best in English, no problem (I hope).

We use a Microsoft SQL Server as our data source.
If the connection to our entries should be established via PowerShell module:

1. there is no Synch AddOn for Exchange or MetaDirectory for RDM contacts
2. it will be an PowerShell-Export with all contact data to an export file and the other system has to handle this export file, right?

Where can I find the therefore needed PowerShell commands and the possibility to filter?

Best regards,
Reiner

Hello Reiner,

There is no synchronization available for Exchange or MetaDirectory, unfortunately,

Here is a sample to export entries to a CSV file - https://github.com/Devolutions/RDMSamples-ps/blob/main/module/export/ExportCustomToCSV.ps1

We support CSV, HTML, and XML for the export:



Best regards,

Hello Richard,

this will give me a very big file which not contains the Asset contact informations.
How can I filter the resulsts by type and how do I get the contact information of this session-objekt?

Kind regards,
Reiner

Hello Reiner,

On the line 17, you can modify it only to include contacts:

$sessions = Get-RDMSession -Type Contact

You can then extract the information you need, for example:

$sessions | Select-Object Name, {$_.MetaInformation.Email}, {$_.MetaInformation.FirstName}, {$_.MetaInformation.LastName}

Best regards,

Hello Richard,

for me it worked only with
$sessions = Get-RDMSession | Where-Objekt {$_.ConnectionType -eq 'Contact'}
but it worked.

Where can I find the MetaInformation-FieldNames that exist?
There must be a documentation somewhere, can you help me out?
In my RDM Version it is called 'Tel. Büro', 'Tel.Privat' etc. and I don't want to guess the english field names,
I want to know them.

Thank's in advance for you help.

kind regards,
Reiner

Hello Reiner,

You can right-click on an entry - Clipboard - Copy - Preview to view the structure of the entry. Please note it will only display the fields in that entry.

For more information, you can refer to https://docs.devolutions.net/rdm/windows/powershell-scripting/tips-tricks/#reverse-engineering-an-entrys-structure

Best regards,

Hello Richard,

thank you.
I will have a look if I can get this to work this way.

I guess I can return to this case in november

kind regards,
Reiner

Hello Richard,

it works like a charm.

# Verbindung zur Datenquelle herstellen
$ds = Get-RDMDataSource -Name "SQLServer Datasource Name"

# Alle Kontakte aus dem RDM auslesen
$sessions =get-rdmsession | Where-Object {$_.ConnectionType -eq 'Contact'}

# Kontakte exportieren mit allen Metainformationen
$sessions | Select -Property ID, Name -ExpandProperty MetaInformation | Export-Csv C:\tmp\RDMKontakte.csv -NoTypeInformation -Encoding Default

The ESTOS MetaDirectory can do an import of these contacts.
Now I "only" have to figure out, how I get these contacts into Exchange/Outlook and ActiveSync.

Thank's for your support.

kind regards,
Reiner

Hello Reiner,

My pleasure; it's great to see you can export the desired information!

Best regards,