Prepend not working when exporting data

Adrian Ursu

Posted on 15/04/2020 10:31:00

Hi guys,

I have a solution running DW 9.7.4 and I have been trying without success to output a feed with products.

First, I have tried using the EcomProvider to export a CSV Product feed containing product data (including images). I have selected ProductDefaultImage (because the old fields are already deprecated) but the field did not output anything although the products have images (stored in EcomDetails) and each product has an image set as Default.

Seeing that this did not work, I have decided to export it as an Excel file with EcomProducts and EcomDetails as separate sheets. The data is there for images but in order to make them usable, I need to add the HostName to each File path. I tried using the Prepend option in order to add the host name but I was again not successful.

Can anybody let me know if I am doing anything wrong? Isn't this how it is supposed to be working?

Thank you,

Adrian

Replies

Nicolai Pedersen

Posted on 15/04/2020 10:43:06

Please show screendumps of your setup

Adrian Ursu

Posted on 15/04/2020 13:23:27

Hi Nicolai,

Here is a video of the setup. I have shown the ProductDefaultImage being blank and the setup for prepend: https://drive.google.com/file/d/1DmTQc5d2E66fjw113_GO8PXtzELew4IE/view

Thank you,

Adrian

Adrian Ursu

Posted on 26/04/2020 15:09:22

Hi Nicolai,

Anything on this topic?

Thank you,
Adrian

Dmitriy Benyuk

Posted on 27/04/2020 10:04:46

Hi Adrian,
there is a problem in Excel provider as it has no feature implemented that can Append/Prepend/Set constant script values.
Could you use the CSV/Xml provider instead and do string search and replace with your needed "Prepend" value in the exported file and import it back?
Kind regards, Dmitrij

Nicolai Pedersen

Posted on 27/04/2020 10:05:38

The video does not work.

Please provide screendumps - thanks!

Adrian Ursu

Posted on 27/04/2020 13:15:53

Hi Nicolai,

The videos probably expired in the meantime.

I cannot post screendumps as the screendumps will not reveal nothing new. I am using standard fields with standard settings but the output is not what I have expected.

My situation has 2 issues:

1. I don't get anything in the ProductDefaultImage field

2. I cannot use prepend with Excel export

for #2 Dmitrij suggested I should use CSV with prepend but that won't help since I am trying to output a single file that can be downloaded by resellers. Excel had the benefit of having separate sheets for each table exported (EcomProducts and EcomDetails)

Which leads me to #1. If I can get the right value in ProductDefaultImage, I can export a single file just from EcomProducts and in this case I can use a CSV file and Prepend.

Thank you,
Adrian

Dan Kristensen Hørlyck

Posted on 20/05/2020 12:57:35

Hi Adrian,

We have added ability to append and prepend in ExcelProvider.

DW version: 9.8.6

Package: Dynamicweb.DataIntegration.Providers.ExcelProvider

Package version: 3.0.15

Sincerely,

Dan

Adrian Ursu

Posted on 20/05/2020 13:51:08

Hi Dan,

Cool!

Thank you very much for the confirmation.
Adrian

You must be logged in to post in the forum

Developer forum

Prepend not working when exporting data

Replies