Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr
Kilo Contributor

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:

import_log.png

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.)

field_maps.png

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.

1 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":



Screen Shot 2016-01-22 at 9.05.41 AM.JPG



2. Using "Load all records":



Screen Shot 2016-01-22 at 9.06.25 AM.JPG



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

17 REPLIES 17

"Test load 20 records" will not insert anything in the target table, I've already explained this before.


You need to run the full import if you want records inserted into the target table.



Regards,


Sergiu


venkata Murali
Tera Contributor

Can any one help on this problem.


bellajohsan
Kilo Contributor

Record Producer allows the end user to pick their printer from cmdb_ci_printer in one of three ways. Check all three ways in the next discussion. Also, set up your printer drivers new update at Epson Printers Support and keep away your printer from any of issues.