Developer forum

Forum » Development » Export with parameters

Export with parameters


Reply

We have a customer that woul like to eksport order data to a specific CSV format for use with the Post Danmark Webpack system: http://www.postdanmark.dk/pfs/pfsHelp/kunde/masseudskriv.htm

 

Currently there is a pipeline that exports all orders/carts, but is it possible to make the same sort of pipeline where the user can enter a date range for the orders to export? Otherwise they end up with at 6 MB CSV file every time.


Replies

 
Reply

Currently this is not possible using Import/Export, but there's a request on this feature.

 

The Database Publishing module allows you to export views to XML and CSV (please read http://developer.dynamicweb.dk/default.aspx?id=16918&action=ShowArticle&ArticleID=39 for further information), but the export routine has no filtering opportunities. A request has also been made for this.

 

In the meantime you might be able to acheive a similar functionality by using the frontend functionality of the Database Publiching module. It's a lot of work, but if you set up your master-, page-, paragraph, and DBPub templates to output XML, you could create a new view in DBPub that would return the data. When attaching the DBPub module on a paragraph, you can filter the output using querystring parameters like this:

 

http://mysite.dk/Default.aspx?ID=1&filtername=t1.OrderDate&filtercondition=%3d&filtervalue=2008/4/30

 

Please let me know, how it works if you choose to use this approach.

 
Reply


 

I will look in to the DB Publishing module. An even simpler solution with that could be to just create the last 100 entries, and then manually delete the ones that have already been sent.

 

You must be logged in to post in the forum