L1 Model building - error when import data to modules

stephw229

Hi,

I am still in the training course and now in lesson 7.2.3

When I tried to import the data to the module, I couldn't map most of the fields and got a lot error message

So basically all the empty fields are not catching up with the source file.

Does anyone have similar issues? Thanks!

Accepted answers

stephw229

Solved. the date fields are due to formatting in the target source.

Other two columns which are not auto mapped so need manual map during the import process.

All comments

Misbah

@stephw229

Looks like your mapping is incorrect. Can you please share your mapping screenshot.

Line items have to be Column Headers I believe

ChrisAHeathcote

@stephw229

Also ensure that the line items in the module are formatted correctly with the relevant list format.

You need to map the date columns too so that Anaplan is able to correctly allocate the start and leave dates. Review the formatting in your source csv and select the corresponding mapping in the mapping set up.

stephw229

Hi Chris,

Thank you for replying. I have checked the format and it is what the training course required.

stephw229

Hi Misbah,

Thank you for replying.

Here is the screenshot of the mapping tab when I tried to import the data

Glamorous

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Bumped into your thread. Thanks for creating it. Looking forward for solution.

stephw229

Solved. the date fields are due to formatting in the target source.

Other two columns which are not auto mapped so need manual map during the import process.

dedrashores

I am having the same issue. Line item format is date, however still cannot get it to import. Did you reformat the source data?

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?