Developer forum

Forum » Integration » Prepend not working when exporting data

Prepend not working when exporting data

Adrian Ursu
Adrian Ursu
Reply

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 Dynamicweb Employee
Nicolai Pedersen
Reply

Please show screendumps of your setup

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

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 Dynamicweb Employee
Adrian Ursu
Reply

Hi Nicolai,

Anything on this topic?

Thank you,
Adrian

 
Dynamicweb Employee
Dmitriy Benyuk
Reply

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 Dynamicweb Employee
Nicolai Pedersen
Reply

The video does not work.

Please provide screendumps - thanks!

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

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 Dynamicweb Employee
Dan Kristensen Hørlyck
Reply

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 Dynamicweb Employee
Adrian Ursu
Reply

Hi Dan,

Cool!

Thank you very much for the confirmation.
Adrian

 

You must be logged in to post in the forum