Item import by DIXF in ax 2012 R3

(0) Share

Report

Posted on by Anand AX

2,172

Hi All,

I am importing items using DIXF. Here what staging field should i select to give value for Category hierarchy and Barcode.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (3)

Verified answer

fatihgork 3,817 on at

Like (1)

Report

Hello,

For barcode I used following fields:

barcodeSetupId,DisplayProductNumber,itemBarCode,UnitID,Blocked,description,RetailShowForItem,useForInput,useForPrinting

I import category hierarchies with excel add-in.

But if product category assignments is what you need, I use the following fields for it:

EcoResCategory_Name,EcoResCategoryHierarchy_Name,Product_DisplayProductNumber

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report

Hi Fatih Gork,

Thanks for the reply. Here i am using product entity to import items,

1. Shall i have any staging field in product entity to give values for Category hierarchy and Barcode.

2. I have imported the item using product entity and also released. If i import category and barcode using Barcode and product category entity now, will that get updated with respect to the items imported already?

Please clarify me!

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (1)

Report

Hi Anand,

There is a separate Product category entity to link a product to a hierarchy.

Also there is a separate entity for Barcodes.

Was this reply helpful? Yes No
Verified answer

fatihgork 3,817 on at

Like (0)

Report

Hello Anand,

Importing Item Category with DIXF will not update any data on products, instead it will insert data to EcoResProductHierarchy. (Will not get any default values from category even if it is specified)

Barcode entity will also not update anything on products, instead it will insert data to InventItemBarcode.

Was this reply helpful? Yes No
Anand AX 2,172 on at

Like (0)

Report

Hi,

Ok thank you, Is there any way to link released product with Category?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (2)

Report

I wonder why an entity with staging fields EcoResCategory_Name, EcoResCategoryHierarchy_Name and Product_DisplayProductNumber will not update this information. There is an entity "Category" which will only update the categories, but the entity "Product category" for sure can handle the link between product and the categories. The EcoResProductCategory is the target for this entity. I have used this one in the past.

The Barcode entity seems to be missing some generate methods in my environment and will without adjustments not work.

Was this reply helpful? Yes No
Suggested answer

fatihgork 3,817 on at

Like (0)

Report

Hello Anand,

I have used the entity Andre mentioned, it attaches the items to category with using EcoResProduct for link and it works for released items as well. I have just done it for 25.000 released items.

Andre, I have not noticed anything wrong with the Barcode entity yet, I really wondered the problem you had.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (1)

Report

Hi Fatih,

When I look at the staging fields in my environment it uses a Product display number field and the target has an Item ID field. You could use the Product display number as ItemId, but the field is not linked automatically. This can be done by adding the link manually or create a some logic in the helper class DMFProductBarcodeEntityClass.

Can you confirm you have the same or do you have or another staging field or also some coding like a Generate method?

Was this reply helpful? Yes No
Verified answer

fatihgork 3,817 on at

Like (0)

Report

Hello Andre,

I have same field but my current environment is like following:

AX runs with 3 companies and they all have the same ItemId.

Also my ItemId equals to my Product number in EcoResProduct table.

When I import barcodes for a Product, I just get the Product ID for DisplayProductNumber

When I do it for a Product Master, I generate the DisplayProductNumber with merging color,size,style, configuration and Product ID like I wrote in the query below.

My last import looked like following:

And my SQL query is:

SELECT

distinct

barcodeSetupId

,max(itembarcode) as ItemBarcode
,UnitId
,'No' Blocked
,[Description]
,'No' [RetailShowForItem]
,'No' [useForInput]
,'No' [useForPrinting]
--Display Product Number Structure: 000106 : CONFIG : SIZE : COLOR : STYLE

--Use for [EcoresProductDimensionGroup_Name]=0013

,[Itemid]+' : '+[inventconfigid]+' : : : '+[inventstyleid] as [DisplayProductNumber]

-- Use for [EcoresProductDimensionGroup_Name]=0005

--,[Itemid]+' : '+[inventconfigid]+' : '+[inventsizeid]+' : '+[inventcolorid]+' : '+[inventstyleid] as [DisplayProductNumber]

--Use for [EcoresProductDimensionGroup_Name]=0010

--,[Itemid]+' : : : '+[inventstyleid]+' :' as [DisplayProductNumber]

--Use for [EcoresProductDimensionGroup_Name]=0012

--,[Itemid]+' : '+[inventconfigid]+' : : '+[inventcolorid]+' : '+[inventstyleid] as [DisplayProductNumber]

--Use for [EcoresProductDimensionGroup_Name] =''

--,[Itemid] as [DisplayProductNumber]

FROM

[AXMasterData].[dbo].[PRODUCTMASTERDATA]

group by itemid,InventColorId,InventConfigId,InventStyleId,InventSizeId,
barcodeSetupId,UnitId,Description

One thing I noticed, Barcode entity does not let you import more than 1 barcode per Product ID, I found that kind of weird. Also for this reason I had to pick the Max ItemBarcode in my query for initial import.

Was this reply helpful? Yes No