Asset Share Commons - Upload File to Filter

[MorganMeik]

Hi,

My organization wants to give Asset Share Commons users the ability to filter assets through a CSV/excel file. The goal is to allow users to upload a file that contains a list of products with unique identifiers (SKU) and have the ASC search results display all assets that pertain to the listed SKUs.

The idea would be similar to the Free-Form Text Filter Component, but specifically allowing users to upload a list in a file format. Does anyone have guidance/instructions on how to do this?

[pulkitvashisth · Accepted solution]

While there isn’t a built-in feature in Asset Share Commons to filter assets using a CSV/Excel file, you can potentially develop a custom solution. Here’s a high-level approach:

1. File Upload Component: Create a component that allows users to upload a CSV/Excel file. This component should be able to read the file and extract the SKUs.

2. Custom Filter Component: Develop a custom filter component similar to the Free-Form Text Filter Component. This component should take the extracted SKUs from the uploaded file and use them to filter the assets.

3. Integration with ASC: Integrate this custom filter with the existing Asset Share Commons infrastructure. You might need to modify the search functionality to accept a list of SKUs as a filter parameter.
   For more details on how filters work in Asset Share Commons, you can refer to the Property Filter documentation. It provides information on how to create filters based on pre-defined asset property restrictions.

[kautuk_sahni]

@MorganMeik Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

[EstebanBustamante]

Hi

As you know, this feature is not available in ASC, so you will have to build your own component(s).

The pattern you will use is exactly what you have pointed out already. You can take the Free-Form Text Filter Component as a basis or even extend it. Change the UI to allow uploading the CSV file you need. Additionally, you will have to read the CSV file and connect its data with the search functionality, which, behind the scenes, involves simple queries to your assets. Here you could reuse the search functionality or create your own.

Hope this helps.