Downloads
Up

Sample Reports

SQL 2 Excel Sample Reports

These reports are provided as-is. Use them to get ideas on how to use SQL 2 Excel for various reports.

 

!JoomlaComment

Export your comments, including user contact information. Tested with !JoComment 4.0 alpha3

Jommlacomment.xml (3.23 kB)

Acajoom News

Export your Newslist Subscribers from Acajoom News with this report. Generates an Excel Workbook with the following sheets:

  • List Subscribers
  • Subscriber Details
  • Subscribers By List
  • Subscribers By Country
  • Subscribers By Format

 

Acajoom_Subscibers.xml (7.12 kB)

BookLibrary

This report exports all your books, reviews, lending history and lending requests as well as suggestions from the BookLibrary component into one single Excel spreadsheet.

Only tested with BookLibrary Basic 1.5.2.4. But I assume it will work with the Premium/Pro versions as well.

BookLibrary.xml (9.92 kB)

Communicator

This report exports your Communicator Newletter subscibers into an Excel Spreadsheet.

 

Communicator.xml (1.79 kB)

Community Builder - User Information

This report exports all user information from Community Builder, including the custom fields that you have defined, into an Excel Spreadsheet.

Community_Builder_Users.xml (1.53 kB)

DOCman

DOCman activity Report, tested with DOCman v1.4.0.stable.

DOCman_Report.xml (9.74 kB)

EasyBook

This report generates an Excel Spreadsheet with all your EasyBook guestbook entries, including user name, email, Yahoo, MSN, Skype etc etc. A second sheet in the workbook will be populated with the Bad Words that you have configured in Easybook.

EasyBook_Report.xml (2.98 kB)

EventList

Export your events and registrations in EventList to Excel with this report. Generates an Excel Workbook with these worksheets:

  • Events
  • Registrations
  • Venues
EventList_Report.xml (5.00 kB)

Jambook

Export all your guestbook entries from Jx Jambook to an Excel spreadsheet with this report.

 

Jambook.xml (1.83 kB)

JCollection

This sample report exports your items, categories and lists in JCollection to a single Excel spreadsheet. The report creates am Excel Workbook with the following sheets:

  • Items
  • Categories
  • Lists
  • Items by List

Tested with JCollection 0.9.8
JCollection.xml (7.54 kB)

Jom Comment

Export Jom Comment data with this report. The report generates generates an Excel Workbook with the following Worksheets:

  • Comments
  • Subscriptions
  • Votes

Tested with Jom Coment 3.0.1 Build 562

Jom_Comment_Report.xml (4.28 kB)

JomSocial - User Profiles

Export your JomSocial user profiles into an Excel spreadsheet.

Note! This report has been configured to work only with the default JomSocial user profile fields. If you have added or unpublished some of the fields, please see this tutorial on how to customize the report:

How to export custom user profile information from JomSocial with SQL 2 Excel

JomSocial_User_Profiles.xml (3.41 kB)

Joom!Fish

This XML file contains two Joom!Fish reports for SQL 2 Excel. You can use these reports for various things such as run your favorite spell checker on your translations, make sure you have translations for all your important items etc etc.

The first report generates one Excel Workbook with specific reports for different types of translations, including the original values. The Workbook contains the following Worksheets:

  • Articles
  • Menus
  • Categories
  • Sections
  • Modules
  • Banners
  • Newsfeeds
  • Weblinks
  • Polls
  • Poll Data


The second report generates one Excel Spreadsheet with all your translations.

Please note that SQL 2 Excel does not fully support all UTF8 character sets. at the moment But most Western languages should work ok.

JoomFish_Reports.xml (19.16 kB)

Kunena Forum

Generates a report for Kunena Forum.  A single Excel Workbook with the following Worksheets:

  • Most Views - All Time
  • Most Views - Last 30 days
  • Most Replies - All Time
  • Most Replies - Last 30 days
  • Threads with no replies
  • Registered Users
  • Logged in Users

Tested with Kunena Forum version 1.0.8.
Kunena_Forum_Report.xml (8.21 kB)

Lyften Bloggie

This report generates an Excel Spreadsheet with statistics from your Lyften Bloggie blog. Number of comments, trackbacks,hits per blog entry.

LyftenBloggie.xml (2.55 kB)

Media Library

Export your media collection from Media Library into a single Excel workbook with this report.

  • Books
  • Games
  • Music
  • Videos
Media_Library.xml (6.31 kB)

Phoca Download

Report for Phoca Download. Tested on Phoca Download version 1.1.

Phoca_Download.xml (7.60 kB)

Phoca Gallery

