Resolved xlm extra

Hello,

If you want to know which path to use form an XML file, you can load the XML file in the Analyzer in CSVI. The Analyzer will tell you which paths that are there. So you can see the exact path you need to use.

When you have multiple nodes with exactly the same name, you will have to skip them. So all nodes must be added to your template of which the first two are of the type skip and the third one would be the category_path field. I believe that should work.

You must add the fields in the order of skip, skip, category_path because otherwise CSVI doesn't know what goes where.

This solution I had thought. but the number of the same node is not always equal. Is it possible to SubjectSchemeIdentifier> 32 </ SubjectSchemeIdentifier>, then <Subject Code>. The number 32 refers to the correct node.

<Subject><MainSubject/><SubjectSchemeIdentifier>32</SubjectSchemeIdentifier><SubjectCode>[category_id]</SubjectCode></Subject>

is somthing like this posibel

Hello,
To get the value of circled node in your screenshot, you need to use path as DescriptiveDetail / Subject / Main Subject/ Subject code in your field. As Roland said you can run your file using CSVI Analyser to get the exact node path and use it in your field in your template fields.

I do have the correct code, but there are several with the same code. The most unpleasant it changes the number of the same code. sometimes 3 or 5.
DescriptiveDetail / Subject / Subject code is the code
[SubjectSchemeIdentifier> 32 <make the difference

Hello,

That the number of nodes is not the same is a real problem because CSVI doesn't know either which node is the last one or not. Your question if it is possible to use the other node with value 32 as identifier is not possible either because nodes are processed independently of each other.

Here is what I am thinking you could do. You combine all the Subject Code fields into 1 field and as combine character you use a dash. This would give you a result like HEA0300-YAN500-450. Now you know that the last value is your category_path. With a regular expression you take out the 450. The expression to use is

.(?=[^-]*$)

. The result will give you -450. With a third replacement rule you remove the -. Leaving you with 450. Now I won't say that this is the solution but it is something you could try.

If that doesn't work, the only other solution I can see is that you need to build a custom rule that will deal with getting the correct category_path value. This will require custom coding it.

We are almost there. I think I'm doing something wrong. Would you look for me.
Step one is working. Step two see pictures

Hello,
In your Rules settings you need to use the regular expression .(?=[^-]*$) in Find field so CSVI will find for matching values. Leave replace field empty and save the rule. Run your import and see if it works.

Php 7 ?? It stil not working.

Hello,
It looks like the entire category_path value is replaced. Put the modified regular expression /.(?![^-]*$)/ in your rules and try import again.

:laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh: :laugh:

[size=20]IT WORKS[/size]

Hello,
Glad to know that it is working and your issues are solved. Would appreciate if you can give us a review on Joomla extension directory.

A very powerful tool for importing and exporting CSV files and xlm. Many possibilities. Actually, you can do anything you want. The helpdesk is sublime. On my website I have 150K of files imported without one error. It just needs some attention, but then you have something. Recommended!

Thank you

Even in het Nederlands ,

Is het mogelijk om voor mij een aanpassing te maken zodat ik het onxi (xml) bestand kan inlezen zonder veel hoofdpijn.
Regelmatig voegen ze er regels aan toe en dan klopt mijn schema niet meer. Ik wil graag een fijnere selectie kunnen maken in het xlm bestand
zoals
Veldnaam Product_sku = ProductIdentifier/ ProductIDType>=03/IDValue
Veldnaam Product_name = DescriptiveDetail/TitleDetail/TitleElement/<TitleElementLevel>02/TitleText
Veldnaam Cattegorie = DescriptiveDetail/Subject/<SubjectSchemeIdentifier>32SubjectCode
En zo verder

Ik ben mij er van bewust dat het een beetje rommelig aandoet.

Wel wat gevonden op internet "Lastly we find the bit in the ONIX tagged up as “ProductIdentifier[ProductIDType = ’03’]/IDValue” and set that as the variable called “isbn”. That last one is a bit complicated but if I show you the ONIX, it’ll make more sense."

"There’s two ProductIdentifier tags here. Oh no – which IDValue should we select? Ah, it’s the one with ProductIDType 03. (A lot of learning programming is about getting familiar with the syntax – the particular way that the programming language is laid out. Here, we’re using square brackets to nest ProductIDType after ProductIdentifier. Don’t fret about learning syntax– that’s the easy bit. Understanding the actual logic is the thing to really master. It’s why kids’ learn-to-code tools such as Scratch are so great – they teach the principles and the logic, not one language’s particular way of writing them.)"

Hello,
Has been answered in this thread.