I
I
Igor2019-05-23 12:06:50
1C
Igor, 2019-05-23 12:06:50

How to build a catalog tree from excel breadcrumbs in 1C?

Here's a question: there is a table in Excel. I asked for a product catalog from the manufacturer's website. I want to create a directory (not by hand) in 1C.
All I have is a table of the form:
folder1 | folder2 | folder 3 | folder 4 | folder 5 | code |
folder1 | folder2 | folder 3 | folder 4 | | code |
folder1 | folder2 | folder 3 | | code |
folder1 | folder2 | folder 3 | folder 4 | folder 5 | code |
folder1 | folder2 | | code |
folder1 | | code |
folder1 | folder2 | folder 3 | folder 4 | folder 5 | code |
folder1 | folder2 | folder 3 | folder 4 | folder 5 | code |
folder1 | folder2 | folder 3 | folder 4 | folder 5 | code |
folder1 | folder2 | folder 3 | folder 4 | | code |
folder1 | folder2 | | code |
How to approach this reason? All folder names in 1C must be unique, then the names can be separately attached to them.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin, 2019-05-24
@fosihas

Search terms, through a separator.
The last value is the commodity. Everything else is a directory.
Further search by name
FindByName(<Name>, <ExactMatch>, <Parent>, <Owner>)
You can search within the "Parent" i.e. "top folder") Did not find creating an element

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question