Hi.
I'm trying to come up with a workflow which will look at a SQL table of data and for each row use three columns to find a file in a specific folder on a server. So for example;
Server name is \\LFFileServer
Row 1, 2 and 3 have;
- Name of Document
- Format of document
- some metadata
- Top-Folder
- Sub-folder
- Filename
I want the workflow to run through all three rows (actually 30,000 in practice) and look on \\LFFileServer\Top-Folder\Sub-Folder\Filename.FileFormat and attach that document to the newly created entry.
I assume I'll need to do this with LF SDK as I can't see a way to do it with WF.