Knowledge Management - Export from Sharepoint - Import to Service Now

[Shirley3476]

We are in the process of implementing Knowledge Management. Alot of our informaiton is in Sharepoint, Wikis...
Is there a way to export the data from Sharepoint into Knowledge Management?

I have done several imports and tranform maps in SN so I am familiar with the process. But wanted to hear from the experts.

Thanks,
Shirley

[Shirley3476]

Hi Steph,
We researched this thouroughly and were unable to come up with a resolution regarding importing the data from Sharepoint into SN.
Our data that was in Sharepoint came from our Knowlix application that was nothing more than a flatfile. We had then converted our information to WIKI articles.
So to move our data from Sharepoint to SN, we had to do a copy and paste on each entry. Yes it was time consuming but once the information is in SN we then can now manage to it.
Good Luck,
Shirley SN Admin

[mdenis]

Our company did this recently. We did not have a wiki format, so it may have been less complicated. We exported from Sharepoint to Access and from there to xml so we could keep the html tags. Then used that to import/map into ServiceNow. We had about 700 Knowledge Base articles and each one had some massaging to do before and after. The full move took about two days not including planning.

[mdenis]

Here are the steps we took:

1) View Data in "Datasheet View" on Sharepoint
2) Under 'Connect & Export' > Select 'Open with Access' (You'll need Access installed on your machine to use this).
3) Choose 'Export a copy of the data'
4) Open in Access
5) Massage the data as needed - a big point with us was that we had to remove multi-select fields. We chose to change these to one selection, but there are queries that would create new records for each selection.
6) In Access (we're using 2010), go to External Data -> XML File

Then create the data source in ServiceNow - I did this by uploading the xml file to the actual data source rather than pointing an external machine; after that the import was like a regular import set import. Hope this helps!

[tonemking]

Were your articles .doc* format? We are about to attempt the same thing, but the XML exports encodes the document as a URL. How does SN handle that?

Antone

[prashantdharne]

Hey Antone,

Were you able to import the Word documents to Servicenow?