1. regme_rojo
  2. RO CSVI
  3. Wednesday, 27 July 2022
  4.  Subscribe via email
Hello!
I created an import template for custom tables to fill in the data from my xml file.
I need to exclude on "line" though, and I used the skip rule plugin to get it done:
skip01.png

skip03.png

skip02.png

But I always get an empty line in my table.

skip04.png

Any idea what I did wrong? :(
Attachments (4)
Accepted Answer
Accepted Answer Pending Moderation
Hello Chris,
Please load the attached patch file and run the import. Check if empty rows are not created with the patch file.
Attachments (1)
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi!
Sorry for the delay. I was "distracted" by other things.
Attached you find all files compressed to a zipfile.

Regards!
Chris
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
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:
Screenshottool.20220802150648-1886x182.png
Screenshottool.20220802150819-1521x920.png
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
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

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


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