You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by "BOLB (Bohdan L Bodnar)" <BO...@panduit.com> on 2014/06/05 16:57:53 UTC

Dynamic Data

I've a situation that I can't figure out how to solve; I'm hoping someone in this forum can provide ideas.  Here is the background:

I am making HTTP-based API calls to a system.  The response to one of these calls returns the ID (an integer) of an entity that has been created.  This ID is extracted via the Regular Expression Extractor and assigned to a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane and the value of DEVICE_ID is written to a .csv file via the Flexible File Writer plugin.  I have confirmed that the integer value is correctly written to the file.  Eventually, I want to delete this entity via an API call.  The following API call (format) works exactly as intended:

/rest/api/X/Y/${DEVICE_ID}

whereas the following fails:
/rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}

The failure occurs because there is no appending of the device ID.

What I am doing incorrectly?

Best regards,

Bo

Re: Dynamic Data

Posted by Deepak Shetty <sh...@gmail.com>.
>Each thread creates entities and deletes entities that it has created.
Even then , I believe the CSVRead loads the file into memory so are you
finished writing everything and then only you load the file? If you cant
share your script , can you share its structure - what samplers/loop and
what you are attempting..


On Fri, Jun 6, 2014 at 6:46 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
wrote:

> Each thread creates entities and deletes entities that it has created.
>  Multiple threads will be doing this during each run (more correctly, using
> Monte Carlo simulation terminology, "independent replication").  I
> considered what you're suggesting and rejected this idea (there are
> technical reasons, mostly pertaining to non-sequential IDs - if they were
> sequential, I'd be using algorithmic methods).
>
> Best regards,
>
> Bo
>
>
> -----Original Message-----
> From: Ryabtsev Vladimir [mailto:v.ryabtsev@pflb.ru]
> Sent: Friday, June 06, 2014 6:28 AM
> To: JMeter Users List
> Subject: RE: Dynamic Data
>
> Hi,
>
> Are you going to create and delete entities during the one test run but
> from the different threads?
> Isn't it work for Inter Thread Communication machinery (
> http://jmeter-plugins.org/wiki/InterThreadCommunication/?utm_source=jmeter&utm_medium=helplink&utm_campaign=InterThreadCommunication),
> is it?
>
> -----
> VR
>
>
> -----Original Message-----
> From: BOLB (Bohdan L Bodnar) [mailto:BOLB@panduit.com]
> Sent: Thursday, June 05, 2014 6:58 PM
> To: jmeter-user@jakarta.apache.org
> Subject: Dynamic Data
>
> I've a situation that I can't figure out how to solve; I'm hoping someone
> in this forum can provide ideas.  Here is the background:
>
> I am making HTTP-based API calls to a system.  The response to one of
> these calls returns the ID (an integer) of an entity that has been created.
>  This ID is extracted via the Regular Expression Extractor and assigned to
> a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane
> and the value of DEVICE_ID is written to a .csv file via the Flexible File
> Writer plugin.  I have confirmed that the integer value is correctly
> written to the file.  Eventually, I want to delete this entity via an API
> call.  The following API call (format) works exactly as intended:
>
> /rest/api/X/Y/${DEVICE_ID}
>
> whereas the following fails:
>
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}
>
> The failure occurs because there is no appending of the device ID.
>
> What I am doing incorrectly?
>
> Best regards,
>
> Bo
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>

RE: Dynamic Data

Posted by "BOLB (Bohdan L Bodnar)" <BO...@panduit.com>.
When scaled upward, there will be hundreds of IDs.  I will be using an API call that requires these IDs as a list.  The problem is not just the deletion - it's also timing this API call.  What I'm doing now is prep work for this future change.

-----Original Message-----
From: Ryabtsev Vladimir [mailto:v.ryabtsev@pflb.ru] 
Sent: Friday, June 06, 2014 10:17 AM
To: JMeter Users List
Subject: Re: Dynamic Data

If that's the case, why are you dissatisfied with /rest/api/X/Y/${DEVICE_ID}?
I totally misunderstand why do you need CSV, or something like that at all.
You will just get ID when creating entity and then use it for deletion.

VR

> 06 июня 2014 г., в 17:46, "BOLB (Bohdan L Bodnar)" <BO...@panduit.com> написал(а):
> 
> Each thread creates entities and deletes entities that it has created.  Multiple threads will be doing this during each run (more correctly, using Monte Carlo simulation terminology, "independent replication").  I considered what you're suggesting and rejected this idea (there are technical reasons, mostly pertaining to non-sequential IDs - if they were sequential, I'd be using algorithmic methods).
> 
> Best regards,
> 
> Bo
> 
> 
> -----Original Message-----
> From: Ryabtsev Vladimir [mailto:v.ryabtsev@pflb.ru] 
> Sent: Friday, June 06, 2014 6:28 AM
> To: JMeter Users List
> Subject: RE: Dynamic Data
> 
> Hi,
> 
> Are you going to create and delete entities during the one test run but from the different threads?
> Isn't it work for Inter Thread Communication machinery (http://jmeter-plugins.org/wiki/InterThreadCommunication/?utm_source=jmeter&utm_medium=helplink&utm_campaign=InterThreadCommunication), is it?
> 
> -----
> VR
> 
> 
> -----Original Message-----
> From: BOLB (Bohdan L Bodnar) [mailto:BOLB@panduit.com] 
> Sent: Thursday, June 05, 2014 6:58 PM
> To: jmeter-user@jakarta.apache.org
> Subject: Dynamic Data
> 
> I've a situation that I can't figure out how to solve; I'm hoping someone in this forum can provide ideas.  Here is the background:
> 
> I am making HTTP-based API calls to a system.  The response to one of these calls returns the ID (an integer) of an entity that has been created.  This ID is extracted via the Regular Expression Extractor and assigned to a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane and the value of DEVICE_ID is written to a .csv file via the Flexible File Writer plugin.  I have confirmed that the integer value is correctly written to the file.  Eventually, I want to delete this entity via an API call.  The following API call (format) works exactly as intended:
> 
> /rest/api/X/Y/${DEVICE_ID}
> 
> whereas the following fails:
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}
> 
> The failure occurs because there is no appending of the device ID.
> 
> What I am doing incorrectly?
> 
> Best regards,
> 
> Bo
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


