Flat File Mapping
CSV and Flat File Mapping:
- Map flat files to or from complex data structures
- Combine multiple sources
- Map sources to one or multiple outputs
- Prepare flat files for database import
- Create immediate data conversion output
- Data streaming for arbitrarily large files
- Generate source code for flat file data mappings
Integrate flat files with XML, databases, EDI, Excel, XBRL data, or Web services
Altova MapForce® 2017 includes flexible support for integrating flat files with XML, databases, EDI, Excel, and XBRL data and for mapping flat file data to Web services operations.
Flat files such as CSV (comma-separated values) and text documents are employed by many different applications and are often used as an exchange format between dissimilar programs. Many organizations continue to utilize legacy software that produces output in the form of text files. Integrating these flat files and text documents with other data formats in a modern computing environment is increasingly difficult.
MapForce supports flat files as both a source and target of any mapping. MapForce does not limit you to one-to-one mappings - you can mix multiple sources and multiple targets to map any combination of data formats.
Developing Flat File Mappings
When you load a CSV or fixed length (FLF) flat file into a MapForce data mapping design, you can append, insert, and remove fields as well as change field header names and values as required before importing the file.
You can also choose to handle empty flat file fields as empty elements in the data target, or you can treat empty fields as absent so they are not rendered in the target data structure.
Once you have loaded all of the content models required for your mapping, simply drag connecting lines between the source and target structures to connect matching elements.
Filtering and Processing Flat Files
MapForce includes a comprehensive library of data processing functions for filtering data based on Boolean conditions or manipulating numeric or string data in flat files as they are converted.
Instant Data Conversion
The built-in MapForce Engine allows you to execute and view the output of a mapping at any time. Mappings to a target XML Schema produce an XML instance document, while mappings to flat files have output in CSV or fixed-length text files, and mappings to EDI produce either EDIFACT, X12, or HL7 messages.
Mappings to a database produce output in the form of SQL scripts (e.g., SELECT, INSERT, UPDATE and DELETE statements) that are run against your target database directly from within MapForce. Mappings to XBRL taxonomies produce fully compliant XBRL financial reports.