When you click the Send Data to Timberline
button, Office Connector creates a list of pending TSWrite
operations, validates that list, prompts the user to approve changes and then writes the approved values to Timberline.
The first thing that happens is Office Connector writes a line to the activity log saying that the user clicked the Send Data to Timberline
button. Then the current database connection is retrieved. If there is no current connection, then the user is prompted for a Timberline data folder and optionally an operator ID and password. If the user cancels out of any prompts then the entire operation is canceled.
Once a database connection has been established, Office Connector attempts to acquire a license concurrency. This attempt will fail if all concurrencies are already in use or if the license has expired or if there is an error accessing the license file. If this attempt fails then the operation is canceled.
Office Connector then verifies that Excel is not currently recalculating formulas. This step prevents unexpected entries in the list of TSWrite
operations for machines that use Hyper-Threading Technology or multiple CPUs.
Next, all TSWrite
formulas are recalculated and stored in a list. If a duplicate is encountered while building the list, a message is displayed and the operation is canceled. If there are no TSWrite
functions, then a message is displayed and the operation is canceled.
The list is then scanned for conflicts in the Action
arguments. Since each TSWrite
function specifies an action, but the action actually applies to the entire row, it is possible to create conflicts. An example of a conflicting action would be two TSWrite
functions that write to two different fields in the same row of a table, but one specifies CreateOrModify
and the other specifies ModifyOnly
. In a situation like this, all action parameters for that row are set to Undefined
, a message is displayed and the user will be required to specify an action in the Approve Changes
window before values can be saved. The action Ignore
is a special case that can be used in conjunction with any other action without creating a conflict.
The list is then scanned for invalid table and field names. If a blank or invalid table or field name is detected, then a message is displayed and the operation is canceled.
Finally the Approve Changes
window is displayed. Once a valid list of TSWrite
operations has been approved, the data are written to Timberline and a report is displayed showing the results of the operation. If your workbook contains any Office Connector Query features, you will be prompted to refresh your data.
Note that the Office Connector Operator Administrator permissions are enforced during the write operation. Even though a user has not been granted permission to write, it will appear that they can until they click
on the Approve Changes
window. At that time a message will be displayed to the user indicating that they do not have permission to write data and the results report will also indicate the same. This behavior is by design.