question Trouble transform mapping assets to Printer [cmdb_ci_printer] in Developer forum

Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr — Thu, 21 Jan 2016 09:58:25 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Thu, 21 Jan 2016 10:19:07 GMT

Hi Frank,

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

Regards,

Sergiu

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr — Thu, 21 Jan 2016 10:55:58 GMT

Hi Sergiu

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

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

arobertson — Thu, 21 Jan 2016 11:51:53 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Thu, 21 Jan 2016 12:57:14 GMT

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

Regards,

Sergiu

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr — Thu, 21 Jan 2016 13:40:27 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr — Thu, 21 Jan 2016 13:43:03 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Thu, 21 Jan 2016 14:07:35 GMT

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

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr — Thu, 21 Jan 2016 16:08:22 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Fri, 22 Jan 2016 08:07:33 GMT

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

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

franktr — Fri, 22 Jan 2016 08:26:37 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Fri, 22 Jan 2016 08:32:32 GMT

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

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

venkata Murali — Fri, 29 Jan 2016 13:15:23 GMT

Hi All,

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

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Fri, 29 Jan 2016 13:45:46 GMT

What exact problem do you experience?

Regards,

Sergiu

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

venkata Murali — Sat, 30 Jan 2016 09:04:15 GMT

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.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

venkata Murali — Mon, 08 Feb 2016 07:21:33 GMT

Can any one help on this problem.

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

sergiu_panaite — Mon, 08 Feb 2016 07:30:20 GMT

"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

Re: Trouble transform mapping assets to Printer [cmdb_ci_printer]

bellajohsan — Wed, 17 Oct 2018 06:53:15 GMT

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.