Forum Discussion

thanvikunal's avatar
thanvikunal
Senior Member
4 years ago
Solved

How to set Data Source path to use on local as well as CI/CD in Azure DevOps

Hi Team,   I have a question related to setting data source path so that I can use the same input excel file in local as well as Azure DevOps pipeline.   I am moving my project and data source (E...
Automation Environments
Data-Driven Testing
  • PrathapR's avatar
    PrathapR
    4 years ago

    Hi thanvikunal 

    Can you please use relative paths.

    Instead of using  "C:/TestDocuments/Inputfile.xlsx" use ${projectDir}/Inputfile.xlsx. Always keep the excel file along with project file(.xml) wherever you store, either in version control or local. Can also keep in a folder(ex: TestData) like ${projectDir}/TestData/Inputfile.xlsx. And Change like below at project level properties.

     

     

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

     

    Thanks!

PrathapR's avatar
PrathapR
Frequent Contributor
4 years ago

Hi thanvikunal 

Can you please use relative paths.

Instead of using  "C:/TestDocuments/Inputfile.xlsx" use ${projectDir}/Inputfile.xlsx. Always keep the excel file along with project file(.xml) wherever you store, either in version control or local. Can also keep in a folder(ex: TestData) like ${projectDir}/TestData/Inputfile.xlsx. And Change like below at project level properties.

 

 

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

 

Thanks!

  • sonya_m's avatar
    sonya_m
    SmartBear Alumni (Retired)
    4 years ago

    Awesome advice Redde, thanks!

     

    thanvikunal does this help?