Importing product attribute values using DIXF in AX2012R2

(0) Share

Report

Posted on by Ronald Richter

I'd like to Import product attribute values for defined products. There is no existing entity. The table structure is rather complex and I couldn't find the right base table to set up a new entity. I thought EcoResProductInstanceValue might be used but it is an extended table (from EcoResInstanceValue) and can hence not be used to create an new entity.

Any hints welcome!

*This post is locked for comments

I have the same question (0)

All responses (66)

Answers (1)

Suggested answer

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

Like (1)

Report

Hi Ronald,

In the past I had also encountered the problem, not being able to create an entity based on an inherited table using the wizard. Still in CU7 it is not supported.

In this case you can actually create manually the needed Staging table, Interaction class and Target query. That was my solution in the past with Operating Units. Luckiy this one is now a standard entity. You can have a look at the details of this entity to create your own without use of the wizard.

It is a bit more work, but at least you will learn every single detail of the technical part.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ronald,

Can you share your solution to import product attributes values for defined product ?

Merci

Was this reply helpful? Yes No
Mariano Gracia on at

Like (1)

Report

It is a bit hard, but finally I managed to create a tool so I could import attributes values from a csv file. To make it easier, my process could create the template from the category hiearchy form (my process searchs the attributes from the current category selected and the inherit attributes), that template contains one row for each item related to the category, and one column for each attribute related to the category. That template is edited by a user (he fills the rows with the attributes values) and then is imported, that part is also difficult, because you have different attributes types (strings, booleans, integers...), and if one of them is a fixed list you have to validate the values against the list. the empty cells are not imported, so the user can update only what he wants.

It took me a lot of time, but it is a easy and friendly tool for the users.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

With what technology the tool it been developed ? Have you an example of template code ?

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report

I've done it inside Dynamics, if you send me an email I can show you how it works.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mariano Gracia,

I am still in the same problem and there are alot of products and can not be done manually product to product so i would love to have the template you created for your solution.

My email address is

ubbi1991@gmail.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mariano,

My email is fpousserot @ bigship.fr

Was this reply helpful? Yes No
Pradeep Itnal 3,248 on at

Like (0)

Report

could you please send the tool to pradeepitnal@gmail.com

Was this reply helpful? Yes No
mail2vd 1,330 on at

Like (0)

Report

can someone please send me tool on mail2vd@mail.com?

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Hi Mariano,

Can you please email me the tool you have created if you don't mind? My email is syed.nedian@gmail.com

Thanks,

Baber.

Was this reply helpful? Yes No