CSV Data Reading for Multiple Users

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

CSV Data Reading for Multiple Users

Nayak, Soumya R.
HI Team,

I have a requirement where in let's say I have 500 rows of data in a CSV file.
I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.

For 500 records in CSV ---
Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV

So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.

Thanks in advance.

Regards,
Soumya



******************************************************************************************
This message may contain confidential or proprietary information intended only for the use of the
addressee(s) named above or may contain information that is legally privileged. If you are
not the intended addressee, or the person responsible for delivering it to the intended addressee,
you are hereby notified that reading, disseminating, distributing or copying this message is strictly
prohibited. If you have received this message by mistake, please immediately notify us by
replying to the message and delete the original message and any copies immediately thereafter.

If you received this email as a commercial message and would like to opt out of future commercial
messages, please let us know and we will remove you from our distribution list.

Thank you.~
******************************************************************************************
FAFLD
Reply | Threaded
Open this post in threaded view
|

Re: CSV Data Reading for Multiple Users

贾国动
On your CSV Data Set Config element, set as below:
Resycle on EOF: False
Stop thread on EOF: True

hope helpful

在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:

    HI Team,
   
    I have a requirement where in let's say I have 500 rows of data in a CSV file.
    I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
    When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
   
    For 500 records in CSV ---
    Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
    Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
    Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
    Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
    Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
   
    So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
    Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
   
    Thanks in advance.
   
    Regards,
    Soumya
   
   
   
    ******************************************************************************************
    This message may contain confidential or proprietary information intended only for the use of the
    addressee(s) named above or may contain information that is legally privileged. If you are
    not the intended addressee, or the person responsible for delivering it to the intended addressee,
    you are hereby notified that reading, disseminating, distributing or copying this message is strictly
    prohibited. If you have received this message by mistake, please immediately notify us by
    replying to the message and delete the original message and any copies immediately thereafter.
   
    If you received this email as a commercial message and would like to opt out of future commercial
    messages, please let us know and we will remove you from our distribution list.
   
    Thank you.~
    ******************************************************************************************
    FAFLD
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

CSV Data Reading for Multiple Users

Nayak, Soumya R.
Hi ,

As per your details below it will not iterate the CSV more than once. That is fine but my requirement is how each thread picks up 100 rows at a time to parameterize the 100 variables in JSON request.
As far as I know each thread picks up one row , but how we can pick up 100 rows at one time with each thread and that too all threads picking up 100 unique records.

Thanks,
Soumya

-----Original Message-----
From: 贾国动 <[hidden email]>
Sent: Wednesday, December 19, 2018 10:38 AM
To: JMeter Users List <[hidden email]>
Subject: Re: CSV Data Reading for Multiple Users

On your CSV Data Set Config element, set as below:
Resycle on EOF: False
Stop thread on EOF: True

hope helpful

在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:

    HI Team,
   
    I have a requirement where in let's say I have 500 rows of data in a CSV file.
    I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
    When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
   
    For 500 records in CSV ---
    Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
    Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
    Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
    Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
    Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
   
    So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
    Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
   
    Thanks in advance.
   
    Regards,
    Soumya
   
   
   
    ******************************************************************************************
    This message may contain confidential or proprietary information intended only for the use of the
    addressee(s) named above or may contain information that is legally privileged. If you are
    not the intended addressee, or the person responsible for delivering it to the intended addressee,
    you are hereby notified that reading, disseminating, distributing or copying this message is strictly
    prohibited. If you have received this message by mistake, please immediately notify us by
    replying to the message and delete the original message and any copies immediately thereafter.
   
    If you received this email as a commercial message and would like to opt out of future commercial
    messages, please let us know and we will remove you from our distribution list.
   
    Thank you.~
    ******************************************************************************************
    FAFLD
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: CSV Data Reading for Multiple Users

贾国动
In reply to this post by 贾国动
forgot one thing:
on your Thread Group element, set as below:
the Number of Threads as yours 5
then set Loop Count: 100



