Home » Categories » Solutions by Business Process » System Features

Data Interchange - Import Large Text Strings

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.

Custom Fields
  • Release ID: 6.6
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Stock Enquiry - History / Detail Database Options
Viewed 10525 times since Mon, Nov 25, 2013
History Database Cross-Links
Viewed 2856 times since Tue, Jun 12, 2012
Log User-Id / Date / Time Database Record Updated
Viewed 3618 times since Fri, Oct 26, 2012
Include Attachments on Documents to Email
Viewed 2879 times since Tue, Jun 12, 2012
Ledger Enquiry - Increased No of Stock Location Pick Items
Viewed 710 times since Thu, Oct 17, 2024
Datafile Software - Menu Parameter Listing
Viewed 3537 times since Wed, Jun 13, 2012
Ledger Enquiry - New Interface
Viewed 4361 times since Wed, Jun 13, 2012
General System Options - Increased No of Saved Selection Criteria
Viewed 742 times since Thu, Oct 17, 2024
Validate Account and Stock Groups Entries
Viewed 2161 times since Fri, May 27, 2016
Advanced Alerts
Viewed 721 times since Tue, Oct 15, 2024