Categories
View Replies (16)

Resolved Virtuemart text input custom fields not exportable

  1. Huubss
    Huubss
  2. RO CSVI
  3. Monday, 21 March 2022
  4.  Subscribe via email
Hello, I want to export my custom field text input in my template. But I cannot find it anywhere. Any idea how to do this? I downloaded the text input plugin but I cannot seem to find it anywhere.
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please remove the previous rule created and follow the steps to set the new rule to check if the text ID nummer horloge is available if not replace with empty.

1. Create a Multi replace rule with below Regular expression. Copy the regex and use it in rule. See attached screenshot.



/^(?!.*?\bID nummer horloge\b).*$/


2. In template fields page for product_attribute field set the rule. Save the template field. See attached screenshot.
3. Run the export and check.

I was thinking if this is all not possible, is it possible to just use a custom query? Because this seems a major oversight in this component to be completely honest.

You can write custom query by writing a custom rule plugin. But i am expecting your issue to be solved with above steps. Run the export and let me know.
Attachments (2)
Screenshot 2022-03-23 at 4.10.15 PM.png Screenshot 2022-03-23 at 4.10.15 PM.png
Screenshot 2022-03-23 at 4.43.18 PM.png Screenshot 2022-03-23 at 4.43.18 PM.png
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
Responses (16)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I want to export my custom field text input in my template. But I cannot find it anywhere. Any idea how to do this?

We do not support custom field text input as template field in VirtueMart product export however you can use custom_title, custom_value and custom_param fields in export to get the text input field data.

I downloaded the text input plugin but I cannot seem to find it anywhere.

The plugin you downloaded is to export text input field value from product_attribute field in VirtueMart order export. It does not support export of fields in VirtueMart product export.
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
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
I want to export my custom field text input in my template. But I cannot find it anywhere. Any idea how to do this?

We do not support custom field text input as template field in VirtueMart product export however you can use custom_title, custom_value and custom_param fields in export to get the text input field data.


How do I do this? Because I'm not sure how to just get the text input value..
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
As i mentioned earlier, add fields custom_title, custom_value and custom_param fields to your export template and run the export. See attached screenshot.
Attachments (1)
Screenshot 2022-03-21 at 5.35.27 PM.png Screenshot 2022-03-21 at 5.35.27 PM.png
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
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
As i mentioned earlier, add fields custom_title, custom_value and custom_param fields to your export template and run the export. See attached screenshot.


I just tried this but my whole CSV is getting scrambled. Isn't there an option to only extract the text input field? Because it's also exporting other fields that are just for display not for data
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I just tried this but my whole CSV is getting scrambled.

In your export template on File tab set Text Enclosure field to " (See attached screenshot). Save the template and run the export. Export file should not be scrambled with that.

Isn't there an option to only extract the text input field? Because it's also exporting other fields that are just for display not for data

As of now there is no option to extract only text input field. Please send us the export file. We can see if we can get text input field data using regular expression in RO CSVI rules.
Attachments (1)
Screenshot 2022-03-21 at 6.18.12 PM.png Screenshot 2022-03-21 at 6.18.12 PM.png
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
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
I just tried this but my whole CSV is getting scrambled.

In your export template on File tab set Text Enclosure field to " (See attached screenshot). Save the template and run the export. Export file should not be scrambled with that.

Isn't there an option to only extract the text input field? Because it's also exporting other fields that are just for display not for data

As of now there is no option to extract only text input field. Please send us the export file. We can see if we can get text input field data using regular expression in RO CSVI rules.


Ok thank you now the file is not scrambled.

But the actual value of the text input is not there. I have attached multiple things. The export template, the export file.
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for the files. From beginning I have been talking about text input custom field data not supported in VirtueMart product export but you are doing VirtueMart Order export. Can you tell me if you are looking at exporting text input custom field data related to the order or text input custom field data related to the product?
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. # 7
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
Thank you for the files. From beginning I have been talking about text input custom field data not supported in VirtueMart product export but you are q VirtueMart Order export. Can you tell me if you are looking at exporting text input custom field data related to the order or text input custom field data related to the product?