Re: Dynamic Data

Posted by Ryabtsev Vladimir <v....@pflb.ru>.
If that's the case, why are you dissatisfied with /rest/api/X/Y/${DEVICE_ID}?
I totally misunderstand why do you need CSV, or something like that at all.
You will just get ID when creating entity and then use it for deletion.

VR

> 06 июня 2014 г., в 17:46, "BOLB (Bohdan L Bodnar)" <BO...@panduit.com> написал(а):
> 
> Each thread creates entities and deletes entities that it has created.  Multiple threads will be doing this during each run (more correctly, using Monte Carlo simulation terminology, "independent replication").  I considered what you're suggesting and rejected this idea (there are technical reasons, mostly pertaining to non-sequential IDs - if they were sequential, I'd be using algorithmic methods).
> 
> Best regards,
> 
> Bo
> 
> 
> -----Original Message-----
> From: Ryabtsev Vladimir [mailto:v.ryabtsev@pflb.ru] 
> Sent: Friday, June 06, 2014 6:28 AM
> To: JMeter Users List
> Subject: RE: Dynamic Data
> 
> Hi,
> 
> Are you going to create and delete entities during the one test run but from the different threads?
> Isn't it work for Inter Thread Communication machinery (http://jmeter-plugins.org/wiki/InterThreadCommunication/?utm_source=jmeter&utm_medium=helplink&utm_campaign=InterThreadCommunication), is it?
> 
> -----
> VR
> 
> 
> -----Original Message-----
> From: BOLB (Bohdan L Bodnar) [mailto:BOLB@panduit.com] 
> Sent: Thursday, June 05, 2014 6:58 PM
> To: jmeter-user@jakarta.apache.org
> Subject: Dynamic Data
> 
> I've a situation that I can't figure out how to solve; I'm hoping someone in this forum can provide ideas.  Here is the background:
> 
> I am making HTTP-based API calls to a system.  The response to one of these calls returns the ID (an integer) of an entity that has been created.  This ID is extracted via the Regular Expression Extractor and assigned to a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane and the value of DEVICE_ID is written to a .csv file via the Flexible File Writer plugin.  I have confirmed that the integer value is correctly written to the file.  Eventually, I want to delete this entity via an API call.  The following API call (format) works exactly as intended:
> 
> /rest/api/X/Y/${DEVICE_ID}
> 
> whereas the following fails:
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}
> 
> The failure occurs because there is no appending of the device ID.
> 
> What I am doing incorrectly?
> 
> Best regards,
> 
> Bo
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


RE: Dynamic Data

Posted by "BOLB (Bohdan L Bodnar)" <BO...@panduit.com>.
Each thread creates entities and deletes entities that it has created.  Multiple threads will be doing this during each run (more correctly, using Monte Carlo simulation terminology, "independent replication").  I considered what you're suggesting and rejected this idea (there are technical reasons, mostly pertaining to non-sequential IDs - if they were sequential, I'd be using algorithmic methods).

Best regards,

Bo


-----Original Message-----
From: Ryabtsev Vladimir [mailto:v.ryabtsev@pflb.ru] 
Sent: Friday, June 06, 2014 6:28 AM
To: JMeter Users List
Subject: RE: Dynamic Data

Hi,

Are you going to create and delete entities during the one test run but from the different threads?
Isn't it work for Inter Thread Communication machinery (http://jmeter-plugins.org/wiki/InterThreadCommunication/?utm_source=jmeter&utm_medium=helplink&utm_campaign=InterThreadCommunication), is it?

-----
VR


-----Original Message-----
From: BOLB (Bohdan L Bodnar) [mailto:BOLB@panduit.com] 
Sent: Thursday, June 05, 2014 6:58 PM
To: jmeter-user@jakarta.apache.org
Subject: Dynamic Data

I've a situation that I can't figure out how to solve; I'm hoping someone in this forum can provide ideas.  Here is the background:

I am making HTTP-based API calls to a system.  The response to one of these calls returns the ID (an integer) of an entity that has been created.  This ID is extracted via the Regular Expression Extractor and assigned to a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane and the value of DEVICE_ID is written to a .csv file via the Flexible File Writer plugin.  I have confirmed that the integer value is correctly written to the file.  Eventually, I want to delete this entity via an API call.  The following API call (format) works exactly as intended:

/rest/api/X/Y/${DEVICE_ID}

whereas the following fails:
/rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}

The failure occurs because there is no appending of the device ID.

What I am doing incorrectly?

Best regards,

Bo

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


RE: Dynamic Data

Posted by Ryabtsev Vladimir <v....@pflb.ru>.
Hi,

Are you going to create and delete entities during the one test run but from the different threads?
Isn't it work for Inter Thread Communication machinery (http://jmeter-plugins.org/wiki/InterThreadCommunication/?utm_source=jmeter&utm_medium=helplink&utm_campaign=InterThreadCommunication), is it?

-----
VR


-----Original Message-----
From: BOLB (Bohdan L Bodnar) [mailto:BOLB@panduit.com] 
Sent: Thursday, June 05, 2014 6:58 PM
To: jmeter-user@jakarta.apache.org
Subject: Dynamic Data

I've a situation that I can't figure out how to solve; I'm hoping someone in this forum can provide ideas.  Here is the background:

