We use Anaplan connect 1.4.4 to import data from SQL. we noticed that after import execution the file delimiter default itself to "Tab" even though it is set to "Comma" delimiter. this is weird.
Interesting part is even if the action changes from comma to tab further load using the same API call works when it was imported using Anaplan client 1.4.4 but this is not working when this action is called from AWS API (v2)
set ActionName="1.1 Current date upload from SQL" set ActionFile="Current_Date.csv" set JDBCFile=JDBC_Current_Date.properties set ErrorFile=Current_Date_Error.txt
set Operation=-auth %AuthUrl% -file %ActionFile% -jdbcproperties "%JDBCpath%\%JDBCFile%" -import %ActionName% -execute -output "%Errorpath%\%ErrorFile%" 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 %DatahubWSID% -model %DatahubModelID% %Operation%
cmd /c %Command%
Action is configured as "Comma" delimiter
After executing the API import, the delimiter automatically changes to "TAB" from "COMMA"
Please suggest why delimiter changes after Anaplan connect 1.4.4 API call
1 other thought came to mind, does the data load successfully after the delimiter setting changes from Comma to Tab?
How many rows of data do you have? I am wondering if this is because there is only 1 element of data in the file which is "Current Date" and Anaplan automatically treats 1 row of data as "Tab" delimited.
Anyway yes going down the Support route would be the best way forward to see if this is a bug or intended behavior.
@Sivasankar -Yes what you can do is you can email email@example.com. Then link this thread in your email so they can help out from here. Emailing support is best because it will formally log a ticket in their system so it can help Anaplan track similar reports and maybe find a similar solution or route it up to higher levels if needed. (I used to work on that team).
They will very much be willing to help and emailing support would help Anaplan manage the case more efficiently!