SOLVED

Sharepoint Online Term set label limits

%3CLINGO-SUB%20id%3D%22lingo-sub-329271%22%20slang%3D%22en-US%22%3ESharepoint%20Online%20Term%20set%20label%20limits%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329271%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EWe%20are%20trying%20to%20import%20data%26nbsp%3Binto%20the%20labels%20of%20a%20term%20set%20from%20a%20cvs%20generated%20Excel%20sheet.%20This%20works%20because%20it%20imports%20the%20records%26nbsp%3Bup%20to%205299%20labels%20and%20than%20stops.%20Is%20there%26nbsp%3Ba%20limit%20(boundary)%20on%20the%20number%20of%20labels%20that%20can%20be%20imported%2Fcreated%20in%20a%20term%20set.%26nbsp%3BWe%20have%20found%20no%20references%20about%20limits%20imposed.%3C%2FP%3E%3CP%3EHope%20someone%20out%20there%20can%20help.%3C%2FP%3E%3CP%3ECheers%20Bram%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-329271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329303%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20Term%20set%20label%20limits%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329303%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20CVS%20import%20process%20has%20been%20around%20for%20many%20years%20and%20has%20some%20significant%20shortcomings%2C%20i.e%2C%20it%20does%20not%20support%20everything%20in%20a%20term%20set.%20I%20recommend%20taking%20a%20look%20at%20the%20PnP%20cmdlets%20for%20working%20with%20terms%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-pnp%2Fnew-pnpterm%3Fview%3Dsharepoint-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fsharepoint-pnp%2Fnew-pnpterm%3Fview%3Dsharepoint-ps%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329294%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20Term%20set%20label%20limits%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329294%22%20slang%3D%22en-US%22%3ENot%20aware%20of%20a%20limit%20in%20the%20Import%20process...there%20is%20a%20limit%20in%20the%20number%20of%20terms%20you%20can%20create%3A%20Managed%20metadata%20-%20200%2C000%20terms%20in%20Term%20Store%2C%201%2C000%20global%20term%20sets%2C%201%2C000%20groups.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Fsharepoint-online-service-description%2Fsharepoint-online-limits%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Fsharepoint-online-service-description%2Fsharepoint-online-limits%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1454368%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online%20Term%20set%20label%20limits%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1454368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F245135%22%20target%3D%22_blank%22%3E%40Bram101%3C%2FA%3E%26nbsp%3BI'm%20sure%20you've%20figured%20out%20an%20alternative%20by%20now%20based%20on%20your%20post%20date%20so%20for%20what%20this%20is%20worth%20it%20sounds%20like%20it%20was%20related%20to%20your%20issue%3A%3C%2FP%3E%3CH2%20id%3D%22toc-hId-1705600070%22%20id%3D%22toc-hId-1705600070%22%3ESolution%2FWorkaround%3C%2FH2%3E%3CP%3ETo%20work%20around%20this%20issue%2C%20only%20use%20the%20term%20store%20tool%20to%20%3CSTRONG%3Eimport%20term%20sets%20that%20contain%20fewer%20than%205%2C000%20terms%3C%2FSTRONG%3E.%20To%20import%20large%20term%20sets%2C%20use%20the%20Client%20Side%20Object%20Model%20(CSOM).%3C%2FP%3E%3CP%3E%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_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Ftroubleshoot%2Fsearch%2Ftroubleshoot-error-when-importing-a-term-set%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello

We are trying to import data into the labels of a term set from a cvs generated Excel sheet. This works because it imports the records up to 5299 labels and than stops. Is there a limit (boundary) on the number of labels that can be imported/created in a term set. We have found no references about limits imposed.

Hope someone out there can help.

Cheers Bram    

3 Replies
Highlighted
Not aware of a limit in the Import process...there is a limit in the number of terms you can create: Managed metadata - 200,000 terms in Term Store, 1,000 global term sets, 1,000 groups.
https://docs.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description...
Highlighted

That CVS import process has been around for many years and has some significant shortcomings, i.e, it does not support everything in a term set. I recommend taking a look at the PnP cmdlets for working with terms, see https://docs.microsoft.com/en-us/powershell/module/sharepoint-pnp/new-pnpterm?view=sharepoint-ps

Highlighted
Best Response confirmed by Bram101 (Occasional Contributor)
Solution

@Bram101 I'm sure you've figured out an alternative by now based on your post date so for what this is worth it sounds like it was related to your issue:

Solution/Workaround

To work around this issue, only use the term store tool to import term sets that contain fewer than 5,000 terms. To import large term sets, use the Client Side Object Model (CSOM).

https://docs.microsoft.com/en-us/sharepoint/troubleshoot/search/troubleshoot-error-when-importing-a-...