Using Fusion To Convert A Spreadsheet to CSV

[Eric_D_Miller]

Hello,

I am trying to build a scenario that will watch for new files being uploaded to a folder. The files being uploaded will be excel spreadsheets and the some of the data from the files needs to be sent to fields on the projects custom form.

Can you use Fusion to accomplish this? I am at a loss on how to

1. Configure a trigger to watch for new files being uploaded to specific project file folders

2. Convert a spreadsheet to a Csv using Fusion

Thank you in advance,

Eric

[Sven-iX · Accepted solution]

@Eric_D_Miller 

Fusion doesn't allow you to check whether a folder's docs were changed.  So you'll need to configure a new-document instant trigger, after that get the documents folders collection. 
I'd recommend doing the uploads to a specific TASK or issue - then you can filter the event by taskID

In Fusion you cannot convert an XLS/XLSX to CSV. XLS/XLSV is binary and Fusion doesn't have file converters. Options:

1. If the file is in Excel 365, you can create a connection and use the Excel 365 modules
2. Request that all data to be ingested by Workfront is XML, JSON or CSV
3. Create a middleware and use Fusion to send the file, get it converted and then use the output.