Hot folder - Ignore field setting blank. Is it possible?

[Former Member]

Hi.

I have a csv file in the hotfolder for two operations, one of them set the base information of a product, and the other some complementary information.

After a import of this file, one field in the product, tagged as in the csv and with previous value is setted to blank.

Is it possible?

Best regards.

[Former Member]

Hi

I did not complete understand your question, it would be really helpful if you provide more details for your problem, with headers, and sample csv. But I will try to answer it with what I got.

To rephrase my assumption for your problem:

"You have a single csv file, which is being used for two mapping operations, one operation updates a basic set of attributes, and the other updates the a different set of complementary attributes for the same product. Once the import is over, that is both the operations are done, one of the attributes in the product, which previous had some data value, is now set as blank/null, even though it was set as ignore "

Now there could be two possible reason this could be happening:

1. The ignore value is not properly tagged in the row values, it has to be declared in angular brackets with ignore keyword:

There is a special value that makes ImpEx skip the entry and leave the item value at the one it currently is. This is useful in combination with the UPDATE mode, for example:

 value;<ignore>;<ignore>;value;value

This way, the values for column 2 and 3 are ignored and, their current values in the database are preserved.

If we leave them blank, then it will be treated as a null value for the corresponding attribute (or default value will be picked if defined, otherwise it pick it as null)

   value;;;value;value

In this case value for column 2 and 3 will be treated as null instead of ignore.

2. Other way is that there might be some issue with the header defined in the hot-folder spring file: For ideal use-case, you should only use those attribute in the header which you want to update, even if you are using the same file. You can actually skip entire columns in the csv if they are not relevant to the operation.

The ImpEx extension allows skipping of entire columns of data by omitting the attribute for that column in the header:

 INSERT myProduct;myAttribute;myAttribute2;;myAttribute4
 ;myValue1;myValue2;myValue3;myValue4

myValue3 is ignored, because there is no header attribute mapping defined for the related column.

These are again based on my assumption for your problem, if you use-case differs, please provide more details on it, i'll be happy to help.

Hope this help you solve your problem! Let me know if you still have issues with this.

Regards,