Jump to:

5539 Posts in 1738 Topics by 1224 members

Customising the CMS

SilverStripe Forums » Customising the CMS » Creating Custom Reports based on Excel Data File

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 649 Views
  • B00mtastikā„¢
    Community Member
    18 Posts

    Creating Custom Reports based on Excel Data File Link to this post

    Hey guys,

    I'm working for a company and trying to automate some of their reports and integrate this into their intranet. Currently we have to run reports via access and excel ( I know I know, I cringed as well ) and then export to PDF and send it out to whoever may need it. I'm currently working on the intranet and trying to get it to display there, so that all users who need any report, can log in and check out the data they need, and if needed print it.

    So, my question/query/headache/insanity is, is there a way for SilverStripe to grab data out of a Excel File, and then have it be displayed on SilverStripe, either as part of the reporting tab, or even as a page that only groups who are enabled for it can see. This report is dynamic, in the sense they users have to be able to search through the data for specific things, or specific groups such as a customer orders from a certain date range, so if working directly with an excel file is not possible, or too slow, is there a way to still display all this data after its been imported into the MySQL database, and if yes, how would that be done in a way to make sure the attributes are named correctly so as to be able to format it properly to show in certain groups and things of that sort. Oh and exporting to PDF would be awesome as well.

    I know this is a whole lot, but I've tried breaking it down to simple things and learning them, but considering this is what a forum is for, I was wondering if anyone had ideas.

    Thank you muchly in advance.


Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.