Import Scripts run successfully but target module did not update as expected

Hi,

We're able to set up a scheduled import actions using Java scripts with certificate authentication and it appears to run successfully according to the import history, but the target module in ANAPLAN is not being updated as expected.

It seems like it is still importing the old csv file instead of the new one. Also, we are deleting and re-exporting the csv file to the file path folder; we do this to as we have updated file daily.
What could be the possible error for this?

Please help. Thanks

Accepted answers

All comments

Stacey_Gibbens

Hi @fsbaste,

Most likely the account that is being used to run the import action is not the account that originally created the import/original data source. Remember that the import data source is a holding location for your uploaded file and therefore even if you are deleting and replacing the original file on your server, it's not loading properly to the Anaplan workspace server's data source associate with the import action within your model. That's why it would still continue to be the original .csv and not the new one. The original .csv is still there, and it can only be accessed by the user account that built it (unless the action is published on a dashboard, yadda, yadda, yadda).

It's a funny requirement, but something that's been in effect since Anaplan put security on import data sources many moons ago. It's just one of those funny little gotcha! things that are quirky about integrations. :) The way to get this to work is to build your import actions for your lists and source data that you plan to automate using the service/integration account. You can log in outside of SSO with the service/integration account and configure everything, then run it via the script with a new .csv to ensure it tests out.

Hope this helps,

Stacey

fssebastian

Hello @Stacey_Gibbens,

I apologize for taking so long to comprehend. I'm not sure if we are using specific account to run the action since we have the certificate authentication which is the java keystore.

Here is the sample bat file that is being run by scheduler.

set Keystore="C:\anaplan-connect\Anaplan Converted Cert\.jks"
set KeystoreAlias=""
set KeystorePassword=""
set WorkspaceId=""
set ModelId=""
set ServiceUrl="https://api.anaplan.com"
set AuthUrl="https://auth.anaplan.com"
set FileName=".csv"
set FilePath="D:\csv"
set ImportName=""
set DumpName=""
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%
set Credentials=-keystore %Keystore% -keystorepass %KeystorePassword% -keystorealias %KeystoreAlias%

Does this need specific account? please help. Thank you!

wsdfghj

Validate eateries with confidence using MT-On's thorough Eat and Run Verification process.먹튀검증사이트

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385