Send Data to 300 Construction And Real Estate Command


When you click the Send Data to Sage 300 CRE 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 Sage 300 CRE.


The first thing that happens is Office Connector writes a line to the activity log saying that the user clicked the Send Data to Sage 300 CRE button.  Then the current database connection is retrieved.  If there is no current connection, then the user is prompted for a Sage 300 CRE 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 Sage 300 CRE 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 Write 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.