All geek questions in one place

Export a list of Sitecore items as Excel (or other formats)

I noticed that sitecore has the ability to export users in Excel format.

screenshot of the user managers

I need to have the same functionality for exporting "participation" (users can sign up to participate in the "event", and if their entry is approved through the sitecore workflow, an element of the "participation" tree is created in the content)

Since basically everything in Sitecore is essentially element based, and I want to export the elements to Excel, my question is which of the best ways to do this?

Questions:

  • Is there a way to reuse this function for regular elements?
  • It would be nice to create a custom admin page (any tips on this?) That has its own code that reads items from the database using the API?
  • Are there sitecore plugins / projects with a common source that can help me with this?

Or does anyone have a better idea? - would it be better to just keep participating in SQL? I basically do it this way because I want to use “free” offers of functionality, for example, a workflow, but if this leads me to use anti-patterns, shoot me;)

+6
source share
2 answers

Found the most excellent general source module that does just that (and much more)! Basically, this allows you to customize (and easily expand, if you need) some kind of tabular report on "elements".

The report module is displayed as an application in the sitecore menu (for example, a user manager tool) and comes with features such as xml, csv, xls export. It is also very easy to set up once you receive it.

http://trac.sitecore.net/AdvancedSystemReporter

+4
source

Now the link is different: https://marketplace.sitecore.net/en/Modules/Advanced_System_Reporter.aspx

PS I can not leave a comment on the original answer, because I do not have enough reputation. Okay:)

+6
source

Source: https://habr.com/ru/post/892233/

More articles:


All Articles