Import & Exporting Product Categories

(0) Share

Report

Posted on by Community Member

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?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

André Arnaud de Cal... 304,553 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No