Bulk knowledge import of at least 10,000 pages
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 08:18 AM - edited 11-30-2022 08:18 AM
Hello everyone. We have a resource that is currently built in SharePoint but uses some 3rd party tool so it is in html or xml or something. We can export it to PDF or Word docs, and need to do a mass import to a ServiceNow knowledge base as soon as possible. I've done plenty of digging in old threads and can't find much other than the existing drag and drop interface.
The content we need to move currently lives in an on prem SharePoint server that will be sunsetted in April due to no longer being supported by Microsoft. As a result, we don't have time to do the manual cleanup/restructure that would be strongly desired. It is a product reference manual, so the info is critical to many areas and it is VERY wordy, but will likely stay that way, anyhow. This is not tech info or incident/problem resolution type content. That being said, I know that Word docs can be imported via the drag and drop interface, but how can a script be written to do a bulk import of this size? Is there a way for a script to identify the title for each page and assign it as the article title?
I realize this is not an ideal scenario, but I don't need to know why we shouldn't do this...I need to know if there is any way possible to do this. We must have this completed by 4/1/2023. Please provide as much guidance as you can. Thank you.
- Labels:
-
bulk_import
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 08:24 AM
I had to do the same thing in the past, but I was able to get an export of XML from the old DB and imported into CSV. I then was able to create a transform map and import to the knowledge base.
If that is not possible and it has to be .doc attachments. I don't know of a way to do it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 10:36 AM
Could you provide a bit more info about this process - what it looked like, how it worked, any examples? This might be a good way to go if we can.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 09:22 AM
hello,
My current experience is to export to pdf (the source is Confluence, so i chose an entire heading to export) and used Adobe Pro to convert to Word and import the word docs.
I'll be taking some time to edit the docs, but i think the point here is that its possible to get data out and imported to SN quickly. As we all know, source data needs to be preserved, and once uploaded it can be modified.
Good luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 10:36 AM
We do have an option to do something similar to this, but did you automate the import? I realize we could put 10,000 Word docs in a folder and drag/drop them but I would like to automate it with a script to run overnight so we don't bog down the system, etc.
