Title: nested xml fields Last modified: November 30, 2016 --- # nested xml fields * Resolved [taro0904](https://wordpress.org/support/users/taro0904/) * (@taro0904) * [9 years, 4 months ago](https://wordpress.org/support/topic/nested-xml-fields/) * How can I output the nested field in the middle of the text…? : * My xml file looks like this: ****text bla bla bla bla bla ****Langboot****. more bla bla bla **** * [FOREACH({verlauf[1]/reisetag})] {inhalt[1] } [ENDFOREACH] * Thank you in advance Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/) * (@wpallimport) * [9 years, 4 months ago](https://wordpress.org/support/topic/nested-xml-fields/#post-8510081) * Hi [@taro0904](https://wordpress.org/support/users/taro0904/) * The only way this would be possible is by using our API to create your own XPath element. Here’s an example snippet for this: * ``` add_filter( 'wpallimport_xml_row', 'wpai_wpallimport_xml_row', 10, 1 ); function wpai_wpallimport_xml_row( $node ){ $elements = $node->xpath( '//reisetag[1]' ); if ( !empty( $elements[ 0 ] ) ) $node->addChild( 'alltext', $elements[ 0 ]->asXML() ); return $node; } ``` * Once you’ve added that, you can then use the following element to return ‘text bla bla bla bla bla Langboot. more bla bla bla’: * `{alltext[1]}` * Thread Starter [taro0904](https://wordpress.org/support/users/taro0904/) * (@taro0904) * [9 years, 4 months ago](https://wordpress.org/support/topic/nested-xml-fields/#post-8514923) * Thank you for your answer, but therre are some mor questions… * Ive copied the snipped in my functions.php. Do I have to add or change anything else in the snipped ? The root is much longer than in my example.. {data[1]/ journeys[1]/journey[1]/description[1]/reise[1]/verlauf[1]/reisetag[1]/inhalt[ 1]} * An how should I create the output ? Ive tried several variations like this, but nothing is working… * ``` [FOREACH({data[1]/journeys[1]/journey[1]/description[1]/reise[1]/verlauf[1]/reisetag})] [wpai_wpallimport_xml_row({inhalt[1]},{inhalt[1]/auszeichnung},{alltext[1]})] [ENDFOREACH] ``` * Best regards taro * Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/) * (@wpallimport) * [9 years, 4 months ago](https://wordpress.org/support/topic/nested-xml-fields/#post-8521801) * Hi [@taro0904](https://wordpress.org/support/users/taro0904/) * You would need to adjust our example snippet to run the correct XPath query for this. The $node variable in our code is a SimpleXMLElement resource, you can read more about that here: [http://php.net/manual/en/class.simplexmlelement.php](http://php.net/manual/en/class.simplexmlelement.php) * Thread Starter [taro0904](https://wordpress.org/support/users/taro0904/) * (@taro0904) * [9 years, 3 months ago](https://wordpress.org/support/topic/nested-xml-fields/#post-8557654) * Sorry, but I still have problems.. * Because its an attribute which has to be added as a child, maybe there exists a function to add attributes in a foreach loop?? Would it be different with atributes? * ``` ... The sun is very hot in the summer ... ``` * Output should be: “The sun is very hot in the summer” * The whole xpath… {stml_data[1]/srml_journeys[1]/srml_journey[1]/srml_description[ 1]/reise[1]/verlauf[1]/reisetag[5]/inhalt[1]/auszeichnung[1]} * And…Because I have some more field in my FOREACH loop how do I have to write the template? * ``` [FOREACH({data[1]/journeys[1]/journey[1]/description[1]/reise[1]/verlauf[1]/reisetag })] {@order}. Day:{titel[1]} [wpai_wpallimport_xml_row({alltext[1]})] {meals[1]} [ENDFOREACH] ``` * Plugin Author [WP All Import](https://wordpress.org/support/users/wpallimport/) * (@wpallimport) * [9 years, 2 months ago](https://wordpress.org/support/topic/nested-xml-fields/#post-8716386) * Hi [@taro0904](https://wordpress.org/support/users/taro0904/) * Very sorry for the delay on this. * The code we provided before would need to be adjusted to achieve the results in your explanation. Accessing individual elements and attributes can all be done with SimpleXML: [http://php.net/manual/en/class.simplexmlelement.php](http://php.net/manual/en/class.simplexmlelement.php). Unfortunately, we don’t have any example snippets for this particular use case. * Keep in mind also that our code creates a single element that you can use in the import template: {alltext}. The FOREACH loop could be used on this element to get all of the results. * So, for example, if you had a file in this format – [https://paste.ee/p/J30O2](https://paste.ee/p/J30O2)– and you were importing the “node” element, you could re-write the function like so: * ``` add_filter( 'wpallimport_xml_row', 'wpai_wpallimport_xml_row', 10, 1 ); function wpai_wpallimport_xml_row( $node ){ $elements = $node->xpath( '//data/journeys/journey/description/reise/verlauf/reisetag' ); if ( !empty( $elements ) ) { foreach ( $elements as $element ) { $node->addChild('alltext', $element->asXML() ); } } return $node; } ``` * And, you could out put both “The sun is very hot in the summer” and “The snow is very cold in the winter” with: * ``` [FOREACH({alltext})] {.} [ENDFOREACH] ``` * Or, you could access each one individually with {alltext[1]} and {alltext[2]}. - This reply was modified 9 years, 2 months ago by [WP All Import](https://wordpress.org/support/users/wpallimport/). Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘nested xml fields’ is closed to new replies. * ![](https://ps.w.org/wp-all-import/assets/icon-256x256.png?rev=2570179) * [WP All Import – Drag & Drop Import for CSV, XML, Excel & Google Sheets](https://wordpress.org/plugins/wp-all-import/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-all-import/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-all-import/) * [Active Topics](https://wordpress.org/support/plugin/wp-all-import/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-all-import/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-all-import/reviews/) * 5 replies * 2 participants * Last reply from: [WP All Import](https://wordpress.org/support/users/wpallimport/) * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/nested-xml-fields/#post-8716386) * Status: resolved