I am making HTTP-based API calls to a system.  The response to one of these calls returns the ID (an integer) of an entity that has been created.  This ID is extracted via the Regular Expression Extractor and assigned to a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane and the value of DEVICE_ID is written to a .csv file via the Flexible File Writer plugin.  I have confirmed that the integer value is correctly written to the file.  Eventually, I want to delete this entity via an API call.  The following API call (format) works exactly as intended:

/rest/api/X/Y/${DEVICE_ID}

whereas the following fails:
/rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}

The failure occurs because there is no appending of the device ID.

What I am doing incorrectly?

Best regards,

Bo

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


Re: Dynamic Data

Posted by sebb <se...@gmail.com>.
On 5 June 2014 15:57, BOLB (Bohdan L Bodnar) <BO...@panduit.com> wrote:
> I've a situation that I can't figure out how to solve; I'm hoping someone in this forum can provide ideas.  Here is the background:
>
> I am making HTTP-based API calls to a system.  The response to one of these calls returns the ID (an integer) of an entity that has been created.  This ID is extracted via the Regular Expression Extractor and assigned to a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane and the value of DEVICE_ID is written to a .csv file via the Flexible File Writer plugin.  I have confirmed that the integer value is correctly written to the file.  Eventually, I want to delete this entity via an API call.  The following API call (format) works exactly as intended:
>
> /rest/api/X/Y/${DEVICE_ID}
>
> whereas the following fails:
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}
>
> The failure occurs because there is no appending of the device ID.
>
> What I am doing incorrectly?

Impossible to say for sure without knowing the format of the csv file.
But maybe the ID is in a different column.

> Best regards,
>
> Bo

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


Re: Dynamic Data

Posted by "Derry, Stanton" <St...@digitalinsight.com>.
Bo,

In reading the thread is there a reason your not using properties to hold
your ID? 

Thanks,
Stan Derry
Digital Insight
Lead Performance Engineer
o: 650-556-8365
This email may contain confidential and privileged material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient, please contact
the sender and delete all copies.






On 6/6/14, 6:47 AM, "BOLB (Bohdan L Bodnar)" <BO...@panduit.com> wrote:

>I'll see what I can do - I'll have to censor most of it.
>
>-----Original Message-----
>From: Masters,Louis [mailto:Louis.Masters@fhlbny.com]
>Sent: Friday, June 06, 2014 8:44 AM
>To: JMeter Users List
>Subject: RE: Dynamic Data
>
>Yes, can you share your script (or a piece)?
>
>> -----Original Message-----
>> From: Deepak Shetty [mailto:shettyd@gmail.com]
>> Sent: Thursday, June 05, 2014 6:12 PM
>> To: JMeter Users List
>> Subject: Re: Dynamic Data
>>
>> I dont think CSV read cares about the data type , it reads a string
>> and returns a String - the error in jmeter.log refers to the column
>> index as far as I can tell - are you able to share your jmeter script?
>>  in any case flexible file writer isnt part of jmeter so any issues
>> would it would have to be taken up elsewhere
>>
>>
>> On Thu, Jun 5, 2014 at 2:16 PM, BOLB (Bohdan L Bodnar)
>> <BO...@panduit.com>
>> wrote:
>>
>> > I think I know what's going on:
>> >
>> > If I take the .csv file and manually enter bogus IDs, the API call
>> > functions as intended.  However, data from the Flexible File Writer
>> > (FFW) results in the malfunction as illustrated below.  The manual
>> > entry results in a string being stored in the .csv file whereas the
>> > FFW approach stores an integer.  Hence, there's a mismatch.
>> >
>> > Is there a simple way of converting an integer to a string in jmeter?
>> > I'm probably missing something obvious, but I just don't see one.
>> >
>> > Best regards,
>> >
>> > Bo
>> >
>> >
>> > -----Original Message-----
>> > From: Deepak Shetty [mailto:shettyd@gmail.com]
>> > Sent: Thursday, June 05, 2014 12:49 PM
>> > To: JMeter Users List
>> > Subject: Re: Dynamic Data
>> >
>> > Hi
>> > I tried on 2.9 - it works fine for me - This is literally the line
>> > ${__CSVRead(../data/a.csv,0)} - ${__CSVRead(../data/a.csv,1)} -
>> > ${__CSVRead(../data/a.csv,next)} prints out the values as expected
>> >
>> > Are you trying to write to the file at the same time as you are
>> > reading from it? I dont think that works
>> >
>> >
>> >
>> >
>> > On Thu, Jun 5, 2014 at 9:32 AM, BOLB (Bohdan L Bodnar)
>> > <BO...@panduit.com>
>> > wrote:
>> >
>> > > Deepak, thank you kindly for such a quick response.  The file is
>> > > being found, and opened, correctly.  The error message is as
>> follows:
>> > >
>> > > 2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1
>> -
>> > > invalid column number: 0 at row 0
>> java.lang.IndexOutOfBoundsException:
>> > > Index: 0, Size: 0
>> > >
>> > > In the current embodiment, there are two columns and one row.
>> > > Each column has one integer in it.  If I replace the column number
>> > > with "1", I obtain the following error message:
>> > >
>> > > 2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1
>> -
>> > > can't parse column number:  1 java.lang.NumberFormatException: For
>> > > input
>> > string:
>> > > " 1"
>> > >
>> > > The integers are separated by a comma followed by a space; for
>> > > example,
>> > >
>> > > 23, 99
>> > >
>> > > I forgot to mention that this is jmeter 2.9
>> > >
>> > > Best regards,
>> > >
>> > > Bo
>> > >
>> > >
>> > > -----Original Message-----
>> > > From: Deepak Shetty [mailto:shettyd@gmail.com]
>> > > Sent: Thursday, June 05, 2014 10:08 AM
>> > > To: JMeter Users List
>> > > Subject: Re: Dynamic Data
>> > >
>> > > Hi
>> > > the 1 will be the second column , do you have two columns?
>> > > Also check jmeter.log \ might be a special character so you could
>> > > either escape it \\ or change to use / . Also check jmeter.log for
>> > > errors
>> > >
>> > > http://jmeter.apache.org/usermanual/functions.html#__CSVRead -
>> > > please read other info in the docs as well (The function is not
>> > > suitable for use with large files, as the entire file is stored in
>> > > memory.)
>> > >
>> > >
>> > > On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar)
>> > > <BO...@panduit.com>
>> > > wrote:
>> > >
>> > > > I've a situation that I can't figure out how to solve; I'm
>> > > > hoping someone in this forum can provide ideas.  Here is the
>>background:
>> > > >
>> > > > I am making HTTP-based API calls to a system.  The response to
>> one
>> > > > of these calls returns the ID (an integer) of an entity that has
>> > > > been
>> > > created.
>> > > >  This ID is extracted via the Regular Expression Extractor and
>> > > > assigned to a variable (call it "DEVICE_ID") in the Regular
>> > > > Expression Extractor pane and the value of DEVICE_ID is written
>> to
>> > > > a .csv file via the Flexible File Writer plugin.  I have
>> confirmed
>> > > > that the integer value is correctly written to the file.
>> > > > Eventually, I want to delete this entity via an API call.  The
>> > > > following API call (format)
>> > > works exactly as intended:
>> > > >
>> > > > /rest/api/X/Y/${DEVICE_ID}
>> > > >
>> > > > whereas the following fails:
>> > > >
>> > > >
>> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bi
>> > > > n\
>> > > > FI
>> > > > LENAME.csv,1)}
>> > > >
>> > > > The failure occurs because there is no appending of the device
>> ID.
>> > > >
>> > > > What I am doing incorrectly?
>> > > >
>> > > > Best regards,
>> > > >
>> > > > Bo
>> > > >
>> > >
>> > > ------------------------------------------------------------------
>> > > -
>> -
>> > > - To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>> > > For additional commands, e-mail: user-help@jmeter.apache.org
>> > >
>> >
>> > --------------------------------------------------------------------
>> > - To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>> > For additional commands, e-mail: user-help@jmeter.apache.org
>> >
>
>
>Confidentiality Notice: The information contained in this e-mail and any
>attachments (including, but not limited to, any attached e-mails) may be
>legally privileged and confidential. If you are not an intended
>recipient, you are hereby notified that any dissemination, distribution
>or copying of this e-mail is strictly prohibited. If you have received
>this e-mail in error, please notify the sender and permanently delete the
>e-mail and any attachments immediately. You should not retain, copy or
>use this e-mail or any attachment for any purpose, nor disclose all or
>any part of the contents to any other person. Thank you.
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>For additional commands, e-mail: user-help@jmeter.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


