Expand my Community achievements bar.

Workfront Fusion 2.0: Reading from an Excel file (not the MS 365 Excel module)

Avatar

Level 2

Does anyone know if there is a way to read from an Excel file (not the MS 365 Excel module) in Fusion 2.0?

The scenario we have today is that the user creates an excel file for all the tasks that need to be added to particular projects. The file is uploaded to SharePoint and then the user manually triggered the scenario to run once. The scenario reads the file and uses the existing mapping in Fusion to add the appropriate tasks to the respective projects.

While this is working now we wanted to be such that the user can just attach a file to a request and submit it in Workfront. A webhook watching the queue can grab the file and the scenario can create tasks just like it's doing today. This would avoid the need for the file to be uploaded to a particular directory and provide for a better experience.

Any thoughts or suggestions for achieving this or another solution to achieve the same integration?

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Level 5

On ours we have them load a CSV file that it watches for.

Avatar

Level 10

Hi Surya,

I believe what you're building is similar to our Scheduled Excel Updater solution.

Regards,

Doug