|
|
Set as favorite
Bookmark
Email this
Hits: 63239 Comments (60)
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} |
nenda
said:
 |
... Hello, I've a set of large business directory database, and want it to load into my Business Directory website which is created using MightyExtension resources package. The question is, with SQL 2 Excel Pro, is that possible to export the complete ME resources database (contents & package) structure into excel spreadsheet as a database template structure, there for I can prepare my set database in it and import it back to my Business Directory website (production server)? Thank's |
nenda
said:
|
... Sorry 2 double post,.. (revised) The question is, with SQL 2 Excel Pro, is that possible to export the complete ME resources database (contents & categories) structure into excel spreadsheet as a database template structure, there for I can prepare my set database in it and import it back to my Business Directory website (production server)? Thank's |
Mats @ Joomla-R-Us
said:
|
... @nenda: I assume the business directory data is stored in the MySQL database. SQL 2 Excel can of course export all of that data into Excel Spreadsheets, assuming there's no binary blob fields. BUT, I would not use SQL 2 Excel to move data over to another database. Use phpMyAdmin or mysqldump to dump out your database. It's much easier/safer to import into another database that way. -Mats |
nenda
said:
|
... Mats, Yes, it is in MySQL Database, I'm not sure whether there are binary blob fields or not. My database set is also in MySQl but with different table structure. So your suggestion is, to dump the ME Resources database with some sample records using phpMyAdmin, and then I can use the dump file as a template to reorganize & prepare my database set?. Is that possible? if yes, then it would be great. Thank's a lot for the info. Nenda |
Mats @ Joomla-R-Us
said:
|
... @nenda: Yes, you can dump the tables you need using phpMyAdmin. The dump file is a simple ASCII file with SQL syntax to create the tables and insert the data. You can easily add more data/change it before you import it into your other database. -Mats |
trb0428
said:
 |
... Hi, I'm currenty using the free version and require more control over the formatting of the reports and am considering the PRO version. My question is whether the PRO version will allow me to do the following: 1) Create a workbook with multiple worksheets based on looping through sections/categories stored in my DB. 2) I need to set a) column to auto-width so all text fits cleanly in the columns, b) set print to fit on a single page, and c) set the print page to landscape. |
snims
said:
 |
... So, I'm trying to figure out if this will work before buying.... I have the basic version of sql2excel and like. What I want to do is to have a front end using rsforms to allow the user to create parameters for report and then feed that to sql2exe - will that work? Thanks in advance. Steve |
tutur655
said:
 |
... Hello, I want to buy SQL 2 Excel pro, but I want to be sure for the price I would have the version compatible with Joomla 1.6 without charge. Thank you for your prompt response. Greetings Tutur |
pknightSpiffy
said:
 |
... Is SQL 2 Excel Pro compatible with Joomla 1.7? I have searched and searched but see no answer to this, making me think the answer is "No." The site I am revamping is now in Joomla 1.5. Would very much appreciate an answer. It's a nice product! |
sameh
said:
 |
... are you looking for the ver that works with joomla1.7 mail me This e-mail address is being protected from spambots. You need JavaScript enabled to view it |
savvas
said:
 |
... Hi. I have wrote at the forum but still haven't got an answer. And I can't find this at the comparison chart. My question is if I can link an excel sheet with Pro ? Meaning that when I change a value in a spreedsheet cell, the changes affect the spreedsheet in my web page automaticly. thanks in advance. |
samy12
said:
 |
... Hello this component connects the mysql database to be output in the form of excel files so when your data change in the database the excel file changes. This e-mail address is being protected from spambots. You need JavaScript enabled to view it |
nitins
said:
 |
... Hello, I have purchased "Sql to excel pro".while using inside worksheet I fired query which has using Join for showing data from two different tables. but it shows fatal error inside excel sheet when we download and see for result. Please help me to sort out this issue. thanks |
dave.jabb
said:
 |
... While it seems that it has been a while since the last update, does the sql 2 excel pro work with joomla 2.5 and on the latest version(s) of excel(say 2010)? |
samy12
said:
|
... if you are looking for the version that work with j1.7 ,1.6 , 2.5 email me This e-mail address is being protected from spambots. You need JavaScript enabled to view it |
sysatl
said:
 |
... I would post my question on the SQL 2 Excel forum but it appears to be over-run by add-bots. I am currently pulling data from several tables on an SQL server and am running client-side queries due to multiple "outer joins". The "meat" of the data is in one table but some of the important data needed is in the peripheral tables. I have 3 questions reference SQL2Excel. Question1: On July 0, 2010, Mats @ Joomla-R-Us posted ...SQL 2 Excel Pro makes it easier since you can add results from multiple SQL queries into the same spreadsheet... Does this mean that I can run the multiple queries server-side (which I intend to do anyway) and return the desired results on a single table? Question2: I am using VLOOKUP's, IF's, OR's, AND's, LEFT/RIGHT's, CONCATENATE's, etc... all to pull date from other worksheets in a workbook. I will still need to run some of these formulas in order to present the data as needed. With SQL2Excel, will I be able to reference between sheets in my formulas? Question3: Nn order to enter columns with formulas and some of the more advanced functions referenced above, will I need the Pro version? Very respectfully, |
emadsam
said:
 |
... are you looking for sql2excel pro compalable with joomla 1.7-1.6-2.5 contact me This e-mail address is being protected from spambots. You need JavaScript enabled to view it only 30$ |
Write comment
You must be logged in to post a comment. Please register if you do not have an account yet.
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.