Error when importing from 2 other models, one works, the other doesn't

I am importing data to a module from 2 other models. One works perfectly whereas the other import comes back with an error message 'The column headers in the file you are attempting to import do not match the import definition'.

The source modules have the same structure apart from there is a numbered list in the source module which fails to load.

Please see the attached.

I've seen issues with importing numbered lists into modules.

Is that the probelm I have here? And is there a workaround?

Thanks

Simon

Anaplan_Error_122271.docx

Accepted answers

simonlee

Hi Andrew

Thanks so much for your help, much appreciated.

I'll look at creating a new module for the export.

Best

Simon

All comments

andrewtye

If you try ignore unmapped on the 2nd screen that might help you.

And as an aside numbered lists model to model always fail which is why you need to use code for them as then they will import fine - because effectively it's reliant on the # being identical in both list which is going to be super unlikely.

Andrew

simonlee

Hi Andrew

Thanks for your message.

Yes, I tried Ignore Unmapped too, and that came back with the error message again (excluding the part about mappings).

So, even if we ignore that list, there tends to be a problem importing modules with numbered lists regardless?

From your post, I need to add the code. I've hit a problem doing this, I wonder if you could help with this one Andrew!

I've tried to pull the code into the source module using Code(Item(L_Ons Offs Segments))

The Code is populated on the numbered list:

But, it doesn't pull through on the view to be imported:

Would you have any idea why this is?

Thanks so much in advance!

Simon

andrewtye

On the code point it's because you've got summary settings to "none" so when you've picked a top-level there'll be nothing coming through. Worth having that code line as just dimensioned against the list.

Also it might make sense to either have the list in the downstream model or create a module in this model that pulls together the data to be easily imported/exported.

simonlee

Hi Andrew

Thanks so much for your help, much appreciated.

I'll look at creating a new module for the export.

Best

Simon

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385