Import error: invalid name

LucaRicci
edited July 18 in Modeling

Hello,

I am trying to run a import into a list in order to update the item code as per what the user inputs. However I get this error:

This is the module view I am importing . I want "New VAT Number" to be the new item code:

Here is the action:

What is wrong?

Thanks,

Luca

Answers

  • Hi @LucaRicci

    The char limit for name or code is 60chars. The supplier's name is going above this limit. That's why this error is showing up.

    You can replicate the error by editing name of any existing items with more than 60chars.

    Thanks!

    -Shubham

  • @ShubhamCh Sorry I did not understand. How is "Olend Belong AS" longer than 60 characters?

  • ShubhamCh
    edited July 18

    @LucaRicci Understood. The second and main reason is if the list is not a numbered list, it can't have items with duplicate names. If you want items with the same name but different codes, use numbered list.

    I know you're trying to update code of an existing item but it being a standard list, Anaplan is considering a new item and while updating the list, it finds the name is already there with different code and throws an error.

    I'd suggest you use a list property in this case.

    Thanks!

  • @ShubhamCh I want to change the code of an item without creating a duplicate name. The name should stay the same

  • ShubhamCh
    edited July 18

    @LucaRicci As far as I know, it can't be done using an import. You can use text-formatted list property in this case.

    There is one workaround to do it but, in that case, you'd have to delete the existing item first which will led to data loss. I believe you'd not want that and to save data you'll have to create some staging module and import back that data again.

    To give you an idea, this is how it'll look:-

    Import the name and the new code in new temporary list > Create Temp modules which will save all the data from original to this Temp module > delete the original item using selection > Import copied(updated) list item in the original list > import back the data from temp module/s into the existing module/s > clear temp list.

    It's a process that you can use but I'd suggest using list item property. That's an easier solution.

    Thanks!

  • @Dikshant Do you have a different solution?

  • Import based on the name and update the code like this:

    With this you will be able to update the code of the existing list member without data loss but 2 conditions:

    1. New Code cant be same as code of other list items.
    2. New Code ⇐ 60 char

    Try it out…

  • @Dikshant thanks, you're the best. I've set the import to "name only" and it seems to be working. Many many thanks

  • Nice catch @Dikshant

    I missed 'Name Only' boolean.