How to copy from one custom table to another within service-now
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2012 06:10 AM
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??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2012 08:35 AM
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2012 08:38 AM
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????