Devolutions ForumDevolutions Forum

Import Assetinfo from CSV

Import Assetinfo from CSV

avatar
Werner

Following that online help page:
Import Strategies and file format (remotedesktopmanager.com)

I prepared a test .csv:
Host,Name,ConnectionType,MetaInformation\SerialNumber,MetaInformation\ServiceTag,MetaInformation\PurchaseDate
Host,Name,Group,12345678,ServiceTag,2021-01-01

After import a folder is created, Information like Host and Name ist imported, but Assetinformation like SerialNumber, ServiceTag and PurchaseDate is not.

Can you help?
Thx!
Werner

All Comments (2)

avatar
Samuel Dery

Hello Werner,

I've done some testing on my end and have been able to achieve the desired results.

You will first have to change your .csv to "." instead of "\" here is what it should look like:
Host,Name,ConnectionType,MetaInformation.SerialNumber,MetaInformation.ServiceTag,MetaInformation.PurchaseDate

With these changes done, when importing the .csv file once you reach the "Mappings" tab you will have to add three "Direct Property" fields with the following:
forum image
With this configuration, it seems to be working without any issues.

Let me know if this helps,

Best regards,

Samuel Dery

avatar
Werner

Hi Samuel,
Works :-) Thank you very much!
Werner