CSV Import does not recognize ConnectionType
Hi All,
When trying to import sessions from a CSV (Import Session CSV Wizard), RDM does not recognize the ConnectionType Field. This results in all the entries becoming "RDP" sessions when I have some SSH connections that need to be imported on the same csv file.
I can create another template to import SSH sessions but not understanding why this extra step needs to be done. When exporting to a CSV, RDM exports all connections and correctly labels them in the "ConnectionType" column of the CSV.
All Comments (6)
Hi,
Unfortunately this is a limitation that we have. You should use the .rdm format to easily import/export your content or continue to use a template. You can also use the refactoring to convert the imported type.
David Hervieux
Hi David,
I chose the CSV format so that it could also be maintained easily. Can a .rdm file be edited by a text editor?
its an xml file, so it is maintainable, but less easily than a csv file
Maurice
The Xml also contains all the fields and not just a subset.
David Hervieux
Thanks Gents for the prompt responses.
As an aside, I often recommend to use a full blown excel workbook to manage their import process. The second step being a template selection, we typically do the export on a type by type basis.
Here's a macro I use to export the activesheet to a csv. A big problem of Office in other cultures is that it uses something other than the comma as a separator, which is fixed when using VBA.
Sub CopyToCSV()
Dim CurrentFile As String
Dim MyFileName As String
CurrentFile = Left(ThisWorkbook.FullName, (InStrRev(ThisWorkbook.FullName, ".", -1, vbTextCompare) - 1))
MyFileName = CurrentFile & Format(Now, "ddmmyyHhNnSs") & ".csv"
'Copies the sheet to a new workbook:
ActiveSheet.Copy
'The new workbook becomes Activeworkbook:
With ActiveWorkbook
.SaveAs Filename:= _
MyFileName, _
FileFormat:=xlCSV, _
CreateBackup:=False
.Close False
End With
End Sub
Maurice