Forum Discussion

SKGREENWOOD's avatar
SKGREENWOOD
New Contributor
13 years ago

[Resolved] Datasink files contain double double quotes

I am using Datasink to capture Request and Response XML to an xml file (separate file for each Test Step and not appending).

The double quotes have all been doubled up, rendering the file unsuitable for opening in XML-Spy or Internet Explorer etc.

I have cleared the "Quotes" option box. This has had the effect of removing the enclosing set of double quotes round the complete file but has not got rid the doubled up double quotes e.g. Datasink file contains
<Response ResponseCode=""OK"">

The raw response xml correctly contains:
<Response ResponseCode="OK">

9 Replies

  • nmrao's avatar
    nmrao
    Icon for Champion Level 1 rankChampion Level 1
    Hello,

    This is a duplicate post by you though it is replied to original post. Have you tried the solution provided there? It would be glad to know if you try the solution and reply worked or not worked.

    Here is the orignal post for reference which has a reply:
    viewtopic.php?f=5&t=19174
  • I had seen the origional response but I dont have the time to write a groovy script. In my mind this is either a SoapUI bug or I have missed setting some option (although it's not the Quote option)

    I thought I was raising raising a SoapUI bug when I raised this yesterday but that seems to not be the case. I'll do that now.

    If anyone was written a groovy script to parse/replace text in datasink files that would be useful.
  • nmrao's avatar
    nmrao
    Icon for Champion Level 1 rankChampion Level 1
    I never saw datasink feature in soapui free version. You may contact soapui team if you are using soapui Pro.
  • I am still having this issue after inserting a groovy step before it up to get rid of them. The logs show the data correct, but when the data shows up in the file, all of my attributes have "" "" and XML Spy won't validate it. Very frustrating. Please advise.
  • nmrao's avatar
    nmrao
    Icon for Champion Level 1 rankChampion Level 1
    Would you post your script logic/sudo code? Are you using patterns here? or just search and replace?
  • elandfill's avatar
    elandfill
    Occasional Contributor
    I am using DataSource and the same thing happens to me. In my .csv file the text is as follows:

    this is a test "test is this"

    Here is how it looks after being read in using DataSource:

    "this is a test ""test is this"""

    what is going on?

    If I take out the quotes:

    this is a test test is this

    then it reads it in as intended:

    this is a test test is this
  • Can you confirm that the quotes are not added when you open your CSV in Excel? Are they there if you first open the CSV file in notepad?

    Thanks,
    Michael Giller
    SmartBear Software