Idea ID: 2701803

Enable Import from excel to Table component

Status: Delivered

Enable Import from excel to Table component

Parents
  • Hi All,

    I'm currently investigating into implementing this capability in a future PPM version. More precisely, it would be about exporting an existing table component to Excel (XLSX), and then importing the contents of the modified excel file back into the table component.

    The main blocker I'm facing is about UI rules: When the table component is modified programatically, the UI rules (which are client-side Javascript) will not take effect. This also applies when updating the TC through REST API by the way. This basically means that you won't be able to have any UI rule take effect when data is modified or inserted in the table component from an Excel Import.

    Is that an acceptable limitation? Do you need the ability to disable Excel Import in the Table Component Validation definition, for the cases where UI Rules cannot be ignored?


    Etienne Canaud
    PPM R&D
    Although I am an OpenText employee, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

Comment
  • Hi All,

    I'm currently investigating into implementing this capability in a future PPM version. More precisely, it would be about exporting an existing table component to Excel (XLSX), and then importing the contents of the modified excel file back into the table component.

    The main blocker I'm facing is about UI rules: When the table component is modified programatically, the UI rules (which are client-side Javascript) will not take effect. This also applies when updating the TC through REST API by the way. This basically means that you won't be able to have any UI rule take effect when data is modified or inserted in the table component from an Excel Import.

    Is that an acceptable limitation? Do you need the ability to disable Excel Import in the Table Component Validation definition, for the cases where UI Rules cannot be ignored?


    Etienne Canaud
    PPM R&D
    Although I am an OpenText employee, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

Children
No Data