Importing HR Data issue via Script using Process in Anaplan.

Options
Deepu
Deepu Member, ALL USERS Posts: 5 Contributor
in Extensibility

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

 

 

 

 

Tagged:

Comments

  • Deepu
    Deepu Member, ALL USERS Posts: 5 Contributor

    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

     

Categories