Not able to export to CSV

juangose · Post by **juangose** » Wed Jun 24, 2009 2:54 pm

I will try to use the last version and then I let you know if it is working.

Thanks

Post by **TheWitness** » Wed Jun 24, 2009 5:54 pm

Yes, if you do not use a preset, things are broken in the current 0.8.7d. We are still preparing a patch for this. Sorry for the delay.

TheWitness

juan50robinson · Post by **juan50robinson** » Thu Jun 25, 2009 8:27 am

I used the rrd.php and graph_xport.php of the SVN Browser, but I still have the problem.

Thanks The Witness, I will wait by the patch.

Thanks a lot to all developers.

Att. Juangose

phalek · Post by **phalek** » Thu Jun 25, 2009 9:04 am

I think that rrd version had a bug and returned mal-formed XML data. I alreay filed a bug for that which got solved:

http://bugs.cacti.net/view.php?id=1436

Btw. TheWitness, I like your last comments on that bug ...

Post by **TheWitness** » Thu Jun 25, 2009 9:05 am

So, you are confirming that the patched lib/xml.php did the trick?

TheWitness

phalek · Post by **phalek** » Thu Jun 25, 2009 9:16 am

argh, I just downgraded to 1.2.30-1 on Centos, which produces the following XML output:

Code: Select all

rrdtool xport --start=1237803382 \
> --end=1237889782 \
> --maxrows=10000 \
> DEF:a="/var/www/html/cacti-0.8.7d/rra/r..._5min_cpu_40.rrd":5min_cpu:AVERAGE \
> XPORT:a:"CPU Usage" \
>
CPU Usage:86400
step: 86400
<?xml version="1.0" encoding="ISO-8859-1"?>

<xport>
  <meta>
    <start>1237852800</start>
    <step>86400</step>
    <end>1237852800</end>
    <rows>1</rows>
    <columns>1</columns>
    <legend>
      <entry>CPU Usage</entry>
    </legend>
  </meta>
  <data>
    <row><t>1237852800</t><v>1.1333333333e+00</v></row>
  </data>
</xport>

Update:

Having used the svn xml.php lib, the code included there solves the issue more elegant than I did.

THe Bug is solved.

I can confirm with using Revision=5115 of the xml.php file from svn and 1.2.30-1 of rrdtool in CentOS.

I need to grab another coffee to get my mind sorted out ...

phalek · Post by **phalek** » Thu Jun 25, 2009 9:30 am

please ignore this

Post by **TheWitness** » Thu Jun 25, 2009 10:37 am

You mean your ramblings right?

T

phalek · Post by **phalek** » Thu Jun 25, 2009 10:59 am

yeah ...

So the code in the new xml.php ( more professional than whatI did

from svn fixes the problem.

juangose · Post by **juangose** » Tue Jun 30, 2009 2:11 pm

Thanks

The xml.php resolved my problem.

Thanks

Att. Juangose

Post by **TheWitness** » Tue Jun 30, 2009 3:56 pm

These fixes were all merged into the 0.8.7e release sent out yesterday.

TheWitness

trinhhoang · Post by **trinhhoang** » Wed Jul 01, 2009 4:46 am

BSOD2600 wrote:php_error log enabled revealed the following, which is the portion of the file which deals with spitting out the text in the csv file..

Code: Select all

[19-Jun-2009 11:50:47] PHP Notice:  Undefined index:  start in C:\Inetpub\wwwroot\cacti\graph_xport.php on line 101
[19-Jun-2009 11:50:47] PHP Notice:  Undefined index:  end in C:\Inetpub\wwwroot\cacti\graph_xport.php on line 102
[19-Jun-2009 11:50:47] PHP Notice:  Undefined index:  step in C:\Inetpub\wwwroot\cacti\graph_xport.php on line 103
[19-Jun-2009 11:50:47] PHP Notice:  Undefined index:  rows in C:\Inetpub\wwwroot\cacti\graph_xport.php on line 104
[19-Jun-2009 11:50:47] PHP Notice:  Undefined index:  columns in C:\Inetpub\wwwroot\cacti\graph_xport.php on line 122
[19-Jun-2009 11:50:47] PHP Notice:  Undefined index:  data in C:\Inetpub\wwwroot\cacti\graph_xport.php on line 128

Please! How to solve it?

diddi · Post by **diddi** » Wed Jul 01, 2009 5:06 am

TheWitness wrote:These fixes were all merged into the 0.8.7e release sent out yesterday.

Thx, works for me now.

Christian

BSOD2600 · Post by **BSOD2600** » Wed Jul 01, 2009 12:26 pm

trinhhoang wrote:Please! How to solve it?

As TheWitness already stated, upgrade to cacti 0.8.7e.

trinhhoang · Post by **trinhhoang** » Thu Jul 02, 2009 1:30 am

BSOD2600 wrote:
trinhhoang wrote:Please! How to solve it?
As TheWitness already stated, upgrade to cacti 0.8.7e.

Thanks! I upgrated my server to cacti 0.8.7e, so that it works.

Cacti

Not able to export to CSV

Who is online