Import Data into DAT04 Distribution Center Parameters Module

Hello,

I'm trying to import Weekly Safety Stock Csv file into the DAT04 Distribution Center Parameters Module.

I'm not sure if something is wrong with my mapping, because I'm not getting any error, the import is being successful without data from the Csv, import results tab says ignored, why is my import getting ignored?

No records are updated

1. The Half Year from the source is mapped correctly

2. The code from the source is mapped correctly

Any help is truly appreciated.

Regards,

Harsha Rappan

Screen_Shot_2021-12-22_at_2_128169.png

Accepted answers

All comments

Javvaji45

Hi Harsh,

Can you share me another tab Details, we can look into the exact one there.

KirillKuznetsov

@HarshaR

This appears then in the imported items there are mapped items which are: non-editable or mentioned as ignored in the settings of your import (either automatically or manually). Practically if there is nothing to be imported from the source, those items will be in Ignored count.

For more details I have to ask you to check all of the import settings mapping tabs (for each dimension).

HarshaR

I don't see any specific details on this tab either. The source file which is SKU flat list for this import has data in it.

The import file is weekly safety stock csv file, attached for your reference. It has year, code and weekly safety stock for each product, basically this file contains the inventory for all the SKUs.

I checked the import mapping setting, i could not find abnormalities there either, not sure what I'm missing here.

Screen_Shot_2021-12-23_at_8_128211.png

Weekly+Safety+Stock_128211.csv

HarshaR

I found the issue. The issue is with the timescale for weekly safety stock line item, the timescale was set to week, i changed it to Half year and the import worked.

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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