Asset Share Commons - Upload File to Filter | Community
Skip to main content
M
MorganMe1
Level 2
January 11, 2024
Solved

Asset Share Commons - Upload File to Filter

  • January 11, 2024
  • 3 replies
  • 921 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by pulkitvashisth

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.

3 replies

pulkitvashisth
Community Advisor
pulkitvashisthCommunity AdvisorAccepted solution
Community Advisor
January 14, 2024

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
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    January 15, 2024

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

    Kautuk Sahni
    EstebanBustamante
    Community Advisor and Adobe Champion
    EstebanBustamanteCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    January 16, 2024

    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.

    Esteban Bustamante
      Terms & ConditionsAccessibility statement

      Loading footer...