Adding more custom fields for bulk importation in RDM
0 vote
I came across a use case with the company I work with where I had to export, in some cases, 20 custom fields for the importation of bulk connections info from templates. RDP Template for example.
I know there's 10 at the moment but it would very helpful to have more, i'm pretty sure that could help some companies to get onboard with the RDM product as well.
If you ever need more precision about the idea
Hello,
Thank you for the request. We've opened an internal ticket for this request.
Regards,
Hubert Mireault
Hi Hubert,
Thank you very much for the interest for this feature request.
I appreciate the follow-up.
Regards,
David
Hi,
Is it something that is in development ?
Hello,
This is not currently in our roadmap, but we are keeping an eye out for additional feedback to help us prioritize this.
Regards,
Hubert Mireault
Hi Hubert,
Thank you for taking the time to do a follow-up.
Since it's "one-time deal" and once the importation is done, that feature isn't used any more, maybe that's why there isn't much feedback here. I asked for this feature I am struggling to import data from Microsoft dynamics where some template has sometimes more than 15 custom fields for now, I'm trying to merge the fields with Excel formula , I did not find any other way around it so far.
Any other idea on how to handle the importation?
Regards,
David
Hello David,
There is a way to do it using the Devolutions.PowerShell module.
If we want to add Custom fields for the first 5 items, we must use the following properties.
CustomField1Value, CustomField2Value, CustomField3Value, CustomField4Value and CustomField5Value
We can also add more items to the CustomFieldEntities array.
Here is a sample code for this scenario.
$entry = New-RDMEntry -Type RDPConfigured -Name "MyRDP" -Host "192.168.1.15" -Group "<Folder Path Here>"
$entry.MetaInformation.CustomField1Value = "<Your value here>"
$entry.MetaInformation.CustomField2Value = "<Your value here>"
$entry.MetaInformation.CustomField3Value = "<Your value here>"
$entry.MetaInformation.CustomField4Value = "<Your value here>"
$entry.MetaInformation.CustomField5Value = "<Your value here>"
$values = <Values you get from the importation file>
foreach ($newvalue in $values)
{
$cf = New-Object Devolutions.RemoteDesktopManager.Business.CustomFieldEntity
$cf.CustomFieldType = 'Text'
$cf.CustomFieldValue = "<Your value here>"
$entry.MetaInformation.CustomFieldEntities += $cf
}
Set-RDMEntry $entry -Refresh
Let us know if that helps.
Best regards,
Érica Poirier
Hi Érica,
Thank you so much for taking the time to respond to this.
In the end, I have chosen the option of "consolidation."
What I mean by that is that the process I have used is simply to export all the necessary fields in a CSV file and with some Excel formula, I have to consolidate some of the columns to arrive at the point where I have 10 columns of information to import and that would fit the limitation of devolution where I have 10 manageable custom fields with RDP / Teamviewer templates.
I hope this could help some other in the same scenario :-).
Have a good day and thank you for your time !
Regards,
David