Moving import sets and transform maps from instance(DEV) to other instance(TEST)

Santhosh40 · ‎03-25-2019

Hi Experts,

As per my requirement, I have to update more than 1000 CI records in the DEV instance.

For this process, I have done for creating Import set and created a transform map, This process is done successfully in DEV instance.During this process, all the customization's are captured in update set.

issue:When I am going to update this update set in the TEST env. The update set is committed successful. and what ever the transform map I had created, it is also updated.

But After transforming the data, it showing the issue as :Loading with ERROR: and Records in the TEST env. are not updated.

Can u please share your thoughts to, How can I update the TEST env. records with out manual process.

As per my requirement, " CIs from app to cloud class has been migrated without using UI.",:

Because of my client req: I don't have chance to Export all the records in XML and importing in the TEST env.

Is there any other way to move this import set to TEST env.?

Thanks in advance for your time and valuable thoughts...

Thanks

Santhosh.K

Chuck Tomasi · ‎03-25-2019

Import sets are created as part of the Data Source process. They are temporary and don't get captured by the update set, nor do you want them to be part of the update set (it would be like capturing emails that have been sent.) Ensure your have the data source and transform map, then you can install those on your other instances. Start with the data source, ensure the credentials, server (perhaps attachment), etc. are correct for your test system, then load all records. Once they are loaded, then you can transform.

View solution in original post

Santhosh40 · ‎03-27-2019

Thank you Chuck & Varsha, Thank you so much for valuable suggestion.

I tried with Chuck's point of view, It's working fine.

But, Again I am Facing one more issue. Please provide your valuable thoughts to overcome this situation.

My Requirement.: I had, around 700 CI records in excel sheet, having Class name as "Application", I need to update all these records Class names as Cloud Space.

Up to this, I had updated using Data sources and transform maps.

In these 700 Records two records(CI) having same name, but created by is different users in different timings.

Issue: After bulk updation, one CI is overridden with another CI. (due to: I have used Name field as unique)

Before updation I have 2 CI's with same name, in my instance, but after updation I have only one CI record with that name,

Trial: Before bulk uploading process, I had taken xml back-up for this specific records, tried to import manually, but, it shows the error as "java.sql.BatchUpdateException: Duplicate entry 'sys_id of record' for key 'PRIMARY'"

So, can u please share your thoughts to overcome this situation.

Your leads are more valuable and appreciated.

Thanks

Santhosh.K

Santhosh40 · ‎03-27-2019