1. regme_rojo
  2. RO CSVI
  3. Thursday, 16 June 2022
  4.  Subscribe via email
As stated in the docs (https://rolandd.com/documentation/ro-csvi/joomla-categories), to import categories the fields "category_path" and "extension" are needed at least.

The problem of my XML file is, that i don't have any path (nested categories) information in the xml field:

<LSRMitarb>
.
.
.
<LSR_ABT>division (details of the division)</LSR_ABT>
.
</LSRMitarb>

Just the plain name of the division. So I need to "create" the path somehow and "hook" the different categories into a root category. How can I do this?

Thanks for your help!
Chris
Accepted Answer Pending Moderation
Hello Chris,
Just the plain name of the division. So I need to "create" the path somehow and "hook" the different categories into a root category. How can I do this?

The example you posted has only one node LSR_ABT. Do you have other nodes to be combined and used in category_path field? If not you can directly use division as category_path field value and that will be considered as a path with single level.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
The example you posted has only one node LSR_ABT. Do you have other nodes to be combined and used in category_path field? If not you can directly use division as category_path field value and that will be considered as a path with single level.

No, unfortunately I don't have any other nodes I could draw values from. The XML file has no hierarchy built in.

That is the follow up question, and it's theoretically at the moment (because I still struggle with the very basic import process). Here's my goal:

  • I import all the categories from the XML
  • at this moment they are all "flat", so no hierarchy.
  • I'm attach all contacts to the system via import at a second run from the same file.
  • My client creates the hierarchy in the backend by nesting the categories in the way the company is structured

So far, so good.
But this import process needs to be done regularily. Is it possible to make an import, correct contact data and category names, but keep the hierarchy / nesting?
I guess that will be quite tricky.

Thanks!
Chris
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Chris,
But this import process needs to be done regularily. Is it possible to make an import, correct contact data and category names, but keep the hierarchy / nesting?
I guess that will be quite tricky.

Yes that is really tricky. Unless there is nested category in category_path or category ID RO CSVI will not know which category row to update. It would think the category in the import file does not exists in database and creates a new row. One thing you can do is find and replace the category_path from import file to the created hierarchy / nesting categories using Find and Replace operation in RO CSVI Multi replace plugin. Something like example in the attached screenshot. But you have to do that for all category_path which is little a too much if the categories are more. Otherwise I don't see any other way to achieve what you need.
Attachments (1)
  1. 2 weeks ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Yes that is really tricky. Unless there is nested category in category_path or category ID RO CSVI will not know which category row to update.


I understand. Completly.
Thanks for your contribution.
Maybe there is a way to use the category ids which Joomla will create with the initial import?
I'll put the question aside for the moment and think about it after the initial import of categories and contacts. There are still a lot of steps to take to this goal.
Can I bring up the thread when I'm ready?
  1. 2 weeks ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Can I bring up the thread when I'm ready?

Sure you can post your questions on the same thread when you are done with initial import.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!