About dominic.literal

Dear Expert,   Good day! Would like to seek your inputs with regards to converting a excel file to csv file in the script using Linux environment (Version: SLES 11 SP4). Please advise. Attached file is the excel file to retrieve the current date (sourcexlsFile.xlsx) and csv file as the expected result(destinationcsvfile.csv) and ExcelToCsv.txt (save as ExcelToCsv.vbs) is the vba code to convert the excel file to csv. In windows script, tried this one and working. Please see attached file as reference also. Thank you in advance.   Regards, Dom   Anaplan Connect script (for Windows):   @Echo off setlocal enabledelayedexpansion del "filelocation\destinationcsvfile.csv" ExcelToCsv.vbs sourcexlsFile.xlsx destinationcsvfile.csv set AnaplanUser="email:password" set WorkspaceId="workspace id" set ModelId="model id" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set Chunksize=1 set FileName="destinationcsvfile.csv" set FilePath="FilePath\destinationcsvfile.csv" set ProcessName="Update Date" set DumpName="Client Location for Dumping the Errored data from Import" set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% set Operation=%Operation% -file %FileName% -put %FilePath% -process %ProcessName% -execute -output %DumpName% 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% %Operation% @Echo %Command% cmd /c %Command% pause ... View more

Hi Expert,   Good day! Would like to seek your insights on how to upload the ValidTo period as 12/31/9999 and in Anaplan it will become blank (Date format). Since in Anaplan unable to load this period format unless set the format as text. Is there any workaround to handle this one or a system limitation? Thank you in advance.   Regards, Dom ... View more

  Dear Expert,   Good day! Would like to seek your insights with regards to Process script issue using Linux interface as below. Thank you in advance.   Check list done as below but still the same error “Anaplan API: Basic Authentication failed” Anaplan access checked (able to access the workspace and model) and password considered also with no special character Anaplan Connect version checked (1.4.4) Java 8 version checked  Regards, Dom ... View more

 Dear Expert,   Good day! Is it possible to get/retrieve the current user from Module 1 to Module 2 even there's no Users list used in Module 2? So that the user will no longer select/choose on the dropdown in Module 2. The reason why we didn't put the Users list in Module 2 because of workspace size issue. Please see attached file as sample.   Any insight would be greatly appreciated. Thank you so much.   Regards, Dom ... View more

  Hi Experts,   I hope all is well and safe.   Would like to seek your assistance with regards to Anaplan Connect script source file. Noticed that when I run the Anaplan Connect script it keeps on getting the old source file in the import process instead of the new source file declared in the script. Please see attached file as reference. Is this the normal behaviour of Anaplan Connect script?   Any insights will be appreciated. Thank you so much.   Best Regards, Doms ... View more