Custom field import
Avatar image
Feb 14, 2013
Francesco wrote
Hi,
I'm looking a way to import from a csv file data to custom fields, how can I do it? Wich expression must have the csv file to import data to custom field?

Many thanks
Reply
10 Answers
Avatar image
Feb 15, 2013
Kateryna Beliukh agent wrote
Thank you for question!

You need to assign column, which contains custom fields data to appropriate database field. Please, check screenshot: http://screencast.com/t/IvV5D1I5FCustom fields feature will be fully supported in next release of Store Manager, which will be available within 2 weeks.

Let us know if any additional questions occur.
Avatar image
Feb 15, 2013
Francesco wrote
Thanks for your reply. My question comes because I saw the "custom field" row in the "link .csv Colums to Database fields" step of the import operation, and I would like to know how Store Manager can assigns data to correct custom field. I.E. if I have two custom fields how I can import data to the right one?
Do you think i have to wait next release? The link you have posted is broken!
Thanks again..
Avatar image
Feb 18, 2013
Kateryna Beliukh agent wrote
Thank you for reply.

Sorry, link was merged with text. Here is correct one: http://screencast.com/t/IvV5D1I5F

In .csv file you need to specify custom fields data in following format:

1custom field name|custom field value|price
2custom field name|custom field value|price
3custom field name|custom field value|price

Data will be automatically assigned to appropriate custom fields.

Avatar image
Feb 18, 2013
Francesco wrote
Great news,
You save me! Thanks a lot!!!
Avatar image
Feb 18, 2013
Francesco wrote
Hi, another one question.. If I have two custom field, how I can put this data in one row? Maybe whit this format:

Customfield1|CustomValue1|price1,Customfield2|CustomValue2|Price2

I'm right?
Thanks
Avatar image
Feb 18, 2013
Francesco wrote
Nope, I tried but the import process works only for first custom field..
How can I add also the second custom field with one import process only? Which is the right expression to do it?

Thank you for your help and for your patience..
Avatar image
Feb 19, 2013
Kateryna Beliukh agent wrote
Thank you for reply.

Each new custom field should be specified in next row. Please, try to use format I have provided you with:1custom field name|custom field value|price
2custom field name|custom field value|price
3custom field name|custom field value|price
Let us know if additional questions occur!
Avatar image
Feb 19, 2013
Francesco wrote
Thanks again..

Sorry but I don't understand how I can put different data in the same column of a CSV file..
You can see a image of my csv file here http://www.screencast.com/t/hwSkkGElld7T probably is more explicative than me. I have more than one custom field, but in Import process I can select only one column to assign to custom field (column 5, or column 6 or column 7), How I can add all of the three columns?
Avatar image
Feb 20, 2013
Kateryna Beliukh agent wrote
Please, submit a ticket here:
http://support.emagicone.com/submit_ticket

and attach you .csv file and store connection configuration file. You can save you store configuration file at: Store Manager > Preferences(F12) > Database Connection tab > Store Configuration section > Actions... > Save current configuration http://screencast.com/t/Hmy0nUDBsHJc
We will import custom fields for you from our side.
Avatar image
Feb 20, 2013
Francesco wrote
Ok, thanks you!