How to copy from one custom table to another within service-now

ty_roach
Tera Guru

I am trying to copy data from one table (a custom table that extended change_request) into another custom table (one that extended task).

It runs successfully, saying that it processed all 63 records and performed 63 inserts (which would be correct), but when I look at my target table for content, it appears empty.

My Data Source is defined as a Type=File, Format=XML. I've taken what I think is a reasonable guess for the XPath for each row value (e.g. //) as well as for File path (e.g. /.do?XML).

Any ideas??

6 REPLIES 6

There's nothing in my "Import Sets". When I click that module, it shows an empty list and there's not even a "NEW" button to add an import set.

As mentioned before, the wiki leads you to believe that you do not need a data source, which, if I'm understanding the terminology right, should feed the Import Set.

Import Sets: Table of all import sets. "An import set" is a set of records imported from a Data source, that can be mapped to an existing table and serves as a staging location for storing imported data.

we are doing a table to table copy (within service-now).

Not sure what to do next. I would have imagined this to be the easiest of all operations (table to table within service-now).


ty_roach
Tera Guru

Am I suppose to first do a transformation map from the source table to an import set (imp_computer being the target for this stage of the transform), then create a second transformation map to go from the imp_computer (import set) into the destination target table????