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

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
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.…