Categories
View Replies (7)

Resolved Error when importing the FastSeller File XLS

  1. denis_kr
    denis_kr
  2. RO CSVI
  3. Wednesday, 24 June 2015
  4.  Subscribe via email
Joomla_3.4.1 + com_virtuemart.3.0.9 + com_csvi_6.0rc1_pro + plg_csviaddon_virtuemart_csvi_6.0rc1 + plg_csviaddon_fastseller_csvi_6.0rc1.


Error when importing the FastSeller Product from the column name product_sku:

1.File XLS, :(
Use file for configuration,
Name of the column
product_sku; product_type_name; type_parts.
Debug information:
Warning: Invalid argument supplied for foreach() in Z:\home\test3.by\www\administrator\components\com_csvi\helper\importfields.php on line 244
Fatal error: Call to a member function getAllFieldnames() on a non-object in Z:\home\test3.by\www\administrator\components\com_csvi\helper\file\import\xls.php on line 111


2. File CSV, :(
Error when importing the FastSeller Product from the type name:
Use file for configuration,
Name of the column
product_sku; product_type_name; type_parts.
Debug information:
#
#<?php die('Forbidden.'); ?>
#Date: 2015-06-24 10:34:45 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: date time line_nr action comment
2015-06-24 10:34:45 0 [DEBUG] Clean up old logs. Found 16 logs and threshold is 25 logs
2015-06-24 10:34:45 0 [QUERY] SELECT csvi_log_id FROM vwqda_csvi_logs ORDER BY csvi_log_id
2015-06-24 10:45:30 0 [DEBUG] Clean up old logs. Found 16 logs and threshold is 25 logs
2015-06-24 10:45:30 0 [QUERY] SELECT csvi_log_id FROM vwqda_csvi_logs ORDER BY csvi_log_id
2015-06-24 10:45:32 0 [DEBUG] Found field delimiter: ,
2015-06-24 10:45:32 0 [DEBUG] Loading the supported fields for com_fastseller, operation producttypename and action import
2015-06-24 10:45:32 0 [QUERY] SELECT `a`.`csvi_name` FROM `vwqda_csvi_availablefields` AS `a` LEFT JOIN `vwqda_csvi_availabletables` AS `t` ON `t`.`template_table` = `a`.`component_table` WHERE `a`.`component` = 'com_fastseller' AND `t`.`component` = 'com_fastseller' AND `t`.`task_name` = 'producttypename' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-06-24 10:45:32 0 [DEBUG] Load the fields to process
2015-06-24 10:45:32 0 [DEBUG] Setup field: product_sku
2015-06-24 10:45:32 0 [DEBUG] Setup field: product_type_name
2015-06-24 10:45:32 0 [DEBUG] Setup field: type_parts
2015-06-24 10:45:32 0 [DEBUG] Use the file for configuration
2015-06-24 10:45:32 0 [DEBUG] ==========
2015-06-24 10:45:32 0 [DEBUG] CSVI Pro Version: 6.0rc1
2015-06-24 10:45:32 0 [DEBUG] PHP version: 5.3.13
2015-06-24 10:45:32 0 [DEBUG] Action: import
2015-06-24 10:45:32 0 [DEBUG] Component: com_fastseller
2015-06-24 10:45:32 0 [DEBUG] Operation: producttypename
2015-06-24 10:45:32 0 [DEBUG] Source: fromupload
2015-06-24 10:45:32 0 [DEBUG] Load from computer: Z:/home/http://test3.by/www/tmp/com_csvi/1435142723/тип детали.csv
2015-06-24 10:45:32 0 [DEBUG] Load from server:
2015-06-24 10:45:32 0 [DEBUG] Delete after import: No
2015-06-24 10:45:32 0 [DEBUG] Load from URL:
2015-06-24 10:45:32 0 [DEBUG] FTP Host:
2015-06-24 10:45:32 0 [DEBUG] FTP Port:
2015-06-24 10:45:32 0 [DEBUG] FTP Root Folder:
2015-06-24 10:45:32 0 [DEBUG] FTP Filename:
2015-06-24 10:45:32 0 [DEBUG] Auto detect delimiters: Yes
2015-06-24 10:45:32 0 [DEBUG] Field Delimiter: comma
2015-06-24 10:45:32 0 [DEBUG] Text Enclosure: "
2015-06-24 10:45:32 0 [DEBUG] Use file extension:
2015-06-24 10:45:32 0 [DEBUG] I'm Mac: No
2015-06-24 10:45:32 0 [DEBUG] Use file for configuration: Yes
2015-06-24 10:45:32 0 [DEBUG] Add extra fields: No
2015-06-24 10:45:32 0 [DEBUG] Skip first line: No
2015-06-24 10:45:32 0 [DEBUG] Overwrite existing data: Yes
2015-06-24 10:45:32 0 [DEBUG] Skip new items: No
2015-06-24 10:45:32 0 [DEBUG] Record name:
2015-06-24 10:45:32 0 [DEBUG] Lines per import: 1000
2015-06-24 10:45:32 0 [DEBUG] Time between imports: 5
2015-06-24 10:45:32 0 [DEBUG] Override system limits?: No
2015-06-24 10:45:32 0 [DEBUG] Maximum execution time:
2015-06-24 10:45:32 0 [DEBUG] Maximum amount of memory:
2015-06-24 10:45:32 0 [DEBUG] Maximum size of POST data in megabytes:
2015-06-24 10:45:32 0 [DEBUG] Maximum allowed size for uploaded files in megabytes:
2015-06-24 10:45:32 0 [DEBUG] ==========
2015-06-24 10:45:32 1 [DEBUG] Use field value for field product_sku
2015-06-24 10:45:32 1 [DEBUG] Use field value for field product_type_name
2015-06-24 10:45:32 1 [DEBUG] Use field value for field type_parts
2015-06-24 10:45:32 1 [DEBUG] Process line 1
2015-06-24 10:45:32 1 [DEBUG] Find the product type ID for type parts
2015-06-24 10:45:32 1 [QUERY] SELECT `product_type_id` FROM `vwqda_fastseller_product_type` WHERE `product_type_name` = 'type parts'


3. :) Import works FastSeller Product type Import only when indicated specify produkt_id File CSV. :)
Name of the column
product_id; product_type_name; type_parts.
0
Responses (7)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The XLS issue is an error indeed, I have fixed this as it was a change that wasn't made in the XLS handler. Thank you for reporting that.

