Importing HR Data issue via Script using Process in Anaplan.

Dear Expert ,

I have to import Hr Data via Anaplan connect Script by using the Process which has been created in Anaplan with Import actions. But while importing its getting failed error as shown below . when i check Process and tried to Execute directly via process i could able to see we need to pass the Period while executing .Does it the reason which is creating issue to load via Anaplan Connect Script. Kindly Help me with the Solution to proceed.

Screen of Process load in Anaplan and script error is attached .

Kindly Advice.

Warm Regards

Deep

Script_Error_107017.jpg

Process_screen_107017.jpg

Accepted answers

All comments

riyazpasha

Hi @Deepu,

You are right the error is because of the period mapping. Whenever you are running the process through the scripts you have to map the time or the period other wise the dimension does not matches and the script fails.

The files will get uploaded but the actions or the process will not run de to the mapping. I don't know how you will do the mapping in the Java code but in python - {'localeName': 'en_US', 'mappingParameters': [{'entityType': 'D4_Day.S ADI', 'entityName': '2021_05_04'}]} you need to map. entity type is the date subset and entity name is the today's data because Iam uploading for today.

Thanks,

Riyaz Pasha

alexpavel

@Deepu the issue is coming from the fact that the import is setup for Time list with the option "Ask each time import is run". I presume that your data file does not contain a column with the month.

This can work fine if the file is loaded manually from a dashboard....but you have issues when you try to run the action via Anaplan Connect.

I personally don't know how to pass to an Anaplan Connect script the parameter for an action setup with the option "Ask each time import is run".

I would try to ask who creates the export CSV file to add a column with the month and map the month using a column from the CSV file.

If this not possible, I would change the approach:

1. in a system module: setup a line-item formatted as Time and chose there on which Month you would like to import the data

2. Import the file in a temporary module (without the Time)

3. create a new import action from the Temporary module (without Time) + line-item setup at point 1. and import data into your final module.

This would create a new step into your import data process but you will not need to choose via Anaplan Connect script on which month you will need to import the CSV data.

Hope it helps

Alex

Deepu

Dear Expert ,

Actually I passed the time/period parameter in Script as shown below , but I am getting the error as

"2021-05-06 10:42:13 INFO [c.a.client.Task :-1 ] 14164 |-- Invalid date or timescale identifier: 24882
2021-05-06 10:42:13 INFO [c.a.client.Task :-1 ] 14164 |-- value - Jan-2020 "

I have pass the value in script as shown below I also tried with jan-20 but below erro coming :

"set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId1% -chunksize %Chunksize% -file %FileName% -put !FilePath! -process %ProcessName% -mappingproperty Period:Jan-2020 -execute

my Import file is having data for line item as shown below , its a HR Data .

Sequence_Number,Start_Date,End_Date,Employee_ID,Position_ID,First_Name,Last_Name,Employee_Age,Adjusted_Date_of_Hire,Most_Recent_Date_of_Hire,Job_Title,Standard_Weekly_Hours,Officer_Indicator,Is_Fulltime_Employee,Sub_Area,Company_Code,Level,Annualized_Salary_Calculation,Cost_Center,Sales_Plan_ID,STI_Target_Percent,Employee_Status,Merit_Eligible,LTI_Eligible,FTE,Sales_Eligible,Geozone,HeadCount
1,06/22/2020,12/31/9999,00004235,74000387,First Name,Last Name,51,06/08/1998,06/08/1998,ZONE VICE PRESIDENT,37.5,Appointive Officer,true,Regular Pay,1010,GRADE Z,300000,100270,ZM - Zone Manager,,Active,No,No,1,Yes,AZ,1

ben_speight

I think it is probably just the value passed in not matching a period name in the timescale. Have you tried -mappingproperty "Period:Jan 20" (note double quotes)?

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…