Developer forum

Forum » CMS - Standard features » Export Data list to Excel

Export Data list to Excel

E-mail notifications
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Reply
Posted on 06/11/2017 18:58:06

Hi,

 

Is there a way to export a Data list to an excel file?

 

I could show the user how to publish to XML and then save it in a file and open that XML file in Excel, but I am trying to make it easier for him, without making it too complicated for me :)

 

Best Regards,

Nuno Aguiar


Replies

 
Nicolai Pedersen
Posted on 06/11/2017 19:06:09
Reply

You can use the integration module using Dynamicweb provider as source and excel as destination.

BR Nicolai

 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Posted on 07/11/2017 17:52:57
Reply

Hi Nicolai,

 

That's an option but we wanted to have 1 single table with EcomProducts and Product category field values. With Data Lists you can do a sql query with inner joins and export that single table.

 

I'll see if the customer is OK with that though.

 

Thanks,

Nuno

 
Nicolai Pedersen
Posted on 08/11/2017 11:00:11
Reply
This post has been marked as an answer

Then use the "Dynamicweb provider with views" and create a view in the database doing just that.

Votes for this answer: 1
 
Nuno Aguiar Dynamicweb Employee
Nuno Aguiar
Posted on 08/11/2017 12:50:46
Reply

Ah... did not remembered that approach. works great for me. thanks

 

Nuno

 

You must be logged in to post in the forum