question Re: How to import an Authority Document from an Excel file? in GRC forum

How to import an Authority Document from an Excel file?

Deloitter — Tue, 16 Jan 2024 10:49:09 GMT

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.

Re: How to import an Authority Document from an Excel file?

victortong — Fri, 08 Mar 2024 15:48:46 GMT

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

Re: How to import an Authority Document from an Excel file?

MichelleL520767 — Thu, 19 Dec 2024 22:01:31 GMT

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