You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Tony Lotts <tl...@gmail.com> on 2009/07/17 21:28:03 UTC
Load results into database
I'm looking for a system which will store JMeter results in a relational
database. It's easy to load results from CSV. However loading XML result
files is a bit more complicated. Has anyone here created, or come across a
similar system (other than Jchav)?
Thanks,
Tony
Re: Load results into database
Posted by Adrian Speteanu <as...@gmail.com>.
Hi Toni,
Take a look at this as well:
http://wiki.apache.org/jakarta-jmeter/LogAnalysis if you haven't
already.
Basically if you want to write xml, to save more data , you can find
there a method to use stylesheets and convert the data into a table.
On Fri, Jul 24, 2009 at 3:16 PM, sebb<se...@gmail.com> wrote:
> On 24/07/2009, Mohamed Niyas <ni...@gmail.com> wrote:
>> Hi Tony,
>>
>> There is a option to save your output files as CSV format as well. From
>> there you can import it to
>> any database. But a small trade off is that if you save the results as CSV,
>> you can not view the
>> output through Jmeter listener (Like Summary, aggregate, graph etc)
>
> Incorrect - you can use CSV with all Listeners (except View Results
> Tree will be incomplete)
>
>> So you need to calculate the those values in order to get your results thru
>> database functions.
>>
>> I would suggest you to go ahead with both. You can simply add the datawriter
>> as CSV which you can
>> import it to DB for archiving purpose. And the XML outputs to see the
>> results from Jmeter tool.
>
> The only difference is that XML output allows one to save a few extra
> fields, such as sample response, see the entries marked (XML) below:
>
> http://jakarta.apache.org/jmeter/usermanual/listeners.html#sample_configuration
>
>> I hope this answers your queries.
>>
>> Regards
>>
>> Mohamed Niyas
>>
>>
>> On Sat, Jul 18, 2009 at 12:58 AM, Tony Lotts <tl...@gmail.com> wrote:
>>
>> > I'm looking for a system which will store JMeter results in a relational
>> > database. It's easy to load results from CSV. However loading XML result
>> > files is a bit more complicated. Has anyone here created, or come across a
>> > similar system (other than Jchav)?
>> >
>> > Thanks,
>> >
>> > Tony
>> >
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Load results into database
Posted by sebb <se...@gmail.com>.
On 24/07/2009, Mohamed Niyas <ni...@gmail.com> wrote:
> Hi Tony,
>
> There is a option to save your output files as CSV format as well. From
> there you can import it to
> any database. But a small trade off is that if you save the results as CSV,
> you can not view the
> output through Jmeter listener (Like Summary, aggregate, graph etc)
Incorrect - you can use CSV with all Listeners (except View Results
Tree will be incomplete)
> So you need to calculate the those values in order to get your results thru
> database functions.
>
> I would suggest you to go ahead with both. You can simply add the datawriter
> as CSV which you can
> import it to DB for archiving purpose. And the XML outputs to see the
> results from Jmeter tool.
The only difference is that XML output allows one to save a few extra
fields, such as sample response, see the entries marked (XML) below:
http://jakarta.apache.org/jmeter/usermanual/listeners.html#sample_configuration
> I hope this answers your queries.
>
> Regards
>
> Mohamed Niyas
>
>
> On Sat, Jul 18, 2009 at 12:58 AM, Tony Lotts <tl...@gmail.com> wrote:
>
> > I'm looking for a system which will store JMeter results in a relational
> > database. It's easy to load results from CSV. However loading XML result
> > files is a bit more complicated. Has anyone here created, or come across a
> > similar system (other than Jchav)?
> >
> > Thanks,
> >
> > Tony
> >
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Load results into database
Posted by Mohamed Niyas <ni...@gmail.com>.
Hi Tony,
There is a option to save your output files as CSV format as well. From
there you can import it to
any database. But a small trade off is that if you save the results as CSV,
you can not view the
output through Jmeter listener (Like Summary, aggregate, graph etc)
So you need to calculate the those values in order to get your results thru
database functions.
I would suggest you to go ahead with both. You can simply add the datawriter
as CSV which you can
import it to DB for archiving purpose. And the XML outputs to see the
results from Jmeter tool.
I hope this answers your queries.
Regards
Mohamed Niyas
On Sat, Jul 18, 2009 at 12:58 AM, Tony Lotts <tl...@gmail.com> wrote:
> I'm looking for a system which will store JMeter results in a relational
> database. It's easy to load results from CSV. However loading XML result
> files is a bit more complicated. Has anyone here created, or come across a
> similar system (other than Jchav)?
>
> Thanks,
>
> Tony
>