As for the CSV file, there is an issue in your CSV file from the small part you posted 
product_sku; product_type_name; type_parts
there shouldn't be any spaces in the column headers.

Also you use ; as field delimiter but in the log file I can see this Found field delimiter: , so that doesn't match. You can set the options Auto-detect delimiters to No in your template and specify your own template delimiter.

The reason it works with the product ID is because it is a direct number, if you use product_sku, you must also include the column extension and specify for which extension your use FastSeller. In your case this would be virtuemart.
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. # 1
denis_kr
denis_kr
Accepted Answer Pending Moderation
Hello,
When I export the goods, I can turn on the column extension and specify the extension virtuemart.
It's all good.
When importing the goods, I can not include the column extension virtuemart, when I use product_sku.
That is the problem.
Please Show me how I can do it.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Denis,

Why can't you use the field extension on import?
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. # 3
denis_kr
denis_kr
Accepted Answer Pending Moderation
I can't use because it simply does not have this field extension on import
Attachments (5)
2015-06-25_162549.jpg 2015-06-25_162549.jpg
2015-06-25_162612.jpg 2015-06-25_162612.jpg
2015-06-25_162700.jpg 2015-06-25_162700.jpg
2015-06-25_163210.jpg 2015-06-25_163210.jpg
testtype22.xls
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
You have the field shown in your screenshot and in your XLS file, so what is the problem?
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. # 5
denis_kr
denis_kr
Accepted Answer Pending Moderation
:( hi, error again and no imports.
Attachments (3)
importxsl_1.jpg importxsl_1.jpg
click_start_import.jpg click_start_import.jpg
xsl_files.jpg xsl_files.jpg
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Denis,

This error is new and something I have never seen before. Can you sent me a private message with login details for the website and FTP. Also include the name of the template you are using and the file you are trying to import. I will take a look to see why this happens.
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. # 7
  • Page :
  • 1


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