ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.

Enable Import from excel to Table component

Idea ID 2701803

Enable Import from excel to Table component

Enable Import from excel to Table component

12 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes

The main challenge here is to resolve as efficiently as possible the values coming from Excel into the Field Validation values. But it's definitely a great idea, so let's open it for votes.

Commodore
Commodore

@Etienne_Canaud Thanks for considering this idea.

Lieutenant Commander
Lieutenant Commander

Hi,

The PPMetrics Excel Interface (XLI) supports updates to table component data, including automatically inheriting the user's PPM security settings, field validations, SQL/UI rules, concurrency management, links to PPM etc. 

The youtube below demonstrates how it works for non table component request fields, but it works the exact same way for TC's. Please email info@ppmetrics.com for details.

Switch to 10:25 on the video.

https://www.youtube.com/watch?time_continue=714&v=gCPuJjyuaNI

Ensign
Ensign

Our team is currently working on a custom solution to this problem. Something that's officially supported and comes standard would be great!

Commodore
Commodore

Hi

@Itay_Erhard Thanks a lot for your input and yes I am aware about XLI Interface. Idea is to have this functionality out of the box available as its having lot of usage.

By the way, could not find anything more specific instruction from the video, to upload the details directly to Table component.

@bcramer Thanks for your support as well.

Lieutenant Commander
Lieutenant Commander

@Aurobinda 

Yes, the youtube demonstrates how it works for non table component request fields, but it works the exact same way for TC's. If you're curious to see what it looks like for TC's, email us at info@ppmetrics.com and I'm sure they'll be able to help you.

Cheers,

Itay

Lieutenant Commander Lieutenant Commander
Lieutenant Commander

Our users have also asked for this capability

Micro Focus Expert
Micro Focus Expert

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?

Commodore
Commodore

@Etienne_Canaud 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.

Micro Focus Expert
Micro Focus Expert

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.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.