AX2433
Import source file considerations
If the import source is a delimited file or an Excel file, then you must consider how the file is specified. There are two options: Prompt for file location and Always use this file.
Prompt for file location
- File permissions
-
The file must be accessible by the user’s file system permissions.
- Data flow
-
- A copy of the file is streamed from the client machine to the application server.
- Import from the application server to the database server.
- The copy of the file on the application server is deleted after the import is complete.
- Ramifications / Limitations
-
- Slower performance (file is copied multiple times)
- Only available when running the import interactively
- Limited to files less than 100MB
Always use this file
- File permissions
-
- File must be accessible by the application server's permissions
- File path must be a UNC path, not a mapped drive (meaning \\servername\foldername, not I:\foldername)
- Data flow
-
The file is streamed from the file source to the database server for import.
- Ramifications / Limitations
-
- Faster performance
- No practical limit to the file size
- Can be used in Scheduler
