i want step by step procedures following task

Narasimman7
Tera Contributor

One of your Project Managers has provided you with a list of stories they have been working on/completed. As the System Administrator, you need to import the data and map it to the correct tables so the data will be available within the Agile application. Using the attached excel file, import the data being sure to map the tables correctly.

  • Create an Import Set table named "HRBP Server Team" and import the data into the Story (rm_story) table
  • Use the same name "HRBP Server Team" for the Transform Map name
  • Use Auto Map Matching Fields and/or Mapping Assist to help you map the 6 columns to the correct fields on story, to complete the transformation*

             i cant able to create import set in data sources in data.. i want step by step procedures

14 REPLIES 14

Clara Lemos
Mega Sage
Mega Sage

Hi @Narasimman7 ,

 

Please follow the steps bellow to import your stories as required.

 

1. Navigate to System Import Sets > Load Data

2. Select Create Table and for the label : HRBP Server Team

3. For the 'Source of the import' select file and upload your excel spread sheet
4. Verify if is all set as the screenshot below and select submit

Screenshot 2023-11-04 at 12.33.22.png

ā€ƒ5. Complete the Table Transform map as follow:

Screenshot 2023-11-04 at 12.34.10.png

ā€ƒ6. Right click on the top of the form and select 'save'

7. Click on Auto Map Matching Fields (related link on the bottom left)

8. Click on Mapping assist and include the missing fields , as per the image below

Screenshot 2023-11-04 at 12.44.01.png

ā€ƒ

9. Click on 'Save' and you'll be back to the table transform map form

10. Verify the field mapping at the bottom of the form

Screenshot 2023-11-04 at 12.44.57.png

ā€ƒ11. Click on 'u_assignment_group' and set : Choice action to ignore and Reference Value field name : name 

 

Screenshot 2023-11-04 at 12.45.42.png

ā€ƒ

12. Click on Update and you'll be back to the transform map form

13. Click on the related link 'Transform'

Screenshot 2023-11-04 at 12.47.19.png

ā€ƒ14. Click on transform again

   15. Your stories should now be available in the rm_story table

 

If that helps please mark my answer as correct / helpful!
And if further help is needed please let me know

Cheers

very helpful. these steps are not in the course and very high level stuff is there. the course should give a link to the steps u gave. so that it helps people while taking up the course.

It should not in my opinion. This is how ServiceNow trainings looked like 6-7 years ago. Not all information was provided. You had to google nad search through docs, not only follow the step-by-step tutorial. If you have to look for the information on your own, you will remember it.

Hi @Clara Lemos ,

Thanks for the detailed steps. I followed all the steps and import did happen. When I check the stories, the values from demo excel for the 5 out of all 6 fields ( Story ID, Short Description, Acceptance Criteria, Assignment Group, State, Points)  are getting populated correctly, but 'Assignment Group' is empty and because of this my task validation is failing.

Any thoughts please?

Thanks!