Import error: invalid name

LucaRicci · 2024-07-18T09:32:01+00:00

There was an error rendering this rich post.

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

Accepted answers

All comments

ShubhamCh

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

LucaRicci

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

ShubhamCh

@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!

LucaRicci

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

ShubhamCh

@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!

LucaRicci

@Dikshant Do you have a different solution?

Dikshant

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:

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

Try it out…

LucaRicci

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

ShubhamCh

Nice catch @Dikshant

I missed 'Name Only' boolean.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…