Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Customising the CMS /

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

Creating Custom Reports based on Excel Data File


Go to End


1178 Views

Avatar
b00mtastik

Community Member, 18 Posts

9 July 2012 at 1:38pm

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.

-B00mtastik