This report generates a Phoca Gallery activity report in a single Excel Workbook. The Workbook contains the following Worksheets:

  • Most Viewed Images
  • Images
  • Views by Category
  • Ratings
  • Ratings by Category
  • Comments
  • Comments by Category

 

Phoca_Gallery_Report.xml (13.22 kB)

Qcontacts

Exports all your contacts from Qcontacts into an Excel Spreadsheet.

Qcontacts.xml (2.04 kB)

RD Autos

Export your car listings in RD Autos to an Excel spreadsheet with this report. The complete inventory and price list in one single spreadsheet file!

rd_autos.xml (2.53 kB)

RokDownloads

This report generates an Excel Spreadsheet with download statistics from RokDownloads :

  • Summary
  • File Statistics

Tested with RokDownloads (free) version 1.0b6
RokDownloads.xml (4.27 kB)

RSMonials

Export your testimonals from RSMonials to Excel with this report.

 

RSMonials.xml (1.77 kB)

SimpleCaddy

This report exports your Orders, Order Details and Products from SimpleCaddy into one single Excel Spreadsheet.

SimpleCaddy.xml (5.64 kB)

Joomla - Site Report


Report for generic Joomla content. Generates a single Excel Workbook with the following Worksheets:

  • Article Hits per Section
  • Article Hits per Category
  • Article Hits per Author
  • Weblink Hits per Category
  • Users
Site_Report.xml (5.65 kB)

SOBI2

Export all your SOBI2 (Sigsiu Online Business Index 2) items and categories into an Excel spreadsheet.

Note! This report has been configured to work only with the default SOBI2 Fields. If you have added or unpublished some of the fields, please see this tutorial on how to customize the report:

How to export SOBI2 Business Index information to Excel

sobi2.xml.xml (5.12 kB)

Teamlog

Export your log entries from the Teamlog component into one Excel spreadsheet with this report. The Workbook  contains 4 different reports:

  • Totals by Project
  • Totals by Project & Task
  • Totals by Project & User
  • Totals by User
Team_Log.xml (7.13 kB)

Virtuemart - Customers

This report exports the customers from Virtuemart.

Virtuemart_Customers_v_1_0.xml (1.81 kB)

Virtuemart - Orders

This Virtuemart report generates an Excel Workbook with the following Worksheets:

  • Orders
  • Order History
  • Top 100 Customers
  • Orders by Country
  • Orders by State / Province
Virtuemart_Orders_v1_1.xml (11.30 kB)

WATicketSystem

Export your tickets from Webamoeba Ticket System to an Excel Spreadsheet with this report.

WATicketSystem.xml (2.17 kB)
Display Num 

 

Powered by Phoca Download

 

Comments (10)add comment
feedSubscribe to this comment's feed

Birger Knudsen said:

0
 ...
Hi
I am planing a new site and use RS form Pro. Do yuo have any plan to make a Report for RS Form Pro?

Regards from Denmark
Birger Knudsen
 
August 15, 2009
Votes: +3

Mats @ Joomla-R-Us said:

admin
 ...
@Birger: I don't have RS Form Pro. Do you know if there is any free demo version that I can download, or do you have to purchase it?
 
August 19, 2009
Votes: +2

Birger Knudsen said:

0
 ...
Hi

On the webside you can DL a try pack. There is a button "Try it for free"

Regards

Birger Knudsen

Denmark
 
August 20, 2009
Votes: +1

shlomi said:

0
 ...
what about Billets Component ? can you guys publish a sample report for that.

thank's a million...
 
July 21, 2010
Votes: +1

admin said:

admin
 ...
@shlomi: Billets is a commercial extension - which I don't have. Can't justify to buy Billets just to create a sample report. Sorry.

-Mats
 
July 21, 2010
Votes: +0

wulfseidel said:

0
 ...
hey there,

is there any plan to create a sample report for com_property
http://www.com-property.com?

this is a free component smilies/smiley.gif
 
August 18, 2010
Votes: +1

admin said:

admin
 ...
@wulfseidel: Sorry, didn't see your comment until now. No current plan to create a report for com_property.

-Mats
 
September 02, 2010
Votes: +0

Grahm said:

ExcelGuru
 ...
The sample reports helped in to better understand the layout in order to create my own.

-Grahm
http://www.oneclickcommissions...ports.html
 
April 19, 2011
Votes: +0

zbabyface said:

zbabyface
 ...
Was RS Form Pro formula ever completed? I'd love to have it! smilies/smiley.gif

Thanks!
 
May 18, 2011
Votes: +0

Write comment
You must be logged in to post a comment. Please register if you do not have an account yet.

busy
 
  Design by augs-burg.de & go-vista.de  
 
     
 
   
  

The Joomla!(R) name is used under a limited license from Open Source Matters in the United States and other countries. http://Joomla-R-Us.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.