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
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
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
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
Thanks again!
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!
Hi,
You can use the tag ClearTextPassword to include an unencrypted password.
David Hervieux
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.
Could you attach your sample?
David Hervieux
http://pastebin.com/We4h9shS
or the attachment.
Thanks for your time.
trialDatasource.xml
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
Thanks again! I'll try with the new information ASAP.
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
Hi,
I've just tried your data source and it works fine for me with the ClearTextPassword.
David Hervieux
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).
Yes it does. I was able to see it with the reveal password. What version of RDM do you use?
David Hervieux
Version 7.6.3.0
Ah this might explain the problem. Could you try with the latest version?
David Hervieux
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
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
Ok the converter, in a very basic version, is completed.