Received File Locked Message During Import But There's No One Else Opening That File
Release Date: 10/31/2023
Version: 7.x & Up
Q - Elliott's COP Billing Selection CSV Import works well. But on the printing output, we get an error message stating
***
Original File Could Not be Deleted, Was Open in Another Program
See sample screen below:
We confirmed there is no other application opening this file. What may cause this to happen?
A - We investigated this issue together with the user and found this to be a permission issue. We first tried to cut and paste the file from the source folder and we noticed that there's a security elevation prompt asking the user to permit or deny.
Generally speaking, any NTFS security settings that will cause UAC security elevation to prompt "permit" or "deny" will not work well with Elliott's import program. The typical Elliott import program will try to delete the ASCII file upon import. Since Elliott can't interact with the UAC security elevation prompt, the import will be problematic. In this case, the user is part of the Administrator group. So the security policy will prompt the user to elevate security. To avoid UAC security elevation prompt, users should be granted explicit NTFS rights to the folder. Do not rely on the implicit rights (e.g. user implicitly has the right because user is part of the admin group.)
For more information on UAC security elevation, see the following KB article:
EMK
Related Articles
ARECIMNT Accounts Receivable Customers and Contacts Import Utility
Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...APINVIMS Accounts Payable Invoice Import Utility
A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...ARCUSMNT Accounts Receivable Customer File Maintenance
Customer File Maintenance Application Overview The Customer File is a very important file. It stores the basic information about every customer you do business with. Almost every major application in the A/R package uses the Customer file to ensure ...Detail Cash Receipt CSV Import with Negative Values Causes Error Message
Release Date: 01/19/2024 Version: 8.5 & Up Q - In the KB article: https://support.netcellent.com/portal/en/kb/articles/feature-support-for-discount-amount-and-reference-in-cash-receipts-detail-interface, I see we can use negative amounts with Detail ...Change Customer Number or Create New Customer and Import Ship-To
Release Date: 02/18/2022 Version: 8.5 & Up Q - We had to create a new customer number for our T&EAZ account. We are doing a web project and the website does not like the "&" symbol that is in this customer number. My question for you is…. Is it ...