Product Specification Attribute import - Attribute types?

Hello,
I'm trying to import a set of Specification attributes for products already in catalog, using the sku as key; these attribute are of the of the custom HTML type, but I don't think I'm setting the attribute type correctly. I've tried using , in the "Attribute type" column, both "Custom HTML text" and "10" (MultilineTextbox, as in here https://www.foxnetsoft.com/the-list-of-possible-values-for-import-manager ) but it updates 0 columns.

Here is my column mapping :
Column source  Column destination
sku  Key (Product Key)  
Type  Attribute type  
Attribute  SpecificationAttribute  
Value  Value

and then in my excel I have something like this for the first try:
sku  Name  Type  Attribute  Value
XYZ  FARINA   Custom HTML text  Ingredienti  <p>Lorem ipsum</p>

and for the second try:
sku  Name  Type  Attribute  Value
XYZ  FARINA   10  Ingredienti  <p>Lorem ipsum</p>

What am I doing wrong? I will also need to import a localized version of the same attributes

/// <summary>
    /// Represents a specification attribute type
    /// </summary>
    public enum SpecificationAttributeType
    {
        /// <summary>
        /// Option
        /// </summary>
        Option = 0,

        /// <summary>
        /// Custom text
        /// </summary>
        CustomText = 10,

        /// <summary>
        /// Custom HTML text
        /// </summary>
        CustomHtmlText = 20,

        /// <summary>
        /// Hyperlink
        /// </summary>
        Hyperlink = 30
    }


You forget about option value. Each specification attribute must have option and nopcommerce uses this option for mapping specification attributes.
Try it
sku  Name  Type  Attribute  Value Option
XYZ  FARINA   20 Ingredienti  <p>Lorem ipsum</p>  OptionName

and remember about separator.
You want to add HTML custom value in the specification attribute but you need to add option for mapping.

Hi, it worked! Thank you very much.
I'm having difficulties with the attribute value localization though.

I've created a new template "Localized values - Product Attribute Value", and mapped it as follows:

Sku  Key (Product Key)  
Attribute  ProductAttribute  (I've tried using both the italian and the english value)
Value  ProductAttributeValue  
Lingua  LanguageId

I've only left out "name" because I guess it refers to the product name

My XLSX is composed like this:

Sku  Attribute  Value  Lingua
FAR001001  Ingredients  <p>EN ingredients for FAR001001</p>  1
FAR001002  Ingredienti  <p>EN ingredients for FAR001002</p>  1
FAR001001  Did you know?...  <p>EN did you know for FAR001001</p>  1
FAR001002  Curiosità  <p>EN did you know for FAR001002</p>  1


The result is Success but with 0 rows updated. In this template, there no Attribute Option to map. Other localization templates don't allow to localize the attribute value, which is the only thing I need to localize

Thank you in advance,
V

Attribute
Do you use the primary attribute name?

yes, for example "Ingredienti" is the Standard specification attr. name

One moment.
Do you want to add localized values for
Product Attribute Value
or
Product Attribute?

Support wrote:

I want to localize the value, on the previous post I was answering this question

"Localized values - Product Attribute Value"

You need to set
Key,
ProductAttribute   - the plugin will sue this parameter for looking for product attribute
ProductAttributeValue   - the plugin will sue this parameter for looking for product attribute value
LocalizedValue  
LanguageID

Support wrote:

I did set all these, except for LocalizedValue, which is not available in the "column destination" select

Any updates?

Key;ProductAtribute;ProductAttributeValue;Language;Name
COMP_CUST;Processor;2.2 GHz Intel Pentium Dual-Core E2200;1;Russian

Product Attribute Value has only one localized value. It name "Name". You need to add this "Name"  in mapping.

Hi, unfortunately still 0 rows updated. My excel is this, with the last column mapped on "Name" as you suggested:

Sku  Attribute  Value  Lingua  NomeLingua
FAR001001  Ingredients  <p>EN ingredients for FAR001001</p>  1  English
FAR001002  Ingredienti  <p>EN ingredients for FAR001002</p>  1  English
FAR001001  Did you know?...  <p>EN did you know for FAR001001</p>  1  English
FAR001002  Curiosità  <p>EN did you know for FAR001002</p>  1  English

Can you give me access to your nopcommerce instance?

Sure! At what email should I write you for the credentials and my import excel?

support@foxnetsoft.com

and upgrade please plugin, I want to be sure that you use the last release.

Hello, just checking in, have you received my email from last monday "RE: localized attribute import" to support@foxnetsoft.com?

Can you send me email again?
I can't find it

Email sent, from progettazione.web@node.coop

Please resend it
I found very old email at Jun 16.

I have already re-sent it, could it be the spam filter?