Maximum Path & File Length for Sales Order Import
Release Date: 05/17/2021
Version: 8.2 & Up
Q - I am experiencing problems with Sales Order Import - it won't process the file. The only thing that has changed is that the new path is 6 characters longer than before. I'm wondering if that extra 6 characters in the server name has pushed me over some type of limit for the length of the resolved directory string?
The F8 key works, and allows me to choose a file that exists in that directory -- but when I attempt to process, I get no results. See sample screen below:
A - Generally speaking, the total length of path + filename in Elliott should be less than 50 characters. We made a special exception to allow sales order import to have a maximum of 70 digits. Looking at your example, the total length of path + file name is over 70 digits. Please shorten your file name or path.
0 1
2
3
4 5
6 7
1234567890123456789012345678901234567890123456789012345678901234567890123
N:\ELLIOTT\DATA_10\SALESORDERIMPORT\202105142221.ElliottSalesOrder.US.txt
There is also an issue that in many areas of CSV import, the maximum length of file name is 20 digits. This was recently resolved. But in all those areas, the total path and file name max is 50 characters. See KB article below:
EMK
Related Articles
Feature - Ability to Change EDI Import Path
Release Date: 1/9/17 This feature gives the user the ability to change the path used when importing EDI orders. This option is enabled through Util-Setup-> Global Setup-> Add-Ons-> Sales Order Import. Field 4. Can User Override Path During Import? ...CPIMPMNU Customer Order Processing Sales Order Import
Sales Order Import Application Overview The Sales Order Import module is designed to import a pre-defined ASCII file to create COP sales orders. It is intended to provide an easy way for developers to create add-on solutions for creating sales ...Presales Import
Release Date: 3/1/24 Revised: 8/29/24 Version: 8.6 and Above The Presales import will have similar functionality as the warehouse receiving CSV import. 1. Receipt File Name: CSV file name to be imported. Defaults to SH*.CSV. Press F1 to change import ...Feature - Import for Product Category / Location Account File
Release Date: 12/16/22 Version: 8.5 and Above This feature allows the user to import records for the Customer Order Processing Product Category Location Account file. A new Import menu option has been added. After choosing the Import option, a new ...Feature - Master Scheduling Sales Forecast Import
Release date: 5/6/2021 Version: 8.5 and Up There is a new import feature in Master Scheduling, Processing, and Sales Forecast Entry. The import will facilitate the entry of Sales Forecast transactions. The import screen is standard with three menu ...