Import hierarchical taxonomy in Drupal 9

The Feeds module copes with the import of node in Drupal 9, but the problem arises at the moment when it is necessary to import taxonomy in a certain hierarchy.

The Feeds Tamper Term Hierarchy module can help this. With it, you can import nodes with a reference to taxonomy with a set hierarchy.

However, if you initially have a file for imports in which the categories are divided into different columns, you need to eat them into one and put a separator between them. This can be done in the excel on the example of the formula

=K2&">"&L2&">"&M2

However, it should be borne in mind that some nodes may have a binding to only one category or two. In this case, after the unification, we may remain in the taxonomy cell one term and two or one separator at the end. If you try to import such a line, you will run into an import error.

If you have a notepad ++ at hand, you can insert the entire column of the combined taxonomies and the challenge first replacement with an empty value for a double separator, and after that, turning on an advanced search mode, make a replacement of the last symbol of the line with the separator

>\r