在 2018/12/19 13:08,“贾国动”<[hidden email]> 写入:

    On your CSV Data Set Config element, set as below:
    Resycle on EOF: False
    Stop thread on EOF: True
   
    hope helpful
   
    在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:
   
        HI Team,
       
        I have a requirement where in let's say I have 500 rows of data in a CSV file.
        I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
        When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
       
        For 500 records in CSV ---
        Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
        Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
        Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
        Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
        Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
       
        So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
        Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
       
        Thanks in advance.
       
        Regards,
        Soumya
       
       
       
        ******************************************************************************************
        This message may contain confidential or proprietary information intended only for the use of the
        addressee(s) named above or may contain information that is legally privileged. If you are
        not the intended addressee, or the person responsible for delivering it to the intended addressee,
        you are hereby notified that reading, disseminating, distributing or copying this message is strictly
        prohibited. If you have received this message by mistake, please immediately notify us by
        replying to the message and delete the original message and any copies immediately thereafter.
       
        If you received this email as a commercial message and would like to opt out of future commercial
        messages, please let us know and we will remove you from our distribution list.
       
        Thank you.~
        ******************************************************************************************
        FAFLD
       
   
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

CSV Data Reading for Multiple Users

Nayak, Soumya R.
Hi Dong,
Are you saying the JSON http request and CSV data config will be under the same threadgroup ? If so , in that case when we loop 100 times , at one time it will pick up 1 record right from CSV.
Or you are saying JSON http request will be in a different thread groups where in TG the CSV looping happens 100 times and its assigned to the 100 variables and these variables are passed to the JSON request in other TG.
Please can you help me explain.

Thanks,
Soumya

-----Original Message-----
From: 贾国动 <[hidden email]>
Sent: Wednesday, December 19, 2018 10:42 AM
To: JMeter Users List <[hidden email]>
Subject: Re: CSV Data Reading for Multiple Users

forgot one thing:
on your Thread Group element, set as below:
the Number of Threads as yours 5
then set Loop Count: 100



在 2018/12/19 13:08,“贾国动”<[hidden email]> 写入:

    On your CSV Data Set Config element, set as below:
    Resycle on EOF: False
    Stop thread on EOF: True
   
    hope helpful
   
    在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:
   
        HI Team,
       
        I have a requirement where in let's say I have 500 rows of data in a CSV file.
        I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
        When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
       
        For 500 records in CSV ---
        Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
        Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
        Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
        Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
        Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
       
        So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
        Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
       
        Thanks in advance.
       
        Regards,
        Soumya
       
       
       
        ******************************************************************************************
        This message may contain confidential or proprietary information intended only for the use of the
        addressee(s) named above or may contain information that is legally privileged. If you are
        not the intended addressee, or the person responsible for delivering it to the intended addressee,
        you are hereby notified that reading, disseminating, distributing or copying this message is strictly
        prohibited. If you have received this message by mistake, please immediately notify us by
        replying to the message and delete the original message and any copies immediately thereafter.
       
        If you received this email as a commercial message and would like to opt out of future commercial
        messages, please let us know and we will remove you from our distribution list.
       
        Thank you.~
        ******************************************************************************************
        FAFLD
       
   
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: CSV Data Reading for Multiple Users

贾国动
In reply to this post by Nayak, Soumya R.
Sorry I misunderstood you before, I think this will solve your problem:

CSV data file as below:
variable1, variable2, variable3, ...variable100
value1-1, value1-2, value1-3, ...value1-100
value2-1, value2-2, value2-3, ...value2-100
...

CSV Data Set Config as below:
Variable Names(for example): v1, v2, v3, ... v100
Ignore first line: True

Then parameterize your request, set the variable as above:
${ v1}, ${ v2}, ${ v3}, ...${ v100}

Every request will get a line with 100 variables.

hope helpful


