Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Database Connectivityea

  • Ricardo Carvalho
  • Ricardo Carvalho's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
26 Mar 2015 11:27 #913

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

Please Log in or Create an account to join the conversation.

More
25 Mar 2015 12:49 #907

Hi Paul,
Yes the issue is resolve in the latest version.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

More
25 Mar 2015 12:37 #906

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

Please Log in or Create an account to join the conversation.

More
19 Mar 2015 14:09 #883

Hi,
It doesn't become static, Values always gets reloaded when the chart is generated, but to see the changes you made in chart settings you first need to save the Chart, It doesn't get updated on runtime.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Ricardo Carvalho
  • Ricardo Carvalho's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
19 Mar 2015 13:36 #882

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:


PKYearCol_1Col_2
1200020002000
2200130002500
3200240003000
4200350003500
5200460004000
6200575000
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

Please Log in or Create an account to join the conversation.

  • Ricardo Carvalho
  • Ricardo Carvalho's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
19 Mar 2015 13:29 #881

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

Please Log in or Create an account to join the conversation.

  • Zaheer Abbas
  • Zaheer Abbas's Avatar
  • Visitor
  • Visitor
19 Mar 2015 12:16 #880

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

Please Log in or Create an account to join the conversation.

More
19 Mar 2015 11:46 #877

Hi,

The issue you mentioned has been corrected in the latest package, Please download it again after logging into your account on WDMtech.
Now you can create a Menu for Chart Layout.
You can use {vchartmodule [Chart ID]} keyword to load the Chart in Article Text e.g. {vchartmodule 1} for Chart ID 1.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Ricardo Carvalho
  • Ricardo Carvalho's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
18 Mar 2015 15:53 #875

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

Please Log in or Create an account to join the conversation.

  • Ricardo Carvalho
  • Ricardo Carvalho's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
18 Mar 2015 13:14 #870

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

Please Log in or Create an account to join the conversation.

  • Zaheer Abbas
  • Zaheer Abbas's Avatar
  • Visitor
  • Visitor
18 Mar 2015 12:40 #869

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

Please Log in or Create an account to join the conversation.

More
17 Mar 2015 06:44 #864

Hello Ricardo,

Thanks for appreciation. We are looking into the issues you pointed out, Will update you very soon on this.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Ricardo Carvalho
  • Ricardo Carvalho's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
16 Mar 2015 20:08 #863

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

Please Log in or Create an account to join the conversation.