RE: Dynamic Data

Posted by "BOLB (Bohdan L Bodnar)" <BO...@panduit.com>.
I'll see what I can do - I'll have to censor most of it.

-----Original Message-----
From: Masters,Louis [mailto:Louis.Masters@fhlbny.com] 
Sent: Friday, June 06, 2014 8:44 AM
To: JMeter Users List
Subject: RE: Dynamic Data

Yes, can you share your script (or a piece)?

> -----Original Message-----
> From: Deepak Shetty [mailto:shettyd@gmail.com]
> Sent: Thursday, June 05, 2014 6:12 PM
> To: JMeter Users List
> Subject: Re: Dynamic Data
>
> I dont think CSV read cares about the data type , it reads a string 
> and returns a String - the error in jmeter.log refers to the column 
> index as far as I can tell - are you able to share your jmeter script?
>  in any case flexible file writer isnt part of jmeter so any issues 
> would it would have to be taken up elsewhere
>
>
> On Thu, Jun 5, 2014 at 2:16 PM, BOLB (Bohdan L Bodnar) 
> <BO...@panduit.com>
> wrote:
>
> > I think I know what's going on:
> >
> > If I take the .csv file and manually enter bogus IDs, the API call 
> > functions as intended.  However, data from the Flexible File Writer
> > (FFW) results in the malfunction as illustrated below.  The manual 
> > entry results in a string being stored in the .csv file whereas the 
> > FFW approach stores an integer.  Hence, there's a mismatch.
> >
> > Is there a simple way of converting an integer to a string in jmeter?
> > I'm probably missing something obvious, but I just don't see one.
> >
> > Best regards,
> >
> > Bo
> >
> >
> > -----Original Message-----
> > From: Deepak Shetty [mailto:shettyd@gmail.com]
> > Sent: Thursday, June 05, 2014 12:49 PM
> > To: JMeter Users List
> > Subject: Re: Dynamic Data
> >
> > Hi
> > I tried on 2.9 - it works fine for me - This is literally the line 
> > ${__CSVRead(../data/a.csv,0)} - ${__CSVRead(../data/a.csv,1)} - 
> > ${__CSVRead(../data/a.csv,next)} prints out the values as expected
> >
> > Are you trying to write to the file at the same time as you are 
> > reading from it? I dont think that works
> >
> >
> >
> >
> > On Thu, Jun 5, 2014 at 9:32 AM, BOLB (Bohdan L Bodnar) 
> > <BO...@panduit.com>
> > wrote:
> >
> > > Deepak, thank you kindly for such a quick response.  The file is 
> > > being found, and opened, correctly.  The error message is as
> follows:
> > >
> > > 2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1
> -
> > > invalid column number: 0 at row 0
> java.lang.IndexOutOfBoundsException:
> > > Index: 0, Size: 0
> > >
> > > In the current embodiment, there are two columns and one row.  
> > > Each column has one integer in it.  If I replace the column number 
> > > with "1", I obtain the following error message:
> > >
> > > 2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1
> -
> > > can't parse column number:  1 java.lang.NumberFormatException: For 
> > > input
> > string:
> > > " 1"
> > >
> > > The integers are separated by a comma followed by a space; for 
> > > example,
> > >
> > > 23, 99
> > >
> > > I forgot to mention that this is jmeter 2.9
> > >
> > > Best regards,
> > >
> > > Bo
> > >
> > >
> > > -----Original Message-----
> > > From: Deepak Shetty [mailto:shettyd@gmail.com]
> > > Sent: Thursday, June 05, 2014 10:08 AM
> > > To: JMeter Users List
> > > Subject: Re: Dynamic Data
> > >
> > > Hi
> > > the 1 will be the second column , do you have two columns?
> > > Also check jmeter.log \ might be a special character so you could 
> > > either escape it \\ or change to use / . Also check jmeter.log for 
> > > errors
> > >
> > > http://jmeter.apache.org/usermanual/functions.html#__CSVRead - 
> > > please read other info in the docs as well (The function is not 
> > > suitable for use with large files, as the entire file is stored in
> > > memory.)
> > >
> > >
> > > On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar) 
> > > <BO...@panduit.com>
> > > wrote:
> > >
> > > > I've a situation that I can't figure out how to solve; I'm 
> > > > hoping someone in this forum can provide ideas.  Here is the background:
> > > >
> > > > I am making HTTP-based API calls to a system.  The response to
> one
> > > > of these calls returns the ID (an integer) of an entity that has 
> > > > been
> > > created.
> > > >  This ID is extracted via the Regular Expression Extractor and 
> > > > assigned to a variable (call it "DEVICE_ID") in the Regular 
> > > > Expression Extractor pane and the value of DEVICE_ID is written
> to
> > > > a .csv file via the Flexible File Writer plugin.  I have
> confirmed
> > > > that the integer value is correctly written to the file.
> > > > Eventually, I want to delete this entity via an API call.  The 
> > > > following API call (format)
> > > works exactly as intended:
> > > >
> > > > /rest/api/X/Y/${DEVICE_ID}
> > > >
> > > > whereas the following fails:
> > > >
> > > >
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bi
> > > > n\
> > > > FI
> > > > LENAME.csv,1)}
> > > >
> > > > The failure occurs because there is no appending of the device
> ID.
> > > >
> > > > What I am doing incorrectly?
> > > >
> > > > Best regards,
> > > >
> > > > Bo
> > > >
> > >
> > > ------------------------------------------------------------------
> > > -
> -
> > > - To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> > > For additional commands, e-mail: user-help@jmeter.apache.org
> > >
> >
> > --------------------------------------------------------------------
> > - To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> > For additional commands, e-mail: user-help@jmeter.apache.org
> >


