Category import - replace / to |

Category import - replace / to |

Feb 02, 2014
Elio - B-side Factory SAS wrote
Hi,
can you help me to create a sql function to replace a character for category import.
I've to change Home/Vini/spumanti to Root|Home|Vini|spumanti
So I've to change the character and I've to add Root| first.
Thanks in advance for your attention.
Ciao.

Reply
19 Answers
Avatar image
Feb 03, 2014
Support Manager agent wrote
Thank you for your interest.

Actually, there is no need to replace delimiter from '/' to '|' - you can simply select correct delimiter at 'Select Delimiter and Quote Character' step of import wizard (see attached)

Please use the following expression to add Root category during import: concat('Root/',[CSV_COL(x)])
where x = number of column from .csv file (see attached)

Let us know if you have more questions
Feb 03, 2014
Elio - B-side Factory SAS wrote
Oh thanks very much!!
You've been so clear.
I've another question!
Is there a way to skip a csv line when a value of a column of this line is equal to "matrix" for example.
Thanks!
Avatar image
Feb 04, 2014
Support Manager agent wrote
Thank you for your reply.

There is no need to skip a line from import for specified column values.

Let us know if you have more quetsions
Feb 04, 2014
Elio - B-side Factory SAS wrote
I've this example:
The export from another program is like this (csv file)

Type reference Combination reference Product name

Matrice taglie/colori DO.PA01
Variante taglie/colori DO.PA01 DO.PA01-F0500 Arbaria Passito di Pantelleria D.O.C
Variante taglie/colori DO.PA01 DO.PA01-F0750 Arbaria Passito di Pantelleria D.O.C

but I've to skip the first line (Matrice taglie/colori) because the 1st item doesn't exist, it's only a matrix wich contains DO.PA01-F0500 and DO.PA01-F0750

If I don't skip the first line (matrix) the result in the web is a double item like this:
http://www.vinotiamo.com/it/10-dolci

I don't know if I'm running the right way...

Can you help me?

Grazie!
Avatar image
Feb 05, 2014
Support Manager agent wrote
Thank you for your reply.

Store Manager does not allow to skip the line line during import. You can select to import from specific line or/and to specific line, but there is no way to skip the line if data in it contain specific text.

Let us know if you have more questions
Feb 05, 2014
Elio - B-side Factory SAS wrote
Ok! Thanks for your support!
Feb 05, 2014
Elio - B-side Factory SAS wrote
I found a trick... to set the same value to reference and combination reference of the matrix

IF([CSV_COL(1)]="Matrice taglie/colori",[CSV_COL(4)],[CSV_COL(3)])

So the import will not create a new product because the reference is the same... I hop it'll works.

Ciao!
Avatar image
Feb 06, 2014
Support Manager agent wrote
Thank you for letting us know.

Feel free to contact us if you need our assistance
Feb 08, 2014
Elio - B-side Factory SAS wrote
Sorry! Another big doubt...
I'm trying to concat this function:
concat('\\Bside_xp\ready\Ready_vinotiamo\vinotiamo_Files',[CSV_COL(16)])

but there's a problem with this character "\"... and the result is not right...

How can I fix this problem?

Thank you very much!!
Avatar image
Feb 10, 2014
Support Manager agent wrote
Thank you for your reply.

Please check if you have not used '\' as separator for values inside column during import (see attached screen-capture).

If the issue remains, let us know what result do you want to get after merging the value with column, so we could check and provide you with possible solution.

Waiting to hear from you
Feb 10, 2014
Elio - B-side Factory SAS wrote
Thanks for your reply.
Yes I checked '\' wasn't used as separator.
I installed your store mangager on my pc workstation while the images are on the server where I've another manager used in the shops.
A possible solution is probably uninstall store manager from my pc and install it on the server.
Have you other solutions?

Thanks!
Avatar image
Feb 11, 2014
Support Manager agent wrote
Thank you for your reply.

Actually issue occurred since you checked '\' as separator - you have to change it, since in this case data inside column is used as separate value

Let us know how it goes
Feb 13, 2014
Elio - B-side Factory SAS wrote
Ok thenk you! I've fixed the problem.
Now I'm trying to find a way to assign all category in a tree:
I've assigned for example this category Root|Home|Vini|dolci but I need to assign automatically even...
Root|Home
Root|Home|Vini
Is the a function?
Thanks very much for your help!
Avatar image
Feb 14, 2014
Support Manager agent wrote
Thank you for your interest.

In order to be able to assign the product to few categories during import, you need to specify path to each of them separated by double delimiter:
Root|Home||Root|Home|Vini||Root|Home|Vini|dolci

Let us know if you have more questions
Feb 14, 2014
Elio - B-side Factory SAS wrote
Thanks for your reply.
I thought there were an automatic function.
Thnaks for your help.
Mar 12, 2014
Elio - B-side Factory SAS wrote
Hi Ira,
can you help me how to import feature in different language?
Thanks!
Avatar image
Mar 13, 2014
Andrii Yanosh agent wrote
Hello Elio,

As we can see, the following screen capture has been taken from the Store Manager for PrestaShop.

In order to apply the multilingual features you have to create them first: http://screencast.com/t/PoVhlBJoIyG

Once the features have been created and translated for multiple languages, you can import Features using a default language values.
Mar 13, 2014
Elio - B-side Factory SAS wrote
Thank you for your reply.
Yes but I'd like to import a feature not like a fixed value but like a description (in default language it works)

Thanks

Avatar image
Mar 17, 2014
Andrii Yanosh agent wrote
Hello Elio,

Please submit a ticket at: http://support.emagicone.com/submit_ticket and provide us with your .csv file, and import configuration file (may be saved at the last step of Import Wizard), so we could check possible options for you.