Rules when Exporting from a Summary to a Database
When you export a summary to a database file (MDB, DBF or ACCDB), Monarch Classic uses the following rules to create the export file:
Records
Each row in the summary is used to create a record in the export file. Subtotal lines and blank lines are not exported. The row containing the column totals is also not exported.
Fields
Each column in the summary is used to create a field in the export file.
Key field columns containing date values are always exported in the eight character YYYYMMDD format.
Key field columns and measure columns containing numeric values are always exported in their most compact form, without currency symbols or thousands separators.
Field names
Each column title is used to name a field in the export file. When appending data to a database file, the column titles are used to map columns from the summary to fields in the target database table.
When exporting to a database format whose field naming rules are more restrictive than Monarch Classic’s (i.e., DBF and DB files), Monarch Classic attempts to automatically adjust field names to conform to the export format's requirements.
If spaces or other punctuation are not allowed in field names, Monarch Classic replaces these characters in the field name with the underscore character.
If field name lengths exceed the export format's requirements, Monarch Classic truncates the field name to the maximum length supported. Note that DBF format supports a maximum field name length of 10 characters.
After the preceding adjustments have been made, Monarch Classic scans the field list to determine whether or not it contains any duplicate field names. If duplicate field names exist in the list, Monarch Classic adjusts the second and subsequent field names to make them unique. Typically, Monarch Classic will truncate the offending field name by three characters, then append a unique three digit number, beginning with "001". The resulting field list can then be exported to the target file format.
© 2024 Altair Engineering Inc. All Rights Reserved.