Automatic import of failure dump

howens21 · 2023-04-26T14:09:38+00:00

There was an error rendering this rich post.

I have an action that imports data from excel into Anaplan. When the data fails to load, it is due to a missing list item (a project). When the items fail, I would like to extract the failure dump, and import those projects into another table, which heads off an import action that brings these missing projects into the list pending a review.

Is there any way to automatically publish the failure dump of an import, to a table in Anaplan?

Accepted answers

AjayM

Hi @howens21 ,

You may try the below steps to achieve what you need:

Import projects from excel into a staging list, let's call it 'STG Projects'
You can import remaining data of these projects from same excel into a module dimensioned by 'STG Projects', lets call the module as 'STG Import Project Data'
Use 'FindItem' to identify existing projects within this module, and create a saved view to import data into your actual target module for the existing projects
The reverse of Finditem function (where it returns FALSE) gives you list of non-existing projects
Create a saved view for these new projects, and create an import action to load these new projects into your desired target module/list

Hope this helps!

Cheers!

All comments

AjayM

Hi @howens21 ,

You may try the below steps to achieve what you need:

Import projects from excel into a staging list, let's call it 'STG Projects'
You can import remaining data of these projects from same excel into a module dimensioned by 'STG Projects', lets call the module as 'STG Import Project Data'
Use 'FindItem' to identify existing projects within this module, and create a saved view to import data into your actual target module for the existing projects
The reverse of Finditem function (where it returns FALSE) gives you list of non-existing projects
Create a saved view for these new projects, and create an import action to load these new projects into your desired target module/list

Hope this helps!

Cheers!

howens21

This changes the end user experience a little, but I like the idea of the user having a "test import" step. This would force them to further assess the import before uploading. Thanks for giving it some thought!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…