Confidentiality Notice: The information contained in this e-mail and any attachments (including, but not limited to, any attached e-mails) may be legally privileged and confidential. If you are not an intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender and permanently delete the e-mail and any attachments immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org

RE: Dynamic Data

Posted by "Masters,Louis" <Lo...@fhlbny.com>.
Yes, can you share your script (or a piece)?

> -----Original Message-----
> From: Deepak Shetty [mailto:shettyd@gmail.com]
> Sent: Thursday, June 05, 2014 6:12 PM
> To: JMeter Users List
> Subject: Re: Dynamic Data
>
> I dont think CSV read cares about the data type , it reads a string and
> returns a String - the error in jmeter.log refers to the column index
> as far as I can tell - are you able to share your jmeter script?
>  in any case flexible file writer isnt part of jmeter so any issues
> would it would have to be taken up elsewhere
>
>
> On Thu, Jun 5, 2014 at 2:16 PM, BOLB (Bohdan L Bodnar)
> <BO...@panduit.com>
> wrote:
>
> > I think I know what's going on:
> >
> > If I take the .csv file and manually enter bogus IDs, the API call
> > functions as intended.  However, data from the Flexible File Writer
> > (FFW) results in the malfunction as illustrated below.  The manual
> > entry results in a string being stored in the .csv file whereas the
> > FFW approach stores an integer.  Hence, there's a mismatch.
> >
> > Is there a simple way of converting an integer to a string in jmeter?
> > I'm probably missing something obvious, but I just don't see one.
> >
> > Best regards,
> >
> > Bo
> >
> >
> > -----Original Message-----
> > From: Deepak Shetty [mailto:shettyd@gmail.com]
> > Sent: Thursday, June 05, 2014 12:49 PM
> > To: JMeter Users List
> > Subject: Re: Dynamic Data
> >
> > Hi
> > I tried on 2.9 - it works fine for me - This is literally the line
> > ${__CSVRead(../data/a.csv,0)} - ${__CSVRead(../data/a.csv,1)} -
> > ${__CSVRead(../data/a.csv,next)} prints out the values as expected
> >
> > Are you trying to write to the file at the same time as you are
> > reading from it? I dont think that works
> >
> >
> >
> >
> > On Thu, Jun 5, 2014 at 9:32 AM, BOLB (Bohdan L Bodnar)
> > <BO...@panduit.com>
> > wrote:
> >
> > > Deepak, thank you kindly for such a quick response.  The file is
> > > being found, and opened, correctly.  The error message is as
> follows:
> > >
> > > 2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1
> -
> > > invalid column number: 0 at row 0
> java.lang.IndexOutOfBoundsException:
> > > Index: 0, Size: 0
> > >
> > > In the current embodiment, there are two columns and one row.  Each
> > > column has one integer in it.  If I replace the column number with
> > > "1", I obtain the following error message:
> > >
> > > 2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1
> -
> > > can't parse column number:  1 java.lang.NumberFormatException: For
> > > input
> > string:
> > > " 1"
> > >
> > > The integers are separated by a comma followed by a space; for
> > > example,
> > >
> > > 23, 99
> > >
> > > I forgot to mention that this is jmeter 2.9
> > >
> > > Best regards,
> > >
> > > Bo
> > >
> > >
> > > -----Original Message-----
> > > From: Deepak Shetty [mailto:shettyd@gmail.com]
> > > Sent: Thursday, June 05, 2014 10:08 AM
> > > To: JMeter Users List
> > > Subject: Re: Dynamic Data
> > >
> > > Hi
> > > the 1 will be the second column , do you have two columns?
> > > Also check jmeter.log \ might be a special character so you could
> > > either escape it \\ or change to use / . Also check jmeter.log for
> > > errors
> > >
> > > http://jmeter.apache.org/usermanual/functions.html#__CSVRead -
> > > please read other info in the docs as well (The function is not
> > > suitable for use with large files, as the entire file is stored in
> > > memory.)
> > >
> > >
> > > On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar)
> > > <BO...@panduit.com>
> > > wrote:
> > >
> > > > I've a situation that I can't figure out how to solve; I'm hoping
> > > > someone in this forum can provide ideas.  Here is the background:
> > > >
> > > > I am making HTTP-based API calls to a system.  The response to
> one
> > > > of these calls returns the ID (an integer) of an entity that has
> > > > been
> > > created.
> > > >  This ID is extracted via the Regular Expression Extractor and
> > > > assigned to a variable (call it "DEVICE_ID") in the Regular
> > > > Expression Extractor pane and the value of DEVICE_ID is written
> to
> > > > a .csv file via the Flexible File Writer plugin.  I have
> confirmed
> > > > that the integer value is correctly written to the file.
> > > > Eventually, I want to delete this entity via an API call.  The
> > > > following API call (format)
> > > works exactly as intended:
> > > >
> > > > /rest/api/X/Y/${DEVICE_ID}
> > > >
> > > > whereas the following fails:
> > > >
> > > >
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bi
> > > > n\
> > > > FI
> > > > LENAME.csv,1)}
> > > >
> > > > The failure occurs because there is no appending of the device
> ID.
> > > >
> > > > What I am doing incorrectly?
> > > >
> > > > Best regards,
> > > >
> > > > Bo
> > > >
> > >
> > > -------------------------------------------------------------------
> -
> > > - To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> > > For additional commands, e-mail: user-help@jmeter.apache.org
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> > For additional commands, e-mail: user-help@jmeter.apache.org
> >


