How to import an Authority Document from an Excel file?
						
					
					
				
			
		
	
			
	
	
	
	
	
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2024 02:49 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-08-2024 07:48 AM
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 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2024 02:01 PM
I'm curious... why can't you use UCF ?
