Import & Exporting Product Categories

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello all, can someone please give an Idea on how to do this:

I have created a code which I am able to import the product numbers which will be the basis of what I will retrieve from the database, For each item that I have imported, it is possibly under one to two categories. My job has no issue in importing, but it has an issue exporting because the data is being cut off due to using the ff code:

type = cells.item(row+1, 1).value().variantType();
}
while (type != COMVariantType::VT_EMPTY);

Example:
Total of 3400 Product records

For each of these 3400 Product records, it is possible that it is under 1-2 categories, which makes the product categories total when you export to:

Total of 4500 Product categories

What happens is it cuts off on 3400 when i export the excel file, because of the code above.

Is there any way/other type of code to use when doing exporting?

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at

Like (0)

Report

RE: Import & Exporting Product Categories

Hi Charos,

You only pasted a small piece of your coding. However, you can also consider using the Data Import Export Framework which is standard for AX 2012 R2 with CU7 and above. This has a standard option to export to and import from Excel.