We hit this problem too. Seems the way to fix this is through the Action. See this info as it helped us figure out what to do to fix the issue: https://help.anaplan.com/anapedia/Content/Import_and_Export/Import_Data_into_Models/Overview_Private_Default_Files.htm?_ga=2.163537212.1486881565.1538087808-649252236.1500578556 Our solution was to choose either Admin Only or Everyone (depending on the data), and we no longer received the error.
... View more
Hi Rumi, This is very similar to what I had issues with. In your comment "The file that I am trying to import is a dummy data with just one line, but I get the message that <0/4671> rows were successful.", this sounds like the Datasource that was built within Anaplan was built with a different file name. Key points: You have 1 record in your import. The message says 0/4671. The file it is importing has 4671 records in it. Obviously, not the 1 record file. This indicates the datasource may be the problem. The datasource used in Anaplan and in the Anaplan Connect script need the same name. If the name changes, then you need to remap the datasource. Example, Import Action is created and maps to file Import_Data_File_201702.txt Anaplan Connect script is loading a datasource called Import_Data_File_201703.txt. Upon running the script, the script uploads the Import_Data_File_201703.txt file to Anaplan. When it goes to perform the import, it is going to re-load the data in the 201702 file as the 201703 file is of a different name (datasource). To ensure the names stay constant, you'll want to make a generic datasource name (one that does not change) and reuse that as the import datasource. If you look at the example above, and would have used the a generic datasource such as Import_Data_File.txt, the import should have worked. Let me know if this doesn't make sense, Robin
... View more
I'm having issues where an anaplan connect import batch script, runs stating "The operational was successful. Name of List: 3515 <0/3515> rows successful, 0 ignored. (It always uses 3515, even thought there may be 90 records in the load file.)
I've reviewed the Anaplan Connect document which outlines some possible reasons for the file to not load and tried out the suggestions quotes, escape characters, to no avail. The file does get loaded to the Anaplan server as I can see it as a source.
Here is the source operation variable I'm using: set SourceOperation= -certificate %certificatepath% -file "%InputFile%" -put "%put%" -import "Action Name" -execute
When I review the command during run time, the values are %certificatepath%, %InputFile%, and %put% are appropriately filling in. I've tried using -debug and -output, and am not seeing anything obvious in the output.
The input file is a .csv file that is semi-colon separated (semi-colon is designated in the file to list mapping).
When I choose a file to import manually in Anaplan (throught the action the script is calling), there are no issues loading the data into the list.
Any other thoughts, as to why the script runs, the file is uploaded to Anaplan but not into the list.
Thank you, Robin
... View more