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.

[sergiu_panaite]

You can use several fields as coalesce. They would be taken into account as a pair.

Regards,

Sergiu

[franktr]

Hi Alex

Yes, I noticed that myself so I removed the coalesce on serial_number and just have it on asset_tag, but made no difference.

[venkata Murali]

Hi All,

I am also facing the same problem. can any one help on this

[sergiu_panaite]

What exact problem do you experience?

Regards,

Sergiu

[venkata Murali]

As i am trying to upload data form the sftp server   before using "Test load 20 Records" will not actually insert anything in the target table. but if i reprocessed the same import set than it is uploading the 20 records in to the target table. please provide us the solution for this issue.