"Line Item identifier(s) were not mapped and ignored" during data import

Hello!

I am running an import from saved view into a model and I am facing this notification - it is not an error, but at the same time nothing gets imported because of it. Weird thing that this line item was indeed mapped and it was mapped automatically.

Any idea what could be wrong here?

Thank you!

Accepted answers

All comments

rishabh01

Can you share the screenshot of last tab of mapping "INP - promo calendar line items" ?

NataliaLink

Yes, sure!

Misbah

@NataliaLink

Outlet format wo totals :Name - Can you use code of this line instead of Name and see if that helps

Misbah

Miz Logix

NataliaLink

Actually it is mapping formats code to a name correctly:

In fact I am wondering why these 2 columns are even considered as line items (Outlet formats wo total and Target scenario code for copy calendar) if I map those to specific target initially (not to line items). It should not appear here, right?

rishabh01

Thanks for sharing that.

What's happening is that "target scenario code for copy calendar" is not ignored and hence it's getting ignored while running import.

If you see in the screenshot, there is "ignore unmapped" button click on that and then click ok.

Again, run the import and check if the same message appears again.

NataliaLink

If I do that, it has no errors, but it imports nothing because basically everything is ignored:

If I understand it correctly, this "target scenario code for copy calendar" should not appear as line item at all because it is mapped to a specific target:

Nipsa

Hi @natalialink , I am facing a similar issue.

I did some testing. Seems like the Saved View you created for the import should never be altered once imported. The column "target scenario code for copy calendar" should get ignored in the initial action creation by itself. After creation, if the view was pivoted and updated, it would update your mapping, and leaves the column un-ignored. Even after you specifically make it ignored, it would import nothing.

I think the catch is to create the Saved View and Action in one go, and not making any changes in the same once created.

Solution in my case was to recreate the actions.

Thanks!

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…