Binding Data

6 posts, 0 answers
  1. Mark
    Mark avatar
    1 posts
    Member since:
    Oct 2015

    Posted 28 Oct 2015 Link to this post

    Hello.  I'm probably missing something really simple but I'm having problems with binding data.  I have created a simple excel file with 4 fields in row 1 with the data in row 2:

     
    UserID Password      Topic       XML
    MyID  MyPassword1 MYTopic <SOURCE>

     I then clicked the Add -> Excel File option and then pointed to the file I created above which seemed to work fine.  When I click on the Manage Data Source option I can see my file.  I then clicked the BIND Test option.  I selected my file but nothing shows up in the Select Table drop-down or the Preview box (see attached).  Can you please let me know what I'm missing?  I aplogize if this is an easy question but I have been asked to evaulate the tool for my management and this is the first hurdle I have come across.

    Thank You.

    Mark Anderson

  2. Cody
    Admin
    Cody avatar
    3360 posts

    Posted 28 Oct 2015 Link to this post

    Hello,

    This problem only seems to happen when trying to use .XLSX files. The older .XLS format doesn't seem to have this problem. You should be able to solve it by following these directions.

    Regards,
    Cody
    Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
  3. Kristin
    Kristin avatar
    5 posts
    Member since:
    Jun 2015

    Posted 02 Dec 2015 Link to this post

    Binding an xls file to a test fails on a compare validation on a date field. Test studio is reading a time stamp on the date field that is not formatted as such. How to get around this? My spreadsheet has the date field formatted as xx/xx/xxxx.

    Cell text verification failed
    Expected: '5/27/2015 12:00:00 AM', Comparison: 'Contains', Actual: '05/27/2015'.

  4. Cody
    Admin
    Cody avatar
    3360 posts

    Posted 02 Dec 2015 Link to this post

    Hi Mark,

    Test Studio uses ADO.net for pulling the data out of the Excel file. It's actually ADO.net that is doing the date and time conversion before Test Studio even gets the data. Fortunately it's easy to work around this. By applying a special format to that cell in the Excel file it will be treated as a raw string instead of a date and time. See the attached screenshot for an example how to do this.


    Regards,
    Cody
    Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
  5. Kristin
    Kristin avatar
    5 posts
    Member since:
    Jun 2015

    Posted 02 Dec 2015 in reply to Cody Link to this post

    Clearing the field of content and then setting the field type to 'text' worked - thank you.
  6. Cody
    Admin
    Cody avatar
    3360 posts

    Posted 02 Dec 2015 Link to this post

    Hi,

    I am glad to hear you found a workable solution. Thank you for the update.

    Regards,
    Cody
    Telerik
     
    The New Release of Telerik Test Studio Is Here! Download, install,
    and send us your feedback!
Back to Top