在 2018/12/19 13:12,“Nayak, Soumya R.”<[hidden email]> 写入:

    Hi ,
   
    As per your details below it will not iterate the CSV more than once. That is fine but my requirement is how each thread picks up 100 rows at a time to parameterize the 100 variables in JSON request.
    As far as I know each thread picks up one row , but how we can pick up 100 rows at one time with each thread and that too all threads picking up 100 unique records.
   
    Thanks,
    Soumya
   
    -----Original Message-----
    From: 贾国动 <[hidden email]>
    Sent: Wednesday, December 19, 2018 10:38 AM
    To: JMeter Users List <[hidden email]>
    Subject: Re: CSV Data Reading for Multiple Users
   
    On your CSV Data Set Config element, set as below:
    Resycle on EOF: False
    Stop thread on EOF: True
   
    hope helpful
   
    在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:
   
        HI Team,
       
        I have a requirement where in let's say I have 500 rows of data in a CSV file.
        I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
        When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
       
        For 500 records in CSV ---
        Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
        Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
        Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
        Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
        Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
       
        So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
        Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
       
        Thanks in advance.
       
        Regards,
        Soumya
       
       
       
        ******************************************************************************************
        This message may contain confidential or proprietary information intended only for the use of the
        addressee(s) named above or may contain information that is legally privileged. If you are
        not the intended addressee, or the person responsible for delivering it to the intended addressee,
        you are hereby notified that reading, disseminating, distributing or copying this message is strictly
        prohibited. If you have received this message by mistake, please immediately notify us by
        replying to the message and delete the original message and any copies immediately thereafter.
       
        If you received this email as a commercial message and would like to opt out of future commercial
        messages, please let us know and we will remove you from our distribution list.
       
        Thank you.~
        ******************************************************************************************
        FAFLD
       
   
   
   
    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [hidden email]
    For additional commands, e-mail: [hidden email]
   
   
    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [hidden email]
    For additional commands, e-mail: [hidden email]
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

CSV Data Reading for Multiple Users

Nayak, Soumya R.
Thanks Dong for the reply.
If it is the case of 100 array of variables in JSON. Like as shown in the below JSON requests - Address_1, City_1, State_1, Zip_1 etc. My CSV is having four columns of Address, City, State and Zip and has 500 rows for the data. Please scroll down to see. How to handle in this scenario. I am creating the CSV file taking data from the database

