CSV import problem

Hi,
It use the default selected template and it must be RDP. There is no type specified in the csv. You can now specify the template field with RDM 9.5 Beta

Hello,

You have a field ConnectionType where you find VNC so if i export this, normaly you can import it using this field no?


As example for my export:

ConnectionType,Name,Group,Description,Expiration,Parent,Host,CredentialUserName,CredentialDomain,CredentialPassword
VNC,I 11,Aust\test,Machine Sydney 114,,,10.10.248.99,,,Pass1!


I want to add 100 lines using this template.

Normallly i have to find a vnc connection.

CSV is much quicker as xml for me.

Thanks
edited by oschott on 6/10/2014

Hi,
I have entered a feature request to support that.

Thanks,

for me was logic if you can export as csv that you can import a csv file, specialy if the feature is there.

Let me know how long it will take to add this feature, we actually test your soft in our IT Dpt ( we have different customers in the world for each a different connection :-) so lucky your soft exist :-)

Bests regards

Olivier
edited by oschott on 6/10/2014

It's much easier to export than import. We added the field for another user that needed it and this explain why we only have half of the work done. I will try to get back to you soon with the answer.

Hello David,

Do you have any update for this point please?

Thanks

Olivier

This is already available in the latest beta:

http://remotedesktopmanager.com/Home/Download#beta

Sorry I've forgotten to notify you.

Thanks for that i will test it ;) David

Hello David,

there is still a issue with this.

When you export the group with any ultravnc connections, here for the exemple there're in a group France\Machines Paris\louvres and have a description information direct for each connection, when you import this again you will have all ultravnc connection in a group direct, in the csv you loose the group information France\Machines Paris\louvres and replace with the data you find in the field description.


Strange For IE is ok so, i think the probem is maybe there for other items, i haven't time to test it.


Regards.

Olivier

Could you create a small sample and post it here?

Hello David,

Here you have the rdm files and the one i exported using the export function see capture.

The goal is too have the same as the file in .rdm in CSV after


Bests regards.

Olivier

Hi,
Our office are closed Monday (Canadian Thanks Giving) but I will look into it soon.

Hello David,

Have fun and enjoy it

Regards

Olivier

Hello David,

Can you reproduce the export problem that bring you to a import problem with the exemple i provide you??

Best regards

Olivier
edited by oschott on 10/16/2014

Hi,
I'm working on this but it's not as simple as it seems. The connection type is translated. This means that it's not simple to import them back. That why the Xml export is really the good solution since it contains all the fields and details. The csv is more intended for reporting than edition. I'm not sure what I could do.

Hi,
I've found a way to fix it. This will be in the next release. Thank you for the sample.

Regards

Thanks David,

You're welcome help to improve this software is important.

regards

Olivier

Hello,

there is a issue with importing a csv the column CredentialPassword is not taken in account when you do a import

I give you a exemple, this exemple you have to put in a csv file and import with the csv session assitant.

ConnectionType,ConnectionSubType,SubMode,Name,Group,Description,Expiration,Parent,Host,Port,CredentialUserName,CredentialDomain,CredentialPassword
VNC,UltraVNC,0,Machine 1,Machine \Site1,,,,10.0.0.1,,,,Password1!
Web Browser (http/https),IE,0,Step 2 Machine 1,Machine \Site1,,,,https://10.0.0.3,,test-88,,Superpass2015!

What's strange its when you export the exemple where you put the password manually everything is populated as the exemple i gave you.

Can you fix this issue because we use this solution to do big import.

Thanks

Best regard

Olivier

Could you try ClearTextPassword instead of CredentialPassword?

Hello David same issue with the ClearTextPassword in the csv file

But a stupid question why the column is populated with a field CredentialPassword when you export as csv and why is it not working in import modus if everything is fine populated ? That's confusing

Olivier

Hi Olivier,
I will look into it next week and try to do something about that ans simplify it.

Hello David,

Thanks will be great, send me a message here when is done so I can try it for you

Regards

OLivier

Hi,
I've found the problem and it will be fixed for the next beta.

Regards

Thanks David,

So I will test it for sure

Regards

Olivier

Hello David,

Sorry the csv import doesn't work try to import the attached files you will see its not good

I put the rdm also you will see the password are not imported


Regards

Olivier

Hi,

I looked at the code, and using "CredentialPassword" instead of "ClearTextPassword" should work fine.

Regards,

Hello Hubert,

Ok i replace it and works now. Maybe you need to purpose this option when you export??


I have 400 import to do its much easy so...

Thanks for the support


Best regard

Olivier

When you export as CSV, it should put the password in the CredentialPassword field which makes for easy export/imports. Could you check if exporting puts the password in that field as expected? I'm not sure if it did that in the previous versions of RDM but it should do that in RDM 11.

Regards,