Categories
View Replies (5)

Resolved Skip empty fields when exporting

  1. Marcel
    Marcel
  2. RO CSVI
  3. Sunday, 05 January 2020
  4.  Subscribe via email
Hi Tharuna!
Best wishes for the upcoming year!
I have a question about skipping empty fields. I tried to find solutions myself but somehow it does not seem to work. You posted some methods about the way to do this with 2 rules (a first multi-replace rule to fill empty fields with a text value and the a second rule for skipping fields with that text value) and I also tried skipping empty field with a regular expression /(\s)/ but both scenarios generates an xml with no records at all. I checked the first rule only (works like a charm, it puts a value in empty the empty field, but adding the skip field results in an empty file. See attachement.

Thanks in advance and kind regards, Marcel
Attachments (1)
skip-field.jpg skip-field.jpg
0
Responses (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
I also tried skipping empty field with a regular expression /(\s)/ but both scenarios generates an xml with no records at all

If you are using regex then you don't need two rules. You can do it with one rule and only using RO CSVI Skip rule plugin. In your Skip rule try setting regex to 
/\s*$/
and see if it works.

You posted some methods about the way to do this with 2 rules (a first multi-replace rule to fill empty fields with a text value and the a second rule for skipping fields with that text value)

That is correct, first rule will replace empty test and second Skip rule will skip the record when the value of the field is 'delete'(as per your screenshot).

I checked the first rule only (works like a charm, it puts a value in empty the empty field, but adding the skip field results in an empty file. See attachement.

Can you post a screenshot of your skip rule? The Multi replace rule seems to be correct from the screenshot.
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
Marcel
Marcel
Accepted Answer Pending Moderation
Hi Tharnua
Here is the screenshot. Your regex gave me the same result, an empty xml.
Attachments (1)
fields.jpg fields.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
Your rules Multi replace and Skip rules looks fine. In template fields for the field you have applied the rules, check the order of the rule in Rules field. It should be first Multi replace rule and then Skip rule. Do you see the order this way?

Your regex gave me the same result, an empty xml.

Can you give a try with the below regex?
/\S/
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
Marcel
Marcel
Accepted Answer Pending Moderation
The order was already like you mentioned. adding your new regex gives me a xml with records but the empty field is still there.
I could create a new login for the site so you can check yourself.

Regards, Marcel
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel,
Before i look into your site, can you post the template XML of your export template? To get your template XML file, in CSVI maintenance menu select CSVI Pro on first option, backup templates on second option, select your export template and download the XML file. Post the XML file so i can run the export on my local site and check.
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. # 5
  • Page :
  • 1


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