About elisa.richomme

since ‎10-02-2018
yesterday
elisa.richomme
elisa.richomme
Occasional Contributor

Re: Anaplan Connect - Use of Certificate in script...

by elisa.richomme in Best Practices
‎10-04-2018 06:21 AM
3 Kudos
‎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

Re: Anaplan Connect - Use of Certificate in script...

by elisa.richomme in Best Practices
‎10-04-2018 02:42 AM
‎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

Re: Anaplan Connect - Use of Certificate in script...

by elisa.richomme in Best Practices
‎10-04-2018 02:20 AM
‎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

Anaplan Connect - Use of Certificate in script doe...

by elisa.richomme in Best Practices
‎10-03-2018 10:16 AM
‎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
My groups