XML / RDM data source format

avatar

Hello, i'm sorry if this question was already answered i did a search with google but without any useful result.

I have a lot of entries in a csv file, and i want to convert them properly for RDM. I tried to play a bit with RDM and i saw that the datasource XML or the RDM are almost the same (kudos for the choice of XML, and anyway, great software!). The point is, instead of "reverse engineering" the format for each type of entry (i mean the sessions), i try to ask first here: where can i find the format to populate correctly a XML datasource or a RDM datasource? So i can create (and why not, share! (1)) a script to convert an csv file with a lot of information in a proper datasource file for RDM.

Thanks a lot for the reply!

(1) As open source of course, the community should help itself! Here: git://git.assembla.com/various-works-only-code.rdmimport.git

PS: if the problem was already address can someone be so kind to link me the previous discussion? Thanks very much!
edited by pierqr.aiello on 1/1/2014
edited by pierqr.aiello on 1/3/2014

All Comments (20)

avatar

Hi,
Unfortunately we don't have a documentation for the format. You can use PowerShell to do it quickly:

http://forum.devolutions.net/forum42-remote-desktop-manager--powershell-repository.aspx

If you really want to generate the Xml manually, you can use the Copy/Paste functionality to quickly get the format. Paste each session type you want to import in notepad to see the format.

David Hervieux

avatar

Yey! A really fast answer! Very kind!

I'll follow your hints and hopefully i'll end with a solution, thanks!
edited by pierqr.aiello on 12/23/2013

avatar

Have a look at this topic, we have another user asking the (almost) same question.

http://forum.devolutions.net/topic9722-import-with-other-fields.aspx

Regards,

Stéfane Lavergne

avatar

Thanks again!

avatar

Ok first problem. Kudos for your choice of safing crypted passwords in the xml. But unless you want to share the encryption algorithm (so i can generate compliant "SafePasswords" ) i need an XML tag for unencrypted passwords. I tried with the tags "Password" and "UnsafePassword" but these didn't work.

Any help?

Thanks!

avatar

Hi,
You can use the tag ClearTextPassword to include an unencrypted password.

David Hervieux

avatar

Ok i used it! (i have to avoid tags because the forum is not happy with them) But the password is not shown in the GUI :(

"Connection"
"ConnectionType"Putty"/ConnectionType"
"Group"FIRST\1st"/Group"
"Name"a putty conn"/Name"
"Putty"
"Host"192.168.252.128"/Host"
"LoginName"root"/LoginName"
"Port"22"/Port"
"ProtocolType"SSH"/ProtocolType"
"ClearTextPassword"root"/ClearTextPassword"
"UseSession"false"/UseSession"
"/Putty"
"/Connection"

Sorry for the repeated question but i have to understand the system at the start.

avatar

Could you attach your sample?

David Hervieux

avatar

http://pastebin.com/We4h9shS

or the attachment.

Thanks for your time.

trialDatasource.xml

avatar

Hi,
I've found two issues:

1. The field ID was missing. This needs to be a unique Guid: http://www.guidgenerator.com/

2. ClearTextPassword was inside the Putty bracket but it's need to be directly inside of Connection

Regards

David Hervieux

avatar

Thanks again! I'll try with the new information ASAP.

avatar

Ok, i added the IDs and the clear password child under the connection section, still no useful result.

With safepassword there is no problem, with cleartextPassword i see nothing in the GUI.

Now the passwords in the csv are not encrypted and the datasource without the passwords will be of little use :( .

trialDatasource[1].xml

avatar

Hi,
I've just tried your data source and it works fine for me with the ClearTextPassword.

David Hervieux

avatar

You mean, does it show the password in the "password" field in the GUI?

Nice. So there is something that doesn't work with my RDM. But whatever, if i have the assurance that it works, i'll start to write the converter (because storing correctly the password is a huge need for the task).

Hopefully i will write again here not with new question but with a first version for the converter (be aware that since RDM allows to store a lot of details in a lot of possible configurations, for now i'm using just the basic fields).

avatar

Yes it does. I was able to see it with the reveal password. What version of RDM do you use?

David Hervieux

avatar

Version 7.6.3.0

avatar

Ah this might explain the problem. Could you try with the latest version?

David Hervieux

avatar

Sure i can, but then all the office should change version. I will update the version after the first iteration (i do small iteration) of the converter and i will update the status here. Thanks a lot for the interest.

And i guess that sooner i will post the link to the code repository (that for now doesn't exist).

OT
I love to share useful tools if these can be copied with ease without destroying the original (so more person can use it), but i don't know if i will be beaten for this xD.

Free knowledge ftw.
/OT

avatar

Small update. The cleartextPassword works correctly. I imported the datasource (just instead of selecting it as datasource, i imported it as .rdm and everything worked).

And i wrote the link to the git repository in the first post.
edited by pierqr.aiello on 1/3/2014
edited by pierqr.aiello on 1/3/2014

avatar

Ok the converter, in a very basic version, is completed.