Anaplan Connect Import source file

Highlighted
New Contributor

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

3 REPLIES 3
Highlighted
Community Boss

Re: Anaplan Connect Import source file

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.

Highlighted
Certified Master Anaplanner

Re: Anaplan Connect Import source file

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

 

Highlighted
New Contributor

Re: Anaplan Connect Import source file

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.