Home » Categories » Solutions by Business Process » Utilities

Omit Exclusive File Locks on DFD Import

Datafile Software

Omit Exclusive File Locks on DFD Import

When running the batch import processes within the Sales, Purchase, Stock and Job Costing Batch Update Accessories the system requires an exclusive file lock on the main application files. New in Release 6.5 if importing from a DFD file and flagging back to show the import record has been updated the system will allow the use of record locking against the main application databases.

Installation

Batch Update Installation Details

A new parameter has been added to the Optional Features settings within the four batch update configuration options. To update the settings select the Utility Programs option from the main menu before selecting the appropriate Batch Update definition. Select the Installation Details option and then Optional Features to set the ‘omit exclusive locks’ parameter.


Lock Records as Required– set to omit exclusive file locks on the application databases and the import database and apply record locks instead.Note this option is only applicable when using a DFD import file and marking input transactions as updated.

In addition to the options for all four updates for record locking on the main import file the sales and purchase batch updates include options for record locking when creating/updating account records.


Lock Records as Required – set to lock account records if importing updated account details. Note unlike the transaction import the system will require an exclusive record lock on the account record to update.

Input Item Number for Updated – flag item (required) on the import file to mark record as updated if successfully updated to the account file.

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Report Specification - Job Costing Batch Update
Viewed 2011 times since Thu, Jul 5, 2012
Confirm Input File and Date - Stock Batch Update
Viewed 1975 times since Thu, Jul 5, 2012
Additional Copy Items from Input File
Viewed 1903 times since Wed, Jun 13, 2012
Create / Update Account Records Before Import
Viewed 2129 times since Wed, Jun 13, 2012
Installation Details - Job Costing Batch Update
Viewed 1715 times since Thu, Jul 5, 2012
Data Interchange Omit First Row from Import
Viewed 2143 times since Fri, May 27, 2016
Confirm Update Definition - Job Costing Batch Update
Viewed 1910 times since Thu, Jul 5, 2012
Alternate Allocation Match Option
Viewed 2119 times since Fri, Jun 8, 2012
Create / Update Accounts - Order Processing Batch Updates
Viewed 1851 times since Thu, Jul 5, 2012
Data Interchange-Wildcards in Input Filename
Viewed 2046 times since Wed, Jun 13, 2012