Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

AMartinez_CustomImportExport 1.5 extension: import/export/and more…! 
 
wervisser
Member
 
Total Posts:  55
Joined:  2009-11-12
 

First of all, thanks to everyone for the efforts of this module. I have read many topics about it and it sounds perfect to import products with even associated ones. This would definitely safe my day since I am creating a new version of my shop in 1.5.0.1.

But, even after reading all these posts and looking at the files installed via Magento Connect I am in a total dark about how it is supposed to work.

Can I just look at the options in a product and use these names as columns in my CSV ? So, for instance the name Price in my product creation page can be used as a column title ?
If I would like to create new categories I would use the column headers .... store, websites, sku, categorie and put in the values of my config. I would then fill in the categorie colums as Categorie1,Categorie2. These values don’t exist at the moment.

I hope this is a bit clear for interpretation… grin

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

First try to run the included csv examples.

Then, add manually some product, export it and analyze result csv smile

PM me if you have more issues

 
Magento Community Magento Community
Magento Community
Magento Community
 
giallu26
Jr. Member
 
Total Posts:  10
Joined:  2011-05-06
 
amartinez - 12 May 2011 12:23 AM

giallu26 - 12 May 2011 12:18 AM
amartinez - 11 May 2011 06:08 AM
@giallu26:

tgz updated

in any case, you can do:

./mage mage-setup
./mage install community (magento connect key)

I think Varien track these clicks, so please click on magento connect :D

did you mean that I can create a tarball in that way?
anyway you forgot to put the updated tgz in the first post :D :D

please get it from magentoconnect It’s easy for me smile

I don’t understand: you are telling me “I don’t provide a stand alone tgz because I prefer to distribute it from magento connect”?
can I download it from magento connect? I don’t see any links for files! help :D
At the moment I’m not interested to install your plugin, I’d like to make changes before that smile

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

please click “get extension key”

check “By checking this box I agree to the extension license agreement.”

click “get extension key” again

you can put that key in your magento administrator, “magento connect manager” (or from command line, by typing: ./mage mage-setup ; ./mage install community <extension>)

regards!

 
Magento Community Magento Community
Magento Community
Magento Community
 
giallu26
Jr. Member
 
Total Posts:  10
Joined:  2011-05-06
 

can you tell me at last what files are added in magento with your plugin?

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

sure!

app/etc/modules/AMartinez_CustomImportExport.xml

app
/code/community/AMartinez/
app/code/community/AMartinez/CustomImportExport
app
/code/community/AMartinez/CustomImportExport/shell
app
/code/community/AMartinez/CustomImportExport/shell/run.php
app
/code/community/AMartinez/CustomImportExport/Helper
app
/code/community/AMartinez/CustomImportExport/Helper/Data.php
app
/code/community/AMartinez/CustomImportExport/etc
app
/code/community/AMartinez/CustomImportExport/etc/config.xml
app
/code/community/AMartinez/CustomImportExport/Model
app
/code/community/AMartinez/CustomImportExport/Model/Import
app
/code/community/AMartinez/CustomImportExport/Model/Import/Adapter
app
/code/community/AMartinez/CustomImportExport/Model/Import/Adapter/Csv1.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Adapter.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Customer.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Customer
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Customer/Address.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Product.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Product
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Product/Type
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Product/Type/Configurable.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Product/Type/Grouped.php
app
/code/community/AMartinez/CustomImportExport/Model/Import/Entity/Product/Type/Simple.php
app
/code/community/AMartinez/CustomImportExport/Model/Export.php
app
/code/community/AMartinez/CustomImportExport/Model/Backup.php
app
/code/community/AMartinez/CustomImportExport/Model/Import.php

var/customimportexport/
var/
customimportexport/test_none.csv
var/customimportexport/test_single_row_style.csv1
var/customimportexport/test_configurable.csv
var/customimportexport/test_grouped.csv

thank you for your collaboration,

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sjixxxy
Jr. Member
 
Total Posts:  2
Joined:  2010-11-09
 
amartinez - 11 May 2011 01:40 PM

For .csv files you must put every category name in new lines:
...
hope it helps!

Thanks for the reply! Though I think I need to restate my questions better. I’m attaching some screen shots to help illustrate.

category1.png represent a hand made category & sub category with a single products in it. If I export that product, and re import it into a fresh Magento install, category2.png shows how the category gets created via your script.

Instead of a category & subcategory, it just creates a single category with a / in the name.

Make sense?

Image Attachments
category1.pngcategory2.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
VernBurton
Jr. Member
 
Total Posts:  23
Joined:  2011-02-22
Rochester, MN
 

I am having the same issues.  I have attached a png of my csv

Sjixxxy - 12 May 2011 05:36 AM

amartinez - 11 May 2011 01:40 PM

For .csv files you must put every category name in new lines:
...
hope it helps!

Thanks for the reply! Though I think I need to restate my questions better. I’m attaching some screen shots to help illustrate.

category1.png represent a hand made category & sub category with a single products in it. If I export that product, and re import it into a fresh Magento install, category2.png shows how the category gets created via your script.

Instead of a category & subcategory, it just creates a single category with a / in the name.

Make sense?

Image Attachments
csv.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
VernBurton
Jr. Member
 
Total Posts:  23
Joined:  2011-02-22
Rochester, MN
 

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.

Image Attachments
category.pngprod-category.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
amartinez
Guru
 
Avatar
Total Posts:  347
Joined:  2008-11-14
Spain
 

about 009 categories creation:

I apologize! I make some changes, and detect some bugs smile

I will solve it fastest!

Thank you all for your support!

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

Hi Martinez!
I’ve set up a magento installation, and created all attributes that I need for a product like this

http://i54.tinypic.com/zksmfn.png

after that I created a csv file for importing (here the header http://pastebin.com/bptWrTcF )

http://pastebin.com/RQPCnwMd

when I run the script I get

http://pastebin.com/CV1jA9kN

I missed something, but what?

thanks!

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

it was my mistake, resolved, thanks anyway

 
Magento Community Magento Community
Magento Community
Magento Community
 
lotusseedsD
Mentor
 
Avatar
Total Posts:  1144
Joined:  2007-08-31
 
amartinez - 12 May 2011 12:04 AM

please get this “real” example…

this one merges csv1 features (categories, associated sku’s) with csv style (multi-stores)

hope it helps!

Thanks for the sample file! WIll test it asap.

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

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
 
infrid
Member
 
Total Posts:  42
Joined:  2011-05-12
 

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
Magento Community
Magento Community
Back to top