Forum Discussion
mmcanelly
Helper II
Helper IIUse an Excel file from a Workspace as a data source
We are trying to integrate some manually-maintained data with our other data sources, and I'm trying to figure out the most streamlined way to do this. What I thought might work is to upload an Excel...
Sharepoint is the easiest way, but since you don't have it I guess I'd create a Dataflow that sources the Excel file via Gateway > Local Excel file.
The user could edit the Excel file and save as normal (locally), then schedule the Dataflow to pick up the latest version. Not sure if you already use a Gateway, but you'd need to add the file path to the Gateway.
cassidy
Power Participant
Power ParticipantSharepoint is the easiest way, but since you don't have it I guess I'd create a Dataflow that sources the Excel file via Gateway > Local Excel file.
The user could edit the Excel file and save as normal (locally), then schedule the Dataflow to pick up the latest version. Not sure if you already use a Gateway, but you'd need to add the file path to the Gateway.