This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
April 04, 2008 4:33pm
Subscribe [4]#1 / Apr 04, 2008 4:33pm
I have a client that wants to have a CMS that they can edit info and then take that info and create either a CSV or an Excel that the user can download or print. Is that possible with EE? It’s a truck body company and I think it will be used for Administrators managing their inventory and they want to be able to edit their inventory online and then download the info.
Thanks
#2 / Apr 04, 2008 4:41pm
CSV is trivial (more or less), Excel is possible, but requires a bit of knowhow in creating the actual .xls file. If you know how to do this with PHP (it is possible), you can do it with EE.
#3 / Apr 04, 2008 5:04pm
Don’t know if this is any help at all but Daniel Walton put together a nice plugin called CSVee which allows you to output data to a CSV file by simply visiting a template which has a SQL query to fetch the data you need.
That might work for you? As Ingmar says Excel is possible but probably a little more advanced. One place to maybe start might be PHP Excel.
Hope some of that helps.
Best wishes,
Mark
#4 / Apr 05, 2008 2:41am
If you can create the CSV file and make it available for download, then Excel will open it straight off the site. All they would have to do is click a link, the browser will ask what you want to do with it. Choose open and specify Excel as the target program. You can even make Excel the default. Or, save the CSV file and open it from within Excel. This will be much easier than trying to create an Excel file using PHP. Either way, Excel will split the data into columns (based on the commas) and rows (based on new lines).
That CSVee plugin that Mark mentioned looks perfect. I haven’t tried it (yet), but if I read correctly all they will have to do is call up a URL to get the downloadable file. Sweet.
#5 / Apr 05, 2008 3:00am
I haven’t tried it (yet), but if I read correctly all they will have to do is call up a URL to get the downloadable file. Sweet.
Yes, you can certainly do that, plugin or not.
#6 / Apr 05, 2008 4:37am
That CSVee plugin that Mark mentioned looks perfect. I haven’t tried it (yet), but if I read correctly all they will have to do is call up a URL to get the downloadable file. Sweet.
Yep should be as easy as that. Give it a try, you can’t really do anything bad with it. It is used to query your database but you can’t UPDATE or DELETE using it so it shouldn’t be able to do anything bad to your system.
Let us know how you get on won’t you.
Best wishes,
Mark