1. vasslis3
  2. RO CSVI
  3. Wednesday, 31 May 2017
  4.  Subscribe via email
I have csvi with the following fields

image,id,sku,active,updated,light_c,light_t,power,lpw,total_l,power_supply,beam_angle,protection_class,cri,avg_life,out_dim,mount_dim,op_temp,socket,replaces,material,warranty,certificate,attachment,category,dimable,id,name,description,locale,price,productId
http://domain.com/uploads/products/257/aec1ca128e9970f003c9cd6932eaad05.png,257,2005,1/1/00,3/15/17,6000K,6000K,3.6 W/m,83 lum/W,300 lum/m,DC12V,120 ΅,IP20,,50000 Hours,5m x 8mm x 2.5mm,5m x 8mm x 2.5mm,-20΅C to ~50΅C,NA,NA,PCB,2 years,CE,,39,0,1203,LED Strip SMD3528 - 60LEDs 6000K Non-waterproof ,LED Strip SMD3528 - 60LEDs 6000K Non-waterproof ,en,0.89,257


I have created all the fields
http://prntscr.com/febowz

Template has the following settings
http://prntscr.com/febpbi

And the result is not corresponding on "Your Field" value but on first field I think....
All fields has got wrong values http://prntscr.com/febrkg

Why it tries to match them byorder and not by field column???
Accepted Answer Pending Moderation
Hello,

Why it tries to match them byorder and not by field column???
That is because CSV files are always matched by order and not by field column. The column Your field is used by XML imports.

So if you order your fields in the same order as your CSV file and empty the Your field fields, your import should run.
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
I understand and you have right.
But when an CSV has headers it's possible to work as I said. Anyway, with FieldMapper I created all the fields at once.


I have 2 problems

1) When I'm trying to import I got error, if I open the developer tools (F12) I see the following error...
http://prntscr.com/feofs5

Seems the request is made in non-www but I'm accessing the admin area with www.

2) CSV with products has a column with manufacturers category id, for example 38. I want to change the 38 to 115 that is my existing category id.
Ok this I have done it via http://prntscr.com/feoj1s . Seems I have to make many copies.
The problem is the field type, I have set "category_id" is it right? http://prntscr.com/feojw8
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,

But when an CSV has headers it's possible to work as I said.
It is possible but that is not the way it is designed because if you have columns with the same name, you have a problem.

As for your first problem, CSVI doesn't make this domain up itself but gets the domain name from Joomla. It sounds like you have the same problems as explained in this post. Have a look at your configuration.php, the live_site should be empty.

CSV with products has a column with manufacturers category id
With the product import you cannot assign manufacturers to manufacturer categories. If you want to update the link between manufacturers and manufacturer categories you must use the manufacturer import and not the product import. The product import is for maintaining products and the manufacturer import is for maintaining manufacturers.

If you want to link your product to a manufacturer you should be using the manufacturer_name field. We do not recommend using IDs because they are maintained by the database. You can use them but then the responsibility for the correct ID is yours. The manufacturer_id field is the field you can use for managing the manufacturer ID.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Sorry I have confused you.
Forget the word "Manufacturer", I mean the CSV file is provided from a manufacturer.

I wan to assign the importing product into existing Product Category. The file contains the id and I want to map it with my categories ids.
For example csv has 38 and I want to change it to 115 (that is my existing category id).

1) Is this the right rule way for mapping http://prntscr.com/feoj1s
2) "category_id" field is the right id to assign the product into a category?
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

The rule is correct and the field is called category_id.

You can see the new value already in the preview assuming it is working.
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Thank you!
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
I have imported.
Some issues. CSV does not have all the fields but I want to add some values to the following:

1) Products stays unpublished
2) Stock & weight are empty
3) Skip row if a field contains a word
4) Image: title is missing and published is 0

I guess need to create for fields in then end of field list?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello,

1) Products stays unpublished
You need to include the field published with a value of Y or 1.

2) Stock & weight are empty
You need to include the appropriate fields, CSVI can't guess the stock and weight of a product.

3) Skip row if a field contains a word
You can create a rule for the skip rule plugin, this can skip records.

4) Image: title is missing and published is 0
You need to add the file_title field with your titles or set the Fill media fields to Yes in your template on the Options tab.

I guess need to create for fields in then end of field list?
Fields with set values can be added to the list of template fields, they do not need to be in your CSV file.
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
I managed to import the products
SKIP rule, skips all products but I have removed that lines that contains the keyword with excel.

One more question
CSV has duplicated lines with same sku etc but with different image but only one image is imported.
These are the template settings http://prntscr.com/fkihjp

I guess that I need something like
skuname-1.jpg
skuname-2.jpg

any advice how I can have multiple images?
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello,
I managed to import the products
SKIP rule, skips all products but I have removed that lines that contains the keyword with excel.

If you had difficulties you could have posted your skip rule settings and we could have helped you.

CSV has duplicated lines with same sku etc but with different image but only one image is imported.
These are the template settings http://prntscr.com/fkihjp

I guess that I need something like
skuname-1.jpg
skuname-2.jpg

any advice how I can have multiple images?

You can import multiple images separated by symbol | like image1.jpg|image2.jpg. You can post your latest import debug log along with your sample import file so we can check on the issue.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
You can import multiple images separated by symbol | like image1.jpg|image2.jpg.

Where I can add this?
http://prntscr.com/fn9mb2
  1. more than a month ago
  2. RO CSVI
  3. # 11
Accepted Answer Pending Moderation
[attachment]15b5f3b894bff6e37a14140c3c9b6a78[/attachment]
test.csv
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello,
Where I can add this?
http://prntscr.com/fn9mb2

Your field is to set the name of the column header from your import file if the column header does not match to CSVI template fields.

You need to have the multiple images set to your file_url field in your import file. Can you send a sample of your import file along with your template XML file? To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
I have already send you csv samle and the log in previous post.
I send you the template
csvi_templates_20170623.xml

Same SKU different image http://prntscr.com/fnac83
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hello,
There is no problem with your csv file but with the setting Create image name on Images tab is set to Yes. You have set this to product_sku, since the product_sku is same for all the images, the query to check the image in virtuemart_medias table says the image already exists and ignores the second and third image. Can you try setting Image name based on to Random and do the import? That would solve your issue. If not, post the latest debug log to check.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  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!