Idea ID: 2701803

Enable Import from excel to Table component

Status: Delivered

Enable Import from excel to Table component

  • Implemented in PPM 9.63.

    There's some pretty significant limitation as importing TC from Excel bypasses the rules - so you can decide at the TC validation level whether or not to enable Excel Import for that specific Table Component.


    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

  • Thanks for the input.

    This won't be easy to implement, as TC will typically only show a few rows that are editable, and excel will allow you to change everything at the same time - for this reason, it's much better fit at saving TC content from Excel directly in the backend, thus bypassing UI Rules.


    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

  •  Thanks for the update. I believe, if we are managing to import the data from excel to table component and once user tries to save the date in TC/request the rules must validate from there. This way, at least the functionality would be bit easier to achieve.

  • 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

  • Our users have also asked for this capability