I'm trying to get a nice workflow for TestLink 1.9.7 and used successfully the template TestCaseXLSTOXML (thanks a lot for providing that ! - just had to made a few edits to get it working as I want
)Anyway, I now have this very nice Excel sheet with all my hierarchy, test-case name, summary, conditions, steps, expected results... I would like to add 2 column for Test Execution :
- notes
- result
The idea is that with a third button "Generate results to XML" and a new VBA macro, I could export test-case results to TestLink through a XML file.
The problem I'm currently facing is, according to the documentation, the results can only be assigned to a test-case by its internal-ID or external-ID on which user has no control :
Would you have any idea that could help for my situation of keeping only 1 Excel sheet to export test-cases and test-results ? Could the test-name be used as a reference to import test-results in TestLink ? Or a custom field ?fman wrote:Important thing to understand:
WHEN IMPORTING Test Case Spec: EXTERNAL ID is used (if used) ONLY TO UNDERSTAND if test case already exists on system, but is value for NON EXISTENT test cases (new test cases) will be ALWAYS assigned by Test Link, i.e. user CAN NOT FORCE an ID for a test case.
Is right to provide this value WHEN EXPORTING because is a better reference than the internal ID (autoincrement field), because on UI internal ID is never displayed.
Thanks you !
PS : I'm Electrical engineer (hence VBA code is lovely for me
), this is meant for hardware testing, and my knowledge about database, SQL and things is <= nil 
PS2 : Thank you very much for providing this tool
