Categories
View Replies (3)

Resolved Custom field name with ' symbol in it

  1. porscha
    porscha
  2. RO CSVI
  3. Thursday, 09 April 2020
  4.  Subscribe via email
Hi guys, hope you are ok!

I am experiencing an issue with custom fields name. I have one custom filed in VM, named Numero d'ordine. (in Italian). When I try to import table with products, this filed is not showed in the preview of the import. I think it is because " ' " symbol. When I try to save the field in Export template it does not search Numero d'ordine in the Filed name field and it can not be saved.

Joomla! 3.9.16
RO CSVI 7.15.0
VirtueMart 3.6.10 10211

In old version of the same site (because now we are making an update) we have:
Joomla! 3.9.15
CSVI Pro 7.12.0
VirtueMart 3.4.2
and there the cutom field has the same name Numero d'ordine, but there is not a problem with the import and the export - the field is ok in CSVI
But I do not think the problem is in Joomla or VM version, There is something in the ' coding with RO CSVI

Plase help me to figure it out,
Thank you and stay safe and be healthy!
Hrissy
0
Accepted Answer
porscha
porscha
Accepted Answer Pending Moderation
Hi Tharuna and thank you for your answer. I tried with Numero d'ordine in my import file, but it did not work, it was skipped again. Beside that when I tried to save an export template with this field, when I save the field, it loses the name of the field. So I figure it out this way:

1. You look for your field in virtuemart customs database table, and rename the field there. In my case I wrote Numero d'ordine
2. Update available fields in admin in RO CSV
3. In the import table I have Numero d'ordine as a name of the field.
4. Import is successful - in the preview you can see the field Numero d'ordine and it would not be skipped.
IMPORTANT: do not save the field from the administration!

Hope this will help other people, because I did not success with the other way.

Have a great evening!
Hrissy
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Hrissy,
But I do not think the problem is in Joomla or VM version, There is something in the ' coding with RO CSVI

It is not problem with Joomla or RO CSVI. It is how VirtueMart saves the custom field. VirtueMart converts the character and saves the field 


Numero d'ordine

as 


Numero d'ordine

in database. RO CSVI reads this field and saves it as available field in the same way as in VirtueMart table. When you run the import with Numero d'ordine, RO CSVI cannot identify this as available field and Skips it. This is the reason for not seeing this field in import preview.
You need to use 



Numero d'ordine


In your import 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
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Hrissy,
Thank you for sharing your solution. Your solution is one way of fixing the issue but not all users would know on how to save the field using database:)
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. # 2
  • Page :
  • 1


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