Export saved query to CSV

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
3/18/2017 9:06:29 AM
ABM
Gravatar
Total Posts 29

Export saved query to CSV

I'm looking to export the results of a saved query as a CSV file. My solution would combine the techniques used in the example of using a saved query to populate a chart and the export subscribers button used in the newsletter feature. I thought the best place to put this logic would be on the members page but I always hesitate updating core mojoPortal code, making upgrades difficult. I guess ideally, I'd like to give users access to my "feature" through a link in an html module. I'm looking for quick and dirty here. Any ideas on how to implement custom logic easily? Would the html fragment feature be useful? I've read about it but don't know if it's appropriate here. I'm an experienced developer but am new to extending mojoPortal. Any help is appreciated.

3/20/2017 11:22:04 AM
Gravatar
Total Posts 503
feet planted firmly on the ground

Re: Export saved query to CSV

Administrators can export the results of a saved query to CSV using the SQL Query tool. See https://www.mojoportal.com/using-the-sql-query-tool.aspx

3/20/2017 11:39:29 AM
ABM
Gravatar
Total Posts 29

Re: Export saved query to CSV

As I mentioned, I want to give this functionality to authenticated users through a web page.
3/20/2017 12:42:52 PM
Gravatar
Total Posts 503
feet planted firmly on the ground

Re: Export saved query to CSV

If you want a bespoke functional control to appear on a page that is accessible only to authenticated users then you can either write a custom feature that can then be added to any CMS page, or you can write it on a custom aspx page within the site (that is accessed from a link on CMS page) and implements its own role checking. See https://www.mojoportal.com/developer-docs