To retrieve the data from uploaded excel in ESC into a custom table

[Chunho]

Hi All,

I have a requirement where the requestor can upload an template excel with columns such as Name, SSN, Phone No., etc as an attachment in the ESC. Once submitting the request, the system will read the uploaded excel and write those data into a custom table automatically.

Is there any existing or suggested method to fulfill the requirement given? Thank you.

[Mark Manders]

I did this once before by making it a record producer (not a catalog item). The record producer created a data source and some scripting made sure the data source was processed into the table through transform maps. Not sure if there is another way.

[Chunho]

Hi @Mark Manders -

Thanks for your response. Currently, we are using record producers instead of catalog item. Could you please share us more details on how you make it previously?

Thank you.