FAQs - Formulas

1. In an Excel export connector, I use a formula to replace the commas with dots of a decimal number stored in a text field. In the test it works, but when opening the file it comes out with commas again. Why?

R: It is not a change from Sales Layer, but from Excel itself that changes the number adapting it to the country norm configured in Windows. The change should be configured from there.

2. In a connector, how can I export the URLs of an image or file type field in all different languages?

R: In this case, it is not possible to obtain the URLs in the different languages of the image or file field using only one formula. To obtain the URLs, the corresponding languages must be enabled in the connector parameters and the following formula must be used in the image or file field: PRINT ({Field_Name.source}).

3. In a connector, how can I get the names and URLs of the clippings of the images?

R: The file names can be changed in certain cases. Spaces are not replaced in the original image, but they are in different sizes, configured in the account. This is due to internal, non-customizable criteria.

When the connector ejects an image thumbnail, the generated name, by which the URL is built, is based on the original product name. If the name of a product is modified, the URLs of its thumbnails will not vary the fragment of the URL, corresponding to the name of the product. You can export names from images using the PRINT formula ({product_image}).

This formula ejects image names that are saved in the respective fields of Sales Layer. The cutouts you have created do not have different names. So, if we use the PRINT formula ({product_image.name.THM}) the result would always be the same. When the connector ejects the.Org file, the name is originally set up, even if it is changed later. If you want to eject the name of the file in its latest version and with the same nomenclature as one of the other exported sizes, you must use the formula PRINT ({nombre_del_campo.org}).

Removing URLs from the clippings it is as easy as indicating the clippings in the formula. For example, to eject the THM size you can use the following formula: PRINT ({product_image.THM}).  It is also possible to work with some variations of it to obtain different results:

The formula {product_image.all.THM} returns the URL of the image files if there are multiple ones.

Using it this way {product_image.1.THM} , it returns the first THM size image in the gallery.