Import Categories

(0) Share

Report

Posted on by Axi Tirol

Hi everybody!

In the default solution there is an entity called Category. Each category can have a parent category and this also can have a parent category and so on, so I get a tree.

Now I have a excel file with the following structure (the first line is the header line, the other cells contain the name (title) of the category.

Level1	Level2	Level3	Level4
SampleCat	SampleChild	SampleChild2
SampleCat	SampleChild	SampleChild3	SampleChild4
SampleCat2	SampleChild	SampleChild5

After Import I should have 8 (eight) categories

SampleCat and SampleCat2 without parent

SampleChild with parent SampleCat

SampleChild with parent SampleCat2

and SampleChild2, SampleChild3, SampleChild4, SampleChild5

Is there any possiblity to import such file with ootb tools or do I have to write a console application to handle this?

thx for any advice

©a-x-i
Tirol

All responses (3)

Answers (1)

Suggested answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: Import Categories

Hi,

Glad that I were helpful.

Please mark my answer verified if i were helpful
Axi Tirol 50 on at

Like (1)

Report

RE: Import Categories

Thanks, I've built a console utility. Works like a charm :)

a-x-i
Verified answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: Import Categories

Hi,

I think for your requirement you need to write console utility to import the data in CRM instance.

OOB import requires the records to be already created to reference in child record.

Please mark my answer verified if i were helpful