Magento Forum

   
AMartinez_CustomImportExport 1.5 extension: import/export/and more…! 
 
gmgarcia53
Jr. Member
 
Total Posts:  19
Joined:  2011-01-28
 

Hi Martinez,

Will your extension work with version 1.5.1.0?

Thanks,

 
Magento Community Magento Community
Magento Community
Magento Community
 
infrid
Member
 
Total Posts:  42
Joined:  2011-05-12
 
infrid - 16 May 2011 05:28 AM

I’ve just used your example csv in a new installation, everything seems ok but in the admin panel I can’t see any simple products associated to the configurable one.

http://img200.imageshack.us/img200/481/2011051613055559391280x.png

solved, if you have the same problem check how your attribute is created, it should be like this

http://i56.tinypic.com/10zpjbb.png

 
Magento Community Magento Community
Magento Community
Magento Community
 
infrid
Member
 
Total Posts:  42
Joined:  2011-05-12
 

now I’m trying to import my configurable product with multiple _super_attribute_code, for this feature I’ve modified Csv1.php for read multiple values in that field http://pastebin.com/Dz7bwQ24

after that I’ve added more attribute to my configurable product like this (note “color,size")

163830,configurable,base,Default,2011-4-8,,1,4,1,1,,,345,2,"nome ",prodottoconfigurabile,blablabla,,"color,size",,163830,"HXW00N06001 CR0",1,HOGAN,300,"HOGAN ",2,AC,052,SCARPE,20,,,

but when i run the script I get this error

infrid@casper:/var/www/magento/app/code/community/AMartinez/CustomImportExport/shellphp run.php -/home/infrid/htdocs/migrazione-mg/out_magento.csv 
Start 
'replace' action (products source file: /home/infrid/htdocs/migrazione-mg/out_magento.csvraw line count178)
PHP Fatal error:  Uncaught exception 'Mage_Core_Exception' with message 'File /home/infrid/htdocs/migrazione-mg/out_magento.csv.tmp.0.csv contains 2 corrupt records (from a total of 178)
:::: Attribute with this code is not super ::::
In Line(s) 89, 145
in /var/www/magento/app/Mage.php:550
Stack trace
:
#0 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(110): Mage::throwException('File /home/infr...')
#1 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(586): AMartinez_CustomImportExport->run()
#2 {main}
  
thrown in /var/www/magento/app/Mage.php on line 550

Fatal error
Uncaught exception 'Mage_Core_Exception' with message 'File /home/infrid/htdocs/migrazione-mg/out_magento.csv.tmp.0.csv contains 2 corrupt records (from a total of 178)
:::: Attribute with this code is not super ::::
In Line(s) 89, 145
in /var/www/magento/app/Mage.php:550
Stack trace
:
#0 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(110): Mage::throwException('File /home/infr...')
#1 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(586): AMartinez_CustomImportExport->run()
#2 {main}
  
thrown in /var/www/magento/app/Mage.php on line 550

color and size are set up correcly (I think), when I import with only one super attribute everything is ok. Where is the problem?

thanks!
and thanks for this plugin, is very useful and it’s help me a lot smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
infrid
Member
 
Total Posts:  42
Joined:  2011-05-12
 

or this

infrid@casper:/var/www/magento/app/code/community/AMartinez/CustomImportExport/shellphp run.php -/home/infrid/htdocs/migrazione-mg/out_magento.csv 
Start 
'replace' action (products source file: /home/infrid/htdocs/migrazione-mg/out_magento.csvraw line count178)
PHP Fatal error:  Uncaught exception 'Mage_Core_Exception' with message 'File /home/infrid/htdocs/migrazione-mg/out_magento.csv.tmp.0.csv contains 90 corrupt records (from a total of 178)
:::: Attribute with this code is not super ::::
In Line(s) 89, 145

:::: Orphan rows that will be skipped due default row errors ::::
In Line(s) 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178
in /var/www/magento/app/Mage.php:550
Stack trace
:
#0 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(110): Mage::throwException('File /home/infr...')
#1 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(586): AMartinez in /var/www/magento/app/Mage.php on line 550

Fatal errorUncaught exception 'Mage_Core_Exception' with message 'File /home/infrid/htdocs/migrazione-mg/out_magento.csv.tmp.0.csv contains 90 corrupt records (from a total of 178)
:::: Attribute with this code is not super ::::
In Line(s) 89, 145

:::: Orphan rows that will be skipped due default row errors ::::
In Line(s) 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178
in /var/www/magento/app/Mage.php:550
Stack trace
:
#0 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(110): Mage::throwException('File /home/infr...')
#1 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(586): AMartinez in /var/www/magento/app/Mage.php on line 550

 
Magento Community Magento Community
Magento Community
Magento Community
 
VernBurton
Jr. Member
 
Total Posts:  23
Joined:  2011-02-22
Rochester, MN
 
infrid - 16 May 2011 04:18 AM

Hi,
I’ve some problems during the import, i get this message

infrid@casper:/var/www/magento/app/code/community/AMartinez/CustomImportExport/shellphp run.php -/home/infrid/htdocs/migrazione-mg/out_magento.csv
Start 
'replace' action (products source file: /home/infrid/htdocs/migrazione-mg/out_magento.csvraw line count178)
PHP Fatal error:  Uncaught exception 'Exception' with message 'Notice: unserialize(): Error at offset 97202 of 97220 bytes  in /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php on line 123' in /var/www/magento/app/code/core/Mage/Core/functions.php:245
Stack trace
:
#0 [internal function]: mageCoreErrorHandler(8, 'unserialize(): ...', '/var/www/magent...', 123, Array)
#1 /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php(123): unserialize('a:178:{i:0;a:34...')
#2 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(1022): Mage_ImportExport_Model_Mysql4_Import_Data->getNextBunch()
#3 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(318): Mage_ImportExport_Model_Import_Entity_Product->_saveProducts()
#4 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Abstract.php(523): Mage_ImportExport_Model_Import_Entity_Product->_importData()
#5 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import.php( in /var/www/magento/app/code/core/Mage/Core/functions.php on line 245

Fatal errorUncaught exception 'Exception' with message 'Notice: unserialize(): Error at offset 97202 of 97220 bytes  in /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php on line 123' in /var/www/magento/app/code/core/Mage/Core/functions.php:245
Stack trace
:
#0 [internal function]: mageCoreErrorHandler(8, 'unserialize(): ...', '/var/www/magent...', 123, Array)
#1 /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php(123): unserialize('a:178:{i:0;a:34...')
#2 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(1022): Mage_ImportExport_Model_Mysql4_Import_Data->getNextBunch()
#3 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(318): Mage_ImportExport_Model_Import_Entity_Product->_saveProducts()
#4 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Abstract.php(523): Mage_ImportExport_Model_Import_Entity_Product->_importData()
#5 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import.php( in /var/www/magento/app/code/core/Mage/Core/functions.php on line 245

I use this csv file http://pastebin.com/LPuYw9sH

why I get those errors?

many thanks

Can’t have non UTF-8 characters in the import

 
Magento Community Magento Community
Magento Community
Magento Community
 
VernBurton
Jr. Member
 
Total Posts:  23
Joined:  2011-02-22
Rochester, MN
 
infrid - 17 May 2011 01:24 AM

or this

infrid@casper:/var/www/magento/app/code/community/AMartinez/CustomImportExport/shellphp run.php -/home/infrid/htdocs/migrazione-mg/out_magento.csv 
Start 
'replace' action (products source file: /home/infrid/htdocs/migrazione-mg/out_magento.csvraw line count178)
PHP Fatal error:  Uncaught exception 'Mage_Core_Exception' with message 'File /home/infrid/htdocs/migrazione-mg/out_magento.csv.tmp.0.csv contains 90 corrupt records (from a total of 178)
:::: Attribute with this code is not super ::::
In Line(s) 89, 145

:::: Orphan rows that will be skipped due default row errors ::::
In Line(s) 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178
in /var/www/magento/app/Mage.php:550
Stack trace
:
#0 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(110): Mage::throwException('File /home/infr...')
#1 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(586): AMartinez in /var/www/magento/app/Mage.php on line 550

Fatal errorUncaught exception 'Mage_Core_Exception' with message 'File /home/infrid/htdocs/migrazione-mg/out_magento.csv.tmp.0.csv contains 90 corrupt records (from a total of 178)
:::: Attribute with this code is not super ::::
In Line(s) 89, 145

:::: Orphan rows that will be skipped due default row errors ::::
In Line(s) 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178
in /var/www/magento/app/Mage.php:550
Stack trace
:
#0 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(110): Mage::throwException('File /home/infr...')
#1 /var/www/magento/app/code/community/AMartinez/CustomImportExport/shell/run.php(586): AMartinez in /var/www/magento/app/Mage.php on line 550

Try this by hand Creating a Configurable Product

then try to make it via script.

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 

New 1.5.010 release!

- Create full path child categories (CAT/SUBCAT1,CAT2)
- Bugs fixed, solved some special combination of new multi-attribute options ("Orphan’s problem")
- Minor improvements…

Regards!

Image Attachments
Captura de pantalla 2011-05-18 a las 12.55.38.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
infrid - 13 May 2011 03:12 AM

it was my mistake, resolved, thanks anyway

Fine! You’re welcome!

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
infrid - 16 May 2011 04:18 AM

Hi,
I’ve some problems during the import, i get this message

infrid@casper:/var/www/magento/app/code/community/AMartinez/CustomImportExport/shellphp run.php -/home/infrid/htdocs/migrazione-mg/out_magento.csv
Start 
'replace' action (products source file: /home/infrid/htdocs/migrazione-mg/out_magento.csvraw line count178)
PHP Fatal error:  Uncaught exception 'Exception' with message 'Notice: unserialize(): Error at offset 97202 of 97220 bytes  in /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php on line 123' in /var/www/magento/app/code/core/Mage/Core/functions.php:245
Stack trace
:
#0 [internal function]: mageCoreErrorHandler(8, 'unserialize(): ...', '/var/www/magent...', 123, Array)
#1 /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php(123): unserialize('a:178:{i:0;a:34...')
#2 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(1022): Mage_ImportExport_Model_Mysql4_Import_Data->getNextBunch()
#3 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(318): Mage_ImportExport_Model_Import_Entity_Product->_saveProducts()
#4 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Abstract.php(523): Mage_ImportExport_Model_Import_Entity_Product->_importData()
#5 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import.php( in /var/www/magento/app/code/core/Mage/Core/functions.php on line 245

Fatal errorUncaught exception 'Exception' with message 'Notice: unserialize(): Error at offset 97202 of 97220 bytes  in /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php on line 123' in /var/www/magento/app/code/core/Mage/Core/functions.php:245
Stack trace
:
#0 [internal function]: mageCoreErrorHandler(8, 'unserialize(): ...', '/var/www/magent...', 123, Array)
#1 /var/www/magento/app/code/core/Mage/ImportExport/Model/Mysql4/Import/Data.php(123): unserialize('a:178:{i:0;a:34...')
#2 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(1022): Mage_ImportExport_Model_Mysql4_Import_Data->getNextBunch()
#3 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Product.php(318): Mage_ImportExport_Model_Import_Entity_Product->_saveProducts()
#4 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import/Entity/Abstract.php(523): Mage_ImportExport_Model_Import_Entity_Product->_importData()
#5 /var/www/magento/app/code/core/Mage/ImportExport/Model/Import.php( in /var/www/magento/app/code/core/Mage/Core/functions.php on line 245

I use this csv file http://pastebin.com/LPuYw9sH

why I get those errors?

many thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
vburton - 12 May 2011 08:00 AM

Also noticing that in .009, that it will create the product and the category, but it will not link the category to the product correctly.

Attached photos.

There’s solved in 010 release too smile

Regards!

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
infrid - 16 May 2011 05:28 AM

I’ve just used your example csv in a new installation, everything seems ok but in the admin panel I can’t see any simple products associated to the configurable one.

http://img200.imageshack.us/img200/481/2011051613055559391280x.png

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
gmgarcia53 - 16 May 2011 06:44 PM

Hi Martinez,

Will your extension work with version 1.5.1.0?

Thanks,

Yes, I always work with a latest updated svn version!

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
infrid - 17 May 2011 01:00 AM

infrid - 16 May 2011 05:28 AM
I’ve just used your example csv in a new installation, everything seems ok but in the admin panel I can’t see any simple products associated to the configurable one.

http://img200.imageshack.us/img200/481/2011051613055559391280x.png

solved, if you have the same problem check how your attribute is created, it should be like this

http://i56.tinypic.com/10zpjbb.png

Great!

Thank you again for test it!

 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 
infrid - 17 May 2011 01:08 AM

now I’m trying to import my configurable product with multiple _super_attribute_code…

Now you don’t need to do this smile

Please check the new 010 release feature:

You can define multi-valued fields with prefix “*” in csv header, like:

“sku”,"*_category", and so on…

Regards!

 
Magento Community Magento Community
Magento Community
Magento Community
 
mminna
Jr. Member
 
Total Posts:  6
Joined:  2011-05-17
 


Could you please provide a a \"how to\” for this extension. I am fairly new to Magento and an having a lot of problems importing a .csv file. I don\’t know what the columns need to be named.
Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top