Anaplan Connect Import source file

Hi Experts,

I hope all is well and safe.

Would like to seek your assistance with regards to Anaplan Connect script source file.
Noticed that when I run the Anaplan Connect script it keeps on getting the old source file in the import process instead of the new source file declared in the script. Please see attached file as reference. Is this the normal behaviour of Anaplan Connect script?

Any insights will be appreciated. Thank you so much.

Best Regards,

Doms

Anaplan_Connect_screenshot_87293.docx

Accepted answers

ben_speight

You don't change the import - data source relationship using the API. Once the import is created it will remain associated with that data source. So the FileName variable refers to the file data source on the server whilst the FilePath variable refers to the file on your local machine, and they can be named differently.

sean_culligan

Think of the Anaplan Filename as a file definition, instead of a file.

So SG_CRC.csv is the file definition on Anaplan, which confusingly you created by uploading a file.

In your Anaplan connect script you want to reference this file definition with the '-file' parameter.

Reading your script you are using the FileName variable but in here you have used the local file name. This should rather be the file name which is in Anaplan so SG_CRC.csv.

If the structure of your source file has changed, then you should upload a new file definition. Select Import Data Sources > Upload New File. Once this new file definition has been set in Anaplan then you could reference this instead. For example if you wanted to post the new file SG_CRC_V1.csv

If you did post a new file you would need to recreate your import action and update the import name in your script, so it may be better to simply update the existing file definition in Anaplan 'SG_CRC.csv'. To do this save your new file with the same name as the Anaplan file 'SG_CRC.csv' then Select Import Data Sources > Upload new file, and point to the updated 'SG_CRC.csv' this will then update the existing file definition. At this point you may wish to check your import to make sure the column mappings are all still sensible.

Hope this helps

Best,

Sean

All comments

ben_speight

sean_culligan

Think of the Anaplan Filename as a file definition, instead of a file.

So SG_CRC.csv is the file definition on Anaplan, which confusingly you created by uploading a file.

In your Anaplan connect script you want to reference this file definition with the '-file' parameter.

Reading your script you are using the FileName variable but in here you have used the local file name. This should rather be the file name which is in Anaplan so SG_CRC.csv.

Hope this helps

Best,

Sean

dominic.literal

Thank you very much for the reply @ben_speight @sean_culligan

Confirmed that it keeps getting the old source file. So what I did was need to replaced the old source file in the script as attached and it's working now.

Again, thank you so much.

Anaplan_Connect_script_-_old_source_file_replace_87538.jpg

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?