Forum Discussion

maxrussell's avatar
maxrussell
Contributor
5 years ago

Excel data sources - using a relative path name for files

We need to use ReadyAPI across different machines. Our code is checked out from Git and sometimes our local directories differ (for example I use E:\, a colleague uses C:\)   As we need to share ou...
  • PrathapR's avatar
    PrathapR
    5 years ago

    Hi maxrussell 

    Can you please use relative paths.

    Instead of using  "E:/GitRepo/Test/Sample.xlsx" use ${projectDir}/GitRepo/Test/Sample.xlsx. Always keep these excel file folders(Ex:GitRepo/Test..) along with project file(.xml)  wherever you store, either in version control or local.  And Change like below at project level properties.

     

     

    https://support.smartbear.com/readyapi/docs/testing/best-practices/root.html

     

    Thanks!

maxrussell's avatar
maxrussell
Contributor
5 years ago

When I try to use the $projectDir variable, I get errors on my datasource test steps:

  • richie's avatar
    richie
    Community Hero
    5 years ago
    Hey @maxrussel,

    Can you indicate step by step exactly what you did please?
    Looking at the screenshot it appears that two full paths have concatenated so it reads something like E:/...E:/fullpath

    Ta

    Rich