"invalid name: ....." error


Hi community. 
When trying to import into a list I receive the error "invalid name". 
Do you know where I can find the explanation of this error? 

Thank you.

Best Answer

  • DavidSmith


    It could be that, or it could also be that the name already exists in the parent list if you are using a composite hierarchy



  • Hi,
    This could be because of name exceeding 60 character limit.
    Workaround : Use numbered list, but ensure code does not exceed 60 characters.

  • I also found this explanation. 
    However, I checked with a "count" on excel and all values have less than 35 characters. 

    Would it be possible that this error is created when a record already exists with the same name? 

  • Thank you David. 
    It was my feeling as weel. 

    Could you explain exactly what a "composite hierarchy is"?

    The strange thing is that this error happens when I am filling the first level of my hierarchy. 
    It has been solved by "adapting names to avoid duplicates" 🙂 

  • Sure - A Composite Hierarchy is where you have 2 lists that make up one list


    So, a list called L1 Country is the parent of a list called L2 Cities


    The advantage of this structure is you can model at the L1 level as appropriate


    If you are getting the error on the first level, then the same description must exist for different items.

    If that is what you want they as @PavanKumar mentioned, you can use a numbered list to display the same description, but try an use a code in all cases if possible; it is much easier later on if you have a code!!


  • Hi Both - I am also bumping into this issue today. I did not had it for a very long time. 


    1. it's not due to a composite Hierarchy issue (only one list - a flat list) 

    2. the name does not exceed 60 characters 


    The name i want to use is 'Reverse Logistics - Extension' , so no special characters either. 


    Anyone an idea? 

  • Hey Nick,


    I had a similar issue recently. What solved it for me where two things:

    1. Use the UPPER & TRIM formulas to make sure all your items are aligned

    2. Make sure that the PARENT item exists in the parent list when loading the child item


    Hope this helps!


  • Coming back to this post, another reason for this error if you use CODE and then some items have a CODE and some others dont have a CODE.