Loading file with different file names for the same action in deployed model

Hi All,

I am trying to run the action through Anaplan Connect with different files in deployed model.
But the action is running only for the file that matches with the source label of that action and if I use the different file name scripting is failing.

Attaching the screenshots for reference.
Screenshot1:File name same as source label: Script passed

Scrrenshot 2: loading action with different file name (file structure same as first): Script Failed

Can anyone suggest is it expected behavior or kindly help me with the Solution.

Regards,
Venkatesh

Accepted answers

All comments

M.Kierepka

Hi @Venki9902,

Can you share more details? It's hard to help without more information, as based on your description everything should work. It would be helpful to see the script, or if not, share details like how do you identify the files (IDs or names, full or relative path)?

Venki9902

Hi @M.Kierepka ,

Please find the dummy code:

set FilePath="Employee Sal Testing.CSV" —> This is executing perfectly because source label is matching

rem set FilePath="abc.csv" —> Failing because file name is different but content/Data same as first one.
set ImportName="Import Action"

set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -put %FilePath% -import %ImportName% -execute -output %DumpName%

Hope this helps :).

Regards,
Venkatesh

M.Kierepka

Hi @Venki9902,

It looks like you are missing the required parameter: "-file %FileName%". You need to tell Anaplan which type of file you are importing. It should be the name of the original file that you used to build the import, you can find the name of the file either in Anaplan (Actions→Import Data Sources), or using Anaplan Connect (argument "-files" lists all the files with their IDs, it's better to use ID for the production).

set FileName="FileName from Import data Source"

set FilePath="FilePath on the Client"

set ImportName="Import Action"

set DumpName="Client Location for Dumping the Errored data from Import"


set Chunksize=1
set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import %ImportName% -execute -output %DumpName%

Venki9902

Hi M.Kierepka,

Thanks for quick reply.
My question is that can we load different file using same action, I have tried with -file option also it is not working in Deployed model.

To further explain: I want different files using same action.

Regards,
Venkatesh

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385