Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

Export Testcases from Excel sheet


#1

Im new to TestRail. I have customized the script provided. but after that im confused . How do I run the PHP script??


#2

Hello Regin,

Thanks for your posting. You would need to run the PHP script (csv2testrail) via the command line. This works on both Windows (“cmd”) and Linux/Unix. The options for this tool are explained on the following page:

http://code.gurock.com/p/testrail-migrate/page/csv2testrail/

So, for example, if your csv file is named “cases.csv” and you would like to create a TestRail XML import file “cases.xml”, the command to execute would be:

php csv2testrail.php custom_filter.php cases.csv cases.xml

Are you on Windows or Linux/Unix?

Regards,
Tobias


#3

I have a Windows.
I have created the script & file
Tried to execute the command frm CMD.

In cmd im getting error as :-
"
'php; is not recognized as internal or external command.
operable program or batch file.

"

Did I miss something?.

Thanks
Regin


#4

Hello Regin,

Thanks for the additional details. You would need to install php as a command line tool. How have you installed PHP (via the Windows Platform Installer as recommended?)?

http://docs.gurock.com/testrail-admin/installation-windows

Could you please check if you have a PHP directory in C:\Program Files or C:\Program Files (x86)?

Regards,
Tobias