Error 013 File Not Found When Importing CSV File Name Longer Than 20 Characters
Revision Date: 1/28/2021
Version: 7.x & up
Users may encounter an Error 013 on an ASCII File when importing from CSV.
This can be due to a limitation of 20 characters for the CSV file name including the extension. For example, the file name LLBEANSHIPTOIMPORT.CSV is 22 characters long. The import application will truncate the name to LLBEANSHIPTOIMPORT.C and the import application will produce the error shown above. Shortening the name to LLBEANSHIPTO.CSV will resolve the issue.
The 20-character file name limitation exists in the following applications:
- APSIMIMP - A/P Simple Transaction Import
- ARFRTIMP - Freight Rate Import
- ARSLSIMP - A/R Sales Transaction Import
- CPCUSIMP - COP Customer Item File Import
- CPFBIMPP - Fill Back Orders Import
- CPINVIMP - COP Invoice Change Header Import
- CPSELIMV - COP Mass Billing CSV Import
- CPSHPIMP - Ship-To File Import
- GLCSVIMP - G/L Interface from CSV
- IMGTINIP - GTIN Import
- IMTSFIMP - "Free" Transfer Batch Import
- POCHGIMP/POCSVIMP - PO Change Import
- POITMIMP - Vendor Item Import
- POREQIMP - PO Requisition Import
- POWRIIMP - PO Warehouse Receiving Import - this is fixed in 8.2 & later versions in Feb. 2019.
- PRTIMIMP - Payroll Time Transaction Import
This issue is resolved in 8.5 & up on 05/05/2021. If your Elliott is on prior version, you may update your Elliott to the latest version to address this issue. Please see the following KB article:
CLS, EMK
Related Articles
Change - CSV Import Programs to Support File Names Longer Than 20 Characters
Release date: 5/5/2021 Version 8.5 & Up There were many Elliott CSV Import programs which had a limitation that the maximum file name could not be greater than 20 characters. See the following KB article: ...
Common Issues with Importing CSV Files Into Elliott
Release Date: 12/18/2020 Version: 7.0 & Up Elliott Business Software has extensive features with CSV file export and import. It provides a gateway to view Elliott's data in Excel spreadsheets and optionally allow users to edit the data in ...
Inconsistent File Name in Btrieve Error Window
Release Date: 09/11/20 Version: 7.x - 8.5 Q - I notice that sometimes in a Btrieve Error window, the physical file and the file name are not consistent. Take, for example, the following error message: EL850P: Btrieve Error 067 on NSCTLFIL COP Control ...
Feature - Allow Importing Duplicate Product Structure Components
Release Date: 09/22/2020 Version: 8.5 & Up There's a vertical add-on feature that you can access in BOMP -> Maintenance -> Product Structure File -> Import. You can import BOMP Product Structure based on the following CSV layout: By design, this ...
Feature - Customer CSV Import
Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...