Below is the sample JSON :--
{
    "username": "",
    "password": "",
    "addresses":
   [
  {
    "streetAddress": "Address_1",
    "city": "City_1",
    "state": "State_1",
    "postalCode": "Zip_1"
  },
  {
    "streetAddress": "Address_2",
    "city": "City_2",
    "state": "State_2",
    "postalCode": "Zip_2"
  },
  {
    "streetAddress": "Address_3",
    "city": "City_3",
    "state": "State_3",
    "postalCode": "Zip_3"
  },
.
.
.
So on Upto 100 addresses.

CSV Structure
Address City State Zip
Abc pqr xxx 12345
Def aaa ooo 334455

Regards,
SOumya

-----Original Message-----
From: 贾国动 <[hidden email]>
Sent: Wednesday, December 19, 2018 11:14 AM
To: JMeter Users List <[hidden email]>
Subject: Re: CSV Data Reading for Multiple Users

Sorry I misunderstood you before, I think this will solve your problem:

CSV data file as below:
variable1, variable2, variable3, ...variable100 value1-1, value1-2, value1-3, ...value1-100 value2-1, value2-2, value2-3, ...value2-100 ...

CSV Data Set Config as below:
Variable Names(for example): v1, v2, v3, ... v100 Ignore first line: True

Then parameterize your request, set the variable as above:
${ v1}, ${ v2}, ${ v3}, ...${ v100}

Every request will get a line with 100 variables.

hope helpful


在 2018/12/19 13:12,“Nayak, Soumya R.”<[hidden email]> 写入:

    Hi ,
   
    As per your details below it will not iterate the CSV more than once. That is fine but my requirement is how each thread picks up 100 rows at a time to parameterize the 100 variables in JSON request.
    As far as I know each thread picks up one row , but how we can pick up 100 rows at one time with each thread and that too all threads picking up 100 unique records.
   
    Thanks,
    Soumya
   
    -----Original Message-----
    From: 贾国动 <[hidden email]>
    Sent: Wednesday, December 19, 2018 10:38 AM
    To: JMeter Users List <[hidden email]>
    Subject: Re: CSV Data Reading for Multiple Users
   
    On your CSV Data Set Config element, set as below:
    Resycle on EOF: False
    Stop thread on EOF: True
   
    hope helpful
   
    在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:
   
        HI Team,
       
        I have a requirement where in let's say I have 500 rows of data in a CSV file.
        I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
        When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
       
        For 500 records in CSV ---
        Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
        Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
        Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
        Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
        Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
       
        So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
        Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
       
        Thanks in advance.
       
        Regards,
        Soumya
       
       
       
        ******************************************************************************************
        This message may contain confidential or proprietary information intended only for the use of the
        addressee(s) named above or may contain information that is legally privileged. If you are
        not the intended addressee, or the person responsible for delivering it to the intended addressee,
        you are hereby notified that reading, disseminating, distributing or copying this message is strictly
        prohibited. If you have received this message by mistake, please immediately notify us by
        replying to the message and delete the original message and any copies immediately thereafter.
       
        If you received this email as a commercial message and would like to opt out of future commercial
        messages, please let us know and we will remove you from our distribution list.
       
        Thank you.~
        ******************************************************************************************
        FAFLD
       
   
   
   
    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [hidden email]
    For additional commands, e-mail: [hidden email]
   
   
    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [hidden email]
    For additional commands, e-mail: [hidden email]
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: CSV Data Reading for Multiple Users

贾国动
I see.
If I were you, in this case, I would write a python script to process the data so that each row contains 100 unique address information, and each row is the complete json body of a request.
As you said, your 500 rows of data are just five requests...

在 2018/12/19 14:08,“Nayak, Soumya R.”<[hidden email]> 写入:

    Thanks Dong for the reply.
    If it is the case of 100 array of variables in JSON. Like as shown in the below JSON requests - Address_1, City_1, State_1, Zip_1 etc. My CSV is having four columns of Address, City, State and Zip and has 500 rows for the data. Please scroll down to see. How to handle in this scenario. I am creating the CSV file taking data from the database
   
    Below is the sample JSON :--
    {
        "username": "",
        "password": "",
        "addresses":
       [
      {
        "streetAddress": "Address_1",
        "city": "City_1",
        "state": "State_1",
        "postalCode": "Zip_1"
      },
      {
        "streetAddress": "Address_2",
        "city": "City_2",
        "state": "State_2",
        "postalCode": "Zip_2"
      },
      {
        "streetAddress": "Address_3",
        "city": "City_3",
        "state": "State_3",
        "postalCode": "Zip_3"
      },
    .
    .
    .
    So on Upto 100 addresses.
   
    CSV Structure
    Address City State Zip
    Abc pqr xxx 12345
    Def aaa ooo 334455
   
    Regards,
    SOumya
   
    -----Original Message-----
    From: 贾国动 <[hidden email]>
    Sent: Wednesday, December 19, 2018 11:14 AM
    To: JMeter Users List <[hidden email]>
    Subject: Re: CSV Data Reading for Multiple Users
   
    Sorry I misunderstood you before, I think this will solve your problem:
   
    CSV data file as below:
    variable1, variable2, variable3, ...variable100 value1-1, value1-2, value1-3, ...value1-100 value2-1, value2-2, value2-3, ...value2-100 ...
   
    CSV Data Set Config as below:
    Variable Names(for example): v1, v2, v3, ... v100 Ignore first line: True
   
    Then parameterize your request, set the variable as above:
    ${ v1}, ${ v2}, ${ v3}, ...${ v100}
   
    Every request will get a line with 100 variables.
   
    hope helpful
   
   
    在 2018/12/19 13:12,“Nayak, Soumya R.”<[hidden email]> 写入:
   
        Hi ,
       
        As per your details below it will not iterate the CSV more than once. That is fine but my requirement is how each thread picks up 100 rows at a time to parameterize the 100 variables in JSON request.
        As far as I know each thread picks up one row , but how we can pick up 100 rows at one time with each thread and that too all threads picking up 100 unique records.
       
        Thanks,
        Soumya
       
        -----Original Message-----
        From: 贾国动 <[hidden email]>
        Sent: Wednesday, December 19, 2018 10:38 AM
        To: JMeter Users List <[hidden email]>
        Subject: Re: CSV Data Reading for Multiple Users
       
        On your CSV Data Set Config element, set as below:
        Resycle on EOF: False
        Stop thread on EOF: True
       
        hope helpful
       
        在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:
       
            HI Team,
           
            I have a requirement where in let's say I have 500 rows of data in a CSV file.
            I have a test scenario for multiple concurrent users , say 5 virtual users and a http JSON request where 100 variables are there which has to be parameterized from the CSV file.
            When I run the test with 5 virtual users ---- each user should pick up at a time 100 unique records from the CSV and parameterize the values of the http request and post it.
           
            For 500 records in CSV ---
            Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
            Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
            Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
            Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
            Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
           
            So is the above scenario possible where each user picks up unique 100 rows of data from the CSV at once and parameterizes the Http request in JMeter in a multiple concurrent users scenario?
            Or is there any other way to achieve the above scenario apart from CSV or any component in JMeter.
           
            Thanks in advance.
           
            Regards,
            Soumya
           
           
           
            ******************************************************************************************
            This message may contain confidential or proprietary information intended only for the use of the
            addressee(s) named above or may contain information that is legally privileged. If you are
            not the intended addressee, or the person responsible for delivering it to the intended addressee,
            you are hereby notified that reading, disseminating, distributing or copying this message is strictly
            prohibited. If you have received this message by mistake, please immediately notify us by
            replying to the message and delete the original message and any copies immediately thereafter.
           
            If you received this email as a commercial message and would like to opt out of future commercial
            messages, please let us know and we will remove you from our distribution list.
           
            Thank you.~
            ******************************************************************************************
            FAFLD
           
       
       
       
        ---------------------------------------------------------------------
        To unsubscribe, e-mail: [hidden email]
        For additional commands, e-mail: [hidden email]
       
       
        ---------------------------------------------------------------------
        To unsubscribe, e-mail: [hidden email]
        For additional commands, e-mail: [hidden email]
       
   
   
   
    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [hidden email]
    For additional commands, e-mail: [hidden email]
   
   
    ---------------------------------------------------------------------
    To unsubscribe, e-mail: [hidden email]
    For additional commands, e-mail: [hidden email]
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

SAS
Reply | Threaded
Open this post in threaded view
|

Re: CSV Data Reading for Multiple Users

SAS
In reply to this post by Nayak, Soumya R.
Hi Soumya

if you reverse the CSV data, it should work.  each row should contain 100
columns, so the row gets picked uniquely by each user.

hope this helps !!

Thanks,
Sastry



On Wed, Dec 19, 2018 at 1:08 AM Nayak, Soumya R. <[hidden email]> wrote:

> Thanks Dong for the reply.
> If it is the case of 100 array of variables in JSON. Like as shown in the
> below JSON requests - Address_1, City_1, State_1, Zip_1 etc. My CSV is
> having four columns of Address, City, State and Zip and has 500 rows for
> the data. Please scroll down to see. How to handle in this scenario. I am
> creating the CSV file taking data from the database
>
> Below is the sample JSON :--
> {
>     "username": "",
>     "password": "",
>     "addresses":
>    [
>   {
>     "streetAddress": "Address_1",
>     "city": "City_1",
>     "state": "State_1",
>     "postalCode": "Zip_1"
>   },
>   {
>     "streetAddress": "Address_2",
>     "city": "City_2",
>     "state": "State_2",
>     "postalCode": "Zip_2"
>   },
>   {
>     "streetAddress": "Address_3",
>     "city": "City_3",
>     "state": "State_3",
>     "postalCode": "Zip_3"
>   },
> .
> .
> .
> So on Upto 100 addresses.
>
> CSV Structure
> Address         City    State   Zip
> Abc             pqr     xxx     12345
> Def             aaa     ooo     334455
>
> Regards,
> SOumya
>
> -----Original Message-----
> From: 贾国动 <[hidden email]>
> Sent: Wednesday, December 19, 2018 11:14 AM
> To: JMeter Users List <[hidden email]>
> Subject: Re: CSV Data Reading for Multiple Users
>
> Sorry I misunderstood you before, I think this will solve your problem:
>
> CSV data file as below:
> variable1, variable2, variable3, ...variable100 value1-1, value1-2,
> value1-3, ...value1-100 value2-1, value2-2, value2-3, ...value2-100 ...
>
> CSV Data Set Config as below:
> Variable Names(for example): v1, v2, v3, ... v100 Ignore first line: True
>
> Then parameterize your request, set the variable as above:
> ${ v1}, ${ v2}, ${ v3}, ...${ v100}
>
> Every request will get a line with 100 variables.
>
> hope helpful
>
>
> 在 2018/12/19 13:12,“Nayak, Soumya R.”<[hidden email]> 写入:
>
>     Hi ,
>
>     As per your details below it will not iterate the CSV more than once.
> That is fine but my requirement is how each thread picks up 100 rows at a
> time to parameterize the 100 variables in JSON request.
>     As far as I know each thread picks up one row , but how we can pick up
> 100 rows at one time with each thread and that too all threads picking up
> 100 unique records.
>
>     Thanks,
>     Soumya
>
>     -----Original Message-----
>     From: 贾国动 <[hidden email]>
>     Sent: Wednesday, December 19, 2018 10:38 AM
>     To: JMeter Users List <[hidden email]>
>     Subject: Re: CSV Data Reading for Multiple Users
>
>     On your CSV Data Set Config element, set as below:
>     Resycle on EOF: False
>     Stop thread on EOF: True
>
>     hope helpful
>
>     在 2018/12/19 11:09,“Nayak, Soumya R.”<[hidden email]> 写入:
>
>         HI Team,
>
>         I have a requirement where in let's say I have 500 rows of data in
> a CSV file.
>         I have a test scenario for multiple concurrent users , say 5
> virtual users and a http JSON request where 100 variables are there which
> has to be parameterized from the CSV file.
>         When I run the test with 5 virtual users ---- each user should
> pick up at a time 100 unique records from the CSV and parameterize the
> values of the http request and post it.
>
>         For 500 records in CSV ---
>         Http JSON Request -1 - Virtual User - 1 --> 1-100 row from CSV
>         Http JSON Request -2 - Virtual User - 2 --> 101-200 row from CSV
>         Http JSON Request -3 - Virtual User - 3 --> 201-300 row from CSV
>         Http JSON Request -4 - Virtual User - 4 --> 301-400 row from CSV
>         Http JSON Request -5 - Virtual User - 5 --> 401-500 row from CSV
>
>         So is the above scenario possible where each user picks up unique
> 100 rows of data from the CSV at once and parameterizes the Http request in
> JMeter in a multiple concurrent users scenario?
>         Or is there any other way to achieve the above scenario apart from
> CSV or any component in JMeter.
>
>         Thanks in advance.
>
>         Regards,
>         Soumya
>
>
>
>
> ******************************************************************************************
>         This message may contain confidential or proprietary information
> intended only for the use of the
>         addressee(s) named above or may contain information that is
> legally privileged. If you are
>         not the intended addressee, or the person responsible for
> delivering it to the intended addressee,
>         you are hereby notified that reading, disseminating, distributing
> or copying this message is strictly
>         prohibited. If you have received this message by mistake, please
> immediately notify us by
>         replying to the message and delete the original message and any
> copies immediately thereafter.
>
>         If you received this email as a commercial message and would like
> to opt out of future commercial
>         messages, please let us know and we will remove you from our
> distribution list.
>
>         Thank you.~
>
> ******************************************************************************************
>         FAFLD
>
>
>
>
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail: [hidden email]
>     For additional commands, e-mail: [hidden email]
>
>
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail: [hidden email]
>     For additional commands, e-mail: [hidden email]
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>


--


Thanks
SASTRY