[TASK] Add functional tests for impexp irre records 93/27993/3
authorMarc Bastian Heinrichs <typo3@mbh-software.de>
Fri, 28 Feb 2014 17:56:33 +0000 (18:56 +0100)
committerChristian Kuhn <lolli@schwarzbu.ch>
Wed, 5 Mar 2014 21:50:46 +0000 (22:50 +0100)
This patch adds functional tests for exporting and
importing all irre_tutorial relation types.

Resolves: #56287
Releases: 6.2
Change-Id: I9fe650151cca11e1f7fcb0d4b1d3ebdbbc0b75ad
Reviewed-on: https://review.typo3.org/27993
Reviewed-by: Anja Leichsenring
Tested-by: Anja Leichsenring
Reviewed-by: Christian Kuhn
Tested-by: Christian Kuhn
typo3/sysext/impexp/Tests/Functional/Export/AbstractExportTestCase.php
typo3/sysext/impexp/Tests/Functional/Export/IrreTutorialRecords/ExportTest.php [new file with mode: 0644]
typo3/sysext/impexp/Tests/Functional/Fixtures/Database/irre_tutorial.xml [new file with mode: 0644]
typo3/sysext/impexp/Tests/Functional/Fixtures/ImportExport/irre-records.xml [new file with mode: 0644]
typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/DataSet/Assertion/importIrreRecords.csv [new file with mode: 0644]
typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/ImportInEmptyDatabaseTest.php [new file with mode: 0644]

index 79e59b2..4fd9d61 100644 (file)
@@ -25,6 +25,7 @@ namespace TYPO3\CMS\Impexp\Tests\Functional\Export;
  ***************************************************************/
 
 use TYPO3\CMS\Core\Utility\GeneralUtility;
+use TYPO3\CMS\Backend\Utility\BackendUtility;
 
 /**
  * Functional test for the ImportExport
@@ -86,4 +87,32 @@ abstract class AbstractExportTestCase extends \TYPO3\CMS\Core\Tests\FunctionalTe
 
                $this->export->setPageTree($idH);
        }
+
+       /**
+        * Adds records to the export object for a specific page id.
+        *
+        * @param int $pid Page id for which to select records to add
+        * @param array $tables Array of table names to select from
+        * @return void
+        */
+       protected function addRecordsForPid($pid, array $tables) {
+               foreach ($GLOBALS['TCA'] as $table => $value) {
+                       if ($table != 'pages' && (in_array($table, $tables) || in_array('_ALL', $tables))) {
+                               if ($GLOBALS['BE_USER']->check('tables_select', $table) && !$GLOBALS['TCA'][$table]['ctrl']['is_static']) {
+                                       $orderBy = $GLOBALS['TCA'][$table]['ctrl']['sortby'] ? 'ORDER BY ' . $GLOBALS['TCA'][$table]['ctrl']['sortby'] : $GLOBALS['TCA'][$table]['ctrl']['default_sortby'];
+                                       $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
+                                               '*',
+                                               $table,
+                                                       'pid = ' . (int)$pid . BackendUtility::deleteClause($table),
+                                               '',
+                                               $GLOBALS['TYPO3_DB']->stripOrderBy($orderBy)
+                                       );
+                                       while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
+                                               $this->export->export_addRecord($table, $row);
+                                       }
+                               }
+                       }
+               }
+       }
+
 }
