jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guy Knights <...@eastsidegamestudio.com>
Subject Re: Double quoted json data in CSV returns EOF
Date Thu, 03 Apr 2014 19:23:06 GMT
Ok, I set allow quoted data to false, and it seems to now be working. I
thought I'd tried this, but apparently not.


On Thu, Apr 3, 2014 at 12:19 PM, Guy Knights <guy@eastsidegamestudio.com>wrote:

> BTW, "allow quoted data" is enabled, and I've tried using two sets of
> double quotes to escape them, but I still get EOF for that JSON data.
>
>
> On Thu, Apr 3, 2014 at 12:17 PM, Guy Knights <guy@eastsidegamestudio.com>wrote:
>
>> Sorry, the single quotes in that example were from a temporary experiment
>> I was doing, I accidentally copied the data when I was trying it out. Also,
>> the "two lines" above are actually one line, split by the mail client.
>>
>> Here is the correct data (this is all one line):
>>
>> 1.0.3|facebook|100000964541055|null|2014-03-19
>> 10:59:14|{"test":"test"}|ODI1MjViNzdmODY1M2ZiOTE2YzcxYzJjODUwYmIwYTI3MTNhY2U3NA==
>>
>>
>> On Thu, Apr 3, 2014 at 12:09 PM, sebb <sebbaz@gmail.com> wrote:
>>
>>> On 3 April 2014 19:58, Guy Knights <guy@eastsidegamestudio.com> wrote:
>>> > I've set up an HTTP request element that pulls data from a CSV file and
>>> > I've run into a frustrating problem. Each line of data in the CSV file
>>> > represents the data for a user request, separated by a pipe character.
>>> See
>>> > below for example:
>>> >
>>> > 1.0.3|facebook|100000964541055|null|2014-03-19
>>> >
>>> 10:59:14|{'test':'test'}|MWQyNzQzZjc4Yjc0YmZhZDk5NjlmYzA2ZDlhY2Y2Mjg3NmVkOWM1OQ==
>>>
>>> Those don't look like double quotes.
>>> And the two lines have different numbers of entries.
>>>
>>> >
>>> > For the record, the JSON above is a very basic example I've been using
>>> to
>>> > try and troubleshoot this issue - the actual data will be a much
>>> longer,
>>> > more complex object.
>>> >
>>> > Anyway, we've found that if we include the double quotes in
>>> > the JSON string, then when the request actually fires off and the data
>>> is
>>> > populated from the CSV file, the JSON string is instead replaced by
>>> <EOF>.
>>> > If we remove the double quotes or replace them with single quotes,
>>> then the
>>> > JSON is pulled correctly, but this breaks something else since single
>>> > quotes in JSON are not valid.
>>> >
>>> > I've tried escaping the double quotes using a backslash, and
>>> alternately by
>>> > doubling up the double quotes, but neither appears to work. Does anyone
>>> > have any suggestions for how we can make this work?
>>>
>>> Please see:
>>>
>>>
>>> http://jmeter.apache.org/usermanual/component_reference.html#CSV_Data_Set_Config
>>>
>>> for the syntax
>>>
>>> > Thanks,
>>> > Guy
>>> >
>>> > <guy@eastsidegamestudio.com>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>>> For additional commands, e-mail: user-help@jmeter.apache.org
>>>
>>>
>>
>>
>> --
>> Guy Knights
>> Lead Systems Administrator
>> <http://eastsidegamestudio.com>
>> www.eastsidegamestudio.com
>> guy@eastsidegamestudio.com
>>
>> <guy@eastsidegamestudio.com>
>>
>
>
>
> --
> Guy Knights
> Lead Systems Administrator
> <http://eastsidegamestudio.com>
> www.eastsidegamestudio.com
> guy@eastsidegamestudio.com
>
> <guy@eastsidegamestudio.com>
>



-- 
Guy Knights
Lead Systems Administrator
<http://eastsidegamestudio.com>
www.eastsidegamestudio.com
guy@eastsidegamestudio.com

<guy@eastsidegamestudio.com>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message