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

[ty_roach]

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??

[ty_roach]

I just read in Data Sources section 1 (http://wiki.service-now.com/index.php?title=Data_Sources) that "When using import sets to map data from one ServiceNow table to another, it is not necessary to define a data source, rather this can be done simply by using the import set mapping tools.".

So, I deleted my data set (originally created in my first posting) and followed the instructions as specified in the Data Source section provided above.

Now I get a transformation error.

When I click "transform", I get a message as follows:
No import set available. Create and load an import set first

So I click the "create and load and import set first" hyperlink from the message, and get a screen where I need to enter the import set table (which there are only 4 options so I guess and use "computer"). Then I must specify the data source (list of 12), so I guess and use Example JDBC MySQL Glide....

I'm really shooting in the dark now.

Any ideas???

[sreed]

I believe all you need to do is create a transform map from the first table to the second. Set your field maps and then run the transform. Have you created a transform map? Thats what tells it which fields in the first table match up with which fields in the second table.

[ty_roach]

yes, I've created the transform map. Very straight forward. As I mentioned, as soon as I click "transform", I get a message that "No import set available. Create and load an import set first" (even though the wiki implies that you do not need to do this for a table-to-table copy). So, I click the link as part of that message and it prompts me to select an import set table. By the way, the only choices available in the selection box are:

Computer [imp_computer]
Location [imp_location]
Notification [imp_notification]
User [imp_user]

I was hoping (expecting) to see my target table, but it was not there.

So, following along the only path I can, I then have to choose from a list of Data Sources. I choose the one that seems the most logical "Example JDBC MySql..."

no luck on this. This just seems wrong.

[cwilker10]

It sounds like you don't have an Import Set that is ready to be processed. Find the Import Set that you were working with and click on the "Reprocess" Related Link in the record. This will provide an Import Set for your transform to act against.