- Community
- :
- About Shailendr
Ask the Community
-
Ask a QuestionGet answers to platform specific questions from Anaplanners everywhere.
-
Suggest an IdeaShare ideas for platform improvements, training, the Community, and more.
-
Get Training HelpComplete your training with support from the experts.
-
Contribute ContentWorkshop content, submit for approval, and contribute best practices to the Community.
-
Connect with CommunityShare feedback, ask questions, and get support from the Community.
About Shailendr
since
01-04-2021
08-10-2021
Shailendr
Occasional Contributor
Activity Feed for Shailendr
- Posted Re: Data Export Script error. on Anaplan Platform. 04-14-2021 11:45 AM
- Posted Data Export Script error. on Anaplan Platform. 04-14-2021 05:19 AM
- Posted Re: Regarding CA Certificte - Ceretion of Encrypted Private key from Recieved S/MIME Certificate. on Anaplan Platform. 03-05-2021 05:43 AM
- Posted Re: Regarding CA Certificte - Ceretion of Encrypted Private key from Recieved S/MIME Certificate. on Anaplan Platform. 03-05-2021 01:44 AM
- Posted Re: Regarding CA Certificte - Ceretion of Encrypted Private key from Recieved S/MIME Certificate. on Anaplan Platform. 03-04-2021 07:25 AM
- Posted Regarding CA Certificte - Ceretion of Encrypted Private key from Recieved S/MIME Certificate. on Anaplan Platform. 03-04-2021 05:00 AM
- Posted Re: Implementation Process for Digi Cert received Certificate. on Anaplan Platform. 02-15-2021 10:31 AM
- Posted Implementation Process for Digi Cert received Certificate. on Anaplan Platform. 02-15-2021 01:42 AM
- Posted Re: Regarding Anaplan Connect Whitelisting - API/Autho Services. on Anaplan Platform. 02-12-2021 08:38 AM
- Posted Re: Does EMAIL ADDRESS Parameter is Mandatory to pass while Generation of CSR via Key store? on Anaplan Platform. 02-09-2021 02:47 AM
- Posted Does EMAIL ADDRESS Parameter is Mandatory to pass while Generation of CSR via Key store? on Anaplan Platform. 02-08-2021 01:33 AM
- Posted Re: Anaplan Connect - Proxy setting in Import Script . on Anaplan Platform. 02-04-2021 06:39 AM
- Posted Re: Anaplan Connect 1.4.4 Upload Error on Anaplan Platform. 02-04-2021 03:15 AM
- Posted Anaplan Connect - Proxy setting in Import Script . on Anaplan Platform. 02-04-2021 02:55 AM
- Posted Re: Regarding Anaplan Connect Whitelisting - API/Autho Services. on Anaplan Platform. 02-04-2021 02:35 AM
- Posted Regarding Anaplan Connect Whitelisting - API/Autho Services. on Anaplan Platform. 02-03-2021 11:30 PM
- Posted Re: Script - Error while Executing Import Action. on Anaplan Platform. 01-27-2021 07:27 AM
- Posted Re: Script - Error while Executing Import Action. on Anaplan Platform. 01-27-2021 07:25 AM
- Posted Script - Error while Executing Import Action. on Anaplan Platform. 01-27-2021 03:53 AM
- Posted Re: Can We Import /Export Files from Windows with SSO Credentials ? on Anaplan Platform. 01-25-2021 04:06 AM
25
Posts
0
Kudos
0
Solutions
04-14-2021
11:45 AM
Dear Ben , Really thankyou for the advice , suggested did magic and I am able to download in required format .txt . Appreciate your great support. Could you please Also Advice me for GL Hierarchy load Script? Actually I need to import GL Account master Data and GL Account Hierarchy . I have been provided with Single Process Name for Both Action and have also Provided with two file name for master data and for Hierarchy load. Does the import will work with single Script or do I need to create two Separate Script ..1 for GL Master Data load and 2nd . for GL hierarchy Load? Kindly advice on the same. Appreciate you kind guidance . Warm Regards Shailender Dubey
... View more
04-14-2021
05:19 AM
Dear Expert , Looking for your kind guidance , I am trying to export the data via script . we have been given process to use in script to export the data from Ana-plan . When i am passing the Details in Script i am getting below shown error And Script sample as below which i am trying to run. set FilePath="C:\Anaplan-Connect\anaplan-connect-1.4.4\anaplan-connect\To be deleted later\Anaplan Connect - Export Test TXT.txt" set ProcessName="ACIntegration_Test_Export TXT" set DumpName="C:\Anaplan-Connect\anaplan-connect-1.4.4\anaplan-connect\dump.txt" set Chunksize=1 set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -process %ProcessName% -execute -get %FilePath% rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 Where as when i am keeping file path without .txt extension as above its working and downloading the data in File format. Kindly do advice me what i need to change in script or from model side setting. warm Regards Shail Dubey
... View more
Labels:
03-05-2021
05:43 AM
Dear Mark , thanks for your Guidance , Now I am god to generate the Encrypted Private key from Received .pfx client certificate . Command For Encrypted Private Key. pkcs12 -in "D:\Anaplan Integration\Certificates\XYZ.pfx" -nocerts -out "D:\Anaplan Integration\Certificates\PVTKEY.pem" pkcs8 -inform PEM -in "D:\Anaplan Integration\Certificates\PVTKEY.pem" -outform PEM -out "D:\Anaplan Integration\Certificates\ENPVTKY.pem" -passout pass:TrwtPFZ Now I am looking for Key store Bundle Creation for Public/Private key .Soon Update on same . Thank you once Again for your Guidance! Warm Regards Shail
... View more
03-05-2021
01:44 AM
Hi DSoomer , I exactly following same commands for creation of Encrypted private and Java key store bundle ,But unfortunately its not working for we . For your Information we received Certificate in .pfx format from vendor .we did extracted public cert and Private unencrypted key. But my challenge here is while extracting Encrypted Private key and while creation of Java key bundle I am getting with error as highlighted above. I would be highly thankful for your great advice to crack it down. Warm Regards Shailender Dubey
... View more
03-04-2021
07:25 AM
Hi Mark , thank you for your kind favor! I did the execution of same command shared by you but still throwing error. Seems error "pkcs8: Option unknown option - error in pkcs8" hope its not able to recognize pkcs8 . Command for Encrypted Private Key : pkcs8 -inform PEM -in "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\PRIV_KEY.pem" -outform PEM -out "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\AC_PRIV_KEY.pem" -passout pass: q2UvIFdnuzdk Error : pkcs8: Use -help for summary. error in pkcs8 OpenSSL> Infect I tried to Create Java Key Store Bundle but again throwing Error. Sharing Command Below for Java key store bindle. Command For Java Key Store Bundle Creation : pkcs12 -export -in "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\Publicrt222.pem" -inkey "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\PRIV_KEY.pem" -out "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\keystore_bundle.p12" -name KEYSTORE_VIR Error : unable to load private key 18152:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto\evp\evp_enc.c:610: 18152:error:23077074:PKCS12 routines:PKCS12_pbe_crypt:pkcs12 cipherfinal error:crypto\pkcs12\p12_decr.c:63: 18152:error:2306A075:PKCS12 routines:PKCS12_item_decrypt_d2i:pkcs12 pbe crypt error:crypto\pkcs12\p12_decr.c:94: 18152:error:0907B00D:PEM routines:PEM_read_bio_PrivateKey:ASN1 lib:crypto\pem\pem_pkey.c:88: error in pkcs12 I would be highly thankful for your support. awaiting to hear ! warm Regard Shailender Dueby
... View more
03-04-2021
05:00 AM
Dear Expert , To work on Import Script, we are going by Certificate based Authentication . So while Generating encrypted private key from received certificate.pfx, I am getting below error . Though I was able to generate the Public key and unencrypted Private key . I followed the Anaplan Connect Guide while creating encrypted private key , but its throwing error in 2nd command . OpenSSL> pkcs8 -inform PEM -in "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\\PRIV_KEY.pem" -outform PEM - "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\AC_PRIV_KEY.pem" -passout pass: q2UvIFdnuzdk pkcs8: Option unknown option - pkcs8: Use -help for summary. error in pkcs8 Kindly Advice me Please ! Warm Regards Shail
... View more
02-15-2021
10:31 AM
Dear Jared , Thank you for your response. I went through those Guide for CA .for your information, we have procured the Certificate from DIGICERT. But my doubt here is we have received 3 files for CA Authority. 2 .CERT and 1 file as .CER. So we are not clear with the SHA256root.cer file as well as Intermediate.crt file. unfortunately ,no where its mentioned in shared ppt. So please let us know which file we should Register/Manage with Anaplan as tenant Administrator? Also what is role of SHA256root.cer and intermediate.crt file. I would be highly thankful for your great Support. Thanks and Regards ShailD
... View more
02-15-2021
01:42 AM
Dear Expert , I would be highly thankful to you if you could help me with the installation process of CA based Authentication in Anaplan Connect. For your information , I have received 3 different files from Vendor . 2 as .CRT and 1 as .CER format file which is named as below. 1. SHA256root .cer 2. Intermediate.crt 3 XYZ.com.crt My doubt/Question here is which once is needed to be register/uploaded into Anaplan system by tenant administrator and what action need to be done with other 2 files. In nutshell , which is public certificate and which one is private key, and what is role of Intermediate crt file? It would be great favor and highly appreciated! Awaiting for your kind guidance. Warm Regards Shail
... View more
Labels:
02-12-2021
08:38 AM
Dear Ben , Hope you are doing great , as per my query on whitelisting . I found ever using Proxy we are mentioning the yellow highlighted in script as shown in attachment. Does it mean even if we use Proxy we need to pass these parameter in script? Kindly Advice how to write Import script with Anaplan Connect . where we did not whitelisted the services API/AUTH. Appreciate your great favor! Warm Regards Shailender Dubey
... View more
02-09-2021
02:47 AM
Hi Jared , Thankyou for your kind advice . As per your Give Code snippet Can we Exclude -service ' https://api.anaplan.com ' -auth ' https://auth.anaplan.com ' from the Script ? Since my Client is not willing to whitelist mentioned both. Could you please advice me the work around in case we need to void( not willing to whitelist due to client security policy) these service and autho in Script for Import/Export. I would be highly thankful to you , awaiting for your kind favor! Warm Regards Shailender Dubey
... View more
02-08-2021
01:33 AM
Dear Team , We are looking for CA from Authority while working on Script for Anaplan Connect. My Question here is Does we Need to Pass Email Address as as command/Parameter while generation CSR via key store? Or email address is option , even if CSR does not have Email Address details will not be a problem to get certificate from CA and on its working functionality? Kindly Advice , would appreciate your helpful support. Warm Regards SD
... View more
Labels:
02-04-2021
06:39 AM
Hi Ben , Kindly Share me the Dummy Script , who to pass Via statement please . Just want to to check will it work then in that way which you Suggested ? Warm Regards Shailneder
... View more
02-04-2021
03:15 AM
HI Ben , Hope you are doing great! Looking for your Kind Advice .. Actually , I am working with Anaplan Connect to Import/Export files from server. Due to Security policy my client is not willing to Whitelist below both services. api.anaplan.com & auth.anaplan.com . where as they are suggesting to use proxy and port in my Script . or Data Power path Anaplan Connect -> www.XXXX.ws.ABC.com/API & www.XXXX.ws.ABC.com/AUTH -> api.anaplan.com & auth.anaplan.com - No proxy config Can we use a different url like www.XXXX.ws.ABC.com/API instead of api.anplan.com in the script. The URL www.XXXX.ws.ABC.com/API will convert to api.anaplan.com when it hits the internet.
... View more
02-04-2021
02:55 AM
Dear Expert , As suggested in Anaplan Connect to Whitelist api.anaplan.com and auth.anaplan.com . But due to security policy client is not willing to do the same . Is their any ways in Script where I can use different URL prvided by my Security team to use as below for Example... Can we use a different url like www.XXXX.ws.ABC.com/API instead of api.anplan.com in the script. The URL www.XXXX.ws.ABC.com/API will convert to api.anaplan.com when it hits the internet. Or Anaplan Connect -> api.anaplan.com & auth.anaplan.com (via zproxy.ABC.com on port XXXX) . So , If we want to use api.anaplan.com and auth.anaplan.com can we mention proxy and port in the script somewhere. Kindly Advice , Awaiting your helpful support. Warm Regards ShailD
... View more
Labels:
02-04-2021
02:35 AM
Dear Nathan , Appreciate your favor , But seems security team is not willing to whitelist the Anaplan URL . Whereas they suggested in below two Approach . Kindly Advice how to proceed with below option provided by them in script? Option 1 : 1. Data Power path Anaplan Connect -> www.XXXX.ws.ABC.com/API & www.XXXX.ws.ABC.com/AUTH -> api.anaplan.com & auth.anaplan.com - No proxy config Can we use a different url like www.XXXX.ws.ABC.com/API instead of api.anplan.com in the script. The URL www.XXXX.ws.ABC.com/API will convert to api.anaplan.com when it hits the internet. Option 2 : Zscalar Proxy path Anaplan Connect -> api.anaplan.com & auth.anaplan.com (via zproxy.ABC.com on port XXXX) - zproxy.ABC.com So,If we want to use api.anaplan.com and auth.anaplan.com can we mention proxy and port in the script somewhere. Kindly Advice! Warm Regards Shailender dubey
... View more
02-03-2021
11:30 PM
Dear Team , I am working with Anaplan Connect to Import/Export files from server. Due to Security policy my client is not willing to Whitelist below both services. api.anaplan.com & auth.anaplan.com . where as they are suggesting to use proxy and port in my Script . Could you please help and suggest me on this since i am not aware about other way apart of whitlisting api.anaplan.com & auth.anaplan.com . Kindly suggest me how to Execute the Script without mentioning the service and by writing Proxy and port setting in script. awaiting your kind favor on subject matter. Warm Regards Shailneder dubey
... View more
01-27-2021
07:27 AM
C:\Users\T19NMOU>echo %JRE_HOME% C:\Program Files\Java\jre1.8.0_15
... View more
01-27-2021
07:25 AM
Dear Sean, Appreciate your favor , We have already done the variable setup since we have JRE so I made JRE_HOME .for your view please see the below screen . But still I am getting error . Kindly do let me know if I a missing another setting.
... View more
01-27-2021
03:53 AM
Dear Expert , Seeking your kind guidance n below matter , I am trying to import File to my Anaplan Model but while doing show I am getting below shown error. I also crossed checked the Java Path which seems correct to me . Could you please assist me on this I would be highly thankful to you. Administrator: Command Prompt
r windows registry.
ERROR: Java binary at path does not exist (C: \Program .exe)
Press any key to continue
C: \Anap1an Connect\anaplan-connect-l call . . bat
. \Anap1anC1ient . bat -user "Shai1ender_Dubey@XXXX.com:"
-debug -service "https://api . ana
auth.anaplan.com" -workspace "XXXXX" -model "XXXXX
file
-put "D: XXXX . csv"
-import "XXXXXX"
cation for Dumping the Errored data from Import"
Absolute path to JAVA 8 or Java 11 or Open]DK8 executable not provided. Will attempt to figure
r Windows registry.
ERROR: Java binary at path does not exist (C: \Program exe)
Press any key to contin
C: \Anap1an Connect\anap1an-connect-1.4.4\anap1an-connect>
C: \Anap1an Connect\anap1an-connect-1.4.4\anap1an-connect> Warm Regards Shail
... View more
Labels:
01-25-2021
04:06 AM
Hi Ashish , Thankyou for the valuable links !! But seems my Query is still unanswered , Suppose My Client is having SSO enabled for me , So is it Possible for me to Work with SSO by having my CA Certificate? Or How CA Certificate works with SSO enabled User?? Warm Regards Shailender Dubey
... View more
01-25-2021
12:10 AM
Hi Ashish , Thank you for your Support , Just last query I have is how SSO enabled is Different from Basic Authentication or you can understand my Query in this way what is Difference in all tree Mode like SSO/Basic/CA based Authentication User. Can you please help me to understand the Differnce in all these 3 mode enabled user. thankyou in Advance and for consistent support. Warm Regards Shailender dubey
... View more
01-24-2021
04:15 AM
Dear AB , But as per my Understanding while scripting , we need to pass Username and password as a mendatory parameter So what kind of setting or steps we need to do in case of SSO enable Id . Could you please elaborate me bit more on this . Warm Regard SD
... View more
01-22-2021
06:55 AM
Dear Experts , Could you please Assist me with my query , Actually i have received SSO for Anaplan System Access . Can I import/Export the Files from Windows? or do i Need Basic or CA authentication as a prerequisites. Also i am not having Model Builder / Workspace Administrator role. I would really appreciate for your great favor. Warm Regards SD.
... View more
Labels:
01-17-2021
03:39 AM
Dear , Thank you soo much for your prompt Response. Warm Regards Shailenderdubey
... View more
01-08-2021
12:25 AM
Dear Team , I am New to Anaplan , I want to Install the Anaplan Connect at Windows Server Side. So i just wanted to know the Installation process and pre Requisites for the installation. I would highly appreciate the great favor. Warm Regards Shailender 7702196644
... View more
Labels:
Posts I kudoed