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

Question

Question

External table maintenance

Laserfiche
Updated July 23, 2014
asked on July 23, 2014

 I have a couple of external tables (we use  MS SQL Server) that I use for values in dynamic fields and lookups in Forms.  These tables may change frequently (for example the table used in forms is an approval routing table).  Is there a practical way to maintain these tables within Workflow or is it easier to just use Management Studio or import an Excel spreadsheet into SQL Server each time the table changes?

0 0

Answer

SELECTED ANSWER
replied on July 23, 2014

Depends who's responsible to maintain these tables:

 

> Admin User: SQL Management Studio

> End User: an Excel spreadsheet uploaded periodically by a workflow into the SQL database

 

Note that in either case, I recommend creating a distinct SQL database to protect your repository data.

0 0

Replies

replied on July 23, 2014

A scheduled import task in SQL Management Studio is the simplest way to go. Workflow would get you a nicer user interface, but you'd be adding unnecessary overhead and a middleman for something that SQL can handle on its own.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...