Expand my Community achievements bar.

SOLVED

Using Fusion to Transfer Data from Excel to Custom Forms in Workfront

Avatar

Level 2

Hi everyone, 

 

During the process of updating our custom forms, I decided to remove the custom field rather than hide it on the same form to preserve historical information. As a result, I noticed that the fields I removed no longer had data in them. Fortunately, I was able to catch this prior to the new refresh on Monday, August 28, so I went to the preview and ran a report to get the data, but I don't want to have to copy and paste them back into the project. I'm looking to use Fusion to move the data back into production from the report I ran in "Preview", now that it's in an excel format. Could anyone show me how I could do this using Fusion. Any help would be appreciated.

 

Thank you in advance,

Margrette

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 9

Hi Margrette,

 

I would export the Excel file as CSV and use "Parse CSV" in combination with an iterator and the WF - "Update a record" module to go through all rows and fill in the values.

 

Regards

Lars

View solution in original post

1 Reply

Avatar

Correct answer by
Level 9

Hi Margrette,

 

I would export the Excel file as CSV and use "Parse CSV" in combination with an iterator and the WF - "Update a record" module to go through all rows and fill in the values.

 

Regards

Lars