Resolved Export-Import data from Joomla custom fields

Hello Jules,
Can you post the debug log of your export? Check How to get debug information? document to get the debug log.

Hello Tharuna,

Sorry, I don't have any log, because I don't know how to create such a file, I tried several things , but nothing seems like the example I gave you.
I tried your example https://csvimproved.com/support/tutorials/278-joomla-custom-fields/2938-joomla-custom-fields#import but this is not what I need.

regards,
Jules

Hello Jules,

Sorry, I don't have any log, because I don't know how to create such a file, I tried several things , but nothing seems like the example I gave you.

Did you check the linked document in my previous reply? That linked document will tell you how to get the debug log.

I tried your example http://csvimproved.com/support/tutorials/278-joomla-custom-fields/2938-joomla-custom-fields#import but this is not what I need.

You are probably looking at wrong article. Have a look at Joomla content import document and in Further reading section. Let me know if that helps.

Hello Tharuna,

Thank you for your quick response. The document was clear. I was looking wrong for fields etc.
Maybe you can give me a hint how to create a filter so that only empty fields of not-empty fields can be exported?
I used the CSVI skip plugin but Regular text is not suitable for finding empty or not-empty records?
Then I tried several regular expressions but they did not work
Can you tell me how to filter out fields empty or not-empty ?

Regards,
Jules

Hello Jules,
Are you looking for exporting records which has a specific field as empty or not?

if yes, you can create a skip rule with regular expression below to get empty values.

/^\s*$/

And for non empty values try the regular expression

/\S/

I am not a regex expert so try and let me know if it works.

Hello Tharuna,

Your suggestions do not work, I found out that /.*\S.*/ will skip the fields not-empty, but I find no way to skip the empty custom fields.
I thought a simple =”” should work, but no …
Any suggestions?
I like to export some data from articles were the custom fields are empty



Kind regards,
Jules

Hello Jules,

I thought a simple =”” should work, but no …
Any suggestions?

Did you try setting Values to match in your CSVI Skip rule by just keeping it empty? Perhaps try giving a empty space character in Values to match field. Check if any of these works.

Hello Tharuna,

I tried that too, but no effect.
I'm afraid that we are making a fallacy, we want to skip a field that is not even there,: if the fields of an article are not filled, they do not even exist ! so there are no records ( rows) in the database, So I guess the filter function does not have anything to filter!
Maybe you can contact the developers on how you can to approach this problem?
.

regards,
Jules

Hello Jules,
If there is no field in the database then we can do nothing about it. CSVI exports data from database table and rules are applied on export to these values.

Hello Tharuna,

I am afraid I was not clear enough. The custom fields are part of the Joomla core, so native Joomla and no 3d party.
The user can create custom fields like I did, brand, price etc. for all articles in the site. What I like to do now is export the articles where the fields are not yet filled in.
That should not be a great problem for such an advanced product as CSVI ?


regards,
Jules

Hello Jules,
There was a small misunderstanding as you said there is no field at all in the database.

I found out that /.*\S.*/ will skip the fields not-empty, but I find no way to skip the empty custom fields.

So reading your previous posts you said that you were able to skip the not-empty fields and no way to skip the empty custom fields. To skip the empty custom field we have added an option Apply in Skip rule plugin. Apply field has two options, one is to Skip always and Skip only when the field has value. Skip always will skip the empty values too. So for your case, do the following.

1. Install the attached modified the Skip rule plugin using Joomla Extension Manager.
2. Create a Skip rule using setting Apply field as Skip always and leave the Values to match field empty.
3. Save the rule.
4. Apply the rule on your custom fields.
5. Run the export.

Check if you are able to skip the empty fields and export only the fields with values.

plg_CSVI_skip.zip

Hello Tharuna,

Sorry for the delay, but it works like a charm !!
I found the description a little cryptic, maybe it can be changed for better clarity ?:

Skip only when field has value
and:
Skip only when field has no value

Thanks for your excellent support !
Kind regards,
Jules

Hello Jules,
Thank you for confirming the modified plugin is working. We will look at changing the description text.

Please leave us a review on Joomla Extension Directory.

Hi
I too would like to Skip a filled field and thought this Plugin update might solve.
However... it does not.
I'm trying to use it to Skip a field that is not empty.
Any clues for how else to achieve it?
It is a Custom Field in Hikashop in my case, so the field does exist.
Advice would be truly appreciated.
Kind regards, Bob

Hello Bob,
You want to Skip the rows with values in custom field so in your Skip rule plugin you should have Apply field to be Skip fields matching expression, Method to match to be Regular expression and in the Regular expression pattern field set the below regex. Save the rule, apply this rule on your custom field from CSVI template fields page and check if your import or export works.

/(.|\s)*\S(.|\s)*/

Thanks Tharuna
I just tried that and it works perfectly, Thank You!
Just to be clear, should I continue to use the new plugin, which gives the option to Skip Always or Skip when the field has contents, or revert to the old plugin that was installed with the latest package? I'm not sure that "Skip only when field has value" is working as intended.
If I need to revert that plugin, could you please provide a link for me to upload just that.
Thanks again! Bob

Hello Bob,
Glad to know that it worked. You should be using the latest version of the plugin as the rule you have created with regex is supported with the this version of the plugin.