Home » Categories » Solutions by Business Process » System Features |
Data Interchange - Import Large Text Strings |
Article Number: 1932 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 5:58 PM
|
Datafile Software Data Interchange - Import Large Text Strings The maximum data item size for text within Datafile is
64-characters which requires, if importing large text strings, pre-processing
outside of Datafile to split the text into constituent parts. This new feature allows Datafile to perform
this processing splitting the text items into separate items based on the size
of the item and to ‘intelligently’ split string of text based on spaces within
the text string. When cross-matching the data items if you reference
the same CSV column number item against consecutive data items you will be
prompted ‘Is this an overflow from the
previous data item’ for you to respond as required. Note To split text over a series of data items they must be equal in size and consecutive within the database. Text split is based on the item size and then works backwards to find the last space character (unless next character is a space) and updates the data item with this text with the remaining text being apportioned in a similar manner over the remaining block items.If no space is found within the number of characters of the item size then split will be based on item size. |
Attachments
There are no attachments for this article.
|
Document Design Manager - Inserting New Items
Viewed 2244 times since Wed, Jun 13, 2012
Table Maintenance
Viewed 1415 times since Mon, Nov 25, 2013
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4226 times since Fri, Jul 21, 2017
Additional Options for History / Analysis Enquiries
Viewed 1640 times since Fri, Oct 26, 2012
Application Memo Options
Viewed 1664 times since Tue, Jun 12, 2012
Company Specific Main Menu Picture
Viewed 2498 times since Wed, Jun 13, 2012
Automatically Display Linked Files - Allow Items from Lookup Database in History/Details List - Link to BOM Detail Pick List
Viewed 1634 times since Fri, Jul 21, 2017
Pre-Defined Criteria - $USER for Current User Id
Viewed 877 times since Thu, Jun 18, 2020
Output to Excel Pivot Table
Viewed 23893 times since Tue, Jun 12, 2012
Order Enquiry - Allow Label Print from Order Details
Viewed 1705 times since Mon, Jun 11, 2012
|