topic Re: Dynamic picklist populated with external data in Alfresco Forum

Dynamic picklist populated with external data

ctorre — Tue, 28 Jan 2020 15:52:16 GMT

Hi all,

I need to understand if Alfresco (we are using the trial last version) allows the implementation of dynamic picklist populated with external data (from excel sheet or csv or database) into Share UI interface or this is only possible through a custom interface.

For example: I want to manage contract documents and for each contract the possibility to select the supplier of that contract from a picklist that is periodically populated with external data (suppliers can change over time). I know that this is possibile with a custom interface, my question is whether it is possible to do it directly in Alfresco Share.

Thanks in advance.

Carlo

Re: Dynamic picklist populated with external data

angelborroy — Tue, 28 Jan 2020 16:16:58 GMT

This is not a feature provided by default, but you can check some Community addons to check if some of them fits your requirements:

http://softwareloop.com/2015/01/14/5-alfresco-picklist-plugins-you-cannot-miss/

Re: Dynamic picklist populated with external data

ctorre — Wed, 29 Jan 2020 16:31:25 GMT

Thanks for your quick reply.

Addons use data lists component it works at node level of a site; my question is if is possible to use data lists at document level - in my case as a field list of suppliers.

Alternatively is it possible to extend the Alfresco Enterprise classes (override) so that I can expose data dynamically in a list field?

Carlo

Re: Dynamic picklist populated with external data

jpotts — Fri, 07 Feb 2020 21:47:51 GMT

Yes, you can configure properties on the document details page to populate a dropdown from any data source, be that a data list or some other service.

The add-on referenced uses data lists to manage the possible values and then those values are used to populate dropdowns in any Share form.

If you don't want to use the add-on or you don't want to use datalists you can always implement your own custom form control. The custom form control can use server-side JavaScript to invoke a service to fetch dropdown values or it can use client-side JavaScript in the browser to make XHR requests to fetch dropdown values from a service.

You can also write your own Java classes to do this if you want.

This is not difficult to do but it will not be out-of-the-box unless one of the add-ons meets your requirements.