Update Codes in a numbered list

Hi there,

the model has been in use for a very long time. However, it is full of dummy codes instead of the correct ones. Certainly, there is a lot of data associated with these elements. So I can't export change, delete the old elements and import the new ones.

Is it possible to mass update the codes in a numbered lists apart from using manual input?

Accepted answers

PaulRitner

Hello, Yes, you can mass update codes, just like you would mass updating a property in a list. First, back up the model ). (Did I say back up the model? Make sure you back up the model.) Then, export the list (keeping Name & Code). The Name is the Anaplan assigned #'d list item (not the Display By)... to get this, you either have to temporarily unset the Display By, or create a property to display the #'d list value. Once you have this dataset, update the codes to what the new values should be and import the list using the numbered list item (mapped to Name) and the new code (mapped to code).

Cheers!

All comments

PaulRitner

Cheers!

nikita_gnilozub

Thank you

SofianeLz

Sorry but when I import in the numbered list, it doesn't allow me to map the #, so at each code that I want to update, Anaplan create a new item instead of updating the code

PulkitChawla

@SofianeLz - You can update the code in the numbered list as well.

Below are the steps to achieve that.

Create a mapping between old and new code and using that mapping create a saved view that will import the data in the list and update the existing code. Below is the screenshot of the same.

2. Using this saved view, import into the list in which you want to update the code. While Importing you have to make sure it is identified by name. Below is the screenshot of the same.

3. After doing this, click on run import and your code will be updated in the list which is numbered list. Below is the screenshot of the same.

Let me know if you still face any challenges which updating the code in the numbered list.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…