Database Connectivityea

Hi Paul

I confirm that the issue is resolved, though you should use "Connect to external database" even if you want to connect to the database of the environment where you have installed the component.

Ric

Has this been resolved? I am looking for a graphs-extension for my site, but need to be able to pull data from our database..

Thanks,
Paul

Good morning

Please confirm that once the graph is defined it becomes static, that the values are not reloaded everytime the chart is generated.

I Explain:

PK	Year	Col_1	Col_2
1	2000	2000	2000
2	2001	3000	2500
3	2002	4000	3000
4	2003	5000	3500
5	2004	6000	4000
6	2005	7500	0

I created a table with the above 4 columns and inserted records 1 to 5. Based on that dataset, I created a line chart and displays the values correctly.

I then inserted row 6, expecting the chart to display the newly inserted row, but it remains the same, no changes.

I go to the chart definition and I see that the Horizontal Value (the X series data) still shows the year from 2000 to 2004 and does not acknowledge the existance of a new value (row 6 Year 2005).

I understand then, that the x series data is only queried at design time and not at runtime. Is this a feature or a bug?

Is it something that is fixable so that your chart component become really dynamic?

Thank you

Good morning

Please confirm that once the graph is defined it becomes static, that the values are not reloaded everytime the chart is generated.

I Explain:

PK Year Col1 Col2
1 2000 2000 2000
2 2001 3000 2500
3 2002 4000 3000
4 2003 5000 3500
5 2004 6000 4000
6 2005 7500 0

I created a table with the above 4 columns and inserted records 1 to 5. Based on that dataset, I created a line chart and displayed ann the values correctly.

I then inserted row 6, expecting tharthe chart to display the newly inserted row, but it remains the same, no changes.

I go to the chart definition and I see that the Horizontal Value (the X series ng data) still shows the year from 2000 to 2004 and does not acknowledge the existance of a new value.

I understand then, that the x series data is only queried at design time and not at runtime. Is this a feature or a bug?

Is it something that is fixable so that your chart component become really dynamic?

Thank you

Hi

After installing our latest vchart package, you have to enable the vchart load module plugin from plugin manager if you want to show the vchart in a article with the following keyword details
{vchartmodule [Chart ID]} keyword to load the Chart in Article Text e.g. {vchartmodule 1} for Chart ID 1.

thanks
zaheer

Hello Zaheer

A different problem is the fact that I am not able to display the graph using the component view (attached to a menu item):

PHP Fatal error: Cannot use object of type stdClass as array in C:\wamp\www\hive\components\com_vchart\views\vchart\view.html.php on line 53
PHP Stack trace:
PHP 1. {main}() C:\wamp\www\hive\index.php:0
PHP 2. JApplicationCms->execute() C:\wamp\www\hive\index.php:40
PHP 3. JApplicationSite->doExecute() C:\wamp\www\hive\libraries\cms\application\cms.php:245
PHP 4. JApplicationSite->dispatch() C:\wamp\www\hive\libraries\cms\application\site.php:224
PHP 5. JComponentHelper::renderComponent() C:\wamp\www\hive\libraries\cms\application\site.php:178
PHP 6. JComponentHelper::executeComponent() C:\wamp\www\hive\libraries\cms\component\helper.php:332
PHP 7. require_once() C:\wamp\www\hive\libraries\cms\component\helper.php:352
PHP 8. JControllerLegacy->execute() C:\wamp\www\hive\components\com_vchart\vchart.php:36
PHP 9. VchartController->display() C:\wamp\www\hive\libraries\legacy\controller\legacy.php:722
PHP 10. JControllerLegacy->display() C:\wamp\www\hive\components\com_vchart\controller.php:32
PHP 11. VchartViewVchart->display() C:\wamp\www\hive\libraries\legacy\controller\legacy.php:685

Everyting is OK displaying the module in a template position, though i have not been able to use {loadposition} and {loadmodule} in articles

Hi, Zaheer

Thank you very much for your fast reply.

I have installed the new version of the component and realized that the changes you have made greatly improve on the backed usability. Creating the charts is now much easier and a lot more intuitive.

Regarding the issues I raised

Chart Data Existing Database

Still not able to save a chart with local data, it still asks me for fields I feel I should not need to fill

Invalid field: Hostname:
Invalid field: User name:
Invalid field: Password:
Invalid field: Database Name:

HOWEVER

Chart Data Other Database

This one is now working perfectly and I am able through it to connect to local database as well.

So as far as my requirements go, i am now satisfied that your component and module (which to be fair I have not tested yet) attend my needs.

Thanks you very much.

PS: Just a very very small note to let you now that the component preview <DIV> is not centered and it is placed on the bottom right hand corner. That is, i believe, a minor bug. But i think that the beauty of your package totally requires it to be fixed.


Thank you very much for you help. I will rate you 5* in Joomla Extensions

Hello Ricardo,

We have corrected the issue , please download the latest version of vchart package from your order section.

We hope this response has sufficiently answered your questions. If not, please reply and we will answer your questions / querie s asap.

thanks
zaheer

Hello,

First, congratulations on your product which seems brilliant in charting data.

However I am only able to chart data based on inputted values and I am not able to use it with the options

• Chart Data Existing Database
• Chart Data Other Database

The symptoms are different

With "Chart Data Existing Database"

the system correctly identifies the tables in the current database.
However after specifying my own SQL query and before previewing the graph, when I attempt to save the chart

I get error messages:
Invalid field: Driver name:
Invalid field: Hostname:
Invalid field: User name:
Invalid field: Password:
Invalid field: Database Name:

I believe I should not receive these messages since all relevant data is read from configuration.php

I am not able to complete that particular chart.

With "Chart Data Other Database"

The system attempts to log in, starts to load the select box with the available tables and stays in the state indefinitely.

I am not able to pursue that particular chart.

While you component appears to be everything I need it fails miserably in some functions with should be absolutely easy to implement.

I also see a lack of documentation. I see a lot of examples of different charts but all for inputted data.

You should also provide a couple of examples of charts using the local database.

I will be expecting some help from you regarding these two issues

Thank you in advance