Assigning Assets to Used by field

[Dave Longley]

We are looking at importing all of our assets via CSV and on the test samples we have selected, it does not auto populate the used by field.

 

I have attached the CSV which imports fine. Can someone tell me what I am missing or doing wrong?

Thanks 

Assets-v1.xlsx

[ArmandoDM]

Hi @Dave Longley

in the attachments I can see that the informations on Used By / Owned By are not complete; they miss usedById and ownedById (which are set under usedByName and ownedByName). You need to provide:

usedById
usedByName
usedByType

ownedById
ownedByName
ownedByType

Hope this helps

Regards

Armando

[Dave Longley]

thanks @ArmandoDM, what needs to go in what field? Same value as UsedByName?

[ArmandoDM]

@David Longley

to populate Used By and Owned By you need to use the same syntax. For example:

usedById = davidl
usedByName = David Longley
usedByType = 0

ownedById = phadley
ownedByName = THE NAME OF THIS USER
ownedByType = 0

All the informations you need can be found on the user profile page:

https://devadmin.hornbill.com/<YOUR INSTANCE NAME>/accounts/users/davidl/

usedById = User ID
usedByName = First Name + Last Name
usedByType = 0

 

Regards

Armando