You are viewing limited content. For full access, please sign in.

Question

Question

Attaching a file to created entry from server location (using tokens for location)

asked on May 13, 2019

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.

0 0

Replies

replied on May 13, 2019

Is this a one-time process or part of an ongoing procedure?

0 0
replied on May 14, 2019

It'll repeat through the 30000 line table, but it's a one off to catch data missed in a migration.

0 0
replied on May 14, 2019

Do you have Import Agent? It sounds like you could use the data from the database to build an XML or LST import file.

Import agent can read the import file and handle entry creation, routing, metadata, etc.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.