No matching reference value found when I tried to update knowledge article by using easy import

[takazawa issei]

Hi there,

I want to update category of knowledge by using "easy import". (I am using Excel file to update knowledge category)

First, I set value "GoogleMeet" on kb_category on Excel file.(Please refer to the image below.)

When I tried to upload the Excel file, error was displayed "No matching reference value found for No matching reference value found for Category. Please use an existing reference value."(Please refer to the image below.)

Next, I set value syd_id of knowledge category on kb_category field.(Please refer to the image below.)

When I tried to upload Excel file again, the same error was displayed.(Please refer to the image below.)

If I click the button "Ignore Row Errors and Complete Import", knowledge article is updated.(Please refer to the image below.)

I would like to ask:

1. Why it kept displaying "No matching reference value found for No matching reference value found for Category. Please use an existing reference value."? What is this error mean?

2. Is it okay to click on button "Ignore Row Errors and Complete Import"?

Thanks in advance.

Regards,

Issei

[takazawa issei]

Hi Mario,

Thank you for your reply.

When I tried the same method but error message was displayed.

Error message: "No matching reference value found for No matching reference value found for Category. Please use an existing reference value."

Best regards,

Issei 

[Pranesh072]

are you using the template for import the data ?

Update template

Template contains a header row with valid field names. Template contains one or more data rows. Template contains a sys_id column to match a row to an existing record.

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/import-sets/referen...

[takazawa issei]

Hi Pranesh, 

Thank you for your reply.

Yes! I used Excel template contain a header row with valid field names.

However I delete the unnecessary field, so the image I posted show only a few column.

Best Regards,

Issei

[matthew_magee1]

Hi. Did you ever find out what was going on w/ the import? We are getting similar results when updating software entitlements (different field/table, but same error message)