Can I do a mass import of SSH connections?

Can I do a mass import of SSH connections?

avatar

I found out how I can use the Host List option to import a bunch of RDP connections which worked great. I just used computer name|IP:Port

Is there any way to do something similar for Native SSH connections?
I would need to be able to specify the Name, Host IP, Local Port, and Remote host (Tunnel) IP.

Thanks.

All Comments (10)

avatar

Hi,
Unfortunately I think you will need to use PowerShell.

David Hervieux

avatar

OK. Can you point me towards some powershell instructions or anything?
Thanks.

avatar

actually, i just improved the import csv wizard to support all fields.

you still have to figure out the name of columns to use though, but it's described in http://help.remotedesktopmanager.com/importsessioncsvwizard.htm?zoom_highlightsub=import%2Bcsv

if you prefer powershell, just let me know and I'll help you out, but it will be tomorrow during the day ;)

Maurice

avatar

Well, I exported one of my existing SSH connections to a CSV file to check the column names and it gave me some of the info but didn't include everything.

It didn't include any fields from the Outgoing Tunnel Settings section. Local IP, Port, Remote Host, Remote Port.

If you can tell me the field names I'd need to use for that data, I think everything else I'd need was included. Or if you'd recommend Powershell, I'm fine either way. We'll just have a couple hundred SSH sessions to create so I need some way of doing a mass import of them.

Thanks!

avatar

Hello,

Indeed, fields that contain default values or that are blank are not exported. Had you specified a value for the fields that you needed?

If you have a simple import scenario, and I feel that this is the case, then I would continue with the CSV import. Powershell is required when you must transform data or apply a certain logic to the workflow.

If you send me an export of a session that has all the fields, I will gladly send you the csv header to use.

Maurice

avatar

I took an existing SSH connection that I have which has the following fields set:
Name, Host, Host Port, Remote Host, Remote Port, Local Port

Of the above fields, the CSV file only contains the fields:
Name, Host, Host Port

It doesn't have entries for the Tunnel settings: Remote Host, Remote Port, or Local Port.

I can email you a screenshot or my connection and the CSV file if that would help.

avatar

Hello,

Please do not export to csv, not all fields are supported.

Right-click on your ssh session, then use Clipboard - Copy, then paste the result in a Private message or send it at support@devolutions.net. Ensure you specify your forum username if using the latter.

Maurice

avatar

Just PM'd you the info. Forgot about this until now...

avatar





hmm, the fields your require are all directly under the root, it should work with our CSV import

Could you create the csv file and run the import? It won't be a loss of time because you need to create the csv file anyway. If it doesn't work I will send you the powershell script.

Best regards

Maurice

avatar

PM'd you back with the details. Two of the fields didn't import. They look to be sub-fields of the Putty container.

Ends in 7 days