| |
Set as favorite
Bookmark
Email this
Hits: 30283 Comments (39)
ebbero
said:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Subscribe to this comment's feed
 |
... Thanks. a great component! Just an idea: A great power of Excel is in the analysis capabilities and especially the pivot tables and charts. How about making a pivot table/chart feature? It would be something like this from a user point of view: 1. In the worksheet, define the SQL query generating a flat list of data. 2. Click "generate pivot table/chart" button (In the background: Parse the query to generate a list of fields) 3. Choose header options: Generate chart (yes/no) Chart type options Table sheet and chart sheet names 4. Choose field options: Define Filter/Row/Column/Data fields from the list of fields Define the field sequence within the four field groups Define Field formats 5. Click "save pivot" (in the background a visual basic macro or similar is created to generate the additional pivot sheets when you run the workbook) Note: It should be possible to generate multiple pivot table/chart pairs from the same SQL query. |
Mats @ Joomla-R-Us
said:
 |
... Graphing capabilities is in the plan. There's quite some groundwork that needs to be done fist, but it will come sooner or later.. Macro support will NOT be possible though. The current PHP library that generates the Excel files does not support macros. I'm looking into a new library with more capabilities, including better graphing etc, but it does not support macros either. -Mats |
Mats @ Joomla-R-Us
said:
|
... @Kent : I created a sample report for Community Builder. You can give that a try, in case you haven't figured it out by yourself already. http://joomla-r-us.com/downloa...le-reports |
Raimund Sacherer
said:
 |
... Hi, can I use it to connect to PostGreSQL to? I would need it bitterly, on a sidenode, i am wondering why you guys do not use the pear system, with pear you should be able to connect to a wide range of databases, including odbc, text files, excel files, ldap, etc. ... best |
Mats @ Joomla-R-Us
said:
|
... @Raimund Sacherer: PostGres is currently not supported. Only MySQL, MS SQL and Oracle at the moment. When do you need it? I might be able to add support for it fairly quickly. -Mats |
Raimund Sacherer
said:
|
... I would need it rather quickly to present reports from my RT ticket system to a client. My other solution would be to convert the RT Ticket system from postgreSQL to MySQL, but you know: Never change a running system ... How long would you need basically to implement postgresql so I need if it is better to wait or if I should prepare to migrate :-) thanks |
Mats @ Joomla-R-Us
said:
|
... @Raimund Sacherer: I'm pretty swamped with other things at the moment. But I think I can implement and test this in 2-3 days, even though I have to work on this in between other things. |
Mats @ Joomla-R-Us
said:
|
... @Raimund Sacherer: postgreSQL support has been added to the latest Pro version (1.5.2) |
digi
said:
 |
... Do you plan something like a "template system"? It would be nice if it will be possible to export single data records in an Excel template to create for example a printable detail view. |
Mats @ Joomla-R-Us
said:
|
... @digi: Yes, I've been testing a new Excel Writer library which can use existing spreadsheets as templates. But I'm finding it's very limited, e.g. a lot of formatting are not supported and are not carried over from the template to the final spreadsheet. Trying to find a better way of doing this. But I haven't found any better way using PHP (yet). |
wtfbrb
said:
 |
... Just purchased pro, was very excited until I realized it cuts off all my leading 0's in zip codes! I have to go back to the old way of doing it please advise. |
Mats @ Joomla-R-Us
said:
|
... @wtfbrb: Problem fixed in version 1.5.6. Please download it and give it a try. PS! Next time, please submit questions in the SQL 2 Excel Pro forum at http://support.joomla-r-us.com for fastest support. -Mats |
Vburgos
said:
 |
... Hi i need to export the CB fields , i want to purchase but i need your help i dont have skills in code. Do you configure this aplication for CB?. work in j 1.0? and 15? many thanks , |
Mats @ Joomla-R-Us
said:
|
... @Vburgos: There is an sample CB report that you can download and install. It should export all custom CB fields. You can download the report here: http://joomla-r-us.com/downloa...le-reports SQL 2 Excel only works in Joomla 1.5. Joomla 1.0 is not supported. |
Josh Carr
said:
 |
... Currently trying to buy the pro version but it gives me an error when I try to complete the purchase in paypal. I have tried a couple times now and it never goes through. Can you take a look and help me buy it  |
Mats @ Joomla-R-Us
said:
|
... @Josh Carr : I'm sorry you are having problems. Not sure what the problem is with the PayPal checkout. Try clearing your browser cache, and maybe use another browser altogether. If you still have problems, please send me an email with the error messages that you see. This e-mail address is being protected from spambots. You need JavaScript enabled to view it |
Mats @ Joomla-R-Us
said:
|
... @ebbero : Pivot tables does not seem to be easy to support due to limitations in the Excel writer libraries unfortunately. You can however create most Pivot tables with plain SQL. See this forum thread for an example: http://joomla-r-us.com/forum?f...d=6&id=513 |
neel99
said:
 |
... It would be nice if you website had a contact us form to ask a question or two about the product. |
Huzefa
said:
 |
