Why do I still see source items from previous versions of upload files in the import definition?

Hi Anaplan community,

I don't understand why I still see source items from previous versions of upload files listed in the import definition tab of an import action.

I used file A with periods call AP01, AP02,... and used that to upload into Anaplan and save that upload as an action.

Later, I changed the file and renamed the periods P01, P02,... and reuploaded the file using the "Import data sources" < New Source < same name of file (otherwise it is not possible to change the file).

When I click on edit of the action to redo the mapping, I still see the AP01, AP02,... in between the source items although these are no longer inside my upload file.

Why is that and how can I remove this?

Thank you!

Accepted answers

All comments

rob_marshall

@LouiseBourgonjon

A couple of things to be careful or understand using files as data sources:

always make sure the name of the new file is exactly the same as the file it is replacing
When you upload the file, make sure you are setting the permissions of the file correctly (Private, Admins, or Everyone)

If you have uploaded a new file, you can edit the data source of the action to point to, so see if you have multiple files in the source area.

Rob

LouiseBourgonjon

Dear Rob,

Thank you for coming back on this.

The replacing file has always the same name as the original file.

I usually choose the setting "everyone". --> would this setting influence what I see in the source of the mapping table?

In the source area, the action is pointing to only one source file.

rob_marshall

@LouiseBourgonjon

Well it can influence if another user uploads the file and doesn't change the permissions and then you try to run the import from that file. In this case, you will see the "old" file definitions while the person who uploaded it will see the new columns.

One thing you can do is go to the module where you are attempting to load the data to and click Data -> Import. Select the file you just uploaded. Obviously, make sure the file definition is correct with the updated columns. Do the mapping, and run the import. If this action created a new action at the bottom of your imports, then that means the source has changed meaning you could have hidden characters (2 spaces vs. 1 space).

Rob

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…