Bulk load/import of standard change templates into new standard change catalog on Geneva?

[timl]

Has anyone attempted or successfully completed a bulk load/import of standard changes templates into the standard change table?

I am looking to import just the standard change "Short Descriptions" to give our IT folks a starting place to use the system (we have almost 200 standard changes).   I plan on them going and updating the template for each one afterwards but since we have so many changes it would be nice if all of them did not all have to be loaded manually one by one by me or the IT teams.  

We are working with a vendor right now who is deploying our instance.   They were able to bulk load the templates into the table, [std_change_template], but now when a standard change template that was imported is clicked on in the catalog it takes you through the "Normal" workflow instead of "Standard".   They have opened a support ticket with ServiceNow but are saying that most likely they will all have to be added manually.

You would expect that since this is a completely new element added to Geneva that ServiceNow would have provided some way to import a companies existing standard changes.

Any guidance or suggestions would be appreciated!   Thanks!

[Jason Thomas]

Hi Tim

I imported a spreadsheet into the std_change_proposal table, and made sure that the approval was set to approved and the proposal type was new.

Make sure that running business rules is checked when creating the transform map, as the BR will create the template etc as if the workflow has completed.

The field map that is important is the 'change request values' and should look something similar to

short_description=Please complete the intended description^descripiton=Please describe the change this covers.

Once you have imported the values will display correctly.

I hope this helps someone in the future

[Ankita23]

I was able to import the templates through excel by the above mentioned process. For me 1 extra step was needed- had to deactivate 'Validate template_value compliance' business rule on standard change proposal table and import was successful.

However the 'Change Request Values' was not fully copied after import. Only the short_description(the first value in column) got copied, rest was not.

I've added all field values with '^' in a single box in excel but it didn't work.

Is there anything else we need to check/add?

Please help!

[Jason Thomas]

You need to ensure that all those fields that are mandatory are populated, otherwise it will not process correctly.

[SusanWinKY]

Jason, would you be willing to share the spreadsheet you used for this?

[SusanWinKY]

Follow-up to my previous comment...

I prepared a spreadsheet for standard change proposals and tried importing it.  I got a message:  

The following fields have been ignored, because they don't exist on the destination table: Change Request values

My spreadsheet has a column named "Change Request values" with the following test data:

short_description=MDM reboot 6 - Include a title for your change no greater than 100 characters^description=MDM reboot 6 - Describe what you plan to do - Weekly planned reboot during maintenance window^implementation_plan=MDM reboot 6 - List the steps in order of completion that will be worked through when implementing this change. Note who will perform each step and whether there are dependencies between steps.^backout_plan=MDM reboot 6 - Describe the steps you will take to revert the change to its pre-implementation state. At what point during the implementation will you take the decision to backout your change?   Does your change window include time to backout if you need to?^test_plan=MDM reboot 6 - Explain what testing you have done or will do prior to implementation that gives you confidence this change will be successful. Describe the tests that will be carried out after implementation to confirm that the change has been successful.^assignment_group=364bfb936f216100a70bff2f5d3ee4f2^justification=MDM reboot 6 - Weekly planned reboot during maintenance window^risk_impact_analysis=MDM reboot 6 - TBD^EQ

Do you have any advice on how to format the spreadsheet so that it will accept this data as the Change Request values? 

I am using the standard import process by right-clicking the list and selecting Import.  Kingston, patch 3.  Would appreciate any insight you can give.  Thanks!