Using RDM enterprise and trying to import a keepass database with a kdbx extension. When I choose import, I get a keepass .csv but no a kdbx. We also have structure within the keepass file so may folders and entries and passwords. When exported to a .csv all of the formatting is lost.
Is this possible to import a .kdbx file and contents into RDM enterprise?
This is not available for now. We would have to implement the format but I don't know how complex this is. What formatting exactly is lost with the CSV? Do you have an example?
Regards
David Hervieux
David, if you can download keepass, create a database with an encrypted password of 1024 or higher, you can test yourself.
Our current structure is as follows;
Clients
--->Client A (FOLDER/GROUP)
------->VMware (FOLDER/GROUP)
----------->VM1 (includes Name, IP/URL, Username, Password, etc)
----------->VM2 (includes Name, IP/URL, Username, Password, etc)
--->Client B (FOLDER/GROUP)
------->VMware (FOLDER/GROUP)
----------->VM1 (includes Name, IP/URL, Username, Password, etc)
----------->VM2 (includes Name, IP/URL, Username, Password, etc)
-------->VPN (FOLDER/GROUP)
----------->IP, Username, Password
When exported to a csv everything ends up at the root;
Clients
Client A (FOLDER/GROUP)
VMware (FOLDER/GROUP)
VM1 (includes Name, IP, Username, Password, etc)
VM2 (includes Name, IP, Username, Password, etc)
Client B (FOLDER/GROUP)
VMware (FOLDER/GROUP)
VM1 (includes Name, IP, Username, Password, etc)
VM2 (includes Name, IP, Username, Password, etc)
VPN (FOLDER/GROUP)
IP, Username, Password
Hello,
Indeed, KeePass doesn't export the folder structure and I don't know why. I have made a lot of researches on the internet to found a way to export the folder structure properly from KeePass and I have not found any solution yet.
As of now, you would need to modify the CSV to put the proper folder structure prior to the import.
If you want to know how to found the proper column name for your CSV file, please consult
https://help.remotedesktopmanager.com/importcsv_strategies.htm
If you have a sample, I can help you to create a proper CSV file with the appropriate column title.
Best regards,
Jeff Dagenais
Hello,
For your information, I have the confirmation that the groups are not exported using the CSV export in KeePass
https://sourceforge.net/p/keepass/discussion/329221/thread/523f3d59/
Best regards,
Jeff Dagenais
Hello,
I had a chat with our engineering department and it's possible to import the XML format of KeePass in RDM and this will include the groups.
To do so, please go in File -> Import -> Session tab and select KeePass (.xml).
The results of the import will look like the following
Best regards,
Jeff Dagenais
2017-08-15_22-29-48.jpg
After I converted to an xml
I tried to import session keepass legacy 3 options
Credentials
Login account and
Login web
For all options I get a error message
Error in xml document (2,2)
--------------- INNER -----------------------
InvalidOperationException - <KeePassFile xmlns=''> was not expected.
Since this file is encrypted and you're never prompted for a password, I didn't expect this to work. Is there another step before importing?
Hello,
How did you performed the export from KeePass? I would like to test the same steps as you in our environment.
Best regards,
Jeff Dagenais
File, Export, Choose KeePass XML (2.x)
Since you can import .xml file and wanted me to test this, I chose the only XML target as an option.
FYI..running Keepass version 2.31
Hello,
You are using the same KeePass version as me.
In RDM, could you try to perform the import using KeePass (.xml) in the Session tab of the File -> Import menu.
Best regards,
Jeff Dagenais
2017-08-23_07-56-14.jpg
I have done this before, early in this thread, I tried each option and they all error out.
I tried to import session keepass legacy 3 options
Credentials
Login account and Login web
For all options I get a error message
Error in xml document (2,2)
--------------- INNER -----------------------
InvalidOperationException - <KeePassFile xmlns=''> was not expected.
Hello,
This is very strange.
Could you provide me a sample of a .kdbx that you have and that you are not able to import in RDM.
Please send me the sample via private message.
Best regards,
Jeff Dagenais
I just created a new database.
Under database settings, and security, I left the default of AES/Rijndael (256bitkey)
Compression is Gzip
I added a few Groups, Sub groups and entries (tiny file).
Then did an export
Tried the import again and got the exact same error.
Under details
InvalidOperationException - There is an error in XML document (2, 2).
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(Stream stream)
at Devolutions.RemoteDesktopManager.Managers.SerializationManager.LoadObjectFromString[T](String str, Boolean createAnInstanceIfNotExists)
at A.cd6d572b7d291832467da73a3563f480c.c3d50f1886324826d286e8820bf3318d7(String cac93450b2ad63adc067b608718610365, XmlTransferType cff3bc3eca41b330825f1afde934b2dbb)
at Devolutions.RemoteDesktopManager.Managers.SessionMenuManager.c7709f11cfc7aec66439e8ca1c963705e(Object c19f185fd70cefc696ba148af1c4faf54, EventArgs cf1018bb83ec7debd818319fd3cb4844e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.PerformClick()
at Devolutions.RemoteDesktopManager.Frames.FreRibbonTabView.c47a27583e2aa22ddafc027ab6f468556(Object c19f185fd70cefc696ba148af1c4faf54, GalleryItemClickEventArgs c7384fd250bc3f20b960fca8dbed799af)
at DevExpress.XtraBars.Ribbon.Handler.GalleryControlHandlerBase.OnUnpressItem(DXMouseEventArgs e)
at DevExpress.XtraBars.Ribbon.Handler.GalleryControlHandlerBase.OnUnpress(DXMouseEventArgs e)
at DevExpress.XtraBars.Ribbon.Handler.GalleryControlHandlerBase.OnMouseUp(DXMouseEventArgs e)
at DevExpress.XtraBars.Ribbon.GalleryControl.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraBars.Ribbon.GalleryControl.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
------------------- INNER -----------------------
InvalidOperationException - <KeePassFile xmlns=''> was not expected.
at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderpwlist.Read6_pwlist()
Capture.PNG
Hello,
I double-check my KeePass version and I am using 2.36, not 2.31 like I mentioned in a previous post. Sorry about that.
That being said, here's a test database that I have created in KeePass and that I was able to import as Credential entries in RDM via the File -> Import -> Session tab -> KeePass (.xml) button.
Let me know if you are able to import this XML in your RDM.
Best regards,
Jeff Dagenais
JohnQuinn.xml