2023:Table Extraction (Concept) - Revision history

Randallkinard at 15:43, 22 November 2024

2024-11-22T15:43:50Z

← Older revision		Revision as of 10:43, 22 November 2024
Line 113:		Line 113:
	# '''''Fixed Width'''''		# '''''Fixed Width'''''
	#* Please note: This method is only designed to work on fixed-width text files.		#* Please note: This method is only designed to work on fixed-width text files.

	~~== Glossary ==~~
	~~<u><big>'''Content Model'''</big></u>: {{#lst:Glossary\|Content Model}}~~

	~~<u><big>'''Data Column'''</big></u>: {{#lst:Glossary\|Data Column}}~~

	~~<u><big>'''Data Element'''</big></u>: {{#lst:Glossary\|Data Element}}~~

	~~<u><big>'''Data Model'''</big></u>: {{#lst:Glossary\|Data Model}}~~

	~~<u><big>'''Data Table'''</big></u>: {{#lst:Glossary\|Data Table}}~~

	~~<u><big>'''Delimited Extract'''</big></u>: {{#lst:Glossary\|Delimited Extract}}~~

	~~<u><big>'''Export'''</big></u>: {{#lst:Glossary\|Export}}~~

	~~<u><big>'''Extract'''</big></u>: {{#lst:Glossary\|Extract}}~~

	~~<u><big>'''Fluid Layout'''</big></u>: {{#lst:Glossary\|Fluid Layout}}~~

	~~<u><big>'''Grid Layout'''</big></u>: {{#lst:Glossary\|Grid Layout}}~~

	~~<u><big>'''Node Tree'''</big></u>: {{#lst:Glossary\|Node Tree}}~~

	~~<u><big>'''Row Match'''</big></u>: {{#lst:Glossary\|Row Match}}~~

	~~<u><big>'''Table Extraction'''</big></u>: {{#lst:Glossary\|Table Extraction}}~~

	~~<u><big>'''Tabular Layout'''</big></u>: {{#lst:Glossary\|Tabular Layout}}~~

Randallkinard at 15:35, 27 August 2024

2024-08-27T15:35:07Z

@@ Line 9: / Line 9: @@
 In Grooper, tabular data can be extracted to '''Data Table''' objects using one of many table extraction methods.
 <br clear=all>
 == What Is a Table? ==
 Tables consists of rows and columns.  Where those rows and columns intersect are cells.  These are the individual units of the table containing individual pieces of data.  Each row consists of the same number of columns (although some columns may be empty in a given row).  A single column consists of the same type of information.  For example, an "Order Date" column will always have dates in the cells below it.  The rows themselves are usually (but not always) in some order as well, such as in order of ascending date.
@@ Line 142: / Line 113: @@
 # '''''Fixed Width'''''
 #* Please note: This method is only designed to work on fixed-width text files.

Randallkinard at 18:20, 10 May 2024

2024-05-10T18:20:44Z

@@ Line 9: / Line 9: @@
 In Grooper, tabular data can be extracted to '''Data Table''' objects using one of many table extraction methods.
 <br clear=all>
 == What Is a Table? ==
 Tables consists of rows and columns.  Where those rows and columns intersect are cells.  These are the individual units of the table containing individual pieces of data.  Each row consists of the same number of columns (although some columns may be empty in a given row).  A single column consists of the same type of information.  For example, an "Order Date" column will always have dates in the cells below it.  The rows themselves are usually (but not always) in some order as well, such as in order of ascending date.

Randallkinard at 20:15, 23 April 2024

2024-04-23T20:15:53Z

← Older revision		Revision as of 15:15, 23 April 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}

	[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]		[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]
	~~<section begin="glossary" />~~
	<blockquote>		<blockquote>{{#lst:Glossary\|Table Extraction}}</blockquote>
	Table Extraction ~~refers to Grooper's functionality to extract data from cells in tables. This is accomplished by configuring the '''[[Data Table]]''' '''''[[Data Element]]''''' in a '''[[Data Model]]'''.~~
	</blockquote>
	~~<section end="glossary" />~~
	Tables are one of the most common ways data is organized on documents. Human beings have been writing information into tables before they started writing literature, even before paper was invented. There are examples of tables carved onto the walls of Egyptian temples! They are excellent structures for representing a lot of information with various characteristics in common in a relatively small space (or an Egyptian temple sized space). However, targeting the data inside them presents its own set of challenges. A table’s structure can range from simple and straightforward to more complex (even confounding). Different organizations may organize the same data differently, creating different tables for what, essentially, is the same data.		Tables are one of the most common ways data is organized on documents. Human beings have been writing information into tables before they started writing literature, even before paper was invented. There are examples of tables carved onto the walls of Egyptian temples! They are excellent structures for representing a lot of information with various characteristics in common in a relatively small space (or an Egyptian temple sized space). However, targeting the data inside them presents its own set of challenges. A table’s structure can range from simple and straightforward to more complex (even confounding). Different organizations may organize the same data differently, creating different tables for what, essentially, is the same data.

	In Grooper, tabular data can be extracted to '''Data Table''' objects using one of many table extraction methods.		In Grooper, tabular data can be extracted to '''Data Table''' objects using one of many table extraction methods.
			<br clear=all>
	== What Is a Table? ==		== What Is a Table? ==

	Tables consists of rows and columns. Where those rows and columns intersect are cells. These are the individual units of the table containing individual pieces of data. Each row consists of the same number of columns (although some columns may be empty in a given row). A single column consists of the same type of information. For example, an "Order Date" column will always have dates in the cells below it. The rows themselves are usually (but not always) in some order as well, such as in order of ascending date.		Tables consists of rows and columns. Where those rows and columns intersect are cells. These are the individual units of the table containing individual pieces of data. Each row consists of the same number of columns (although some columns may be empty in a given row). A single column consists of the same type of information. For example, an "Order Date" column will always have dates in the cells below it. The rows themselves are usually (but not always) in some order as well, such as in order of ascending date.

Randallkinard: Randallkinard moved page 2023:Table Extraction to 2023:Table Extraction (Concept) without leaving a redirect: new naming convention

2024-04-18T16:39:57Z

Randallkinard moved page 2023:Table Extraction to 2023:Table Extraction (Concept) without leaving a redirect: new naming convention

← Older revision	Revision as of 11:39, 18 April 2024
(No difference)

Dgreenwood at 14:50, 9 January 2024

2024-01-09T14:50:07Z

← Older revision		Revision as of 09:50, 9 January 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}
	[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]		[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]
	<~~blockquote style~~="~~font-size:14pt~~">		<section begin="glossary" />
			<blockquote>
	Table Extraction refers to Grooper's functionality to extract data from cells in tables. This is accomplished by configuring the '''[[Data Table]]''' '''''[[Data Element]]''''' in a '''[[Data Model]]'''.		Table Extraction refers to Grooper's functionality to extract data from cells in tables. This is accomplished by configuring the '''[[Data Table]]''' '''''[[Data Element]]''''' in a '''[[Data Model]]'''.
	</blockquote>		</blockquote>
			<section end="glossary" />
	Tables are one of the most common ways data is organized on documents. Human beings have been writing information into tables before they started writing literature, even before paper was invented. There are examples of tables carved onto the walls of Egyptian temples! They are excellent structures for representing a lot of information with various characteristics in common in a relatively small space (or an Egyptian temple sized space). However, targeting the data inside them presents its own set of challenges. A table’s structure can range from simple and straightforward to more complex (even confounding). Different organizations may organize the same data differently, creating different tables for what, essentially, is the same data.		Tables are one of the most common ways data is organized on documents. Human beings have been writing information into tables before they started writing literature, even before paper was invented. There are examples of tables carved onto the walls of Egyptian temples! They are excellent structures for representing a lot of information with various characteristics in common in a relatively small space (or an Egyptian temple sized space). However, targeting the data inside them presents its own set of challenges. A table’s structure can range from simple and straightforward to more complex (even confounding). Different organizations may organize the same data differently, creating different tables for what, essentially, is the same data.

Dgreenwood at 17:04, 3 January 2024

2024-01-03T17:04:54Z

← Older revision		Revision as of 12:04, 3 January 2024
Line 1:		Line 1:
			{{AutoVersion}}
	[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]		[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]
	<blockquote style="font-size:14pt">		<blockquote style="font-size:14pt">

Dgreenwood: /* Table Extract Methods Overview */

2024-01-03T16:31:47Z

Table Extract Methods Overview

← Older revision		Revision as of 11:31, 3 January 2024
Line 102:		Line 102:
	There are seven different methods to extract data from tables. They are set on the '''''Extract Method''''' property of the '''Data Table''' object. Each method identifies a table's structure and extracts each cell differently and has their own benefits and limitations. The seven methods are as follows:		There are seven different methods to extract data from tables. They are set on the '''''Extract Method''''' property of the '''Data Table''' object. Each method identifies a table's structure and extracts each cell differently and has their own benefits and limitations. The seven methods are as follows:

	# '''''[[~~Delimited Extract]]'''''~~		# '''''[[Row Match]]'''''
	~~# '''''Fixed Width'''''~~
	~~# '''''[[Fluid Layout~~]]'''''
	# '''''[[Grid Layout]]'''''		# '''''[[Grid Layout]]'''''
			# '''''[[Tabular Layout]]'''''
	# '''''[[Header-Value]]'''''		# '''''[[Header-Value]]'''''
	#* Please note: This method is only in newer versions of Grooper for backwards compatibility. You should use '''''Tabular Layout''''' instead for simpler setup and increased functionality. This method will be removed from Grooper in version 2023.1.		#* Please note: This method is only in newer versions of Grooper for backwards compatibility. You should use '''''Tabular Layout''''' instead for simpler setup and increased functionality. This method will be removed from Grooper in version 2023.1.
	# '''''[[~~Row Match~~]]'''''		# '''''[[Fluid Layout]]'''''
	# '''''[[~~Tabular Layout~~]]'''''		#* Please note: This is a highly specialized method that requires [[Label Sets]] to function.
			# '''''[[Delimited Extract]]'''''
			#* Please note: This method is only designed to work on character delimited text files, such as CSV files.
			# '''''Fixed Width'''''
			#* Please note: This method is only designed to work on fixed-width text files.

Dgreenwood: /* Table Extract Methods Overview */

2024-01-03T16:28:24Z

Table Extract Methods Overview

← Older revision		Revision as of 11:28, 3 January 2024
Line 102:		Line 102:
	There are seven different methods to extract data from tables. They are set on the '''''Extract Method''''' property of the '''Data Table''' object. Each method identifies a table's structure and extracts each cell differently and has their own benefits and limitations. The seven methods are as follows:		There are seven different methods to extract data from tables. They are set on the '''''Extract Method''''' property of the '''Data Table''' object. Each method identifies a table's structure and extracts each cell differently and has their own benefits and limitations. The seven methods are as follows:

	# ''[[Delimited Extract]]		# '''''[[Delimited Extract]]'''''
	# ''Fixed Width''		# '''''Fixed Width'''''
	# ''[[Fluid Layout]]''		# '''''[[Fluid Layout]]'''''
	# ''[[Grid Layout]]''		# '''''[[Grid Layout]]'''''
	# ''[[Header-Value]]''		# '''''[[Header-Value]]'''''
	# ''[[~~Row Match (Table Extract Method)\|~~Row Match]]''		#* Please note: This method is only in newer versions of Grooper for backwards compatibility. You should use '''''Tabular Layout''''' instead for simpler setup and increased functionality. This method will be removed from Grooper in version 2023.1.
	# ''[[Tabular Layout]]''		# '''''[[Row Match]]'''''
			# '''''[[Tabular Layout]]'''''
	~~[[Category:Articles]]~~
	~~[[Category:Version 2023]]~~

Dgreenwood at 16:25, 3 January 2024

2024-01-03T16:25:53Z

← Older revision		Revision as of 11:25, 3 January 2024
Line 1:		Line 1:
	[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]		[[File:Table-extraction-simple-table.png\|thumb\|300px\|Data in an Excel spreadsheet is an example of tabular data.]]
	~~<onlyinclude>~~
	<blockquote style="font-size:14pt">		<blockquote style="font-size:14pt">
	Table Extraction refers to Grooper's functionality to extract data from cells in tables. This is accomplished by configuring the '''[[Data Table]]''' '''''[[Data Element]]''''' in a '''[[Data Model]]'''.		Table Extraction refers to Grooper's functionality to extract data from cells in tables. This is accomplished by configuring the '''[[Data Table]]''' '''''[[Data Element]]''''' in a '''[[Data Model]]'''.
	</blockquote>		</blockquote>

	~~{\| class="wikitable" style="margin:left"~~
	~~! Previous Versions~~
	\|-
	\|
	~~[[Table Extraction - 2.80]]~~
	~~<br>~~
	\|}

	Tables are one of the most common ways data is organized on documents. Human beings have been writing information into tables before they started writing literature, even before paper was invented. There are examples of tables carved onto the walls of Egyptian temples! They are excellent structures for representing a lot of information with various characteristics in common in a relatively small space (or an Egyptian temple sized space). However, targeting the data inside them presents its own set of challenges. A table’s structure can range from simple and straightforward to more complex (even confounding). Different organizations may organize the same data differently, creating different tables for what, essentially, is the same data.		Tables are one of the most common ways data is organized on documents. Human beings have been writing information into tables before they started writing literature, even before paper was invented. There are examples of tables carved onto the walls of Egyptian temples! They are excellent structures for representing a lot of information with various characteristics in common in a relatively small space (or an Egyptian temple sized space). However, targeting the data inside them presents its own set of challenges. A table’s structure can range from simple and straightforward to more complex (even confounding). Different organizations may organize the same data differently, creating different tables for what, essentially, is the same data.

	In Grooper, tabular data can be extracted to '''Data Table''' objects using one of many table extraction methods.		In Grooper, tabular data can be extracted to '''Data Table''' objects using one of many table extraction methods.
	~~</onlyinclude>~~

	== What Is a Table? ==		== What Is a Table? ==

← Older revision		Revision as of 10:43, 22 November 2024
Line 113:		Line 113:
	# '''''Fixed Width'''''		# '''''Fixed Width'''''
	#* Please note: This method is only designed to work on fixed-width text files.		#* Please note: This method is only designed to work on fixed-width text files.

	~~== Glossary ==~~
	~~<u><big>'''Content Model'''</big></u>: {{#lst:Glossary\|Content Model}}~~

	~~<u><big>'''Data Column'''</big></u>: {{#lst:Glossary\|Data Column}}~~

	~~<u><big>'''Data Element'''</big></u>: {{#lst:Glossary\|Data Element}}~~

	~~<u><big>'''Data Model'''</big></u>: {{#lst:Glossary\|Data Model}}~~

	~~<u><big>'''Data Table'''</big></u>: {{#lst:Glossary\|Data Table}}~~

	~~<u><big>'''Delimited Extract'''</big></u>: {{#lst:Glossary\|Delimited Extract}}~~

	~~<u><big>'''Export'''</big></u>: {{#lst:Glossary\|Export}}~~

	~~<u><big>'''Extract'''</big></u>: {{#lst:Glossary\|Extract}}~~

	~~<u><big>'''Fluid Layout'''</big></u>: {{#lst:Glossary\|Fluid Layout}}~~

	~~<u><big>'''Grid Layout'''</big></u>: {{#lst:Glossary\|Grid Layout}}~~

	~~<u><big>'''Node Tree'''</big></u>: {{#lst:Glossary\|Node Tree}}~~

	~~<u><big>'''Row Match'''</big></u>: {{#lst:Glossary\|Row Match}}~~

	~~<u><big>'''Table Extraction'''</big></u>: {{#lst:Glossary\|Table Extraction}}~~

	~~<u><big>'''Tabular Layout'''</big></u>: {{#lst:Glossary\|Tabular Layout}}~~