search

BlackbitDigitalCommerce / pimcore-data-director

Import Bundle for Pimcore
16 stars 3 forks source link

Public URLs on Excel export #90

Closed jarinirv closed 1 year ago

jarinirv commented 1 year ago

Let's say I've field 'mainpic' and it is a pic within Assets. With XLSX-export I've tried eg 'mainpic:url' among other choices but nothing seems to work, I just get empty field where I'd expect public url, which btw works. Same applies with PDF-files but normal text-fields are exported just fine. Suggestions?

BlackbitDevs commented 1 year ago

Have you set the Main Domain in Pimcore's system settings?

Bildschirmfoto 2023-04-19 um 08 19 23

Exports run as CLI processes, so there is no HTTP request which can be used for retrieving the domain. For this reason the url helper depends on above setting to generate URLs.

jarinirv commented 1 year ago

Nope but that's now fixed. This, unfortunately, did not solve the issue but I got some good progress. Now I get that path visible in Preview which was not the case earlier. So to get the url to Excel I guess I have to continue with attribute mappings. Thanks for the help.

jarinirv commented 1 year ago

Forgot to close this. Let's say that I have that I have in DAM a folder 'Product pictures and attachments', below it a subfolder 'Product 1' and there mainpic.png. In DD's settings\Data Query Selector need to use ':url' and nothing else to get that field to output. It would then result in DD's Settings Example Data https://host.maindomain/Product pictures and attachments/Product 1/mainpic.png and in DD's Preview https://host.maindomain/Product%20pictures%20and%20attachments/Product%20 1/mainpic.png.