Fixed Length Files can be much
more than the files you can import into an Excel spreadsheet. Some
applications export Structured Fixed Length Files with a structure
like this
File Header
Document Header
Line
Line
Line
Document Footer
File
Footer
Each field in the file is
defined by the start and length of the field within the
line.
These files contain information
in the File Header as well as in the Document Header and the Lines,
and this has made the interpretation and import of this type of
file very cumbersome, often requiring a programmer to make a
program to convert these files.
With EDIView for TaskCentre you
can use the Fixed Length File tools to read and create files like
this, and either import them into an ERP system or use some of the
other EDIView for TaskCentre tools to convert them to a format you
can use for importing into something else.
With EDIView for TaskCentre it
is easy to define the format of the files using the interactive
Interchange Editor where you specify the start position and length
of each field in the line in the various sections of the
file.
This type of files is seen when
working with Bank Integration (eg. payment files) and import/export
files from ERP systems, where objects such as invoices can be
exported and imported through Structured Fixed Length
Files.