8 Replies Latest reply: May 15, 2014 10:04 AM by Olly Bond RSS

    Remember the "First row contains column names" option

    sgpm _

      Hi again,

       

      It seems that when opening an excel spreadsheet in monarch, the option "First row contains column names" is not stored in the model.

       

      I assume there is a key in the registry for this, but which one?

       

      thank you in advance,

       

      Pierre-Marie

        • Remember the "First row contains column names" option
          sgpm _

          Hi there,

           

          nobody got a clue on my previous question? Is there maybe somewhere a summary of monarch registry keys?

           

          thanks,

           

          Pierre-Marie

          • Remember the "First row contains column names" option
            joey

            I don't have a solution, but I've noticed the same problem.  I rarely deal with excel as input, so I didn't think much of it.

              • Remember the "First row contains column names" option
                Olly Bond

                Hello SGPM,

                 

                If you have access to the registry, you can always have look for Monarch's settings in there.

                 

                But the Help files do also contain (run Monarch, F1 for Help, then search for Settings) a handy table indicating where certain settings are stored (some are in the model, some the project, some in the registry, as well as a list of Hidden Settings in the registry.

                 

                Perhaps it would be helpful to post that list here so people searching for these settings can find them easily. I'll let Datawatch confirm whether they are OK with us doing that.

                 

                Best wishes

                 

                Olly

                  • Remember the "First row contains column names" option
                    sgpm _

                    This is a great idea! I already took a look at it and didn't find an answer to my issue. But it surely can be helful for other people.

                     

                    Here are the place where monarch settings are stored. For each item, the 3 rows mean :

                    - is the setting stored in the project file?

                    - is the setting stored in the model file?

                    - is the setting stored in registry?

                     

                    (there are also a bunch of so-called hidden settings, to define more detailed stuff such as color, max values, etc.)

                     

                     

                    Data extraction templates

                    No

                    Yes

                    No

                     

                    Field characteristics (including name, type, data length, decimals, column width, display order and the repeat field values setting)

                    No

                    Yes

                    No

                     

                    Calculated field definitions

                    No

                    Yes

                    No

                     

                    External Lookup parameters

                    No

                    Yes

                    No

                     

                    Filter definitions (including the active filter setting)

                    No

                    Yes

                    No

                     

                    Sort order definitions (including the active sort order setting)

                    No

                    Yes

                    No

                     

                    Summary definitions (including chart definitions and active summary setting)

                    No

                    Yes

                    No

                     

                    Report, Table and Summary print settings

                    No

                    Yes

                    No

                     

                    Report, model, import/join, portable report/project, and export folders

                    No

                    No

                    Yes

                     

                    Input, import/join, and export file extensions

                    No

                    No

                    Yes

                     

                    Input file(s)

                    Yes

                    No

                    No

                     

                    Import database reference

                    Yes

                    No

                    No

                     

                    Import database password

                    Yes

                    No

                    No

                     

                    PDF password

                    Yes

                    No

                    No

                     

                    Import/join, and Export file types

                    No

                    No

                    Yes

                     

                    Date format (interpretation of report dates)

                    No

                    Yes

                    Yes

                     

                    Date range for YY (interpretation of 2 digit years)

                    No

                    Yes

                    Yes

                     

                    Date/Time Extraction Patterns

                    No

                    Yes

                    Yes

                     

                    Trap Case Sensitivity

                    No

                    Yes

                    Yes

                     

                    Decimal character (interpretation of report numbers)

                    No

                    Yes

                    Yes

                     

                    Ignore form feed characters

                    No

                    Yes

                    Yes

                     

                    Ignore unused print control characters

                    No

                    Yes

                    Yes

                     

                    Ignore Leading control characters

                    No

                    Yes

                    Yes

                     

                    Force Page Break After __ Lines

                    Force Page Break Look Ahead (hidden setting)

                    No

                    Yes

                    Yes

                     

                    Include field names as first row of output

                    No

                    Yes

                    Yes

                     

                    Enforce DBF field naming rules

                    No

                    Yes

                    Yes

                     

                    Pad fields with one space

                    No

                    Yes

                    Yes

                     

                    Map Characters Above 127 To ASCII/ANSI

                    No

                    Yes

                    Yes

                     

                    Pad numeric fields with zeros, suppress decimal point, use trailing negation.

                    No

                    Yes

                    Yes

                     

                    Use "quoted" character fields in delimited text files

                    No

                    Yes

                    Yes

                     

                    Delimiter character for delimited text files

                    No

                    Yes

                    Yes

                     

                    Suppress zero values

                    No

                    Yes

                    Yes

                     

                    Null value display string

                    No

                    Yes

                    Yes

                     

                    Convert chart colors to hatch patterns

                    No

                    Yes

                    Yes

                     

                    Default row height for column titles and data rows

                    No

                    Yes

                    Yes

                     

                    Stylesheet Names and Status

                    No

                    No

                    Yes

                     

                    User-edited field values

                    Yes

                    No

                    No

                     

                    Auto-update and hidden settings

                    No

                    No

                    Yes

                      • Remember the "First row contains column names" option
                        sgpm _

                        And this is the list of hidden settings:[/U]

                         

                        AdditionalUKCounties[/B]

                        This setting specifies a comma separated list of county names that can to be added to the existing list of UK counties that are recognized.

                         

                        Location - Settings

                         

                        Format - AdditionalUKCounties=a,b,c,d

                         

                        Type - String

                         

                        AlwaysBackup[/B]

                        Specifies whether to backup Excel files using the V10 engine, regardless of whether the backup bit is set within the Excel file.

                         

                        Location - Export\Excel

                         

                        Format - 0 is do not backup, 1 is backup regardless.

                         

                        Type - DWord

                         

                        ArgumentSeparator[/B]

                        This setting specifies the character to use when separating function arguments in calculated field, filter and find expressions. Comma is the default argument separator.

                         

                        Location - Settings

                         

                        Format - ArgumentSeparator=separator character (separator character is a single character)

                         

                        Type - String

                         

                        BookMarkColor[/B]

                        This setting specifies the color of the text for bookmarks.

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        BranchLimit[/B]

                        This setting specifies the number of branches allowed in the Tree View.

                         

                        Location - Settings

                         

                        Format - Numeric value of the maximum number of branches allowed. The default value is 65536.

                         

                        Type - DWord

                         

                        DefaultTableName[/B]

                        This setting provides a default table name when exporting data from Monarch's Table window to a spreadsheet or database file.

                         

                        Location - Export

                         

                        Format - DefaultTableName="tablename" (tablename may be any string that conforms to the naming rules for both spreadsheet and database tables.)

                         

                        Type - String

                         

                        DiskSpaceThreshold[/B]

                        This setting specifies a minimum disk space requirement that Monarch adheres to when populating the Table window or when building a summary. If the available disk space falls below this threshold, Monarch will display an error and cancel the table or summary build operation. If you encounter performance problems (i.e., disk thrashing or crashes - due to Windows virtual memory requirements) when using Monarch on a system with limited available disk space, you might consider increasing this threshold. Although doing so will not change the way in which Monarch builds the table window database or a summary, it will cause Monarch to display a disk space error message when the threshold is breached. In other words, the threshold can be used as an early warning to avoid problems when working on systems with little available disk space. If you work with small files (<=4MB) you may decrease the threshold from its default of 10000KB (10MB) to a more reasonable threshold of, say, 4000KB (4MB). This will allow Monarch to fully utilize the available disk space before issuing an error. However, it is not advisable to attempt to use Windows in an environment with less than 10MB of available disk space.

                         

                        Location - Settings

                         

                        Format - DiskSpaceThreshold=n

                         

                        n represents the number of KB of required disk space in the Monarch WorkPath folder and in the Windows temporary folder. The default is 10000 (10,000KB).

                         

                        Type - DWord

                         

                        ExportNullsAsText[/B]

                        This setting specifies whether to export null values as text to Excel from the Summary Window.

                         

                        Location - Export\Excel

                         

                        Format - 1 is the default, export null values as text.  0 is export values as nulls.

                         

                        Type - DWord

                         

                        ExtendedPostalRecognition[/B]

                        Monarch’s Postal Trap feature uses separate sets of rules to recognize U.S./Canadian addresses versus German addresses versus Australian addresses. If your reports contain German or Australian address blocks, you can use this setting to enable the appropriate recognition rules. This feature is still supported for compatibility with previous versions of Monarch, however, the Address Block feature introduced in Monarch 6 should now be used.

                         

                        Location - Settings

                         

                        Format - ExtendedPostalRecognition=0|1|2

                         

                        0 = U.S. and Canadian address recognition

                        1 = German address recognition

                        2 = Australian address recognition

                         

                        Type - DWord

                         

                        FixedFieldBackground[/B]

                        This setting specifies the color of the background for fixed fields. If this setting is missing or empty, then the color used is the current window text color (generally black).

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        FixedFieldText[/B]

                        This setting specifies the color of the text for fixed fields. If this setting is missing or empty, then the color used is the current window background color (generally white).

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        FloatingFieldBackground[/B]

                        Color of the background for floating fields. If this setting is missing or empty, then the color used is the current window text color (generally black).

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        FloatingFieldText[/B]

                        Color of the text for floating fields. If this setting is missing or empty, then the color used is the current Windows background color (generally white).

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        ForcePageBreakLookAhead[/B]

                        This setting modifies the behavior of the Force Page Break After Lines setting described under the Input Options dialog. This setting instructs Monarch to insert a page break on a blank line, so that it doesn’t interrupt a block of data. For example, with Force Page Break After 60 Lines and ForcePageBreakLookAhead=10, Monarch inserts a page break at the first blank line it finds after line 50 (60-10). If no blank line exists before line 60, Monarch will insert the page break at line 60.

                         

                        Location - Settings

                         

                        Format - ForcePageBreakLookAhead=n

                         

                        n = number of lines to look ahead for a blank line.

                         

                        Type - DWord

                         

                        GreenColor[/B]

                        This setting determines the color for the greenbar display. The color is made up from a red, a green and a blue component. Each component is represented by a number from 0 to 255. The default, 144, 255, 200, mixes a medium red with bright green and a medium bright blue to produce a subtle green.

                         

                        Location - InputView

                         

                        Format - GreenColor=n,n,n

                         

                        Each n represents an RGB color value in the range 0 - 255. You may use the MS-Paintbrush application to experiment with the color mix before modifying this color setting. Start Paintbrush and double-click on any color in the palette to display the Edit Colors dialog. Use the edit boxes or the scroll bar to modify the color mix (enter 144, 255, and 200 to start with the Monarch greenbar color). When you find a color you like, record the RGB color numbers, cancel the dialog, quit Paintbrush and enter the numbers in the GreenColor setting.

                         

                        Type - String

                         

                        HighlightedBkColor[/B]

                        This setting determines the background color for the highlighted text in report view. The color is made up from a red, a green and a blue component. Each component is represented by a number from 0 to 255. The default is 192,192,192 (light gray).

                         

                        Location - InputView

                         

                        Format - HighlightedBkColor=n,n,n

                         

                        Each n represents an RGB color value in the range 0 - 255. You may use the MS-Paintbrush application to experiment with the color mix before modifying this color setting. Start Paintbrush and double-click on any color in the palette to display the Edit Colors dialog. Use the edit boxes or the scroll bar to modify the color mix (enter 192, 192, and 192 to start with the default color). When you find a color you like, record the RGB color numbers, cancel the dialog, quit Paintbrush and enter the numbers in the HighlightedBkColor setting.

                         

                        Type - String

                         

                        HighlightedTextColor[/B]

                        This setting determines the text color for the highlighted text in report view. The color is made up from a red, a green and a blue component. Each component is represented by a number from 0 to 255. The default is 0,0,0 (black).

                         

                        Location - InputView

                         

                        Format - HighlightedTextColor=n,n,n

                         

                        Each n represents an RGB color value in the range 0 - 255. You may use the MS-Paintbrush application to experiment with the color mix before modifying this color setting. Start Paintbrush and double-click on any color in the palette to display the Edit Colors dialog. Use the edit boxes or the scroll bar to modify the color mix. When you find a color you like, record the RGB color numbers, cancel the dialog, quit Paintbrush and enter the numbers in the HighlightedBkColor setting.

                         

                        Type - String

                         

                        HtmlCellPadding[/B]

                        This setting determines the amount of space between adjacent columns in HTML output.

                         

                        Location - Export\Web

                         

                        Format - HtmlCellPadding=n

                         

                        n represents a number from 0 to 9. The default cell padding setting is 3.

                         

                        Type - DWord

                         

                        HtmlShowHref[/B]

                        When loading HTML files, this setting governs whether they are shown in the resulting conversion in the Report Window.

                         

                        Location - Settings

                         

                        Format - 1 (the default) shows the Href entries, 0 suppresses them.

                         

                        Type - DWord

                         

                        Import File Type[/B]

                        Monarch uses the Jet database engine to import and join data from local data files. This engine supports database operation against several types of files, with several versions of each file type supported. Most files can be read by specifying the latest version of the file type, but sometimes an older version must be specified. The Import File Type settings let you specify the version of a file that you intend to import or join data from.

                         

                        Location - Import

                         

                        Format - DBF\JetFormat=version

                        where version may be "dBASE III", "dBASE IV", or "dBASE 5.0"

                         

                        Excel\JetFormat=version

                        where version may be "Excel 3.0", "Excel 4.0", "Excel 5.0", or "Excel 8.0"

                         

                        MS Access\JetFormat=version

                        where version may be "Access 1.0", "Access 1.1", "Access 2.0", "Access 3.0", or "Current Version"

                         

                        Paradox\JetFormat=version

                        where version may be "Paradox 3.X", "Paradox 4.X", "Paradox 5.X", or "Paradox 7.X"

                         

                        Type - String

                         

                        LogOperations[/B]

                        Monarch generates a log file in its temporary folder to record error conditions that may occur during a Monarch session. Normally, the log file is deleted at the end of the session if no error has occurred.

                         

                        The LogOperations setting expands the use of the log file to record the path and filename of files exported from Monarch. When used in this manner, the log file is left intact at the end of the Monarch session.

                         

                        Location - Settings

                         

                        Format - LogOperations=OFF|AUTO|ALL

                         

                        OFF = No operations are logged.

                        AUTO = Logs operations if session is launched via OLE or batch mode. This is the default setting.

                        ALL = Logs operations regardless of how session is launched.

                         

                        Notes:

                         

                        1. Monarch creates the log file in the Monarch temporary folder and assigns it a temporary filename in the form Filen.ERR. You may assign a different log filename using the SetLogFile() OLE automation function. To determine the location of the Monarch temporary folder, see the WorkPath setting, below. For a description of the SetLogFile() OLE function, see the Monarch Programmer's Guide.

                         

                        2. The Monarch log file is an ASCII text file with one entry per line. The export file entries take the following form:

                         

                        When an export file is created from the Table window, the log file records the export path and filename, the name of the current filter and the name of the current sort order, as in:

                         

                        Export table to: c:\export\sales.dbf

                        Current filter: sales

                        Current sort: customer

                         

                        When an export file is created from the Summary window, the log file records the export path and filename, the name of the current filter and the name of the summary, as in:

                         

                        Export summary to: c:\export\sales.dbf

                        Current filter: sales

                        Current summary: sales1.

                         

                        Type - String

                         

                        MapAlphaTrapTo[/B]

                        MapNumericTrapTo[/B]

                        MapBlankTrapTo[/B]

                        MapNonblankTrapTo[/B]

                        Windows can be configured to display text from two or more languages on screen at the same time by assigning the Windows code pages that display each language's alphabet. For example, Windows can be configured to display both the Korean alphabet and the Latin alphabet (used for English and Western European languages). However, systems configured in this way may not display some of the extended characters in the Western European character set (character codes 128 - 255), including the characters that Monarch uses to represent its special trap characters.

                         

                        If one or more trap characters does not appear on screen when you create a data extraction template (see Creating data extraction templates), you may use these Registry settings to re-configure Monarch's trap display characters for the Alpha, Numeric, Blank and Non-blank traps. For example, to remap Monarch's Numeric trap display character from a  (character code 209) to a # (character code 35), set MapNumericTrapTo=35 in the Registry.

                         

                        At the beginning of each session, Monarch reads the Registry settings to determine how to map the corresponding trap display characters. If a setting is not present in the Registry, Monarch uses the default trap display character for that setting (the default character is the character pictured on the trap button face). For each setting that is present, Monarch will accept either the original trap display character or the new trap display character. In the example above, both # and  are interpreted as a Numeric Trap.

                         

                        Be sure to map the trap display characters to characters that you will not otherwise use in your trap. For example, if you map the Blank trap character to "B", you will no longer be able to use a "B" in the trap line to trap on a label, such as "ACCOUNT NUMBER:" The "B" would be interpreted by Monarch as a Blank trap character rather than the letter "B".

                         

                        When you save a model file, the re-mapped trap display characters are converted to the original trap display characters so that the model will be portable to a system that does not have the same Registry entries. In this way, two Monarch users can establish different trap display character settings and still share model files.

                         

                        Location - InputView

                         

                        Format - MapAlphaTrapTo=n

                        MapNumericTrapTo=n

                        MapBlankTrapTo=n

                        MapNonblankTrapTo=n

                         

                        (where n is the character code of the character to display in place of the designated trap character)

                         

                        Type - DWord

                         

                        MarkUpColor[/B]

                        This setting specifies the color of the text for the markup on imported HTML files.

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        MaxCachePages[/B]

                        This setting determines the number of pages Monarch will read into memory at-a-time when viewing or extracting from a report.

                         

                        Location - InputView

                         

                        Format - MaxCachePages=n

                        (where n is the maximum number of pages that Monarch will load into memory at-a-time).

                         

                        The default value for this setting is 50 pages. Though increasing this number may enhance performance on some systems, it is recommended that you not change this setting.

                         

                        Type - Dword

                         

                        MaxCells[/B]

                        This setting determines the maximum number of cells that can be exported to HTML.

                         

                        Location - Export\Web

                         

                        Format - MaxCells=n

                        (where n is the maximum number of cells that can be exported to HTML).

                         

                        The default value for this setting is 65536 cells. Increasing this number will enable a larger number of cells to be exported, but performance decreases when very large files are created.

                         

                        Type - DWord

                         

                        MaxChartElements[/B]

                        When Monarch is asked to display a chart, it first calculates the number of data elements that will be displayed on the chart. If the number of elements exceeds the limit specified by this setting, Monarch displays the error, "Maximum number of chart elements exceeded. Chart will not be displayed."

                         

                        Location - SummaryView

                         

                        Format - MaxChartElements=n

                        (where n is the maximum number of chart elements that Monarch will pass to the charting engine).

                         

                        The default value for this setting is 800 (increased from 400 under Monarch V3). Increasing this number allows Monarch to display charts with more data elements, but may result in charts with overlapping elements or blank charts (if the charting engine determines that the chart is too complex to display).

                         

                        Type - DWord

                         

                        MaxClipboardRows[/B]

                        This setting determines the number of rows (or lines) that Monarch will copy to the Clipboard. If you attempt to copy a selection that includes more rows, Monarch will display an error message. On systems with severe resource limitations you may use this setting to restrict the number of rows that Monarch will attempt to send to the Clipboard. Without such a restriction, the Clipboard memory management routines might cause the system to drastically slow down.

                         

                        Location - Export

                         

                        Format -

                        MaxClipboardRows=n

                        (where n is the number of rows)

                         

                        The default value for this setting is 65535.

                         

                        Type - DWord

                         

                        MaxPasswordLength[/B]

                        This setting determines the maximum number of characters that Monarch will accept when entering a password to encrypt a PRF file.

                         

                        Location - Settings

                         

                        Format - MaxPasswordLength=n

                        (where n is in the range 8 - 54, representing the maximum number of characters accepted for a password).

                         

                        The default value for this setting is 32.

                         

                        Type - DWord

                         

                        MaxUniqueValues[/B]

                        This setting specifies the maximum unique values per tree field in the Tree.

                         

                        Location - Publish

                         

                        Format - MaxUniqueValues=n

                         

                        The default value for this setting is 65536.

                         

                        Type - DWord

                         

                        MonUser /B(network editions only)

                        This setting is used by the network named user and concurrent user editions of Monarch and is initialized when the user runs the workstation setup program.

                         

                        For the network named user edition, this setting is used by the license metering software to allow the user to bypass the metering software's log-in dialog. This setting should be modified on the user's system whenever the user's name is modified in the network named user license database via the Monarch Administrator utility (e.g., from "Joe Smith" to "Joe Smith in Sales").

                         

                        For the network concurrent user edition, this setting allows the Monarch administrator to identify each user who is currently running a Monarch session. This setting may be modified on the user's system at any time to update the user name as you would like it reported to the Monarch administrator (e.g., from "Joe Smith" to "Joe Smith in Sales").

                         

                        Location - Settings

                         

                        Format - MonUser=user name

                        (where user name is the log-in name assigned to the user by the Monarch administrator).

                         

                        Type - String

                         

                        SummaryChartDisplay[/B]

                        This setting determines the display state of the Summary window. This setting is also saved in each project file. When the project file is loaded, the state saved in the project file overrides the default state.

                         

                        Location - SummaryView

                         

                        Format - SummaryChartDisplay=0|1|2|3

                         

                        0 = Split vertical (summary on left, chart on right)

                        1 = Split horizontal (summary on top, chart on bottom)

                        2 = Maximize chart

                        3 = Maximize summary

                         

                        Type - DWord

                         

                        TableRemainingLoadTime[/B]

                        TableCompletionThreshold[/B]

                        In order to export data from its Table window, Monarch first builds the table data set, then exports the data set to your chosen export file. However, in many situations Monarch may not need to first build the table prior to exporting it. Referred to as a table-less export operation, this method draws data directly from the report file and passes the data to the export engine. A table-less export operation reduces the time required to perform an export operation by up to 50%. This can be a significant savings when dealing with large data sets.

                         

                        Not all table export operations can be implemented as table-less exports. If a sort order is applied to the table data, Monarch must build and sort the entire table prior to beginning the export operation, therefore it cannot perform a table-less export for a sorted table.

                         

                        Further, it is not always desirable to use the table-less export method, as any portion of the table that has already been built must be discarded in order to perform a table-less export. Since Monarch extracts report data and builds the table data set as a background operation while you work in Monarch, it may have already built much of the table data set at the time you initiate an export operation. If Monarch has already built 75% of the table, an export operation may be faster if Monarch completes the table build operation and then performs the export. In this case, the export operation will be faster than a table-less export because Monarch takes advantage of the pre-built table data set. In other cases (e.g., when the table is less than 25% built), you may save time by discarding the table and performing a table-less export.

                         

                        The TableRemainingLoadTime and TableCompletionThreshold settings establish parameters used by Monarch to determine when to discard the table and perform a table-less export. The default settings established by the Monarch setup program are designed to yield the best performance across a broad range of export scenarios. However, you may modify these settings to suit your own needs.

                         

                        The TableRemainingLoadTime setting specifies the minimum number of seconds remaining to build the internal table before Monarch will consider discarding the internal table to perform a table-less export. This setting says, "Don’t bother with table-less exports if it takes less than 10 seconds to finish building the internal table." You may set the number of seconds to any value.

                         

                        If Monarch calculates that the number of seconds remaining to complete the internal table is less than this number, Monarch will continue to build the internal table and then perform the export operation from the internal table.

                         

                        If Monarch calculates that the number of seconds remaining to complete the internal table is greater than this number, it will defer to the TableCompletionThreshold setting to determine whether it should continue to build the internal table or discard it and perform a table-less export operation.

                         

                        The TableCompletionThreshold setting specifies a threshold representing the percentage completion before which Monarch will discard the internal table and perform a table-less export. This setting says, "If Monarch hasn’t built more than 50% of the table at the time the user initiates an export operation, Monarch will discard the internal table and perform a table-less export." You may set the percentage to any number from 0 to 100.

                         

                        If Monarch calculates that the percentage of the internal table that has been built is less than this number, it will discard the internal table and perform a table-less export operation.

                         

                        If Monarch calculates that the percentage of the internal table that has been built is greater than or equal to this number, it will continue to build the internal table and then use the internal table to perform the export operation.

                         

                        Note that the TableCompletionThreshold setting is dependant upon the TableRemainingLoadTime setting.

                         

                        Location - Export

                         

                        Format - TableRemainingLoadTime=n

                        (where n represents the number of seconds remaining to build the internal table data set)

                        The default value for this setting is 10.

                         

                        TableCompletionThreshold=n

                        (where n represents the percentage completion of the internal table data set)

                        The default value for this setting is 50.

                         

                        To force Monarch to always discard its internal table and perform a table-less export, use the following settings:

                        TableRemainingLoadTime=0

                        TableCompletionThreshold=100

                         

                        To force Monarch to always build its internal table prior to performing an export, use the following settings:

                        TableRemainingLoadTime=ffffffff (enter value as a Hexadecimal)

                        TableCompletionThreshold=0

                         

                        Type - DWord

                         

                        UseSingleSpaceDelimiter[/B]

                        When you copy a selection from the Report window to the Clipboard, Monarch parses the selection into individual worksheet columns by examining the spaces between columns of text. The selection is split wherever it contains an uninterrupted column of at least two spaces from the top of the selection to the bottom. If your data contains columns separated by only a single space, you can use this default setting to modify Monarch’s parsing rule.

                         

                        Location - InputView

                         

                        Format - UseSingleSpaceDelimiter=FALSE|TRUE

                         

                        FALSE requires two or more spaces between columns.

                        TRUE requires only a single space between columns.

                         

                        Type - String

                         

                        VariableFieldBackground[/B]

                        Color of the background for variable fields. If this setting is missing or empty, then the color used is the current window text color (generally black).

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        VariableFieldText[/B]

                        Color of the text for variable fields. If this setting is missing or empty, then the color used is the current window background color (generally white).

                         

                        Location - Colors

                         

                        Format - String giving the desired red, green, and blue components, in RGB order, and as decimal values separated by commas. For example, "255,0,0" specifies pure red.

                         

                        Type - String

                         

                        WorkPath[/B]

                        Specifies the location where Monarch will create temporary work files. Since the temporary files can potentially be quite large relative to your input files, you should specify a drive and folder where there is sufficient disk space available. The default folder, established when you first run Monarch for the first time (or by an installation previous to V10), is your temporary user folder. You must have Read, Write and Create rights to the folder specified by this setting.

                         

                        Location - Settings

                         

                        Format - Workpath=drive:\path

                        drive refers to a valid drive, such as C

                        path refers to a valid path, such as Temp

                         

                        Type - String

                          • Remember the &quot;First row contains column names&quot; option
                            Grant Perkins

                            There are a couple of small potential problems with posting all that information into the forum - apart from that observation that there really is no need since it is all in the Help file.

                             

                            Although Monarch, at this level, is and has been quite consistent over the years chenges, usually enhancements, do appear form time to time and the version of HELP provided with specific versions of Monarch will reflect the developments up to that version. So a user has relevant and pertinent content in the help file for their version of Monarch.

                             

                            Posting the contents of your current version's help file here will place a time capsule in the forum which may not have complete relevance for future versions and may offer misleading guidance to users stuck with older versions.

                             

                            So I have some reticence about the value of posting this information in the forum especially since users could be expected to have direct access to the information on their desk top along with a lot of other very useful guidance.

                             

                            Either way at the very least I think it would be pertinent, as Olly suggested, to let Datawatch confirm that they would have no problem with the information being posted. It would also be sensible to indicate the version of Monarch Help from which the information has been extracted.

                             

                            Just my 2 cents.

                             

                             

                            Grant

                              • Remember the &quot;First row contains column names&quot; option
                                sgpm _

                                You're right, I should have said that it was for version 10. And I agree with all other issues you are pointing out.

                                 

                                However, to me this information could be helpful to people wondering if latest Monarch version fixes one specific issue they encounter. At least to me this would have helped.

                                 

                                If olly tells me that datawatch does not agree with the display of this information, I will promptly remove it.

                                 

                                Pierre-Marie

                                  • Remember the &quot;First row contains column names&quot; option
                                    Olly Bond

                                    Hello SGPM,

                                     

                                    I was a little surprised to see you post the data in without waiting to see if DW gave us the green light first. I agree with Grant, that every user will have the Help files, but some users might be looking to solve a problem without necessarily having the latest version of Monarch on their machines.

                                     

                                    So I think it might be sensible for DW to consider putting the help files online, in a searchable format. That would ensure that the latest version only was available.

                                     

                                    I understand that the moderator of the forums has changed recently, so I'll drop the new one a line to draw his attention to this thread.

                                     

                                    Best wishes,

                                     

                                    Olly