Import 5K+ term set in SharePoint Online using CSOM

%3CLINGO-SUB%20id%3D%22lingo-sub-2266001%22%20slang%3D%22en-US%22%3EImport%205K%2B%20term%20set%20in%20SharePoint%20Online%20using%20CSOM%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2266001%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI'm%20looking%20for%20an%20inexperienced%20guide%2Fwalkthrough%20to%26nbsp%3Bimport%20term%20store%20terms%20using%20CSOM%20or%20PowerShell.%20I%20have%20put%20together%20a%20term%20set%20for%20our%20purchasing%20and%20procurement%20team%20to%20use%20when%20purchasing%20products%20or%20services%20-%20see%20attachment%20for%20reference.%26nbsp%3B%20I%20couldn't%20import%20the%20term%20set%26nbsp%3Busing%20the%20CSV%20format%20in%20admin%20center.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20that%20we%20can't%20import%20more%20than%205%2C000%20items%20-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Ftroubleshoot%2Fsearch%2Ftroubleshoot-error-when-importing-a-term-set%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%26nbsp%3Bhttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Ftroubleshoot%2Fsearch%2Ftroubleshoot-error-when-importing-a-term-set%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20never%20used%20CSOM%20or%20PowerShell%20but%20I%20did%20download%20and%20install%20SharePoint%20client%20components%20sdk.%20There%20is%20an%20article%20which%20provides%20some%20information%20on%20how%20to%20do%20that%2C%20but%20I%20couldn't%20figure%20it%20out%20%3CA%20href%3D%22https%3A%2F%2Fblog.josephvelliah.com%2Fo365-sharepoint-online-import-term-store-terms-using-csom-powershell%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E-%26nbsp%3Bhttps%3A%2F%2Fblog.josephvelliah.com%2Fo365-sharepoint-online-import-term-store-terms-using-csom-powershell%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20someone%20can%20help%20out.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2266001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowershell%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi there,

I'm looking for an inexperienced guide/walkthrough to import term store terms using CSOM or PowerShell. I have put together a term set for our purchasing and procurement team to use when purchasing products or services - see attachment for reference.  I couldn't import the term set using the CSV format in admin center. 

 

It seems that we can't import more than 5,000 items - https://docs.microsoft.com/en-us/sharepoint/troubleshoot/search/troubleshoot-error-when-importing-a...

 

I've never used CSOM or PowerShell but I did download and install SharePoint client components sdk. There is an article which provides some information on how to do that, but I couldn't figure it out - https://blog.josephvelliah.com/o365-sharepoint-online-import-term-store-terms-using-csom-powershel...

 

Hope someone can help out.

Thanks

0 Replies