Assets uploaded (Computer Peripheral) not being picked-up on Add/Get nodes of workflow (data missing the "0" in "urn:sys:0:" reference)

[Berto2002]

Hi, we are about to upload data for 500 headsets.

The values for h_used_by and h_used_by_name were exactly as they are in the user profile in Service Manager (same case etc)

The upload was "successful" according to the UI and if I view the record in the Asset Manager, the data looks fine (Used by and Name showing in the fields and lists.

BUT, when I run workflow to pick-up and use the peripheral asset uploaded it is not found/processed by the Add/Get nodes.

When I probe the database I have this name in the h_used_by field: 

urn:sys::First Last:FirstLast@ourdomain.gov.uk

When I edit the Used by manually and re-save it, I then have this name in the h_used_by field: 

urn:sys:0:First Last:FirstLast@ourdomain.gov.uk

The difference is the "0". Something about the upload is missing the "0" and this appears to render the data undetectable to the workflow. Defect?
 

[Berto2002]

@andrewmorris

[Steve Giller]

19 minutes ago, Berto2002 said:

The upload was "successful" according to the UI

The upload was successful, the issue is with the data.

19 minutes ago, Berto2002 said:

the data looks fine (Used by and Name showing in the fields and lists.

This is because the Display fields are populated.

19 minutes ago, Berto2002 said:

The difference is the "0". Something about the upload is missing the "0" and this appears to render the data undetectable to the workflow. Defect?

Not a defect, it's incorrect data within your import. (I'm sure we have addressed this previously with exactly the same issue that was causing the "Add Assets" node not to act as expected.)

You can correct the data by updating it using the Asset Import Tool. This can use a csv as a source, so you can correct the data in the spreadsheet, save as a csv if necessary, and then import the updated values. For this you will only need to populate h_owned_by and/or h_used_by with a valid UserId.

[Berto2002]

@andrewmorris

[Berto2002]

@Steve Giller I need a little more of your patience here please because it still has not worked.

We are using the Asset Import feature: (https://live.hornbill.com/xxx/servicemanager/asset/upload/)

We download the csv template (Asset Computer Peripherals). Previously we did in include the usedById and the usedByName but on your advice above, we removed data from the usedByName and tried again.

The result was:

• In the UI it all looked good; we saw the userID and name showing
• In the DB it didn't. The name was missing and the userId showed as . This time it had 3 colons (previously it was either ":0:" or "::") and again was not detected by workflow.

We do not want to use the Asset Importer program. We want to use the uploader in the UI. This is the thing that is not working. What do we do to get this feature to correctly understand the user identifier for new assets? Our data has the correct UserID and UserName but the data is not correctly received in this UI fuction whichever combination of these we use.

To use the Asset Importer program we would need to have the instructions updated to tell us how to use it for net new assets; when we look, all the examples seem to have this section which matches existing assets and we don't know how to remove that so it doesn't try to match but creates net new:

[Steve Giller]

29 minutes ago, Berto2002 said:

we don't know how to remove that so it doesn't try to match but creates net new

As per the documentation, if no match is found and the operationType is set to "Create" or "Both" a new asset will be created:

The advice to just use the User Name was for the Asset Import Tool, not the UI.

On 09/07/2024 at 12:11, Steve Giller said:

You can correct the data by updating it using the Asset Import Tool. This can use a csv as a source, so you can correct the data in the spreadsheet, save as a csv if necessary, and then import the updated values. For this you will only need to populate h_owned_by and/or h_used_by with a valid UserId.

The UI upload assumes you know what data you are putting in and why, which means you will need the correct User ID, User Name, and User Type for each User, mismatching any of these will result in an incorrectly formed URN.

[Berto2002]

14 minutes ago, Steve Giller said:

you will need the correct User ID, User Name, and User Type for each User

OK so that's what we have done and we have an issue so I will do one more test and then log a ticket with support to investigate our case if we confirm the data is correct but not being imported correctly. Thank you.