webapp.excel-importer-admin.pages.mappings.jsp Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ch.sbb.polarion.extension.excel-importer Show documentation

This Polarion extension provides possibility to update (or create) WorkItems using xlsx-file

There is a newer version: 2.7.0

Show newest version




<%! String bundleTimestamp = ch.sbb.polarion.extension.generic.util.VersionUtils.getVersion().getBundleBuildTimestampDigitsOnly(); %>


    Mappings
    
    
    
    




    Mappings

    

    

    General Settings
    
        
            Import rows from sheet:
            
        
        
            Start import from row:
            
        
        
            Overwrite with empty values
        
    
    Workitem Type
    
        Import rows as: 
    
    Column Name To Workitem Field Mapping
    
    
    Link Column
    
        Column name to link Excel row with Polarion workitem: 
    
    "/>
    



    
    
    



    Quick Help

    
        How-to configure excel column to Workitem field mapping
        First section contains inputs with Excel sheet name (standard Excel sheet name 'Sheet1' by default) and row number (1 by default) to import data from.
        Second section contains combobox with workitem types available for current project.
        Third section contains comboboxes with Excel column name to Polarion workitem field mapping.
        Next section contains combobox with Excel column name to link Excel row with Polarion workitem to import data to.
        If date, time, or date-time will be stored in the text format cells, there will be an attempt to parse stored information from ISO date format.
        For date-time pattern 'yyyy-MM-ddTHH:mm:ss' supported.
        For date only pattern 'yyyy-MM-dd' supported.
        For time only both 'HH:mm:ss' and 'HH:mm' patterns are supported.
        For duration type field only days and hours are supported due to polarion limitations.
        Examples: (d=days, h=hours): 1d, 3d, 1/2h, 2 1/2h, 3d 1h

Import rows from sheet:
Start import from row:
Overwrite with empty values