Hello.
So I have created a workflow on Form where I:
- Read in a specific sheet from a specific excel file stored on my C
- Make some changes in the digits of that sheet
- Enter those changes to a feature writer where I update the sheet in question on my C
- That then triggers a feature reader that reads in the excel document that I just updated with the feature writer on my C
- The excel read in the feature reader has then done all the calculations based on the newly entered criteria.
- Process this onwards
The purpose of this workflow is that the excel in question is a complex calculation module that has multiple intertwined sheets, so by doing this I just open up Form, fill out some published parameters (the digit changes) and then export an excel with calculation results. All without ever needing to open excel.
My problem is that now I want to put this process on Flow with the following setup:
- Read in a specific sheet from a specific excel file stored in the resource folder on Flow
- Make some changes in the digits of that sheet
- Enter those changes to a feature writer where I update a excel document stored in the resource folder on Flow
- That then triggers a feature reader that reads in the excel document that I just updated with the feature writer on my resource folder on Flow
- The excel read in the feature reader has then done all the calculations based on the newly entered criteria.
- Send a download link to the excel results
I have done some trying here and so far I only get sent the criteria I entered in and nothing more of the excels. I have also checked the excel that I make the feature writer change on Flow and nothing in it changes. So basically Flow isn’t reading in nor editing any of the excel i reference in the resource folders.
They are referenced like this in the Form I post:
$(FME_SHAREDRESOURCE_DATA)/Blabla/Blabla.xlsx
So to sum up, how can I make Flow manipulate documents stored in its resource folders just like Form manipulates files stored on my C?
With thanks, Hlynur.
PS.Nota bene I tried the TempPathNameCreator->AttributeFileWriter->FeatureReader method for this aswell and its not functional for excel. But i am willing to be proven wrong on that.