Confidentiality Notice: The information contained in this e-mail and any attachments (including, but not limited to, any attached e-mails) may be legally privileged and confidential. If you are not an intended recipient, you are hereby notified that any dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender and permanently delete the e-mail and any attachments immediately. You should not retain, copy or use this e-mail or any attachment for any purpose, nor disclose all or any part of the contents to any other person. Thank you.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org

Re: Dynamic Data

Posted by Deepak Shetty <sh...@gmail.com>.
I dont think CSV read cares about the data type , it reads a string and
returns a String - the error in jmeter.log refers to the column index as
far as I can tell - are you able to share your jmeter script?
 in any case flexible file writer isnt part of jmeter so any issues would
it would have to be taken up elsewhere


On Thu, Jun 5, 2014 at 2:16 PM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
wrote:

> I think I know what's going on:
>
> If I take the .csv file and manually enter bogus IDs, the API call
> functions as intended.  However, data from the Flexible File Writer (FFW)
> results in the malfunction as illustrated below.  The manual entry results
> in a string being stored in the .csv file whereas the FFW approach stores
> an integer.  Hence, there's a mismatch.
>
> Is there a simple way of converting an integer to a string in jmeter?  I'm
> probably missing something obvious, but I just don't see one.
>
> Best regards,
>
> Bo
>
>
> -----Original Message-----
> From: Deepak Shetty [mailto:shettyd@gmail.com]
> Sent: Thursday, June 05, 2014 12:49 PM
> To: JMeter Users List
> Subject: Re: Dynamic Data
>
> Hi
> I tried on 2.9 - it works fine for me - This is literally the line
> ${__CSVRead(../data/a.csv,0)} - ${__CSVRead(../data/a.csv,1)} -
> ${__CSVRead(../data/a.csv,next)} prints out the values as expected
>
> Are you trying to write to the file at the same time as you are reading
> from it? I dont think that works
>
>
>
>
> On Thu, Jun 5, 2014 at 9:32 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
> wrote:
>
> > Deepak, thank you kindly for such a quick response.  The file is being
> > found, and opened, correctly.  The error message is as follows:
> >
> > 2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 -
> > invalid column number: 0 at row 0 java.lang.IndexOutOfBoundsException:
> > Index: 0, Size: 0
> >
> > In the current embodiment, there are two columns and one row.  Each
> > column has one integer in it.  If I replace the column number with
> > "1", I obtain the following error message:
> >
> > 2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 -
> > can't parse column number:  1 java.lang.NumberFormatException: For input
> string:
> > " 1"
> >
> > The integers are separated by a comma followed by a space; for
> > example,
> >
> > 23, 99
> >
> > I forgot to mention that this is jmeter 2.9
> >
> > Best regards,
> >
> > Bo
> >
> >
> > -----Original Message-----
> > From: Deepak Shetty [mailto:shettyd@gmail.com]
> > Sent: Thursday, June 05, 2014 10:08 AM
> > To: JMeter Users List
> > Subject: Re: Dynamic Data
> >
> > Hi
> > the 1 will be the second column , do you have two columns?
> > Also check jmeter.log \ might be a special character so you could
> > either escape it \\ or change to use / . Also check jmeter.log for
> > errors
> >
> > http://jmeter.apache.org/usermanual/functions.html#__CSVRead - please
> > read other info in the docs as well (The function is not suitable for
> > use with large files, as the entire file is stored in memory.)
> >
> >
> > On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar)
> > <BO...@panduit.com>
> > wrote:
> >
> > > I've a situation that I can't figure out how to solve; I'm hoping
> > > someone in this forum can provide ideas.  Here is the background:
> > >
> > > I am making HTTP-based API calls to a system.  The response to one
> > > of these calls returns the ID (an integer) of an entity that has
> > > been
> > created.
> > >  This ID is extracted via the Regular Expression Extractor and
> > > assigned to a variable (call it "DEVICE_ID") in the Regular
> > > Expression Extractor pane and the value of DEVICE_ID is written to a
> > > .csv file via the Flexible File Writer plugin.  I have confirmed
> > > that the integer value is correctly written to the file.
> > > Eventually, I want to delete this entity via an API call.  The
> > > following API call (format)
> > works exactly as intended:
> > >
> > > /rest/api/X/Y/${DEVICE_ID}
> > >
> > > whereas the following fails:
> > >
> > > /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\
> > > FI
> > > LENAME.csv,1)}
> > >
> > > The failure occurs because there is no appending of the device ID.
> > >
> > > What I am doing incorrectly?
> > >
> > > Best regards,
> > >
> > > Bo
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> > For additional commands, e-mail: user-help@jmeter.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>

