Task scheduler issue in Anaplan Connect.

Hi Community,

I would like to ask something about the Anaplan Connect. So in our client model, we created a Anaplan connect to update the current date on the model. This is used for period locking. The date will be used to lock certain period so admin can control the date range of when the users can only enter values to the model. We created a Anaplan connect to regularly update the current date on the model.

Issue: the client set the task scheduler to run the Anaplan Connect every day. But when it is run thru the task scheduler it deletes the file destinationcsvfile.csv hence it produces an error on the .bat file. See below.

Before it is run by the task scheduler. The black screen is when the user run it manually. The destination csvfile.csv holds the current date for the model.

After the task scheduler run

below is the script

Appreciate any suggestion you can provide

THanks and Regards,

Accepted answers

M.Kierepka

Hi,
I believe it is correct that it removes older file. I think the problem is that it fails to create new one, and I think I might know why:
On line 5 of your script you try to create the CSV date file using Excel. But the paths given there are relative (only name of the files), so it works only if you are in the same directory (like running script manually), but not if you run it from Scheduler. You have to change the paths there to absolute paths (like you done for the path on line 16).

M.Kierepka

What I mean is"
line 5 looks like it tries to do exactly what I described – and it does the job correctly if you run it manually. It only doesn't work when you run it automatically (note that Task Scheduler starts scripts in "some" path, but it's not the path of your script), and I believe it's because in line 5 you use relative paths (just names of files) instead of full paths ("C:\Users\User\Desktop....."). Just add path of the folder with your script before names of the files in line 5, and it should work.

M.Kierepka

Another solution would be to just change the current path of execution for this script, so it's always in the correct one. You can do it by putting "cd" command with path to your folder on line 3.

All comments

M.Kierepka

Jsdeloria21

Hi M.Kierepka,

First of all, I appreciate the time to respond to my query. So your saying is that we need to create a line in row 5 where we will create the destinationcsvfile.csv file? row 5 currently shows below.

we will replace that with a statement where we will create the destinationcsvfile.csv and then test it again.?? it actually make sense.

Again appreciate your feedback on the matter.

Thanks and Regards,

M.Kierepka

Another solution would be to just change the current path of execution for this script, so it's always in the correct one. You can do it by putting "cd" command with path to your folder on line 3.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…