XML is a popular format used to describe data and is widely used in applications, web services, Electronic Data Interchange (EDI), and much more. GoAnywhere MFT can create XML files using information stored in a database or pulled from other files like CSV or Excel spreadsheets. Additionally, data can be extracted from XML files and loaded into databases or converted into other file formats. GoAnywhere MFT supports simple XML elements and attributes as well as multi-level or nested elements that represent relationships.
Reading XML
The data read from XML documents can be imported into one or more database tables. XML data can also be translated into other formats including Excel, delimited text and fixed-width. The following user-specified options are available when reading XML files in GoAnywhere MFT:
- Parse multi-level XML documents
- Schema or DTD validation
- Header/Detail support
- Specify field names and types
- Data trim options
- Formatting options for dates and numbers
- Null substitute values
- Skip invalid records
- Pass in variables (at runtime) to override attributes
Writing XML
XML documents can be created from data which is retrieved from one or more database tables. Additionally, XML documents can be created from data which is translated from other file formats including Excel, delimited text and fixed-width text.
GoAnywhere MFT can create XML documents using a variety of user-specified options:
- Create multi-level XML documents
- Header/Detail support
- Custom XML tag names and attribute names
- Formatting options for dates and numbers
- Null substitute values
- Data trim options
- Indention option for tidy output
- Schema or DTD validation
- Pass in variables (at runtime) to override attributes
After an XML document is generated, GoAnywhere MFT can compress or encrypt the file and store it on the network or distribute the document to a remote server.