Trouble transform mapping assets to Printer [cmdb_ci_printer]

[franktr]

Hi

I am trying to update the table Printer [cmdb_ci_printer] via a Data Source and then running a Transform Map on those.

I can read in the data to the imp-table just fine, but when I try to transform it to the printer table it does not add anything to it.

The import log looks like this:

My field mapping in the transform map looks like this and you can see that I coalesce on the asset_tag field. I don't run any scripts or something like that and all the other settings is default.

(The source field for asset is called u_serialnr_customer, but it is actually the asset tag. Don't ask me why.)

Is there any special requirements that you need to have to add to the Printer [cmdb_ci_printer] table?

I've done something similar earlier on the same system with some POS terminals that we needed to add, but then I created my own destination table which I extendend from the Configuration Item-table.

[franktr]

Yes, I'm still in testing now so I go to my data source and click "Test Load 20 Records"

On the next page I get this, so you see it inserts 20 items in the imp-table.

I then click Run Transform and select the correct Import set and transform maps. And in this case I have only one of each, so real easy and then click Transform.

It then comes right back with this message

But when I then check the Transform history or Import log it says the same:

total: 0, inserts 0, updates 0, ignored 0, skipped 0, errors 0

It doesn't throw any errors or anything, it just decides to do nothing, but the Import Set is gone, so it's marked as processed.

[sergiu_panaite · Accepted solution]

Hi Frank,

As I said before using "Test load 20 Records" will not actually insert anything in the target table. I've done a quick test on my own instance and here are the results:

1. Using "Test load 20 records":

2. Using "Load all records":

You can see in second case I have "Ignored" = 20 as I already loaded the rows previously.

So, can you try "Load all records" rather than "Test load 20 records"?

Regards,

Sergiu

[franktr]

Thanks, Sergiu, that worked!

Don't know why a test load shouldn't work though, cause I see that it creates 20 rows in the import table.

It just sounded counter intuitive, so that's why I was a little "slow".

But anyway, now the printers are there.

[sergiu_panaite]

Hi Frank,

"Test load 20 records" is just there to make sure we can import data in the import set table. It's not going to the target table unless you use the "Load all records" UI action.

But glad that it worked in the end.

Regards,

Sergiu

[arobertson]

Hi,

I can see from your second screenshot that you are coalesce two values "asset_tag" & "name", i believe you should only be using one.

As for your source headings. They would have been taken from the column headings in your excel spreadsheet.