Yes I understand but it’s related to the order because you cannot order the product without putting in the text.
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You need to add product_attribute field to your export template to get text input field data related to order. But remember this field contains all the custom field data stored when an order has been placed. Try and let me know if that is what you expect in export.
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. # 9
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
You need to add product_attribute field to your export template to get text input field data related to order. But remember this field contains all the custom field data stored when an order has been placed. Try and let me know if that is what you expect in export.


Thanks that seems to do the trick. Is it possible to only show 1 specific custom field?

So for example in my is ID number, show that else show an empty box?
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Is it possible to only show 1 specific custom field?

So for example in my is ID number, show that else show an empty box?

Can you give a detailed explanation with example? Which ID number you are looking at and what you want to export? Please also include the export 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. # 11
Huubss
Huubss
Accepted Answer Pending Moderation
In the files I have added have a CSV file. In the CSV file there is the last column which has the product attributes. I only want the ID nummer in the last column, if there is another field i just want the column to be empty. Also I want the ID nummer to be removed so only. the actual numbers are there.
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for the explanation.

Also I want the ID nummer to be removed so only. the actual numbers are there.

You can use RO CSVI Multi replace rule and create a rule to find and replace ID nummer value. Apply this rule on product_attribute field and run the export. See attached screenshot.

I only want the ID nummer in the last column, if there is another field i just want the column to be empty.

If you just want ID nummer value, you can do that using regular expression in RO CSVI Multi replace rule plugin with two rule operations as in the below screenshots. But making a column empty if there is another field is not possible with rules and regular expressions.

Apply the rules on product_attribute and run the export. Let me know on how that goes.
Attachments (2)
Screenshot 2022-03-23 at 3.35.54 PM.png Screenshot 2022-03-23 at 3.35.54 PM.png
Screenshot 2022-03-23 at 3.33.13 PM.png Screenshot 2022-03-23 at 3.33.13 PM.png
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. # 13
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
Thank you for the explanation.

Also I want the ID nummer to be removed so only. the actual numbers are there.

You can use RO CSVI Multi replace rule and create a rule to find and replace ID nummer value. Apply this rule on product_attribute field and run the export. See attached screenshot.

I only want the ID nummer in the last column, if there is another field i just want the column to be empty.

If you just want ID nummer value, you can do that using regular expression in RO CSVI Multi replace rule plugin with two rule operations as in the below screenshots. But making a column empty if there is another field is not possible with rules and regular expressions.

Apply the rules on product_attribute and run the export. Let me know on how that goes.


Isn't it possible to check whether or not the ID nummer horloge is available, and if not just make the whole field empty? I'm a bit confused. Do i need to add both rules?

Also, isn't it possible to just check for a certain amount of numbers and extract that? And if thats not available nothing gets put in the box?

I added both rules but it's not working. Everything is the same.


EDIT:

I was thinking if this is all not possible, is it possible to just use a custom query? Because this seems a major oversight in this component to be completely honest.
  1. more than a month ago
  2. RO CSVI
  3. # 14
Huubss
Huubss
Accepted Answer Pending Moderation
Hello,
Please remove the previous rule created and follow the steps to set the new rule to check if the text ID nummer horloge is available if not replace with empty.

1. Create a Multi replace rule with below Regular expression. Copy the regex and use it in rule. See attached screenshot.



/^(?!.*?\bID nummer horloge\b).*$/


2. In template fields page for product_attribute field set the rule. Save the template field. See attached screenshot.
3. Run the export and check.

I was thinking if this is all not possible, is it possible to just use a custom query? Because this seems a major oversight in this component to be completely honest.

You can write custom query by writing a custom rule plugin. But i am expecting your issue to be solved with above steps. Run the export and let me know.


That is absolutely gorgeous. Thank you!
  1. more than a month ago
  2. RO CSVI
  3. # 15
  • Page :
  • 1


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