RE: Dynamic Data

Posted by "BOLB (Bohdan L Bodnar)" <BO...@panduit.com>.
I think I know what's going on:

If I take the .csv file and manually enter bogus IDs, the API call functions as intended.  However, data from the Flexible File Writer (FFW) results in the malfunction as illustrated below.  The manual entry results in a string being stored in the .csv file whereas the FFW approach stores an integer.  Hence, there's a mismatch.

Is there a simple way of converting an integer to a string in jmeter?  I'm probably missing something obvious, but I just don't see one.

Best regards,

Bo


-----Original Message-----
From: Deepak Shetty [mailto:shettyd@gmail.com] 
Sent: Thursday, June 05, 2014 12:49 PM
To: JMeter Users List
Subject: Re: Dynamic Data

Hi
I tried on 2.9 - it works fine for me - This is literally the line ${__CSVRead(../data/a.csv,0)} - ${__CSVRead(../data/a.csv,1)} - ${__CSVRead(../data/a.csv,next)} prints out the values as expected

Are you trying to write to the file at the same time as you are reading from it? I dont think that works




On Thu, Jun 5, 2014 at 9:32 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
wrote:

> Deepak, thank you kindly for such a quick response.  The file is being 
> found, and opened, correctly.  The error message is as follows:
>
> 2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 - 
> invalid column number: 0 at row 0 java.lang.IndexOutOfBoundsException:
> Index: 0, Size: 0
>
> In the current embodiment, there are two columns and one row.  Each 
> column has one integer in it.  If I replace the column number with 
> "1", I obtain the following error message:
>
> 2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 - 
> can't parse column number:  1 java.lang.NumberFormatException: For input string:
> " 1"
>
> The integers are separated by a comma followed by a space; for 
> example,
>
> 23, 99
>
> I forgot to mention that this is jmeter 2.9
>
> Best regards,
>
> Bo
>
>
> -----Original Message-----
> From: Deepak Shetty [mailto:shettyd@gmail.com]
> Sent: Thursday, June 05, 2014 10:08 AM
> To: JMeter Users List
> Subject: Re: Dynamic Data
>
> Hi
> the 1 will be the second column , do you have two columns?
> Also check jmeter.log \ might be a special character so you could 
> either escape it \\ or change to use / . Also check jmeter.log for 
> errors
>
> http://jmeter.apache.org/usermanual/functions.html#__CSVRead - please 
> read other info in the docs as well (The function is not suitable for 
> use with large files, as the entire file is stored in memory.)
>
>
> On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar) 
> <BO...@panduit.com>
> wrote:
>
> > I've a situation that I can't figure out how to solve; I'm hoping 
> > someone in this forum can provide ideas.  Here is the background:
> >
> > I am making HTTP-based API calls to a system.  The response to one 
> > of these calls returns the ID (an integer) of an entity that has 
> > been
> created.
> >  This ID is extracted via the Regular Expression Extractor and 
> > assigned to a variable (call it "DEVICE_ID") in the Regular 
> > Expression Extractor pane and the value of DEVICE_ID is written to a 
> > .csv file via the Flexible File Writer plugin.  I have confirmed 
> > that the integer value is correctly written to the file.  
> > Eventually, I want to delete this entity via an API call.  The 
> > following API call (format)
> works exactly as intended:
> >
> > /rest/api/X/Y/${DEVICE_ID}
> >
> > whereas the following fails:
> >
> > /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\
> > FI
> > LENAME.csv,1)}
> >
> > The failure occurs because there is no appending of the device ID.
> >
> > What I am doing incorrectly?
> >
> > Best regards,
> >
> > Bo
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org

Re: Dynamic Data

Posted by Deepak Shetty <sh...@gmail.com>.
Hi
I tried on 2.9 - it works fine for me - This is literally the line
${__CSVRead(../data/a.csv,0)} - ${__CSVRead(../data/a.csv,1)} -
${__CSVRead(../data/a.csv,next)}
prints out the values as expected

Are you trying to write to the file at the same time as you are reading
from it? I dont think that works




On Thu, Jun 5, 2014 at 9:32 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
wrote:

