{"id":48882,"date":"2021-07-12T21:15:22","date_gmt":"2021-07-13T04:15:22","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?post_type=docs&#038;p=48882"},"modified":"2022-07-05T09:44:13","modified_gmt":"2022-07-05T16:44:13","slug":"transact-ai-table-rule-builder","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/","title":{"rendered":"Transact AI Table Rule Builder"},"content":{"rendered":"<h1>Introduction<\/h1>\n<p>This document describes how to use the Ephesoft Transact AI Table Rule Builder in Ephesoft Transact. With the Ephesoft Transact AI Table Rule Builder, operators can create extraction rules for invoice table line items during the Validation stage in Ephesoft Transact. This feature also provides improved extraction accuracy by excluding rows that are not needed. With AI Table Rule Builder, users can configure and save extraction rules that are unique to vendor-specific invoices. The Ephesoft Transact AI Table Rule Builder is provided as an external application that is configured in the VALIDATE_DOCUMENT plugin and integrates with the Validation module.<\/p>\n<p><strong>Note: <\/strong>The Transact AI Table Rule Builder is currently limited to creating rules for single-page basic invoices. It was designed for invoice document types, and has not been tested with other document types.<\/p>\n<h2>Prerequisites<\/h2>\n<p>To use the Transact AI Table Rule Builder, the following prerequisites must be in place:<\/p>\n<ul>\n<li>Ephesoft Transact 2020.1.05 or above environment<\/li>\n<li>Install and enable the Transact AI Table Rule Builder. Follow the steps in the <strong>InstallationNotes.txt <\/strong>packaged with the ZIP file provided by Ephesoft.<\/li>\n<li>Ensure the TABLE_EXTRACTION plugin is added to the <strong>Extraction<\/strong> module and turned on.<\/li>\n<li>Add the table and table columns to your document type. Transact can only create extraction rules for existing tables. For steps, refer to <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/semi-automated-table-extraction\/#add-table-columns\">Add Table Columns<\/a>.<\/li>\n<\/ul>\n<p><strong>Important:<\/strong> Each <strong>Column Name<\/strong> must exactly match the column header for the table, or the table will not be extracted, and the rule will not be created.<\/p>\n<p><strong>Note: <\/strong>This plugin must be installed separately for the 2020.1.05 release.<\/p>\n<h2><a id=\"post-48882-_3znysh7\"><\/a>Installation<\/h2>\n<p><b>Note:<\/b><span style=\"font-weight: 400\"> W<\/span><span style=\"font-weight: 400\">hen upgrading Transact from version 2020.1.05 to version 2020.1.06, t<\/span><span style=\"font-weight: 400\">here is a known issue in which Transact will not run successfully if the AI Table Rule Builder is installed. As a workaround, you will need to re-install the AI Table Rule Builder after completing the upgrade.<\/span><\/p>\n<ol>\n<li>Download the current version of the Transact AI Table Rule Builder plugin from the <a href=\"https:\/\/ephesoft.force.com\/login?ec=302&amp;startURL=%2Fs%2F\">Customer Support Portal<\/a>.<\/li>\n<li>Stop the Transact server.<\/li>\n<li>Extract the ZIP file to a temporary location.<\/li>\n<li>For Windows:\n<ul>\n<li>Navigate to the directory where you extracted the plugin files.<\/li>\n<li>Open a command prompt and run the command <code>install_auto_table_rule_builder.bat<\/code><\/li>\n<\/ul>\n<\/li>\n<li>For Linux:\n<ul>\n<li>Navigate to the directory where you extracted the plugin files.<\/li>\n<li>Open the terminal and run the command <code>.\/install_auto_table_rule_builder.sh<\/code><\/li>\n<li><strong>Note:<\/strong> If you are unable to run the command because of a permission issue, then run the following: <strong>chmod +x install_auto_table_rule_builder.sh<\/strong><\/li>\n<\/ul>\n<\/li>\n<li>Start the server.<\/li>\n<\/ol>\n<p><strong>Note:<\/strong> For Transact Cloud users, the Ephesoft Technical Operations Team will install the AI Table Rule Builder for you. However, you will need to configure the VALIDATE_DOCUMENT plugin. Please review the <a href=\"#Config_VALIDATE_DOCUMENT_Plugin\">Configuring the VALIDATE_DOCUMENT Plugin<\/a> section for more details.<\/p>\n<h2>Configuring the VALIDATE_DOCUMENT Plugin<\/h2>\n<p>You must configure the VALIDATE_DOCUMENT plugin to use the Transact AI Table Rule Builder. Once configured, the Transact AI Table Rule Builder will appear in the Validate screen as a selectable link from the <strong>More External Application<\/strong> menu.<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>From the <strong>Batch Class Management <\/strong>page, select your batch class and click <strong>Open<\/strong>.<\/li>\n<li>Expand the <strong>Validate Document<\/strong> module and select the <strong>VALIDATE_DOCUMENT<\/strong> plugin.<\/li>\n<li>In the Plugin Configuration screen, set the <strong>External Application Switch <\/strong>to <strong>ON<\/strong>.<\/li>\n<li>Type <code>http:\/\/[<em>Server_Name<\/em>]:8080\/dcma\/autoTable<\/code> or an HTTPS URL in one of the following fields:\n<ul>\n<li><strong>URL1(Ctrl+4)<\/strong><\/li>\n<li><strong>URL2(Ctrl+7)<\/strong><\/li>\n<li><strong>URL3(Ctrl+8)<\/strong><\/li>\n<li><strong>URL4(Ctrl+9)<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>In <em>Figure 1. VALIDATE_DOCUMENT plugin configuration<\/em>, the <strong>URL1(Ctrl+4)<\/strong> field is used.<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol start=\"5\">\n<li>In the corresponding URL Title field, type a name for the External Application link.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p>In <em>Figure 1. VALIDATE_DOCUMENT plugin configuration<\/em>, the name is AI Table Rule Builder.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48883\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96.png\" alt=\"\" width=\"1100\" height=\"672\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96.png 1223w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96-300x183.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96-1024x625.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96-768x469.png 768w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" \/><em>Figure 1. VALIDATE_DOCUMENT plugin configuration<\/em><\/p>\n<ol start=\"6\">\n<li>Click <strong>Deploy<\/strong>.<\/li>\n<\/ol>\n<h2><a id=\"post-48882-_tz5o7fyrql6b\"><\/a>Launching the Application<\/h2>\n<p>Operators can launch the application from the <strong>Validation <\/strong>page for a batch instance by clicking <strong>More <\/strong>&gt; <strong>External Application <\/strong>and then selecting the link assigned to the AI Table Rule Builder. In <em>Figure 2. Launch Application<\/em>, the name is AI Table Rule Builder but the name may vary depending on how the VALIDATE_DOCUMENT plugin is configured.<\/p>\n<p><strong><img decoding=\"async\" class=\"alignnone wp-image-48884\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-97.png\" alt=\"\" width=\"615\" height=\"307\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-97.png 605w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-97-300x150.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/strong><em>Figure 2. Launch Application<\/em><\/p>\n<p><strong>Note:<\/strong> Operators can use shortcuts to launch the AI Table Rule Builder. The shortcut is dependent on which External Application URL is associated with the AI Table Rule Builder. For example, if it is registered as the first External Application URL for the batch class, then the shortcut <strong>CTRL+4<\/strong> will open it. Other shortcuts are as follows:<\/p>\n<table>\n<tbody>\n<tr style=\"color: #ffffff;background-color: #1f3864\">\n<td><strong>External Application URL<\/strong><\/td>\n<td><strong>Shortcut<\/strong><\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td>URL1<\/td>\n<td>Ctrl+4<\/td>\n<\/tr>\n<tr>\n<td>URL2<\/td>\n<td>Ctrl+7<\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td>URL3<\/td>\n<td>Ctrl+8<\/td>\n<\/tr>\n<tr>\n<td>URL4<\/td>\n<td>Ctrl+9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><a id=\"post-48882-_g95sxcqq9ep8\"><\/a>Overview<\/h2>\n<p>Using 1 of 4 modes (<strong>Automatic<\/strong>, <strong>Standard<\/strong>, <strong>Advanced<\/strong> or <strong>Manual<\/strong>), operators can choose the configuration mode that best suits their skill level. A new guided in-app configuration screen helps users identify line item information to extract. Transact then creates the extraction rules and uses them to extract data from any subsequent invoices submitted by the same vendor.<\/p>\n<p>The Table Extraction Rule builder includes multiple modes depending on your needs.<\/p>\n<table>\n<tbody>\n<tr style=\"color: #ffffff;background-color: #1f3864\">\n<td><strong>Extraction Mode<\/strong><\/td>\n<td><strong>Description<\/strong><\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td><a href=\"#post-48882-_c2bjuyhd2ilc\">Automated Mode<\/a><\/td>\n<td>This is the AI Table Rule Builder default mode. If you need to edit the extraction results or rule, you can select one of the remaining modes to make changes.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"#post-48882-_viw5e3qbm7dh\">Standard Mode<\/a><\/td>\n<td>Recommended edit mode for most use cases. This wizard will walk you through each step in configuring an extraction rule.<\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td><a href=\"#post-48882-_o4xmffwb1kut\">Advanced Mode<\/a><\/td>\n<td>Alternative edit mode for operators, administrators, or developers familiar with regular expressions.<\/td>\n<\/tr>\n<tr>\n<td><a href=\"#post-48882-_d4zbbo1oleit\">Manual Mode<\/a><\/td>\n<td><strong>Manual Mode<\/strong> allows users to extract table data without creating new table extraction rules.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><a id=\"post-48882-_c2bjuyhd2ilc\"><\/a>Automated Mode<\/h2>\n<p><strong>Automated Mode<\/strong> is the default configuration mode for AI Table Rule Builder. Operators define the location of the table data on the document using an overlay, select a table name from a menu, and click <strong>Next<\/strong>. Then, Transact uses an AI engine to extract and analyze the data and generate extraction rules. If needed, operators can manually adjust column names or select an alternative mode (Standard, Advanced, or Manual) to refine the new extraction rule. Once configured, Transact will populate the table Validation screen using the new table extraction rule. Operators can then finish validating the extracted data.<\/p>\n<p>To create an extraction rule using the wizard, perform the following steps.<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>From the dropdown, select the table you want to build a rule for.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/3.jpg\"><img decoding=\"async\" class=\"alignnone size-large wp-image-51465\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/3-1024x617.jpg\" alt=\"\" width=\"840\" height=\"506\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/3-1024x617.jpg 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/3-300x181.jpg 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/3-768x463.jpg 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/3.jpg 1193w\" sizes=\"(max-width: 840px) 100vw, 840px\" \/><\/a><\/p>\n<p><em>Figure 3. Select Table<\/em><\/p>\n<p><strong>Note: <\/strong>If no tables are listed, or if your desired table is missing, ensure you have satisfied all <a href=\"#post-48882-_1fob9te\">Prerequisites<\/a>.<\/p>\n<ol start=\"2\">\n<li>Use the overlay to draw a box around your table on the preview image. This should include the header row, and span the full height and width of the table.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/4.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-51466\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/4.png\" alt=\"\" width=\"573\" height=\"459\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/4.png 573w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/4-300x240.png 300w\" sizes=\"(max-width: 573px) 100vw, 573px\" \/><\/a><\/p>\n<p><em>Figure 4. Draw Overlay<\/em><\/p>\n<ol start=\"3\">\n<li>Click <strong>Next<\/strong>.<\/li>\n<li>Review the extracted results.\n<ul>\n<li>If you are satisfied with the results, click <strong>Next <\/strong>to review the extraction rule, then click <strong>Save<\/strong>. Your extraction rule will be created, and the wizard will close.<\/li>\n<li>If the columns contain the correct data, but are mapped incorrectly, select the correct header name using the label button and proceed as normal.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><strong>Important:<\/strong><\/p>\n<ul>\n<li>When adding a new table and table columns for a document type, the <strong>Column Name <\/strong>must exactly match the column header, or the table will not be extracted, and the rule will not be created. Alternatively, the dictionary synonyms should be defined to properly match the column header. Please see the <a href=\"#post-48882-_radofrsh6y3w\">Automated Mode Dictionary<\/a> section of this document for more information on configuring the dictionary synonyms.<\/li>\n<li>When using <strong>Automated Mode<\/strong>, column data may merge together if data in columns are closely aligned. Please see the <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/announcements\/release-notes\/release-note-2020-1-05\/known-issues-and-workarounds-2020-1-05\/\">Known Issues and Workarounds<\/a> document for more information.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/5.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-51467\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/5.png\" alt=\"\" width=\"638\" height=\"297\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/5.png 638w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/5-300x140.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/a><\/p>\n<p><em>Figure 5. Map Incorrect Headers<\/em><\/p>\n<ul>\n<li>If the columns do not contain the correct data, or are missing data, click <strong>Edit <\/strong>and select your edit mode.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/6.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-51468\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/6.png\" alt=\"\" width=\"599\" height=\"470\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/6.png 599w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/6-300x235.png 300w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/a><\/p>\n<p><em>Figure 6. Select Edit Mode<\/em><\/p>\n<p>Select one of the following edit modes based on your use case:<\/p>\n<ul>\n<li><a href=\"#post-48882-_viw5e3qbm7dh\">Standard Mode<\/a> (recommended)<\/li>\n<li><a href=\"#post-48882-_o4xmffwb1kut\">Advanced Mode<\/a><\/li>\n<li><a href=\"#post-48882-_d4zbbo1oleit\">Manual Mode<\/a><\/li>\n<\/ul>\n<h3><a id=\"post-48882-_radofrsh6y3w\"><\/a>Automated Mode Dictionary<\/h3>\n<p>The Automated Mode Dictionary allows batch class administrators to define a set of table header synonyms. AI Table Rule Builder will use synonym-based detection if it is unable to detect headers by matching column names using the Transact table header detection algorithm.<\/p>\n<h3><a id=\"post-48882-_6a4o4nb5gw3p\"><\/a>Configuring the Automated Mode Dictionary<\/h3>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>From the <strong>Batch Class Management <\/strong>page, select your batch class and click <strong>Open<\/strong>.<\/li>\n<li>Go to <strong>Document Types<\/strong> &gt; [<em>Document_Type_Name<\/em>] &gt; <strong>Tables<\/strong> &gt; [<em>Table_Name<\/em>] &gt; <strong>Table Columns<\/strong>.<\/li>\n<li>In the <strong>Column Synonym<\/strong> column, create regex patterns for each synonym.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48895\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-102.png\" alt=\"\" width=\"950\" height=\"440\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-102.png 1102w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-102-300x139.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-102-1024x474.png 1024w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-102-768x355.png 768w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/p>\n<ol start=\"4\">\n<li>Click <strong>Deploy <\/strong>once you have created the synonyms.<\/li>\n<\/ol>\n<h2><a id=\"post-48882-_viw5e3qbm7dh\"><\/a>Standard Mode<\/h2>\n<p>Standard Mode is the recommended edit mode for most use cases. Standard Mode uses a guided wizard to dynamically build table extraction rules. Once the rule is created, operators can review the rule and tune it for improved extraction results. Standard Mode also includes the option to select any rows in the table that should be excluded from the extraction rule.<\/p>\n<p>This wizard will walk you through creating an extraction rule for your table step by step. To access this wizard, click <strong>Edit <\/strong>when available and select <strong>Standard Mode (recommended)<\/strong>.<\/p>\n<p><img decoding=\"async\" width=\"547\" height=\"302\" class=\"wp-image-48896\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-103.png\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-103.png 547w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-103-300x166.png 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/><em>Figure 7. Select <\/em><strong><em>Standard Mode<\/em><\/strong><\/p>\n<p>The wizard separates creating an extraction rule into the following steps:<\/p>\n<table>\n<tbody>\n<tr style=\"color: #ffffff;background-color: #1f3864\">\n<td><strong>Step in Wizard<\/strong><\/td>\n<td><strong>Action<\/strong><\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td><strong>Step 1: <\/strong>Header Row<\/td>\n<td>Select whether a header row exists for this table or not. If yes, draw the provided overlay over the full height and width of the header row. The header row is the preferred option when creating an extraction rule.<\/td>\n<\/tr>\n<tr>\n<td><strong>Step 2:<\/strong> Preceding Text<\/td>\n<td>Select whether the table has preceding text (text immediately before the table). If yes, draw the overlay over a single line of preceding text.<br \/>\n<strong>Note:<\/strong> The system needs some header row or preceding text to create an extraction rule. If both header row and preceding text are selected, then Transact will default to using the header row text to create the extraction rule.<br \/>\nFor help, refer to the section <a href=\"#post-48882-_lje88a1j04jl\">Note on Preceding and Trailing Text<\/a>.<\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td><strong>Step 3: <\/strong>Trailing Text<\/td>\n<td>Select whether the table has trailing text (text immediately after the table rows). If yes, draw the provided overlay over a single line of trailing text.<br \/>\nFor help, refer to the section <a href=\"#post-48882-_lje88a1j04jl\">Note on Preceding and Trailing Text<\/a>.<\/td>\n<\/tr>\n<tr>\n<td><strong>Steps 4 and up:<\/strong> Columns<br \/>\n<em>(varies depending on number of columns)<\/em><\/td>\n<td>Select whether the table has the mentioned column. If yes, draw the overlay over the full height and width of the column, not including the header. This step will repeat based on the number of columns configured for the selected table.<\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td><strong>Final step:<\/strong> Ignore Rows<\/td>\n<td>Select whether any extracted rows should be ignored using the sample extracted table. For example, on an invoice you may want to ignore the subtotal rows.<br \/>\n<strong>Note:<\/strong> If you reach this step and no data is populated in the sample table, Transact will not be able to create an extraction rule. Try the wizard again, or use the <a href=\"#post-48882-_o4xmffwb1kut\">Advanced Mode<\/a>. Otherwise, you can perform a one-time extraction using <a href=\"#post-48882-_d4zbbo1oleit\">Manual Mode<\/a>.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><a id=\"post-48882-_lje88a1j04jl\"><\/a>Note on Preceding and Trailing Text<\/h3>\n<p>Identifying preceding and trailing text helps Transact determine where a table begins and ends. Use the following guidelines to select the best preceding and trailing text:<\/p>\n<ul>\n<li>This text should be immediately before or after your table. If anything is between your text and the table it will be treated as part of the table, and may result in incorrect extraction results.<\/li>\n<li>This text should be static, which means it will not change from document to document.<\/li>\n<li>This text should only span a single line.<\/li>\n<\/ul>\n<h4><a id=\"post-48882-_etup0xxqe4tj\"><\/a>Examples<\/h4>\n<p><span style=\"font-weight: bold;color: #00cc00\">Good:<\/span> The following example shows a sample invoice with the line &#8220;Sub Total&#8221; selected as the trailing text. This works well for this invoice because:<\/p>\n<ul>\n<li>There is nothing between the table and the highlighted text.<\/li>\n<li>The text is an invoice field name, which means it will not change.<\/li>\n<li>The text only spans a single line.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48897\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-104.png\" alt=\"\" width=\"615\" height=\"397\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-104.png 595w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-104-300x194.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><em>Figure 8. Good Trailing Text<\/em><\/p>\n<p><span style=\"font-weight: bold;color: #ff0000\">Poor: <\/span>The following example shows the same sample invoice with the line &#8220;Thank you for your business&#8221; selected as the trailing text. This is a poor selection because there are multiple lines between this line and the table, including a QR code.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48899\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-106.png\" alt=\"\" width=\"615\" height=\"393\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-106.png 589w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-106-300x192.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><em>Figure 9. Poor Trailing Text<\/em><\/p>\n<h2><a id=\"post-48882-_o4xmffwb1kut\"><\/a>Advanced Mode<\/h2>\n<p>Advanced Mode provides operators with additional flexibility to create extraction rules using column overlays and custom regex patterns. Operators can also test regex patterns within the rule builder or exclude rows from the rule for additional fine tuning. This mode is ideal for users with advanced knowledge of regex.<\/p>\n<p>To access this mode, click <strong>Edit <\/strong>when available and select <strong>Advanced Mode<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48901\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-109.png\" alt=\"\" width=\"615\" height=\"335\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-109.png 543w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-109-300x164.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><em>Figure 10. Select <\/em><strong><em>Advanced Mode<\/em><\/strong><\/p>\n<p>To create an advanced rule using regular expressions, perform the following steps:<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>Create the following regular expressions (regex):\n<ul>\n<li><strong>Start Pattern Regex:<\/strong> Defines the starting point of the table. This must be unique across all extraction rules in a document type. A good choice for a start pattern is often part of the table column headers. For example &#8220;Code Description Price&#8221;.<\/li>\n<li><strong>End Pattern Regex: <\/strong>Defines the end point of the table. Refer to the section <a href=\"#post-48882-_lje88a1j04jl\">Note on Preceding and Trailing Text<\/a> for guidance.<\/li>\n<li><strong>Column Regex: <\/strong>Defines the pattern for the column data. You will need to define a regular expression for each available column.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><strong>Note: <\/strong>Each column includes selectable <strong>Anchor<\/strong> and <strong>Required<\/strong> checkboxes.<\/p>\n<table>\n<tbody>\n<tr style=\"color: #ffffff;background-color: #1f3864\">\n<td><strong>Checkbox<\/strong><\/td>\n<td><strong>Description<\/strong><\/td>\n<\/tr>\n<tr bgcolor=\"#d9e2f3\">\n<td><strong>Anchor<\/strong><\/td>\n<td>This checkbox allows you to indicate the start of a new row if a value from this column is extracted. This is useful when table rows span more than a single line (i.e. &#8220;wrap&#8221;). For best results, select a single value from the end of the wrapped line that will always be present. You can only select one <strong>Anchor<\/strong> checkbox at a time.<\/td>\n<\/tr>\n<tr>\n<td><strong>Required<\/strong><\/td>\n<td>Selecting the required checkbox will make the column mandatory for operator validation. The extraction algorithm will always expect this column to be present in the document.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ol>\n<li style=\"list-style-type: none\">\n<ul>\n<li><strong>Row Exclusion Regex: <\/strong>Define a pattern for table rows that should be ignored, such as the subtotal row in an invoice. If a row is extracted that fully or partially matches the regex, that row will be removed from the table results.<\/li>\n<\/ul>\n<\/li>\n<li>Resize the provided overlays over the full height and width of each column. These overlays are color-coded and labeled to match each column.<\/li>\n<li>Click <strong>Test Extraction<\/strong> and review the extracted results. You may need to test multiple times as you fine-tune your rule.<\/li>\n<li>When you&#8217;re satisfied, click <strong>Save<\/strong>. The extraction rule will be created and you will return to the <strong>Validation <\/strong>screen.<\/li>\n<\/ol>\n<h2><a id=\"post-48882-_d4zbbo1oleit\"><\/a>Manual Mode<\/h2>\n<p><strong>Manual Mode<\/strong> allows users to extract table data without creating new table extraction rules. It is ideal to use when operators need to quickly extract and validate data but no rule exists, documents have poor OCR quality, or contain a complex table layout. Although Manual Mode will extract and save data to the batch instance, it does not create and save extraction rules to the batch class.<\/p>\n<p><strong>Important: <\/strong>Using this mode will <strong>not <\/strong>create an extraction rule for the table.<\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48904\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-110.png\" alt=\"\" width=\"615\" height=\"339\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-110.png 543w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-110-300x165.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/p>\n<p><em>Figure 11. Select <\/em><strong><em>Manual Mode<\/em><\/strong><\/p>\n<p>Refer to the following section for help <a href=\"#post-48882-_egk2y1e8n4yz\">performing manual edits<\/a>. When you&#8217;re satisfied with your changes, click <strong>Update Batch <\/strong>to return to the <strong>Validation <\/strong>screen.<\/p>\n<h3><a id=\"post-48882-_egk2y1e8n4yz\"><\/a>Performing Manual Edits<\/h3>\n<p>The following section provides a summary of the table editing tools and how to use them.<\/p>\n<ul>\n<li><strong>Edit cells<\/strong> \u2014 Click any non-header cell to enter edit mode and begin typing.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48905\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-6.gif\" alt=\"\" width=\"615\" height=\"330\" \/><\/p>\n<p><em>Figure 12. Edit Cells<\/em><\/p>\n<ul>\n<li><strong>Map incorrect headers<\/strong> \u2014 Fix any incorrect headers by clicking the label icon and selecting a header from the dropdown.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48908\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-7.gif\" alt=\"\" width=\"615\" height=\"330\" \/><\/p>\n<p><em>Figure 13. Map Incorrect Headers<\/em><\/p>\n<p><strong>Note: <\/strong>A header can only be mapped to one column at a time. Selecting a header that is already mapped to another column will swap the mapping with the existing column.<\/p>\n<p>You can also insert, merge, or delete rows.<\/p>\n<ul>\n<li><strong>Insert a row <\/strong>\u2014 Click the three-dot icon to the right of a row and select either <strong>Insert row above <\/strong>or <strong>Insert row below<\/strong>.<\/li>\n<li><strong>Merge rows \u2014 <\/strong>Click the three-dot icon to the right of a row and select either <strong>Merge row above<\/strong> or <strong>Merge row below<\/strong>.<\/li>\n<li><strong>Delete a row <\/strong>\u2014 Click the three-dot icon to the right of the row you want to delete and select <strong>Delete row<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48910\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-114.png\" alt=\"\" width=\"615\" height=\"380\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-114.png 728w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-114-300x185.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/p>\n<p><em>Figure 14. Insert, Merge, or Delete Rows<\/em><\/p>\n<p>You can also clear an entire column.<\/p>\n<ul>\n<li><strong>Clear column<\/strong> \u2014 Click the three-dot icon to the right of a row and select <strong>Clear column<\/strong>.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone wp-image-48912\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-115.png\" alt=\"\" width=\"615\" height=\"346\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-115.png 862w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-115-300x169.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-115-768x432.png 768w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/p>\n<p><em>Figure 15. Clear column<\/em><\/p>\n<h2><a id=\"post-48882-_pc9274jn1cfp\"><\/a>Limitations<\/h2>\n<p>The following types of tables are not good candidates for the AI Table Rule Builder, and may receive inaccurate results:<\/p>\n<ul>\n<li>Tables with overlapping columns<\/li>\n<li>Tables with closely packed column data<\/li>\n<li>Tables within the cell of another table (i.e. &#8220;nested&#8221; tables)<\/li>\n<li>Tables with <a href=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/batch-class-management\/table-extraction\/hidden-table-column-feature\/\">hidden columns<\/a><\/li>\n<li>Tables that span more than one page<\/li>\n<\/ul>\n<h2><a id=\"post-48882-_2oq7pvz57cpn\"><\/a>Conclusion<\/h2>\n<p>This completes an overview of how to use the Transact AI Table Rule Builder in Ephesoft Transact.<\/p>\n","protected":false},"featured_media":0,"parent":31686,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Transact AI Table Rule Builder | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transact AI Table Rule Builder\" \/>\n<meta property=\"og:description\" content=\"Introduction This document describes how to use the Ephesoft Transact AI Table Rule Builder in Ephesoft Transact. With the Ephesoft [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-05T16:44:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/\",\"name\":\"Transact AI Table Rule Builder | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2021-07-13T04:15:22+00:00\",\"dateModified\":\"2022-07-05T16:44:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Developer Documentation\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"External Applications\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Transact AI Table Rule Builder\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Transact AI Table Rule Builder | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Transact AI Table Rule Builder","og_description":"Introduction This document describes how to use the Ephesoft Transact AI Table Rule Builder in Ephesoft Transact. With the Ephesoft [&hellip;]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/","og_site_name":"Ephesoft Docs","article_modified_time":"2022-07-05T16:44:13+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2021\/07\/word-image-96.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/","name":"Transact AI Table Rule Builder | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2021-07-13T04:15:22+00:00","dateModified":"2022-07-05T16:44:13+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/transact-ai-table-rule-builder\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Developer Documentation","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/"},{"@type":"ListItem","position":4,"name":"External Applications","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/developers\/external-applications\/"},{"@type":"ListItem","position":5,"name":"Transact AI Table Rule Builder"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/48882"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=48882"}],"version-history":[{"count":5,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/48882\/revisions"}],"predecessor-version":[{"id":51469,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/48882\/revisions\/51469"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31686"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=48882"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=48882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}