CSV import with subconnections

Resolved

CSV import with subconnections

avatar

Hi,

I' am trying to import sessions with subconnections from a CSV file.

For testing purpurses, I've created two RDP connections with following names:

test (group)
--Computer 1 (session)
--------Computer 1 (subconnection)
--Computer 2 (session)
--------Computer 2 (subconnection)

Sessions Computer 1 and 2 are Microsoft Remote Desktop (RDP) and subsessions Computer 1 and 2 are Remote Assistance.

My export CSV file looks like this:

ConnectionType,ConnectionSubType,SubMode,Name,Group,Description,Expiration,Parent,Host,Port,CredentialUserName,CredentialDomain,CredentialPassword,OpenInConsole
Microsoft Remote Desktop (RDP),,0,Computer 1,test,,,,computer1,,,,,No
Remote Assistance,,0,Computer 1,,,,Computer 1,,,,,,
Microsoft Remote Desktop (RDP),,0,Computer 2,test,,,,computer2,,,,,No
Remote Assistance,,0,Computer 2,,,,Computer 2,,,,,,

When I try to import the thing back, an unexpected error occures. Log:

[26.6.2015 13:25:05]ERROR SILENT System.ArgumentException: Object of type 'System.String' cannot be converted to type 'Devolutions.RemoteDesktopManager.Business.Connection'.
at System.RuntimeType.TryChangeType(Object value, Binder binder, CultureInfo culture, Boolean needsSpecialCast)
at System.RuntimeType.CheckValue(Object value, Binder binder, CultureInfo culture, BindingFlags invokeAttr)
at System.Reflection.MethodBase.CheckArguments(Object[] parameters, Binder binder, BindingFlags invokeAttr, CultureInfo culture, Signature sig)
at System.Reflection.RuntimeMethodInfo.InvokeArgumentsCheck(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.RuntimePropertyInfo.SetValue(Object obj, Object value, BindingFlags invokeAttr, Binder binder, Object[] index, CultureInfo culture)
at System.Reflection.RuntimePropertyInfo.SetValue(Object obj, Object value, Object[] index)
at Devolutions.Utils.ReflectionUtils.SetPropertyValue(Object obj, String propertyName, Object value, Boolean allowNull)
at Devolutions.RemoteDesktopManager.Business.BusinessHelper.SetPropertyDirect(Object source, String containerName, String propertyName, Object value)
at Devolutions.RemoteDesktopManager.Business.CsvFormat.CsvImport.ImportFromCsv(String fileName, String rootFolder, Connection connectionTemplate, String& errorMessage, List`1 importCanditates)
at Devolutions.RemoteDesktopManager.Forms.FrmImportCsvWizard.ImportFromCsv(String fileName, String destGroup)

If Remote Assistance entries from CSV are deleted, import goes well. No subconnection gets imported, of course.

How do I construct my CSV file to do it right?

All Comments (2)

avatar

was this answered actually?

avatar

Hello,

Thank you for contacting us on that matter.

Unfortunately, there is no way to import sub-entries via the CSV file at the moment.
We opened a recent feature request for this. For future information on this feature, you can refer to this link.
https://forum.devolutions.net/topics/43513/import-ssh-session

Best regards,

Jacob Lafrenière