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
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
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.
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.
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..
Do you think i have to wait next release? The link you have posted is broken!
Thanks again..
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.
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.
Feb 18, 2013
Francesco
wrote
Great news,
You save me! Thanks a lot!!!
You save me! Thanks a lot!!!
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
Customfield1|CustomValue1|price1,Customfield2|CustomValue2|Price2
I'm right?
Thanks
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..
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..
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!
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!
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?
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?
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.
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.
Feb 20, 2013
Francesco
wrote
Ok, thanks you!