Anaplan Connect using Bat Script For Windows - How to dynamically load a file in bat script ?

SIVAPRASADPERAM · 2023-01-31T15:24:06+00:00

There was an error rendering this rich post.

I have a file for the month of January on my local system, using that file I created a batch script using Anaplan connect.

I defined my January month file name and file path in batch script so that my script works fine with Anaplan connect.

Suppose I am in the month of February - I am planning to upload the February file to the above Anaplan connect batch script, it will not accept the February file as the file names are different (January file and February file).

is every month we need to change file in batch script ? ( OR ) Is there any solution like to run dynamically ?

Please provide some inputs here, it's really help to understand myself.

Many Thanks,

Accepted answers

Stacey_Gibbens

Hi @SIVAPRASADPERAM

If you plan to use a batch script, the name of the file for import must be the same. Make it a generic name like, "MonthlyImportData.csv" and then the time field will be mapped to the month in Anaplan.

Hope this helps,

Stacey

M.Kierepka

Hi @SIVAPRASADPERAM,

It depends also how much control you have on the source system, and do you need to store the file, or it can be replaced every month.

Generally, batch scripts allow for simple data and string manipulation, so you can get the current date/month and make your file name a variable etc. If you have time, you can experiment a little, like:

set timestamp=%date:~10,4%-%date:~4,2%-%date:~7,2%

All comments

Stacey_Gibbens

Hi @SIVAPRASADPERAM

Hope this helps,

Stacey

SIVAPRASADPERAM

Thanks @Stacey_Gibbens for your quick response.

It is really helpful to understand.

M.Kierepka

Hi @SIVAPRASADPERAM,

It depends also how much control you have on the source system, and do you need to store the file, or it can be replaced every month.

set timestamp=%date:~10,4%-%date:~4,2%-%date:~7,2%

SIVAPRASADPERAM

Thanks @M.Kierepka for your response.

I am planning to store the files in directory .

Sure, i will check this approach as well.

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…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…