\ No newline at end of file
diff --git a/typo3/sysext/impexp/Tests/Functional/Export/IrreTutorialRecords/ExportTest.php b/typo3/sysext/impexp/Tests/Functional/Export/IrreTutorialRecords/ExportTest.php
new file mode 100644 (file)
index 0000000..007efaf
--- /dev/null
@@ -0,0 +1,311 @@
+<?php
+namespace TYPO3\CMS\Impexp\Tests\Functional\Export\IrreTutorialRecords;
+
+/***************************************************************
+ * Copyright notice
+ *
+ * (c) 2014 Marc Bastian Heinrichs <typo3@mbh-software.de>
+ * All rights reserved
+ *
+ * This script is part of the TYPO3 project. The TYPO3 project is
+ * free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * The GNU General Public License can be found at
+ * http://www.gnu.org/copyleft/gpl.html.
+ *
+ * This script is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * This copyright notice MUST APPEAR in all copies of the script!
+ ***************************************************************/
+
+use TYPO3\CMS\Backend\Utility\BackendUtility;
+
+require_once __DIR__ . '/../AbstractExportTestCase.php';
+
+/**
+ * Functional test for the ImportExport
+ */
+class ExportTest extends \TYPO3\CMS\Impexp\Tests\Functional\Export\AbstractExportTestCase {
+
+       /**
+        * @var array
+        */
+       protected $testExtensionsToLoad = array(
+               'typo3/sysext/core/Tests/Functional/Fixtures/Extensions/irre_tutorial',
+       );
+
+       public function setUp() {
+               parent::setUp();
+
+               $this->importDataSet(__DIR__ . '/../../Fixtures/Database/irre_tutorial.xml');
+       }
+
+       /**
+        * @test
+        */
+       public function exportIrreRecords() {
+
+               $recordTypesIncludeFields = array(
+                       'pages' => array(
+                               'title',
+                               'deleted',
+                               'doktype',
+                               'hidden',
+                               'perms_everybody'
+                       ),
+                       'tt_content' => array(
+                               'CType',
+                               'header',
+                               'deleted',
+                               'hidden',
+                               't3ver_oid',
+                               'tx_irretutorial_1nff_hotels',
+                               'tx_irretutorial_1ncsv_hotels'
+                       ),
+                       'tx_irretutorial_1ncsv_hotel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'offers',
+                       ),
+                       'tx_irretutorial_1ncsv_offer' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'prices',
+                       ),
+                       'tx_irretutorial_1ncsv_price' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'price',
+                       ),
+                       'tx_irretutorial_1nff_hotel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'parentid',
+                               'parenttable',
+                               'parentidentifier',
+                               'title',
+                               'offers',
+                       ),
+                       'tx_irretutorial_1nff_offer' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'parentid',
+                               'parenttable',
+                               'parentidentifier',
+                               'title',
+                               'prices',
+                       ),
+                       'tx_irretutorial_1nff_price' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'parentid',
+                               'parenttable',
+                               'parentidentifier',
+                               'title',
+                               'price',
+                       ),
+                       'tx_irretutorial_mnasym_hotel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'offers',
+                       ),
+                       'tx_irretutorial_mnasym_hotel_offer_rel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'deleted',
+                               'hidden',
+                               'hotelid',
+                               'offerid',
+                               'hotelsort',
+                               'offersort',
+                               'prices',
+                       ),
+                       'tx_irretutorial_mnasym_offer' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'hotels',
+                       ),
+                       'tx_irretutorial_mnasym_price' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'parentid',
+                               'title',
+                               'price',
+                       ),
+                       'tx_irretutorial_mnattr_hotel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'offers',
+                       ),
+                       'tx_irretutorial_mnattr_hotel_offer_rel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'deleted',
+                               'hidden',
+                               'hotelid',
+                               'offerid',
+                               'hotelsort',
+                               'offersort',
+                               'quality',
+                               'allincl',
+                       ),
+                       'tx_irretutorial_mnattr_offer' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'hotels',
+                       ),
+                       'tx_irretutorial_mnmmasym_hotel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'offers',
+                       ),
+                       'tx_irretutorial_mnmmasym_hotel_offer_rel' => array(
+                               'uid_local',
+                               'uid_foreign',
+                               'tablenames',
+                               'sorting',
+                               'sorting_foreign',
+                               'ident',
+                       ),
+                       'tx_irretutorial_mnmmasym_offer' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'hotels',
+                               'prices',
+                       ),
+                       'tx_irretutorial_mnmmasym_offer_price_rel' => array(
+                               'uid_local',
+                               'uid_foreign',
+                               'tablenames',
+                               'sorting',
+                               'sorting_foreign',
+                               'ident',
+                       ),
+                       'tx_irretutorial_mnmmasym_price' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'price',
+                               'offers',
+                       ),
+                       'tx_irretutorial_mnsym_hotel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'sorting',
+                               'deleted',
+                               'hidden',
+                               'title',
+                               'branches',
+                       ),
+                       'tx_irretutorial_mnsym_hotel_rel' => array(
+                               'cruser_id',
+                               'sys_language_uid',
+                               'l18n_parent',
+                               'deleted',
+                               'hidden',
+                               'hotelid',
+                               'branchid',
+                               'hotelsort',
+                               'branchsort',
+                       )
+
+               );
+
+               $this->export->setRecordTypesIncludeFields($recordTypesIncludeFields);
+
+               $this->export->export_addRecord('pages', BackendUtility::getRecord('pages', 1));
+               $this->addRecordsForPid(1, array_keys($recordTypesIncludeFields));
+
+               $this->setPageTree(1);
+
+               // After adding ALL records we set relations:
+               for ($a = 0; $a < 10; $a++) {
+                       $addR = $this->export->export_addDBRelations($a);
+                       if (!count($addR)) {
+                               break;
+                       }
+               }
+
+               $this->export->export_addFilesFromRelations();
+               $this->export->export_addFilesFromSysFilesRecords();
+
+               $out = $this->export->compileMemoryToFileContent('xml');
+
+               $this->assertXmlStringEqualsXmlFile(__DIR__ . '/../../Fixtures/ImportExport/irre-records.xml', $out);
+       }
+
+}
\ No newline at end of file
diff --git a/typo3/sysext/impexp/Tests/Functional/Fixtures/Database/irre_tutorial.xml b/typo3/sysext/impexp/Tests/Functional/Fixtures/Database/irre_tutorial.xml
new file mode 100644 (file)
index 0000000..8c8f020
--- /dev/null
@@ -0,0 +1,651 @@
+<?xml version="1.0" encoding="utf-8"?>
+<dataset>
+       <pages>
+               <uid>1</uid>
+               <pid>0</pid>
+               <title>IRRE</title>
+               <doktype>1</doktype>
+               <deleted>0</deleted>
+               <perms_everybody>15</perms_everybody>
+       </pages>
+       <tt_content>
+               <uid>1</uid>
+               <pid>1</pid>
+               <CType>text</CType>
+               <header>Test content</header>
+               <deleted>0</deleted>
+               <t3ver_oid>0</t3ver_oid>
+               <t3ver_wsid>0</t3ver_wsid>
+               <tx_irretutorial_1nff_hotels>2</tx_irretutorial_1nff_hotels>
+               <tx_irretutorial_1ncsv_hotels>1,2</tx_irretutorial_1ncsv_hotels>
+               <tx_irretutorial_flexform><![CDATA[<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
+<T3FlexForms>
+    <data>
+        <sheet index="sDEF">
+            <language index="lDEF">
+                <field index="hotels">
+                    <value index="vDEF">0</value>
+                </field>
+            </language>
+        </sheet>
+    </data>
+</T3FlexForms>]]></tx_irretutorial_flexform>
+       </tt_content>
+       <tx_irretutorial_1ncsv_hotel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 1 (csv)</title>
+               <offers>1,2</offers>
+       </tx_irretutorial_1ncsv_hotel>
+       <tx_irretutorial_1ncsv_hotel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 2 (csv)</title>
+               <offers>3</offers>
+       </tx_irretutorial_1ncsv_hotel>
+       <tx_irretutorial_1ncsv_offer>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 1.1 (csv)</title>
+               <prices>1</prices>
+       </tx_irretutorial_1ncsv_offer>
+       <tx_irretutorial_1ncsv_offer>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 1.2 (csv)</title>
+               <prices>2</prices>
+       </tx_irretutorial_1ncsv_offer>
+       <tx_irretutorial_1ncsv_offer>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>64</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 2.2 (csv)</title>
+               <prices>3</prices>
+       </tx_irretutorial_1ncsv_offer>
+       <tx_irretutorial_1ncsv_price>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Price 1.1.1 (csv)</title>
+               <price>567.00</price>
+       </tx_irretutorial_1ncsv_price>
+       <tx_irretutorial_1ncsv_price>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Price 1.2.1 (csv)</title>
+               <price>90.00</price>
+       </tx_irretutorial_1ncsv_price>
+       <tx_irretutorial_1ncsv_price>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>64</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Price 2.2.1 (csv)</title>
+               <price>112.00</price>
+       </tx_irretutorial_1ncsv_price>
+       <tx_irretutorial_1nff_hotel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <parenttable>tt_content</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Hotel 1 (nff)</title>
+               <offers>2</offers>
+       </tx_irretutorial_1nff_hotel>
+       <tx_irretutorial_1nff_hotel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>2</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <parenttable>tt_content</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Hotel 2 (nff)</title>
+               <offers>1</offers>
+       </tx_irretutorial_1nff_hotel>
+       <tx_irretutorial_1nff_offer>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <parenttable>tx_irretutorial_1nff_hotel</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Offer 1.1 (nff)</title>
+               <prices>2</prices>
+       </tx_irretutorial_1nff_offer>
+       <tx_irretutorial_1nff_offer>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>2</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <parenttable>tx_irretutorial_1nff_hotel</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Offer 1.2 (nff)</title>
+               <prices>1</prices>
+       </tx_irretutorial_1nff_offer>
+       <tx_irretutorial_1nff_offer>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>2</parentid>
+               <parenttable>tx_irretutorial_1nff_hotel</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Offer 2.1 (nff)</title>
+               <prices>1</prices>
+       </tx_irretutorial_1nff_offer>
+       <tx_irretutorial_1nff_price>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <parenttable>tx_irretutorial_1nff_offer</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Price 1.1.1 (nff)</title>
+               <price>4.00</price>
+       </tx_irretutorial_1nff_price>
+       <tx_irretutorial_1nff_price>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>2</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <parenttable>tx_irretutorial_1nff_offer</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Price 1.1.2 (nff)</title>
+               <price>869.00</price>
+       </tx_irretutorial_1nff_price>
+       <tx_irretutorial_1nff_price>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>2</parentid>
+               <parenttable>tx_irretutorial_1nff_offer</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Price 1.2.1 (nff)</title>
+               <price>678.00</price>
+       </tx_irretutorial_1nff_price>
+       <tx_irretutorial_1nff_price>
+               <uid>4</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>3</parentid>
+               <parenttable>tx_irretutorial_1nff_offer</parenttable>
+               <parentidentifier></parentidentifier>
+               <title>Price 2.1.1 (nff)</title>
+               <price>5467567.00</price>
+       </tx_irretutorial_1nff_price>
+       <tx_irretutorial_mnasym_hotel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 1 (m:n ASym)</title>
+               <offers>2</offers>
+       </tx_irretutorial_mnasym_hotel>
+       <tx_irretutorial_mnasym_hotel_offer_rel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <hotelid>1</hotelid>
+               <offerid>2</offerid>
+               <hotelsort>2</hotelsort>
+               <offersort>1</offersort>
+               <prices>1</prices>
+       </tx_irretutorial_mnasym_hotel_offer_rel>
+       <tx_irretutorial_mnasym_hotel_offer_rel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <hotelid>1</hotelid>
+               <offerid>1</offerid>
+               <hotelsort>1</hotelsort>
+               <offersort>1</offersort>
+               <prices>1</prices>
+       </tx_irretutorial_mnasym_hotel_offer_rel>
+       <tx_irretutorial_mnasym_offer>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 1 (m:n ASym)</title>
+               <hotels>1</hotels>
+       </tx_irretutorial_mnasym_offer>
+       <tx_irretutorial_mnasym_offer>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 2 (m:n ASym)</title>
+               <hotels>1</hotels>
+       </tx_irretutorial_mnasym_offer>
+       <tx_irretutorial_mnasym_price>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>1</parentid>
+               <title>Price 1 1:2 (m:n ASym)</title>
+               <price>678.00</price>
+       </tx_irretutorial_mnasym_price>
+       <tx_irretutorial_mnasym_price>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>1</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <parentid>2</parentid>
+               <title>Price 2 1:1 (m:n ASym)</title>
+               <price>45.00</price>
+       </tx_irretutorial_mnasym_price>
+       <tx_irretutorial_mnattr_hotel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 1 (m:n Attr)</title>
+               <offers>1</offers>
+       </tx_irretutorial_mnattr_hotel>
+       <tx_irretutorial_mnattr_hotel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>512</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 2 (m:n Attr)</title>
+               <offers>1</offers>
+       </tx_irretutorial_mnattr_hotel>
+       <tx_irretutorial_mnattr_hotel_offer_rel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <hotelid>1</hotelid>
+               <offerid>1</offerid>
+               <hotelsort>1</hotelsort>
+               <offersort>0</offersort>
+               <quality>2</quality>
+               <allincl>1</allincl>
+       </tx_irretutorial_mnattr_hotel_offer_rel>
+       <tx_irretutorial_mnattr_hotel_offer_rel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <hotelid>2</hotelid>
+               <offerid>2</offerid>
+               <hotelsort>1</hotelsort>
+               <offersort>0</offersort>
+               <quality>4</quality>
+               <allincl>0</allincl>
+       </tx_irretutorial_mnattr_hotel_offer_rel>
+       <tx_irretutorial_mnattr_offer>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 1 (m:n Attr)</title>
+               <hotels>0</hotels>
+       </tx_irretutorial_mnattr_offer>
+       <tx_irretutorial_mnattr_offer>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>512</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 2 (m:n Attr)</title>
+               <hotels>0</hotels>
+       </tx_irretutorial_mnattr_offer>
+       <tx_irretutorial_mnmmasym_hotel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 1 (m:n (MM) ASym)</title>
+               <offers>2</offers>
+       </tx_irretutorial_mnmmasym_hotel>
+       <tx_irretutorial_mnmmasym_hotel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>512</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 2 (m:n (MM) ASym)</title>
+               <offers>1</offers>
+       </tx_irretutorial_mnmmasym_hotel>
+       <tx_irretutorial_mnmmasym_hotel_offer_rel>
+               <uid>1</uid>
+               <uid_local>1</uid_local>
+               <uid_foreign>1</uid_foreign>
+               <tablenames></tablenames>
+               <sorting>1</sorting>
+               <sorting_foreign>0</sorting_foreign>
+               <ident></ident>
+       </tx_irretutorial_mnmmasym_hotel_offer_rel>
+       <tx_irretutorial_mnmmasym_hotel_offer_rel>
+               <uid>2</uid>
+               <uid_local>1</uid_local>
+               <uid_foreign>2</uid_foreign>
+               <tablenames></tablenames>
+               <sorting>2</sorting>
+               <sorting_foreign>0</sorting_foreign>
+               <ident></ident>
+       </tx_irretutorial_mnmmasym_hotel_offer_rel>
+       <tx_irretutorial_mnmmasym_hotel_offer_rel>
+               <uid>3</uid>
+               <uid_local>2</uid_local>
+               <uid_foreign>3</uid_foreign>
+               <tablenames></tablenames>
+               <sorting>1</sorting>
+               <sorting_foreign>0</sorting_foreign>
+               <ident></ident>
+       </tx_irretutorial_mnmmasym_hotel_offer_rel>
+       <tx_irretutorial_mnmmasym_offer>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 1.1 (m:n (MM) ASym)</title>
+               <hotels>0</hotels>
+               <prices>1</prices>
+       </tx_irretutorial_mnmmasym_offer>
+       <tx_irretutorial_mnmmasym_offer>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 1.2 (m:n (MM) ASym)</title>
+               <hotels>0</hotels>
+               <prices>1</prices>
+       </tx_irretutorial_mnmmasym_offer>
+       <tx_irretutorial_mnmmasym_offer>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>64</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Offer 2.1 (m:n (MM) ASym)</title>
+               <hotels>0</hotels>
+               <prices>1</prices>
+       </tx_irretutorial_mnmmasym_offer>
+       <tx_irretutorial_mnmmasym_offer_price_rel>
+               <uid>1</uid>
+               <uid_local>1</uid_local>
+               <uid_foreign>1</uid_foreign>
+               <tablenames></tablenames>
+               <sorting>1</sorting>
+               <sorting_foreign>0</sorting_foreign>
+               <ident></ident>
+       </tx_irretutorial_mnmmasym_offer_price_rel>
+       <tx_irretutorial_mnmmasym_offer_price_rel>
+               <uid>2</uid>
+               <uid_local>2</uid_local>
+               <uid_foreign>2</uid_foreign>
+               <tablenames></tablenames>
+               <sorting>1</sorting>
+               <sorting_foreign>0</sorting_foreign>
+               <ident></ident>
+       </tx_irretutorial_mnmmasym_offer_price_rel>
+       <tx_irretutorial_mnmmasym_offer_price_rel>
+               <uid>3</uid>
+               <uid_local>3</uid_local>
+               <uid_foreign>3</uid_foreign>
+               <tablenames></tablenames>
+               <sorting>1</sorting>
+               <sorting_foreign>0</sorting_foreign>
+               <ident></ident>
+       </tx_irretutorial_mnmmasym_offer_price_rel>
+       <tx_irretutorial_mnmmasym_price>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Price 1.1.1 (m:n (MM) ASym)</title>
+               <price>567.00</price>
+               <offers>0</offers>
+       </tx_irretutorial_mnmmasym_price>
+       <tx_irretutorial_mnmmasym_price>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Price 1.2.2 (m:n (MM) ASym)</title>
+               <price>567.00</price>
+               <offers>0</offers>
+       </tx_irretutorial_mnmmasym_price>
+       <tx_irretutorial_mnmmasym_price>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>64</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Price (m:n (MM) ASym)</title>
+               <price>223.00</price>
+               <offers>0</offers>
+       </tx_irretutorial_mnmmasym_price>
+       <tx_irretutorial_mnsym_hotel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>256</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel 1 (mm sym)</title>
+               <branches>2</branches>
+       </tx_irretutorial_mnsym_hotel>
+       <tx_irretutorial_mnsym_hotel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>128</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel Branch 1.1 (mm sym)</title>
+               <branches>1</branches>
+       </tx_irretutorial_mnsym_hotel>
+       <tx_irretutorial_mnsym_hotel>
+               <uid>3</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <sorting>192</sorting>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <title>Hotel branch 1.2 (mm sym)</title>
+               <branches>0</branches>
+       </tx_irretutorial_mnsym_hotel>
+       <tx_irretutorial_mnsym_hotel_rel>
+               <uid>1</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <hotelid>1</hotelid>
+               <branchid>2</branchid>
+               <hotelsort>1</hotelsort>
+               <branchsort>1</branchsort>
+       </tx_irretutorial_mnsym_hotel_rel>
+       <tx_irretutorial_mnsym_hotel_rel>
+               <uid>2</uid>
+               <pid>1</pid>
+               <cruser_id>1</cruser_id>
+               <sys_language_uid>0</sys_language_uid>
+               <l18n_parent>0</l18n_parent>
+               <deleted>0</deleted>
+               <hidden>0</hidden>
+               <hotelid>1</hotelid>
+               <branchid>3</branchid>
+               <hotelsort>2</hotelsort>
+               <branchsort>0</branchsort>
+       </tx_irretutorial_mnsym_hotel_rel>
+</dataset>
\ No newline at end of file
diff --git a/typo3/sysext/impexp/Tests/Functional/Fixtures/ImportExport/irre-records.xml b/typo3/sysext/impexp/Tests/Functional/Fixtures/ImportExport/irre-records.xml
new file mode 100644 (file)
index 0000000..1e64f04
--- /dev/null
@@ -0,0 +1,1955 @@
+<?xml version="1.0" encoding="utf-8" standalone="yes" ?>
+<T3RecordDocument>
+       <header type="array">
+               <records type="array">
+                       <table index="pages" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>0</pid>
+                                       <title>IRRE</title>
+                                       <size>162</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tt_content" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Test content</title>
+                                       <size>254</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1nff_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1nff_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_1nff_hotel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1nff_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_1ncsv_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1ncsv_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_1ncsv_hotel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1ncsv_hotel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_1nff_hotel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 1 (nff)</title>
+                                       <size>336</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1nff_offer:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1nff_offer</table>
+                                               </element>
+                                               <element index="tx_irretutorial_1nff_offer:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1nff_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 2 (nff)</title>
+                                       <size>336</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1nff_offer:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1nff_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_1nff_offer" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1.1 (nff)</title>
+                                       <size>354</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1nff_price:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                               <element index="tx_irretutorial_1nff_price:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 2.1 (nff)</title>
+                                       <size>354</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1nff_price:4" type="array">
+                                                       <id>4</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1.2 (nff)</title>
+                                       <size>354</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1nff_price:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_1nff_price" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.1.1 (nff)</title>
+                                       <size>358</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.2.1 (nff)</title>
+                                       <size>360</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="4" type="array">
+                                       <uid>4</uid>
+                                       <pid>1</pid>
+                                       <title>Price 2.1.1 (nff)</title>
+                                       <size>365</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.1.2 (nff)</title>
+                                       <size>360</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnasym_hotel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 1 (m:n ASym)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnasym_hotel_offer_rel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnasym_hotel_offer_rel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnasym_hotel_offer_rel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>1</title>
+                                       <size>282</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnasym_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnasym_offer:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_offer</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnasym_price:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>2</title>
+                                       <size>282</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnasym_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnasym_offer:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_offer</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnasym_price:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnasym_offer" type="array">
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 2 (m:n ASym)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnasym_hotel_offer_rel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1 (m:n ASym)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnasym_hotel_offer_rel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnasym_price" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1 1:2 (m:n ASym)</title>
+                                       <size>281</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Price 2 1:1 (m:n ASym)</title>
+                                       <size>280</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnmmasym_hotel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 1 (m:n (MM) ASym)</title>
+                                       <size>257</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnmmasym_offer:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnmmasym_offer</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnmmasym_offer:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnmmasym_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 2 (m:n (MM) ASym)</title>
+                                       <size>257</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnmmasym_offer:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_mnmmasym_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnmmasym_offer" type="array">
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 2.1 (m:n (MM) ASym)</title>
+                                       <size>279</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnmmasym_price:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_mnmmasym_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1.2 (m:n (MM) ASym)</title>
+                                       <size>280</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnmmasym_price:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnmmasym_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1.1 (m:n (MM) ASym)</title>
+                                       <size>280</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnmmasym_price:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnmmasym_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnmmasym_price" type="array">
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Price (m:n (MM) ASym)</title>
+                                       <size>279</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.2.2 (m:n (MM) ASym)</title>
+                                       <size>286</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.1.1 (m:n (MM) ASym)</title>
+                                       <size>286</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnsym_hotel" type="array">
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel Branch 1.1 (mm sym)</title>
+                                       <size>261</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnsym_hotel_rel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel branch 1.2 (mm sym)</title>
+                                       <size>261</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnsym_hotel_rel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 1 (mm sym)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnsym_hotel_rel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnsym_hotel_rel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnsym_hotel_rel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>1</title>
+                                       <size>264</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnsym_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnsym_hotel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>2</title>
+                                       <size>264</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnsym_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnsym_hotel:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnattr_hotel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 1 (m:n Attr)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnattr_hotel_offer_rel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 2 (m:n Attr)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnattr_hotel_offer_rel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnattr_hotel_offer_rel" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>1</title>
+                                       <size>305</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnattr_hotel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnattr_offer:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>2</title>
+                                       <size>305</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnattr_hotel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_hotel</table>
+                                               </element>
+                                               <element index="tx_irretutorial_mnattr_offer:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_mnattr_offer" type="array">
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1 (m:n Attr)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnattr_hotel_offer_rel:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 2 (m:n Attr)</title>
+                                       <size>252</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_mnattr_hotel_offer_rel:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_1ncsv_hotel" type="array">
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 2 (csv)</title>
+                                       <size>247</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1ncsv_offer:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1ncsv_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Hotel 1 (csv)</title>
+                                       <size>249</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1ncsv_offer:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1ncsv_offer</table>
+                                               </element>
+                                               <element index="tx_irretutorial_1ncsv_offer:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1ncsv_offer</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_1ncsv_offer" type="array">
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 2.2 (csv)</title>
+                                       <size>248</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1ncsv_price:3" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1ncsv_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1.2 (csv)</title>
+                                       <size>249</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1ncsv_price:2" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1ncsv_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Offer 1.1 (csv)</title>
+                                       <size>249</size>
+                                       <relations index="rels" type="array">
+                                               <element index="tx_irretutorial_1ncsv_price:1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1ncsv_price</table>
+                                               </element>
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+                       <table index="tx_irretutorial_1ncsv_price" type="array">
+                               <rec index="3" type="array">
+                                       <uid>3</uid>
+                                       <pid>1</pid>
+                                       <title>Price 2.2.1 (csv)</title>
+                                       <size>254</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="2" type="array">
+                                       <uid>2</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.2.1 (csv)</title>
+                                       <size>254</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                               <rec index="1" type="array">
+                                       <uid>1</uid>
+                                       <pid>1</pid>
+                                       <title>Price 1.1.1 (csv)</title>
+                                       <size>255</size>
+                                       <relations index="rels" type="array">
+                                       </relations>
+                                       <softrefs type="array">
+                                       </softrefs>
+                               </rec>
+                       </table>
+               </records>
+               <pid_lookup type="array">
+                       <page_contents index="0" type="array">
+                               <table index="pages" type="array">
+                                       <item index="1">1</item>
+                               </table>
+                       </page_contents>
+                       <page_contents index="1" type="array">
+                               <table index="tt_content" type="array">
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_1nff_hotel" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_1nff_offer" type="array">
+                                       <item index="1">1</item>
+                                       <item index="3">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_1nff_price" type="array">
+                                       <item index="1">1</item>
+                                       <item index="3">1</item>
+                                       <item index="4">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnasym_hotel" type="array">
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnasym_hotel_offer_rel" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnasym_offer" type="array">
+                                       <item index="2">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnasym_price" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnmmasym_hotel" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnmmasym_offer" type="array">
+                                       <item index="3">1</item>
+                                       <item index="2">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnmmasym_price" type="array">
+                                       <item index="3">1</item>
+                                       <item index="2">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnsym_hotel" type="array">
+                                       <item index="2">1</item>
+                                       <item index="3">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnsym_hotel_rel" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnattr_hotel" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnattr_hotel_offer_rel" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_mnattr_offer" type="array">
+                                       <item index="1">1</item>
+                                       <item index="2">1</item>
+                               </table>
+                               <table index="tx_irretutorial_1ncsv_hotel" type="array">
+                                       <item index="2">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_1ncsv_offer" type="array">
+                                       <item index="3">1</item>
+                                       <item index="2">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                               <table index="tx_irretutorial_1ncsv_price" type="array">
+                                       <item index="3">1</item>
+                                       <item index="2">1</item>
+                                       <item index="1">1</item>
+                               </table>
+                       </page_contents>
+               </pid_lookup>
+               <pagetree type="array">
+                       <node index="1" type="array">
+                               <uid>1</uid>
+                       </node>
+               </pagetree>
+       </header>
+       <records type="array">
+               <tablerow index="pages:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">0</field>
+                               <field index="deleted">0</field>
+                               <field index="perms_everybody">15</field>
+                               <field index="hidden">0</field>
+                               <field index="title">IRRE</field>
+                               <field index="doktype">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tt_content:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="t3ver_oid">0</field>
+                               <field index="hidden">0</field>
+                               <field index="CType">text</field>
+                               <field index="header">Test content</field>
+                               <field index="deleted">0</field>
+                               <field index="tx_irretutorial_1nff_hotels">2</field>
+                               <field index="tx_irretutorial_1ncsv_hotels">1,2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="tx_irretutorial_1nff_hotels" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1nff_hotel</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1nff_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="tx_irretutorial_1ncsv_hotels" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1ncsv_hotel</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1ncsv_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_hotel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="parenttable">tt_content</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Hotel 1 (nff)</field>
+                               <field index="offers">2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1nff_offer</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1nff_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_hotel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">2</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="parenttable">tt_content</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Hotel 2 (nff)</field>
+                               <field index="offers">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1nff_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_offer:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="parenttable">tx_irretutorial_1nff_hotel</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Offer 1.1 (nff)</field>
+                               <field index="prices">2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_offer:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">2</field>
+                               <field index="parenttable">tx_irretutorial_1nff_hotel</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Offer 2.1 (nff)</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>4</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_offer:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">2</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="parenttable">tx_irretutorial_1nff_hotel</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Offer 1.2 (nff)</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1nff_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_price:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="parenttable">tx_irretutorial_1nff_offer</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Price 1.1.1 (nff)</field>
+                               <field index="price">4.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_price:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">2</field>
+                               <field index="parenttable">tx_irretutorial_1nff_offer</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Price 1.2.1 (nff)</field>
+                               <field index="price">678.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_price:4" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">4</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">3</field>
+                               <field index="parenttable">tx_irretutorial_1nff_offer</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Price 2.1.1 (nff)</field>
+                               <field index="price">5467567.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1nff_price:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">2</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="parenttable">tx_irretutorial_1nff_offer</field>
+                               <field index="parentidentifier"></field>
+                               <field index="title">Price 1.1.2 (nff)</field>
+                               <field index="price">869.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_hotel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 1 (m:n ASym)</field>
+                               <field index="offers">2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_hotel_offer_rel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="hotelid">1</field>
+                               <field index="offerid">2</field>
+                               <field index="hotelsort">2</field>
+                               <field index="offersort">1</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotelid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="offerid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_hotel_offer_rel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="hotelid">1</field>
+                               <field index="offerid">1</field>
+                               <field index="hotelsort">1</field>
+                               <field index="offersort">1</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotelid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="offerid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_offer:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 2 (m:n ASym)</field>
+                               <field index="hotels">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotels" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_offer:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 1 (m:n ASym)</field>
+                               <field index="hotels">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotels" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnasym_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_price:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">1</field>
+                               <field index="title">Price 1 1:2 (m:n ASym)</field>
+                               <field index="price">678.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnasym_price:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">1</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="parentid">2</field>
+                               <field index="title">Price 2 1:1 (m:n ASym)</field>
+                               <field index="price">45.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_hotel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 1 (m:n (MM) ASym)</field>
+                               <field index="offers">2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnmmasym_offer</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnmmasym_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_hotel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">512</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 2 (m:n (MM) ASym)</field>
+                               <field index="offers">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_mnmmasym_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_offer:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">64</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 2.1 (m:n (MM) ASym)</field>
+                               <field index="hotels">0</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_mnmmasym_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_offer:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 1.2 (m:n (MM) ASym)</field>
+                               <field index="hotels">0</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnmmasym_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_offer:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 1.1 (m:n (MM) ASym)</field>
+                               <field index="hotels">0</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnmmasym_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_price:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">64</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Price (m:n (MM) ASym)</field>
+                               <field index="price">223.00</field>
+                               <field index="offers">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_price:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Price 1.2.2 (m:n (MM) ASym)</field>
+                               <field index="price">567.00</field>
+                               <field index="offers">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnmmasym_price:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Price 1.1.1 (m:n (MM) ASym)</field>
+                               <field index="price">567.00</field>
+                               <field index="offers">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnsym_hotel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel Branch 1.1 (mm sym)</field>
+                               <field index="branches">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="branches" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnsym_hotel:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">192</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel branch 1.2 (mm sym)</field>
+                               <field index="branches">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="branches" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnsym_hotel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 1 (mm sym)</field>
+                               <field index="branches">2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="branches" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnsym_hotel_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnsym_hotel_rel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="hotelid">1</field>
+                               <field index="branchid">2</field>
+                               <field index="hotelsort">1</field>
+                               <field index="branchsort">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotelid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="branchid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnsym_hotel_rel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="hotelid">1</field>
+                               <field index="branchid">3</field>
+                               <field index="hotelsort">2</field>
+                               <field index="branchsort">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotelid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="branchid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_mnsym_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnattr_hotel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 1 (m:n Attr)</field>
+                               <field index="offers">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnattr_hotel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">512</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 2 (m:n Attr)</field>
+                               <field index="offers">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnattr_hotel_offer_rel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="hotelid">1</field>
+                               <field index="offerid">1</field>
+                               <field index="hotelsort">1</field>
+                               <field index="offersort">0</field>
+                               <field index="quality">2</field>
+                               <field index="allincl">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotelid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="offerid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnattr_hotel_offer_rel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="hotelid">2</field>
+                               <field index="offerid">2</field>
+                               <field index="hotelsort">1</field>
+                               <field index="offersort">0</field>
+                               <field index="quality">4</field>
+                               <field index="allincl">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotelid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_hotel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                               <field index="offerid" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnattr_offer:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 1 (m:n Attr)</field>
+                               <field index="hotels">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotels" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_mnattr_offer:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">512</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 2 (m:n Attr)</field>
+                               <field index="hotels">0</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="hotels" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_mnattr_hotel_offer_rel</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_hotel:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 2 (csv)</field>
+                               <field index="offers">3</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1ncsv_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_hotel:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Hotel 1 (csv)</field>
+                               <field index="offers">1,2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="offers" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1ncsv_offer</table>
+                                               </element>
+                                               <element index="1" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1ncsv_offer</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_offer:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">64</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 2.2 (csv)</field>
+                               <field index="prices">3</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>3</id>
+                                                       <table>tx_irretutorial_1ncsv_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_offer:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 1.2 (csv)</field>
+                               <field index="prices">2</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>2</id>
+                                                       <table>tx_irretutorial_1ncsv_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_offer:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Offer 1.1 (csv)</field>
+                               <field index="prices">1</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                               <field index="prices" type="array">
+                                       <type>db</type>
+                                       <relations index="itemArray" type="array">
+                                               <element index="0" type="array">
+                                                       <id>1</id>
+                                                       <table>tx_irretutorial_1ncsv_price</table>
+                                               </element>
+                                       </relations>
+                               </field>
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_price:3" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">3</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">64</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Price 2.2.1 (csv)</field>
+                               <field index="price">112.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_price:2" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">2</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">128</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Price 1.2.1 (csv)</field>
+                               <field index="price">90.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+               <tablerow index="tx_irretutorial_1ncsv_price:1" type="array">
+                       <fieldlist index="data" type="array">
+                               <field index="uid">1</field>
+                               <field index="pid">1</field>
+                               <field index="cruser_id">1</field>
+                               <field index="sys_language_uid">0</field>
+                               <field index="l18n_parent">0</field>
+                               <field index="sorting">256</field>
+                               <field index="deleted">0</field>
+                               <field index="hidden">0</field>
+                               <field index="title">Price 1.1.1 (csv)</field>
+                               <field index="price">567.00</field>
+                       </fieldlist>
+                       <related index="rels" type="array">
+                       </related>
+               </tablerow>
+       </records>
+</T3RecordDocument>
\ No newline at end of file
diff --git a/typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/DataSet/Assertion/importIrreRecords.csv b/typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/DataSet/Assertion/importIrreRecords.csv
new file mode 100644 (file)
index 0000000..e935836
--- /dev/null
@@ -0,0 +1,85 @@
+"pages"
+,"uid","pid","sorting","deleted","title"
+,1,0,256,0,"IRRE"
+tt_content
+,uid,pid,sorting,deleted,sys_language_uid,l18n_parent,header,categories,tx_irretutorial_1nff_hotels,tx_irretutorial_1ncsv_hotels
+,1,1,256,0,0,0,"Test content",0,2,"1,2"
+tx_irretutorial_1ncsv_hotel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,offers
+,1,1,1,0,0,256,0,0,"Hotel 1 (csv)","1,2"
+,2,1,1,0,0,128,0,0,"Hotel 2 (csv)",3
+tx_irretutorial_1ncsv_offer
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,prices
+,1,1,1,0,0,256,0,0,"Offer 1.1 (csv)",1
+,2,1,1,0,0,128,0,0,"Offer 1.2 (csv)",2
+,3,1,1,0,0,64,0,0,"Offer 2.2 (csv)",3
+tx_irretutorial_1ncsv_price
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,price
+,1,1,1,0,0,256,0,0,"Price 1.1.1 (csv)",567.00
+,2,1,1,0,0,128,0,0,"Price 1.2.1 (csv)",90.00
+,3,1,1,0,0,64,0,0,"Price 2.2.1 (csv)",112.00
+tx_irretutorial_1nff_hotel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,parentid,parenttable,parentidentifier,title,offers
+,1,1,1,0,0,2,0,0,1,tt_content,,"Hotel 2 (nff)",1
+,2,1,1,0,0,1,0,0,1,tt_content,,"Hotel 1 (nff)",2
+tx_irretutorial_1nff_offer
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,parentid,parenttable,parentidentifier,title,prices
+,1,1,1,0,0,2,0,0,2,tx_irretutorial_1nff_hotel,,"Offer 1.2 (nff)",1
+,2,1,1,0,0,1,0,0,1,tx_irretutorial_1nff_hotel,,"Offer 2.1 (nff)",1
+,3,1,1,0,0,1,0,0,2,tx_irretutorial_1nff_hotel,,"Offer 1.1 (nff)",2
+tx_irretutorial_1nff_price
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,parentid,parenttable,parentidentifier,title,price
+,1,1,1,0,0,2,0,0,3,tx_irretutorial_1nff_offer,,"Price 1.1.2 (nff)",869.00
+,2,1,1,0,0,1,0,0,2,tx_irretutorial_1nff_offer,,"Price 2.1.1 (nff)",5467567.00
+,3,1,1,0,0,1,0,0,1,tx_irretutorial_1nff_offer,,"Price 1.2.1 (nff)",678.00
+,4,1,1,0,0,1,0,0,3,tx_irretutorial_1nff_offer,,"Price 1.1.1 (nff)",4.00
+tx_irretutorial_mnasym_hotel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,offers
+,1,1,1,0,0,256,0,0,"Hotel 1 (m:n ASym)",2
+tx_irretutorial_mnasym_hotel_offer_rel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,deleted,hidden,hotelid,offerid,hotelsort,offersort,prices
+,1,1,1,0,0,0,0,1,1,1,1,1
+,2,1,1,0,0,0,0,1,2,2,1,1
+tx_irretutorial_mnasym_offer
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,hotels
+,1,1,1,0,0,256,0,0,"Offer 1 (m:n ASym)",1
+,2,1,1,0,0,128,0,0,"Offer 2 (m:n ASym)",1
+tx_irretutorial_mnasym_price
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,parentid,title,price
+,1,1,1,0,0,1,0,0,1,"Price 2 1:1 (m:n ASym)",45.00
+,2,1,1,0,0,1,0,0,2,"Price 1 1:2 (m:n ASym)",678.00
+tx_irretutorial_mnattr_hotel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,offers
+,1,1,1,0,0,256,0,0,"Hotel 2 (m:n Attr)",1
+,2,1,1,0,0,128,0,0,"Hotel 1 (m:n Attr)",1
+tx_irretutorial_mnattr_hotel_offer_rel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,deleted,hidden,hotelid,offerid,hotelsort,offersort,quality,allincl
+,1,1,1,0,0,0,0,1,1,1,1,4,0
+,2,1,1,0,0,0,0,2,2,1,1,2,1
+tx_irretutorial_mnattr_offer
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,hotels
+,1,1,1,0,0,256,0,0,"Offer 2 (m:n Attr)",1
+,2,1,1,0,0,128,0,0,"Offer 1 (m:n Attr)",1
+tx_irretutorial_mnmmasym_hotel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,offers
+,1,1,1,0,0,256,0,0,"Hotel 2 (m:n (MM) ASym)",1
+,2,1,1,0,0,128,0,0,"Hotel 1 (m:n (MM) ASym)",2
+tx_irretutorial_mnmmasym_offer
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,hotels,prices
+,1,1,1,0,0,256,0,0,"Offer 1.1 (m:n (MM) ASym)",0,1
+,2,1,1,0,0,128,0,0,"Offer 1.2 (m:n (MM) ASym)",0,1
+,3,1,1,0,0,64,0,0,"Offer 2.1 (m:n (MM) ASym)",0,1
+tx_irretutorial_mnmmasym_price
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,price,offers
+,1,1,1,0,0,256,0,0,"Price 1.1.1 (m:n (MM) ASym)",567.00,0
+,2,1,1,0,0,128,0,0,"Price 1.2.2 (m:n (MM) ASym)",567.00,0
+,3,1,1,0,0,64,0,0,"Price (m:n (MM) ASym)",223.00,0
+tx_irretutorial_mnsym_hotel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,sorting,deleted,hidden,title,branches
+,1,1,1,0,0,256,0,0,"Hotel 1 (mm sym)",2
+,2,1,1,0,0,128,0,0,"Hotel branch 1.2 (mm sym)",1
+,3,1,1,0,0,64,0,0,"Hotel Branch 1.1 (mm sym)",1
+tx_irretutorial_mnsym_hotel_rel
+,uid,pid,cruser_id,sys_language_uid,l18n_parent,deleted,hidden,hotelid,branchid,hotelsort,branchsort
+,1,1,1,0,0,0,0,1,2,2,0
+,2,1,1,0,0,0,0,1,3,1,1
diff --git a/typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/ImportInEmptyDatabaseTest.php b/typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/ImportInEmptyDatabaseTest.php
new file mode 100644 (file)
index 0000000..859d950
--- /dev/null
@@ -0,0 +1,47 @@
+<?php
+namespace TYPO3\CMS\Impexp\Tests\Functional\Import\IrreTutorialRecords;
+
+/***************************************************************
+ * Copyright notice
+ *
+ * (c) 2014 Marc Bastian Heinrichs <typo3@mbh-software.de>
+ * All rights reserved
+ *
+ * This script is part of the TYPO3 project. The TYPO3 project is
+ * free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ *
+ * The GNU General Public License can be found at
+ * http://www.gnu.org/copyleft/gpl.html.
+ *
+ * This script is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * This copyright notice MUST APPEAR in all copies of the script!
+ ***************************************************************/
+
+require_once __DIR__ . '/../AbstractImportTestCase.php';
+
+/**
+ * Functional test for the ImportExport
+ */
+class ImportInEmptyDatabaseTest extends \TYPO3\CMS\Impexp\Tests\Functional\Import\AbstractImportTestCase {
+
+       protected $dataSetDirectory = 'typo3/sysext/impexp/Tests/Functional/Import/IrreTutorialRecords/DataSet/';
+
+       /**
+        * @test
+        */
+       public function importIrreRecords() {
+
+               $this->import->loadFile(__DIR__ . '/../../Fixtures/ImportExport/irre-records.xml', 1);
+               $this->import->importData(0);
+
+               $this->assertAssertionDataSet('importIrreRecords');
+       }
+
+}
\ No newline at end of file