Developer forum

Forum » Integration » Comments export (mix columns?)

Comments export (mix columns?)

Peter Bille Larsen
Reply
Hi there

we are doing a daily export of the comments (ecom comments on products), so the editor can check if anybody has written some junk, which should be deleted.

But the editor cannot see which productnumber, because the columns are PRODXXX.

How can I mix columns from other tables to extend the result-excel, while doing the same operation? I have made a job where the comments table are exported, but if I add another table export, it says that the Table are in use?
I need the productnumber, shop name, and entry date of comment, and all comments in same table.

cheers
Peter


 

comments.png

Replies

 
Morten Snedker
Reply
This post has been marked as an answer
 Hi Peter,

Unfortunately this is not possible at the moment, as the Dynamicweb Provider only lists tables. I have created a work item (9110) that will give the possibility to also list views. The functionality will be ready within a couple of weeks (approx).

But in order to create a view (query) you will need access to the SQL Server Management Studio. Otherwise you will have to create your own smart little "thing" to create views.

A work-around till then could be using the Data Lists module. In this you can create views (not sql views!) and make an XML publication.

Hopes this will help you along for now!  :-)


Regards /Snedker
Votes for this answer: 1
 
Peter Bille Larsen
Reply
 Hi Morten

ok cool, for now I have just instructed the client to use the prodnum in an url : /default.aspx...xxx


thanks
Peter

 

You must be logged in to post in the forum