merauluka
 New Member Posts:88

 |
| 08 Mar 2010 05:44 PM |
|
I have been using XMod for a while now with great success in a variety of applications. The main being event registrations. One feature that is very hard to cope with is the inability to download my data as CSV or Excel data. I know that people have asked about this in the past, but it doesn't seem to be resolved. I have the Form Exporter that was available from PS1 Systems and haven't ever known how to get it to work. I'm assuming, since it's a DLL file, that I'm supposed to use a custom control, but I don't know how to construct it. Has anyone had any luck in using this add-on? If no, does anyone have alternatives that would allow me to export my data as a CSV/Excel file? One of the nice things about the PS1 add-on was that it allowed users to download the file without going through the XMod interface. I would like to be able to keep that feature so my users can simply click a link and download new registrations. |
|
|
|
|
Derek Gentry
 Basic Member Posts:463

 |
| 22 Jun 2010 10:09 AM |
|
Honestly, the best answer I have is getting the ReportGrid module from snowcovered and then writing a quick query to get the data you need. I can assist if you need me to. Let me know. |
|
|
|
|
Ryan Moore
 Basic Member Posts:222

 |
| 23 Jun 2010 06:25 AM |
|
If anyone else has suggestions on xmod setup to export (might be done with a 3rd party/external page with records out from xmod perhaps...) but really, there are several modules that do it well as Derek mentioned. our two favorites are: #1 - SQL Delux by Smoke Ranch. it is an excellent module for doing raw data export. it allows for custom and filtered queries/reports and all can be previewed and sorted on screen and then exported to CSV #2 - BGI LMS Reports - for formatted PDF, DOC and XLS reports, there's nothing better... the power of nested reports (looping) is amazing. it is for "pretty" or formatted reports that can have a designer's level of look to them. the XLS export here is formated with colors, fonts, etc, so it's a formatted XLS vs raw data csv. We use both of these heavily and have used them as export/reporting arms for working with XMOD generated list and result tables. |
|
|
|
|
merauluka
 New Member Posts:88

 |
| 12 Oct 2010 12:40 AM |
|
What I ended up doing was creating a template in XMod that showed all of the values I wanted and told it to display all records. Then I used Outwit for Firefox to harvest the table data as a CSV file. Imported that into Excel and Poof. :-) |
|
|
|
|