Magento

Hi Dweeves,
there is an issue i want to know how to do.
I switched to “Generic SQL Datasource” for importing product. I´ve created a Table within Magento and fill this with “DBSync” from my MSSQL database. Every thing works but german charakters. In the new Table are Field like “name” correctly shown ( Example : “HP Officejet Multifunktionsgerät , 4800dpi ...")
But when i start the query like :

“SELECT ...,name,.. FROM <my_tablename>”
and Products are imported then name shows for Example : “HP Officejet Multifunktionsger”
instead of
“HP Officejet Multifunktionsgerät , 4800dpi ...”
The Name is cutted at “ä”. Same with “ä,ü,ö,ß”

Can You help me ?

bye
Kepir

Hello,
sorry if the answer has already been discuss but I didn’t found it.

I’ve got a problem using image attribut processor.
in my csv file I’ve the colomn image, small_image, thumbnail and the same for label.
I’ve put in this d/_/d/dcat1.jpeg for example the plugin media/catalog/product/ is the root for image processor.
and each time I’ve got this error message and I don’t know what is wrong ? I can not put subfolder path ?
should I create a colomn name base product image for magmi in my csv ? and if yes how to tell image processor that the image are in this colomn ?

here is the error code :

Image attributes processor v1.0.17 - error copying ../../media/catalog/product/d/_/d_chat_1.jpeg : 8,fgetcsv() [function.fgetcsv]: enclosure must be a single character
Image attributes processor v1.0.17 - no_selection not found, skipping image
Image attributes processor v1.0.17 - error copying ../../media/catalog/product/d/_/d_chat_1.jpeg : 8,fgetcsv() [function.fgetcsv]: enclosure must be a single character
Image attributes processor v1.0.17 - error copying ../../media/catalog/product/d/_/d_chat_1.jpeg : 8,fgetcsv() [function.fgetcsv]: enclosure must be a single character

thanks a lot really.
Antoine

@kepir

You need to send the following statement to the DB :

@auarstadt

1) media/catalog/product canot be used as import source “directory” by magmi since its the “final destination” directory where magmi will finally copy imported images (since it’s where magento will read them)

so , if you have images to import, please do not put them in the destination folder but somewhere else before importing, otherwise magmi will try to copy files over themselves which won’t work (or use “keep existing images” setting in magmi image processor plugin which may prevent the undoable copy)

2) it seems that magmi complains about your CSV enclosure. as said in the error, it must be a single char.  Please ensure you have “magic_quote_gpc” flag set to off in your php config.

Dear Dweeves

Thanks for your cool tool. I’m trying to import grouped products (type="grouped")

I have a Group Product and several hidden products attached to this group product.

I did not find out, how to import this, but I’m quite sure its possible.

Can you give me a hint?

Thanks a lot for your quick answer.

I don’t know exactly where I can check this parameter in my php since I don’t really know the php langage. Can you explain more please or give me a link ? otherwise I’m gonna make search over the forum.
thanks a lot again.
kind regards.
Antoine

auarstadtt - 19 July 2011 07:27 AM

I don’t know exactly where I can check this parameter in my php since I don’t really know the php langage. Can you explain more please or give me a link ?

This parameter is initialized on the activ php.ini file on your server.
To see your PHP config:
1. Create a file named phpinfo.php using the notepad of your computer.
2. In this file insert this line:

PS: it seems I saw you already somewhere, is’nt it ? 

I got trouble for my database settings, the database table prefix I used is ss, not ss_ , when I put ss in table prefix got the following error
ss_core_website’ doesn’t exist
my table is sscore_website
please help

dweeves - 18 July 2011 11:40 PM

@kepir

You need to send the following statement to the DB :

SET NAMES 'utf8'

before issuing the request.
Magmi has a field “Input DB Initial Statements” that you can use for that.

Thank you dweeves,
now it works. Thanks.

There is an other issue :

PHP Notice:  Undefined variable: gattdesc in /var/www/magmi/plugins/extra/itemprocessors/imageprocessor/imageitattributeemprocessor.php on line 601
PHP Notice:  Undefined index: page_layout in /var/www/magmi/engines/magmi_productimportengine.php on line 600

What about this ?

bye

Hello Dweeves,

An absolutely excellent tool. Thank you very much for it\’s creation.

Just getting my head around it and hit a slight wall with the Value Replacer. I want to format the Categories field I have to use the auto category creation element. The are comma separated, which is fine, except that some are as below:

So I need to only replace the comma-space outside the quotation marks.

I have the preg_replace function, and it works upon testing: http://f99e.freephptest.com/.

The code is:

However, when I save this, the code both doesn\’t work, and the value of the value of the box configuring the replacer is changed to:

Is there a limit on the field size? Or is it objecting to the /e perhaps?

Thanks again for the tool eitherway, is extrememly useful!

Thanks,

Alex

Hi Alex,

Glad you use the full power of magmi with complex value replacer expressions.

The problem comes from “ (double quote) char that conflicts with parameter saving.

try this instead

this may work better (\x22 being the char value for double quote)

Thanks for you quick, and accurate reply! That did the trick!

This is great, but the ability to use utf8_encode on the value replace has been a real life saver!

I\’m still working through the myriad functions it offers, possibly images next! But it really has been a revelation!

Many thanks,

Alex

Edited wiki to document restriction on double quote usage in value replacer.

Hi,
I don’t know if you remember, I run across this issue a while ago.
I’ll start from end to start.

Image attributes processor v1.0.17 - no image attributes found in datasource, disabling image processor
Column mapper v0.0.3 - Replacing Column pics by image
Column mapper v0.0.3 - Replicating Column pics to small_image,thumbnail

I also have Value Replacer v0.0.5 to replace pics to image.
There is no problem, I can easily change my csv but I wanted to let you know. In this scenario image processor hit first and obviously there are no images columns yet.

Hi Dweeves,

I have been reading the Wiki and this thread for some hours now, but can’t seem to find an answer to my question:

Is it possible to let Magmi auto-create product attributes + values within a attribute-set (for simple products) during import?

Thanks for your great importer!
Michiel

-------
Thanks for your answer (below)