... SQL 2 Excel Pro license is domain specific or i can use it for unlimited domain name |
Mats @ Joomla-R-Us
said:
|
... @Huzefa: There is no domain restrictions. You can use SQL 2 Excel Pro on all your websites. As long as you run the different websites then it's ok. |
sandstorm
said:
 |
... Hi, Would your sql 2 excel extension work for the following problem Im currently having. I have a SOBI2 directory on a site where my client needs there users to be able to download a set of search results, or whole results from one category. There doesn't seem to be any sort of plug in for this mentioned on the SOBI2 site or forums. If it will work, which version do i need. Thanks in advance |
Mats @ Joomla-R-Us
said:
|
... @sandstorm : SQL 2 Excel generates an Excel Spreadsheet from data in the database. Not exactly sure what you need here. SQL 2 Excel Pro allows you to use parameterized reports, e.g. let the users select which category etc that they want the report to be run for. Install the free version of SQL 2 Excel, then download and install the sample SOBI2 report. http://joomla-r-us.com/downloads/category/20-sample-reports It will give you a feel for what SQL 2 Excel can do. The professional versions adds a long list of features, but you might be able to use just the free version for this - depending on what you need. |
sandstorm
said:
|
... sorry for replying here & not the forum, I just wanted to know wether the pro version (or free) will allow users in the front end to save or download the report genertaed by sobi 2 to excel. from reading the instructions within this website it may just be back end, in which case its no good for me. Thanks , Andy |
Mats @ Joomla-R-Us
said:
|
... You can let users download the reports in the frontend with both the free version and Pro! Publish a Menu to the SQL 2 Excel Section/Category list in the frontend or Install and publish the SQL 2 Excel Module |
tfaustino
said:
 |
... I saw mention of request on pivots and charts back in Aug 09; where are you with that and if operational can we get some demos? |
Mats @ Joomla-R-Us
said:
|
... @tfaustino : The PHP library that writes the Excel files do not support native Excel Pivot tables. BUT, you can however generate spreadsheets, looking like Pivot tables, using nifty SQL. See: http://joomla-r-us.com/forum?f...d=6&id=513 SQL 2 Excel Pro makes it easier since you can add results from multiple SQL queries into the same spreadsheet Another way to make Pivot tables from databse data is to use a Excel Web query to get the data from Joomla/SQL 2 Excel Pro. You can then setup a native Pivot table in that spreadsheet using the standard Excel functionality. See: http://joomla-r-us.com/compone...-excel-pro -Mats |
Victor
said:
 |
... Hello, I want to use the component for Import and Export items in SOBI2, the, components that help me? |
admin
said:
|
... @Victor: SQL 2 Excel can export data from SOBI2. There's a sample report for SOBI2 here: http://joomla-r-us.com/downloa...le-reports SQL 2 Excel can however NOT import things into Joomla database. You have to use some other kind of upload mechanism/utility. |
Ayman Hassan
said:
 |
... Hello, We have a client who has a master spreadsheet with their entire price list. Can I import that list into your program and then access that data so end users can go online and choose their products/quantity and an itemized spreadsheet would tally it up? Regards, Ayman |
Mats @ Joomla-R-Us
said:
|
... @Ayman Hassan: Please see the post above your post....SQL 2 Excel does NOT enable you to import data into your database. It can generate spreadsheets for any data that is in the database - but it's not a import utility. You have to use some other extension/tool to do the import. -Mats |
cbjomma
said:
 |
... Does the pro version of SQL 2 Excel have an option for menu items to point directly to a worksheet, rather than a section list? I want the worksheets to appear in the Joomla template. |
Prom Night
said:
 |
... Forgive the non-codespeaking nature of my query. I'm not a real developer. I have a web site with Joomla admin interface and have been using the RSForm Pro plugin to collect data from users. The data is stored in a spreadsheet format and is downloadable by admin in CSV or Excel format on demand. That's all great however, I have an extra requirement. On one form, I need the user to be able to enter data via RS Form Pro and have that data visible in real time in a window, insert or other page that displays this data in a spreadsheet format, and also allows edits or deletions of that data on the spot. I don't want them to only be able to see it or download it but to have full freedom to manipulate it on line. With a brief skim of the capabilities of this plugin, I assume it can do what I ask. Can you verify or clarify that it can? |
davstone23
said:
 |
... So - I paid for the product via credit card purchase and other than the pay pal receipt I have received no communications form you. No license key, no download link, no email - nada -zip..... I'm not too happy right now  |
Mats @ Joomla-R-Us.com
said:
|
... @davstone23: Sorry you are having problems. An automatic email was sent out when you made the purchase with download instructions. It must have ended up in some spam filter somewhere. Please contact me directly at This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it . Please include your PayPal email address so that I can locate your purchase. -Mats |
josh t
said:
 |
... Hey guys, I love this utility its great. Just a thought about an upgrade. In the Range Formatting of a worksheet can you add the ability to insert a Sub-Report. What i mean is enter some sql that can generate sub table data based upon a value in the current report. So we can do things like get a list of products as a sub report of an Order from virtuemart. Main Report select user_id, order_id, ... from jos_vm_orders Sub report (setup in the Range Format) Select order_item_id, order_item_name,.. from jos_vm_order_item where order_id = {order_id} |
Write comment
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.