You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by mayank panwar <ma...@gmail.com> on 2009/03/21 18:42:33 UTC

JMeter- how to point to single CSV file

Hi,
I am having some problem in using the "CSV data set config". how can i take
input from the csv file to enter username and password for the web-site.

Thanks in advance.

Regards,
Mayank Panwar.

RE: JMeter- how to point to single CSV file

Posted by SAUMET Yoann SILICOMP <yo...@orange-ftgroup.com>.
Hi Mayank,

I think you have to add the 'HTTP cookie manager' ( without any
modifications) in you test plan.


Cordialement, 
Yoann SAUMET

-----Message d'origine-----
De : mayank panwar [mailto:mayankcool84@gmail.com] 
Envoyé : lundi 23 mars 2009 21:41
À : SAUMET Yoann SILICOMP; JMeter Users List
Objet : Re: JMeter- how to point to single CSV file

Hi Yoann,

Thanks a lot for your reply. well i tried the above steps but i think i am
missing something in HTTP Request.

here is the full scenario:

1. Created Workbench --> Http proxy server.
2. Checked HTTP proxy server --> Attempt https spoofing.
3. Created Test plan --> Thread group.
4. Created Thread group --> Http Request default.
5. Enter server name, port no(8080) in the http request default.
6. Created CSV data config --> Enter variable name(USER, PASS) and file
name.
7. Add listener --> View result table, view result tree, summary report.
8. Make changes in the IE LAN setting --> localhost and 8080.
8. Http proxy server --> Target controller --> test plan -thread group,
9. Click start and record the http requests.
10. Click Stop.
11. Under login request --> change email and password value to ${USER},
${PASS}.
12. login (http request) --> Add View result tree.
13. Start the proxy server and clcik Run.

Result:
1. Summary reort shows 100% error on every request. :(
2. View result in tree shows warining in every thread request.
3. View result tree shows the blank POST in the login request (refer:
attachment in the 1st post)which means JMeter is unable to read data from
the CSV file.

I think the main concern here is the error on every requested page.

Please reply the missing points.

Thanks in advance.
Mayank.


On Mon, Mar 23, 2009 at 1:37 PM, SAUMET Yoann SILICOMP <
yoann.saumet@orange-ftgroup.com> wrote:

>  *CSV Data Set Config*
>
> If you need to *set up variables*, for example to connect an application
> with several users, it’s very useful to use a CSV file linked with
> variables:
>
>    - First you need to create a CSV file. In our case with Excel, two
>    columns, one with users, one with respective passwords.
>    - Then add a CSV Data Set Config (Add/Config Element) in a thread group
>    or in a loop controller within the thread group. You have to set up the
>    number of loop equals to the numbers of users to check.
>
>
>
>
>
>
>
>       Configure it with CSV file path, file encoding, column/variables
> names and delimiter.
>
>
>    - Then, in the connection page, replace recorded data by variables:
>
>       Syntax is: ${variable}
>
>
>
>
>
>
>
>
>
> Cordialement,
>
> Yoann SAUMET
>
>
>
> -----Message d'origine-----
> De : mayank panwar [mailto:mayankcool84@gmail.com]
> Envoyé : samedi 21 mars 2009 18:43
> À : jmeter-user@jakarta.apache.org
> Objet : JMeter- how to point to single CSV file
>
>
>
> Hi,
>
> I am having some problem in using the "CSV data set config". how can i
take
>
> input from the csv file to enter username and password for the web-site.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
> Mayank Panwar.
>


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

Re: JMeter- how to point to single CSV file

Posted by mayank panwar <ma...@gmail.com>.
Hi Yoann,

Thanks a lot for your reply. well i tried the above steps but i think i am
missing something in HTTP Request.

here is the full scenario:

1. Created Workbench --> Http proxy server.
2. Checked HTTP proxy server --> Attempt https spoofing.
3. Created Test plan --> Thread group.
4. Created Thread group --> Http Request default.
5. Enter server name, port no(8080) in the http request default.
6. Created CSV data config --> Enter variable name(USER, PASS) and file
name.
7. Add listener --> View result table, view result tree, summary report.
8. Make changes in the IE LAN setting --> localhost and 8080.
8. Http proxy server --> Target controller --> test plan -thread group,
9. Click start and record the http requests.
10. Click Stop.
11. Under login request --> change email and password value to ${USER},
${PASS}.
12. login (http request) --> Add View result tree.
13. Start the proxy server and clcik Run.

Result:
1. Summary reort shows 100% error on every request. :(
2. View result in tree shows warining in every thread request.
3. View result tree shows the blank POST in the login request (refer:
attachment in the 1st post)which means JMeter is unable to read data from
the CSV file.

I think the main concern here is the error on every requested page.

Please reply the missing points.

Thanks in advance.
Mayank.


On Mon, Mar 23, 2009 at 1:37 PM, SAUMET Yoann SILICOMP <
yoann.saumet@orange-ftgroup.com> wrote:

>  *CSV Data Set Config*
>
> If you need to *set up variables*, for example to connect an application
> with several users, it’s very useful to use a CSV file linked with
> variables:
>
>    - First you need to create a CSV file. In our case with Excel, two
>    columns, one with users, one with respective passwords.
>    - Then add a CSV Data Set Config (Add/Config Element) in a thread group
>    or in a loop controller within the thread group. You have to set up the
>    number of loop equals to the numbers of users to check.
>
>
>
>
>
>
>
>       Configure it with CSV file path, file encoding, column/variables
> names and delimiter.
>
>
>    - Then, in the connection page, replace recorded data by variables:
>
>       Syntax is: ${variable}
>
>
>
>
>
>
>
>
>
> Cordialement,
>
> Yoann SAUMET
>
>
>
> -----Message d'origine-----
> De : mayank panwar [mailto:mayankcool84@gmail.com]
> Envoyé : samedi 21 mars 2009 18:43
> À : jmeter-user@jakarta.apache.org
> Objet : JMeter- how to point to single CSV file
>
>
>
> Hi,
>
> I am having some problem in using the "CSV data set config". how can i take
>
> input from the csv file to enter username and password for the web-site.
>
>
>
> Thanks in advance.
>
>
>
> Regards,
>
> Mayank Panwar.
>

RE: JMeter- how to point to single CSV file

Posted by SAUMET Yoann SILICOMP <yo...@orange-ftgroup.com>.
CSV Data Set Config


If you need to set up variables, for example to connect an application with
several users, it’s very useful to use a CSV file linked with variables:

*	First you need to create a CSV file. In our case with Excel, two
columns, one with users, one with respective passwords.
*	Then add a CSV Data Set Config (Add/Config Element) in a thread
group or in a loop controller within the thread group. You have to set up
the number of loop equals to the numbers of users to check.

 

 

 

      Configure it with CSV file path, file encoding, column/variables names
and delimiter.



*	Then, in the connection page, replace recorded data by variables:

      Syntax is: ${variable}

 

 

 

 

Cordialement, 

Yoann SAUMET

 

-----Message d'origine-----
De : mayank panwar [mailto:mayankcool84@gmail.com] 
Envoyé : samedi 21 mars 2009 18:43
À : jmeter-user@jakarta.apache.org
Objet : JMeter- how to point to single CSV file

 

Hi,

I am having some problem in using the "CSV data set config". how can i take

input from the csv file to enter username and password for the web-site.

 

Thanks in advance.

 

Regards,

Mayank Panwar.