> Deepak, thank you kindly for such a quick response.  The file is being
> found, and opened, correctly.  The error message is as follows:
>
> 2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 -
> invalid column number: 0 at row 0 java.lang.IndexOutOfBoundsException:
> Index: 0, Size: 0
>
> In the current embodiment, there are two columns and one row.  Each column
> has one integer in it.  If I replace the column number with "1", I obtain
> the following error message:
>
> 2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 - can't
> parse column number:  1 java.lang.NumberFormatException: For input string:
> " 1"
>
> The integers are separated by a comma followed by a space; for example,
>
> 23, 99
>
> I forgot to mention that this is jmeter 2.9
>
> Best regards,
>
> Bo
>
>
> -----Original Message-----
> From: Deepak Shetty [mailto:shettyd@gmail.com]
> Sent: Thursday, June 05, 2014 10:08 AM
> To: JMeter Users List
> Subject: Re: Dynamic Data
>
> Hi
> the 1 will be the second column , do you have two columns?
> Also check jmeter.log \ might be a special character so you could either
> escape it \\ or change to use / . Also check jmeter.log for errors
>
> http://jmeter.apache.org/usermanual/functions.html#__CSVRead - please
> read other info in the docs as well (The function is not suitable for use
> with large files, as the entire file is stored in memory.)
>
>
> On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
> wrote:
>
> > I've a situation that I can't figure out how to solve; I'm hoping
> > someone in this forum can provide ideas.  Here is the background:
> >
> > I am making HTTP-based API calls to a system.  The response to one of
> > these calls returns the ID (an integer) of an entity that has been
> created.
> >  This ID is extracted via the Regular Expression Extractor and
> > assigned to a variable (call it "DEVICE_ID") in the Regular Expression
> > Extractor pane and the value of DEVICE_ID is written to a .csv file
> > via the Flexible File Writer plugin.  I have confirmed that the
> > integer value is correctly written to the file.  Eventually, I want to
> > delete this entity via an API call.  The following API call (format)
> works exactly as intended:
> >
> > /rest/api/X/Y/${DEVICE_ID}
> >
> > whereas the following fails:
> >
> > /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FI
> > LENAME.csv,1)}
> >
> > The failure occurs because there is no appending of the device ID.
> >
> > What I am doing incorrectly?
> >
> > Best regards,
> >
> > Bo
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>

RE: Dynamic Data

Posted by "BOLB (Bohdan L Bodnar)" <BO...@panduit.com>.
Deepak, thank you kindly for such a quick response.  The file is being found, and opened, correctly.  The error message is as follows:

2014/06/05 11:15:52 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 - invalid column number: 0 at row 0 java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

In the current embodiment, there are two columns and one row.  Each column has one integer in it.  If I replace the column number with "1", I obtain the following error message:

2014/06/05 11:24:16 WARN  - jmeter.functions.CSVRead: APIUSER1 1-1 - can't parse column number:  1 java.lang.NumberFormatException: For input string: " 1"

The integers are separated by a comma followed by a space; for example,

23, 99  

I forgot to mention that this is jmeter 2.9

Best regards,

Bo


-----Original Message-----
From: Deepak Shetty [mailto:shettyd@gmail.com] 
Sent: Thursday, June 05, 2014 10:08 AM
To: JMeter Users List
Subject: Re: Dynamic Data

Hi
the 1 will be the second column , do you have two columns?
Also check jmeter.log \ might be a special character so you could either escape it \\ or change to use / . Also check jmeter.log for errors

http://jmeter.apache.org/usermanual/functions.html#__CSVRead - please read other info in the docs as well (The function is not suitable for use with large files, as the entire file is stored in memory.)


On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
wrote:

> I've a situation that I can't figure out how to solve; I'm hoping 
> someone in this forum can provide ideas.  Here is the background:
>
> I am making HTTP-based API calls to a system.  The response to one of 
> these calls returns the ID (an integer) of an entity that has been created.
>  This ID is extracted via the Regular Expression Extractor and 
> assigned to a variable (call it "DEVICE_ID") in the Regular Expression 
> Extractor pane and the value of DEVICE_ID is written to a .csv file 
> via the Flexible File Writer plugin.  I have confirmed that the 
> integer value is correctly written to the file.  Eventually, I want to 
> delete this entity via an API call.  The following API call (format) works exactly as intended:
>
> /rest/api/X/Y/${DEVICE_ID}
>
> whereas the following fails:
>
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FI
> LENAME.csv,1)}
>
> The failure occurs because there is no appending of the device ID.
>
> What I am doing incorrectly?
>
> Best regards,
>
> Bo
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org

Re: Dynamic Data

Posted by Deepak Shetty <sh...@gmail.com>.
Hi
the 1 will be the second column , do you have two columns?
Also check jmeter.log \ might be a special character so you could either
escape it \\ or change to use / . Also check jmeter.log for errors

http://jmeter.apache.org/usermanual/functions.html#__CSVRead - please read
other info in the docs as well (The function is not suitable for use with
large files, as the entire file is stored in memory.)


On Thu, Jun 5, 2014 at 7:57 AM, BOLB (Bohdan L Bodnar) <BO...@panduit.com>
wrote:

> I've a situation that I can't figure out how to solve; I'm hoping someone
> in this forum can provide ideas.  Here is the background:
>
> I am making HTTP-based API calls to a system.  The response to one of
> these calls returns the ID (an integer) of an entity that has been created.
>  This ID is extracted via the Regular Expression Extractor and assigned to
> a variable (call it "DEVICE_ID") in the Regular Expression Extractor pane
> and the value of DEVICE_ID is written to a .csv file via the Flexible File
> Writer plugin.  I have confirmed that the integer value is correctly
> written to the file.  Eventually, I want to delete this entity via an API
> call.  The following API call (format) works exactly as intended:
>
> /rest/api/X/Y/${DEVICE_ID}
>
> whereas the following fails:
>
> /rest/api/X/Y/${__CSVRead(C:\Users\Administrator\Desktop\jmeter\bin\FILENAME.csv,1)}
>
> The failure occurs because there is no appending of the device ID.
>
> What I am doing incorrectly?
>
> Best regards,
>
> Bo
>