Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr · ‎01-21-2016

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.

sergiu_panaite · ‎01-22-2016

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

View solution in original post

sergiu_panaite · ‎01-21-2016

Hi Frank,

Do the fields in the import table (stagging table) have same type as the ones in cmdb_ci side?

Regards,

Sergiu

franktr · ‎01-21-2016

Hi Sergiu

That's a good question.
I'll be sure to check that when I come back to the instance.

franktr · ‎01-21-2016

Hi again, Sergiu

Checked the fields now and all of them were strings. Some had different lengths but in all cases the Printer-table had the longest length, so that should not be the reason.

I also removed the coalesce on the serial_number-field, as that might be the same between different makes, but this should make absolutely no difference.

If I just had an error I could have read the error message and gotten some clue on what was wrong, but now it just seems it's doing nothing.

sergiu_panaite · ‎01-21-2016

Hi Frank,

How do you load the data using data source? By clicking on "Test load 20 Records" ? Because that only inserts the records on the import set table but not on the target table.

Your first screen shot also shows that 20 records were inserted and that made me thing you used "Test load 20 records" UI action.

Regards,

Sergiu