Resolved import skip rule creates empty entry in table

Hello,

There is a question: When setup the actual site (starting from scratch; importing all template and rules, etc.) I figure I need to load all those patches, too. Right?

That depends on when the patch file was sent. If you run the latest RO CSVI version then you don't need to load the old patches as the latest version includes the fixes sent in patch file. But the last patch for Skip rule will be included in the upcoming RO CSVI release as it was fixed recently. If you have the same issue in another site then install RO CSVI latest 8.3.1 version and then load the patch file sent.

Or do I just download the component from your site to have everything included? Do you maintain the component with all those patches or are those patches just for my problems?

No patch files are not just for your problems. The fixes sent in patch files are included with RO CSVI release.

Hello,
Please post the import debug log, template XML and sample import file to check. To get the debug log check How to collect debug information? document. To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.

Hi!
Sorry for the delay. I was "distracted" by other things.
Attached you find all files compressed to a zipfile.

Regards!
Chris

Hello Chris,
Thank you for posting the requested files. I see the case of empty query running from your debug log. Can you send me the structure of customtables_table_schulen table? You can post a screenshot of it. I want to check on how you have id (primary key) field defined in the table.

I can post a "create table" command:

CREATE TABLE `jbidion_customtables_table_schulen` (

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `published` tinyint(1) NOT NULL DEFAULT 1,

  `es_schuleid` int(11) DEFAULT NULL COMMENT 'Schule ID',

  `es_schulekat` int(10) unsigned DEFAULT NULL COMMENT 'Schulkategorie',

  `es_schulebez` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Schulname',

  `es_schulename` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Schulname',

  `es_schuleadresse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Schuladresse',

  `es_schuleplz` int(11) DEFAULT NULL COMMENT 'Postleitzahl',

  `es_schuleort` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Ort',

  `es_schuletel1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Telefonnummer',

  `es_schulefax` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FaxNr.',

  `es_schuleemail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'eMail',

  `es_schulewww` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Webseite',

  `es_schuleskz` int(11) DEFAULT NULL COMMENT 'Schulkennzahl',

  `es_salias` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'alias',

  PRIMARY KEY (`id`),

  KEY `es_schulekat` (`es_schulekat`)

) ENGINE=InnoDB AUTO_INCREMENT=389 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='schulen';

Also som screenshots are possible:


I did not care about a primary key field when I created the table.
The category column get's it's data from another table via Join

Thanks for your help

Done!
Empty row just vanished.
Thanks a lot!

There is a question: When setup the actual site (starting from scratch; importing all template and rules, etc.) I figure I need to load all those patches, too. Right?
Or do I just download the component from your site to have everything included? Do you maintain the component with all those patches or are those patches just for my problems?