1. chaosicq
  2. RO CSVI
  3. Thursday, 05 March 2015
  4.  Subscribe via email
Hi
VirtueMart version 3.40
CSVI version 5.20
no data imported yet so no debug file needed.

Ok i want to import products form affiliate window manually at first then using cron taking the file from a url csv example attached.
I have used lots of different import systems so i have a good understanding of how the process works.
okay so i created a custom fields configuration for vm product import.
example 1st field
= product_sku now my 1st field in the file is aw_product_id which is field i want to use for product sku, when i tick the product_sku box and click edit is this the option to tell the import to accept aw_product_id in place of product_sku if so what which field do i enter the info & am i in the right place for what i am trying to do?.
Thank you
Accepted Answer Pending Moderation
looked at field mapping again after i did make one, but then did not see what to do next, the Create Template button looks like a delete file button that's why i never clicked it you might want to make a better button in version 6 just a suggestion :-)

after now trying the import i have an error no product sku found log file attached.

have changed the term id as i see this is an issue but it still does not seem to be reading the csv correctly.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hello,

the Create Template button looks like a delete file button
:) I never looked at it that way. As for version 6, it is no longer a button, just plain text.

In your template, on the first tab there is an option called Use column headers/nodes as configuration, set this to No and give it another shot. By changing this you tell CSVI to use the fields specified on the Fields tab.
Kind regards,

RolandD

=========================
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
Accepted Answer Pending Moderation
Hi
Now get error :::
1062 Duplicate entry '65535' for key 'PRIMARY' SQL=INSERT INTO bonnie_virtuemart_manufacturers (virtuemart_manufacturer_id,`virtuemart_manufacturercategories_id`) VALUES ('234197242','')

disabled manufacturer name then got this error :

1054 Unknown column 'category' in 'where clause' SQL=SELECT COUNT(*) AS

total FROM bonnie_virtuemart_product_categories WHERE

virtuemart_product_id = 2 AND virtuemart_category_id = category

then disabled category and all works i guess i have to find another way to tell it to import in to a specific category and add a brand name to the product.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hello,

i guess i have to find another way to tell it to import in to a specific category and add a brand name to the product.
To specify a category use the category_path or category_id field, however ID fields are discouraged because they may change. With the name you are always sure to get it correct. As for specifying manufacturer use only the manufacturer_name field.

You need to set Skip first line to Yes because your first line doesn't have any real values.
virtuemart_product_id = 2 AND virtuemart_category_id = category
You get this because you have specified the category_id to be used and in column L you have a word and not a number on the first row.

1062 Duplicate entry '65535' for key 'PRIMARY' SQL=INSERT INTO bonnie_virtuemart_manufacturers (virtuemart_manufacturer_id,`virtuemart_manufacturercategories_id`) VALUES ('234197242','')
Something has screwed up the manufacturer IDs because an ID with a value of 234197242 is impossible since the maximum is 65535.

You will need to reset the VirtueMart manufacturer tables so the indexes are fixed. You can do that by either emptying all the VirtueMart tables via the Maintenance menu in CSVI or use an SQL query
TRUNCATE TABLE bonnie_virtuemart_manufacturers;
Warning, this will empty the full manufacturers table. The same you will need to do for the other manufacturer tables with a name like bonnie_virtuemart_manufacturers_en_gb if you use English.
Kind regards,

RolandD

=========================
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. # 4
Accepted Answer Pending Moderation
Hi Roland
have another issue now when importing the data get this message repeatedly :
Deprecated: Non-static method CsviHelper::fileExistsRemote() should not be called statically, assuming $this from incompatible context in /var/www/vhosts/http://askshopper.com/httpdocs/administrator/components/com_csvi/helpers/images.php on line 826

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/http://askshopper.com/httpdocs/administrator/components/com_csvi/helpers/images.php on line 1236
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
Hello,

This isn't a real issue, just that you have set the error reporting to a developers level. If you go to System -> Global configuration -> Server -> Error reporting. Set it to System Default, in case it is already that, set it to None and save the settings. These warnings will be gone.

This is a technical issue that won't be fixed in CSVI 5 but has been cleaned up in CSVI 6 that will be out later. Nothing broken or anything, just means the code needs tidying up.
Kind regards,

RolandD

=========================
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. # 6
  • Page :
  • 1


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