Categories
View Replies (5)

Resolved Import custom fields VM products stays empty

  1. gelauff
    gelauff
  2. RO CSVI
  3. Thursday, 04 January 2018
  4.  Subscribe via email
Hello,
I'm on Joomla 3.8.3 with Virtuemart 3.2.12.
I'm trying to import custom fields for VM products, but nothing is displayed in the preview and nothing is imported.
Please note: I exported from a recent database in order to import in an older database.
This had to be done after a major database problem.
Please see attached files: the csv and the log.
Thanks in advance!
com_csvi.log.31.zip
import_new_fields.csv
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Do you know in which encoding the export files are delivered?

It should depend on the settings you have on your notepad++ and the version of the program. You can check it by going to Settings > Preferences> New Document > Encoding and see if UTF-8 is selected.
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 (5)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Two things i noticed with your import file, one is that your file is a BOM file, you can see three weird characters at starting of your file which says that. You have to save your file as a normal UTF-8 file to run the import. Second is the use of field virtuemart_product_id, you should be using product_sku field instead of virtuemart_product_id. virtuemart_product_id is a primary key field of a database table and it is not advised to use the field. Moreover using product_sku field will create new records if they are not in database table but with virtuemart_product_id you say that the records already exists and it has to be updated.
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
gelauff
gelauff
Accepted Answer Pending Moderation
Hi Thurana,

Yes, it was the BOM issue.

What made me make the mistake is that the CSVI export file, which I used to create the import file, is a BOM file, so I thought it was the encoding was okay.
(Working with different import tools on different platforms (Joomla, Virtuemart, Prestashop) I'm often confused with the BOM question.)
Maybe the export file being a BOM file is an issue for you? Just let me know if I'm not clear.

As for the virtuemart_product_id and product_sku: I was importing custom fields for existing products only.
Since the shop owner's product_skus are not very reliable (high risk of duplicates) I preferred to use the virtuemart_product_id.

Thanks again Thurana, have a very nice day :)
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Maybe the export file being a BOM file is an issue for you? Just let me know if I'm not clear.

BOM is not generated with export but by the tool you use to open the CSV files. It says that your file has some encoding issue or can be said as not a UTF-8 encoded file. We often recommend our users to use OpenOffice to avoid such issues with encoding. To know on how to change your file check Save a CSV file as UTF-8 document.
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
gelauff
gelauff
Accepted Answer Pending Moderation
I see.
I use Notepad++.
Do you know in which encoding the export files are delivered?
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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