How to export data from one instance to another EXCLUDING sys ids (target instance should generate new sys ids)?

BabyYoda
Tera Expert

This question is applicable for nearly any topic but, specifically, my objective is to export a select number of categories from Knowledge > Knowledge Categories from a Development instance to a Production instance.

To avoid sys id conflicts, I'd prefer the target instance--Production--generate new Sys Ids for the imported records. Is this possible to do with exporting the data as XML or update sets? Would I have to create a script? Or is this something available out-of-the-box or as a plugin?

5 REPLIES 5

Raj_Esh
Kilo Sage
Kilo Sage

Hi BabyYoda,

Not sure, why you would need a new sys_id in production.

In general, the process to do changes in Dev and then move to Test and then Production. In which we will have the same sys_id and it helps to maintain the instances. Not only during the enhancements but also during the upgrade of instances.

 

Hope it helps.

 

Thanks,

Raj

--Raj

Hi Raj,

 

Yup, I'm completely on board with you. Same sys Id throughout. 3-tier--or possibly 4-tier--setup. All of it. However, at the moment, I'm only dealing with two instances. Unfortunately, the Prod and Dev instances are no longer in-sync. Cloning down from Prod to Dev is in the works but I need to get these categories imported into Prod before the clone down. I hope that makes sense.

Now that I think about it, Sys Id value is a GUID and not a logical sequence so, as long as there's no Sys Id Conflict between the two instances when importing/exporting data, it doesn't matter what the sys id value is.

 

Thanks for your help!

Hi BabyYoda,

 

In that case, if you're looking only for few categories export them in XML and import in Production. You may try with one category and see how it works.

 

Hope it helps.

 

Thanks,

Raj

--Raj

I'll give that a try and see how it goes. The Categories are not added to an Update Set automatically. They must be added via scripting or export XML.

I see that exporting data as Excel does not include the Sys Id. Therefore, if I export data as Excel and then import data as Excel, I think the target instance will create a new Sys Id for each record. I haven't checked other formats like CSV but it sure looks like Excel would be one way OOTB to import records and generate new Sys Id for each record.

Thanks again for your help, Raj.