About elisa.richomme
since
10-02-2018
Wednesday
elisa.richomme
Occasional Contributor
5
Posts
3
Kudos
1
Solution
3 weeks ago
Hello, Wondering if someone has found a workaround to this limitation? I have the exact same issue with my production plan Thank you, Elisa
... View more
10-04-2018
06:21 AM
3 Kudos
Thank you so much for your help Pavan! It worked after a little change from your last script. In the end this is the scrip that works in case this might help people: @echo on :: This script looks up the current date, writes it to a csv file, and sends it to Anaplan :: Here we set the file path of the csv file we will be writing the current date too set FileName="C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\CurrentDate.csv" :: rem This is a simple for loop that parses the date /t function FOR /f "tokens=1,2,3 delims=-" %%a in ('date /t') do (set mm=%%b& set dd=%%c& set yyyy=%%a) set mydate=%yyyy%%mm%%dd% @echo "Current Date","Heure"> %FileName% @echo "%mydate%","%TIME%">> %FileName% set Operation=-file "CurrentDate.csv" -put %FileName% -import "Today from CurrentDate.csv" -execute -output "C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\Errors" rem ************************************************************** rem This example loads a source text file and runs an Anaplan import into a module. rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc set certificate="C:\Users\Elisa\Documents\certificate-222628677637089600518301929753078471363.cer" set WorkspaceId="8a81b09457ee03b601581c074c2a04e2" set ModelId="C0A17C7D902343359BA909CCD3D3DC7E" set Operation= -file "CurrentDate.csv" -put %FileName% -import "Today from CurrentDate.csv" -execute rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %certificate% == "" set Credentials=-certificate %certificate% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command%
... View more
10-04-2018
02:42 AM
Hello, I did and its the same result, that's why I tried again with sticking to your example: This is the script with just the change you mentionned: The script here, updates a file with today's date and then tries to import it to Anaplan. The updating file part works, but there is no import in Anaplan. @echo off set AnaplanUser="anaplanadmin@withings.com" set WorkspaceId="8a81b09457ee03b601581c074c2a04e2" set ModelId="C0A17C7D902343359BA909CCD3D3DC7E" set Operation -certificate "C:\Users\Elisa\Documents\certificate-222628677637089600518301929753078471363.cer" -export :: This script looks up the current date, writes it to a csv file, and sends it to Anaplan :: Here we set the file path of the csv file we will be writing the current date too set FileName="C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\CurrentDate.csv" :: rem This is a simple for loop that parses the date /t function FOR /f "tokens=1,2,3 delims=-" %%a in ('date /t') do (set mm=%%b& set dd=%%c& set yyyy=%%a) set mydate=%yyyy%%mm%%dd% @echo "Current Date","Heure"> %FileName% @echo "%mydate%","%TIME%">> %FileName% set Operation=-file "CurrentDate.csv" -put %FileName% -import "Today from CurrentDate.csv" -execute -output "C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\Errors" rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %certificate% == "" set Credentials=-certificate %certificate% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command% pause
... View more
10-04-2018
02:20 AM
Hello, Thank you for your help. Unfortunately it is still not working. I set up my script just like your example. Is there something particular I should be doing with the certificate maybe? New script: @echo off set certificate="C:\Users\Elisa\Documents\certificate-222628677637089600518301929753078471363.cer" set WorkspaceId="8a81b09457ee03b601581c074c2a04e2" set ModelId="C0A17C7D902343359BA909CCD3D3DC7E" :: This script looks up the current date, writes it to a csv file, and sends it to Anaplan :: Here we set the file path of the csv file we will be writing the current date too set FileName="C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\CurrentDate.csv" :: rem This is a simple for loop that parses the date /t function FOR /f "tokens=1,2,3 delims=-" %%a in ('date /t') do (set mm=%%b& set dd=%%c& set yyyy=%%a) set mydate=%yyyy%%mm%%dd% @echo "Current Date","Heure"> %FileName% @echo "%mydate%","%TIME%">> %FileName% set Operation=-file "CurrentDate.csv" -put %FileName% -import "Today from CurrentDate.csv" -execute -output "C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\Errors" rem *** End of settings - Do not edit below this line *** setlocal enableextensions enabledelayedexpansion || exit /b 1 cd %~dp0 if not %certificate% == "" set Credentials=-certificate %certificate% set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation% @echo %Command% cmd /c %Command% pause
... View more
10-03-2018
10:16 AM
Hello,
I have the following script written up to update a module to hold Today's date and time.
The script worked fine when I was using my username and was prompted for the password.
As I am looking to schedule this script everyday, I want ahead and downloaded the certificate linked to my user and changed the script as seen on user guides.
However I still get prompted for a password.
Can someone please help me?
This is the script:
@echo off
set AnaplanUser="anaplanadmin@withings.com" set WorkspaceId="8a81b09457ee03b601581c074c2a04e2" set ModelId="C0A17C7D902343359BA909CCD3D3DC7E" set Operation -certificate "C:\Users\Elisa\Documents\certificate-222628677637089600518301929753078471363.cer" -export
:: This script looks up the current date, writes it to a csv file, and sends it to Anaplan :: Here we set the file path of the csv file we will be writing the current date too
set FileName="C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\CurrentDate.csv"
:: rem This is a simple for loop that parses the date /t function
FOR /f "tokens=1,2,3 delims=-" %%a in ('date /t') do (set mm=%%b& set dd=%%c& set yyyy=%%a)
set mydate=%yyyy%%mm%%dd%
@echo "Current Date","Heure"> %FileName%
@echo "%mydate%","%TIME%">> %FileName%
set Operation=-file "CurrentDate.csv" -put %FileName% -import "Today from CurrentDate.csv" -execute -output "C:\Users\Elisa\Downloads\anaplan-connect-1-3-3-5\anaplan-connect-1-3-3-5\Errors"
rem *** End of settings - Do not edit below this line ***
setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%
pause
... View more
Labels:
My Accepted Solutions
| Subject | Views | Posted |
|---|---|---|
| 875 | 10-04-2018 06:21 AM |
Activity Feed for elisa.richomme
- Posted Re: Allow the same action to run multiple times within a single process on Idea Exchange. 3 weeks ago
- Got a Kudo for Re: Anaplan Connect - Use of Certificate in script does not work. 11-11-2018 08:24 AM
- Got a Kudo for Re: Anaplan Connect - Use of Certificate in script does not work. 10-09-2018 12:38 AM
- Got a Kudo for Re: Anaplan Connect - Use of Certificate in script does not work. 10-04-2018 07:44 AM
- Posted Re: Anaplan Connect - Use of Certificate in script does not work on Anaplan Discussions. 10-04-2018 06:21 AM
- Posted Re: Anaplan Connect - Use of Certificate in script does not work on Anaplan Discussions. 10-04-2018 02:42 AM
- Posted Re: Anaplan Connect - Use of Certificate in script does not work on Anaplan Discussions. 10-04-2018 02:20 AM
- Posted Anaplan Connect - Use of Certificate in script does not work on Anaplan Discussions. 10-03-2018 10:16 AM
- Tagged Anaplan Connect - Use of Certificate in script does not work on Anaplan Discussions. 10-03-2018 10:16 AM
- Tagged Anaplan Connect - Use of Certificate in script does not work on Anaplan Discussions. 10-03-2018 10:16 AM
My Top Kudoed Posts
| Subject | Kudos | Views |
|---|---|---|
| 3 | 875 |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 3 | 10-04-2018 06:21 AM |
My kudoed posts
| Subject | Kudos | Posted |
|---|---|---|
| 3 | 10-04-2018 06:21 AM |
