How to import an Authority Document from an Excel file?

Deloitter
Tera Contributor

Hi there,

 

I'm looking to import an Authority Document from an Excel file (can't use UCF unfortunately). I have four different tabs (see attached document):

 

1. Level 1: Authority Document name, description, URL, references to subjects.

2. Level 2: Subjects, references to source and references to sections.

3. Level 3: Sections, section descriptions, references to subjects and references to subsections.

4. Level 4: Subsections, references to sections.

 

How can I import this into ServiceNow without having to manually copy-paste everything, and what would the structure in the system be? How do the three levels (subject, section, subsection) under Authority Documents map to the AD? Are subjects created as citations, sections as citations within citations, etc.?

 

However, the most important question is how to import this automatically, because my file is too big to individually copy-paste manually? I'm new to ServiceNow so if possible please include any basic information I need to know to do this.

2 REPLIES 2

victortong
Tera Contributor

You may need to explore the transform map target table mapping for map the control objective and citation.
I used 2 steps approach to import it.
Import Authority Doc first. Then, citation and control object. You can have a look to following information for more idea.
https://grclibrary.com/info_data_id.php?id=45 Screenshot 2024-03-08 154506.png

Michelle_lim
Tera Contributor

I'm curious... why can't you use UCF ?