Home » Categories » Solutions by Business Process » Utilities |
Omit Exclusive File Locks on DFD Import |
Article Number: 53 | Rating: Unrated | Last Updated: Wed, Jun 14, 2023 at 4:23 PM
|
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. |
Attachments
![]() There are no attachments for this article.
|
Calling a Batch Update Definition - Profiler
Viewed 1921 times since Thu, Jul 5, 2012
Input File Pathname - Sales/Purchase Batch Updates
Viewed 1655 times since Thu, Jul 5, 2012
Run Time Prompt - Stock Batch Update
Viewed 1625 times since Thu, Jul 5, 2012
Confirm Printer - Job Costing Batch Update
Viewed 1665 times since Thu, Jul 5, 2012
Selection Criteria Range ‘Value’ Input
Viewed 1877 times since Fri, May 27, 2016
Confirm Printer - Stock Batch Update
Viewed 1713 times since Thu, Jul 5, 2012
Report Specification - Job Costing Batch Update
Viewed 1888 times since Thu, Jul 5, 2012
System Status - Sales/Purchase Batch Updates
Viewed 1631 times since Thu, Jul 5, 2012
Import Payment Transactions and Summarise
Viewed 1918 times since Tue, Jun 12, 2012
Ignore ‘Stock Not Exist’ Error
Viewed 1536 times since Wed, Jun 13, 2012
|