2023:Delimited Extract (Table Extract Method) - Revision history

Randallkinard at 19:20, 21 November 2024

2024-11-21T19:20:17Z

← Older revision		Revision as of 14:20, 21 November 2024
Line 407:		Line 407:
	(Alternatively, we could have created a single parent '''Data Model''' and taken advantage of a '''Document Type's''' '''''Data Element Override''''' properties. Both approaches accomplish the same task. The point is we would need to classify the different types of files as different '''Document Types''' and used different configurations of '''''Delimited Extract''''', one applicable to CSV files and one to pipe-delimited TXT files.)		(Alternatively, we could have created a single parent '''Data Model''' and taken advantage of a '''Document Type's''' '''''Data Element Override''''' properties. Both approaches accomplish the same task. The point is we would need to classify the different types of files as different '''Document Types''' and used different configurations of '''''Delimited Extract''''', one applicable to CSV files and one to pipe-delimited TXT files.)
	\|}		\|}

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

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

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

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

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

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

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

	~~<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>'''Document Type'''</big></u>: {{#lst:Glossary\|Document Type}}~~

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

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

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

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

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

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

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

	~~<u><big>'''Microsoft Office Integration'''</big></u>: {{#lst:Glossary\|Microsoft Office Integration}}~~

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

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

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

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

Randallkinard at 16:01, 26 August 2024

2024-08-26T16:01:38Z

@@ Line 4: / Line 4: @@
 This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.
 == About ==
 {|class="download-box"
+|
@@ Line 459: / Line 407: @@
 (Alternatively, we could have created a single parent '''Data Model''' and taken advantage of a '''Document Type's''' '''''Data Element Override''''' properties.  Both approaches accomplish the same task.  The point is we would need to classify the different types of files as different '''Document Types''' and used different configurations of '''''Delimited Extract''''', one applicable to CSV files and one to pipe-delimited TXT files.)
 |}

Randallkinard at 18:12, 8 May 2024

2024-05-08T18:12:54Z

← Older revision		Revision as of 13:12, 8 May 2024
Line 4:		Line 4:

	This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.		This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.

			== Glossary ==
			<u><big>'''Batch Folder'''</big></u>: {{#lst:Glossary\|Batch Folder}}

			<u><big>'''Batch Process'''</big></u>: {{#lst:Glossary\|Batch Process}}

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

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

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

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

			<u><big>'''Content Type'''</big></u>: {{#lst:Glossary\|Content Type}}

			<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>'''Document Type'''</big></u>: {{#lst:Glossary\|Document Type}}

			<u><big>'''Document Viewer'''</big></u>: {{#lst:Glossary\|Document Viewer}}

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

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

			<u><big>'''File Store'''</big></u>: {{#lst:Glossary\|File Store}}

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

			<u><big>'''Grooper Repository'''</big></u>: {{#lst:Glossary\|Grooper Repository}}

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

			<u><big>'''Microsoft Office Integration'''</big></u>: {{#lst:Glossary\|Microsoft Office Integration}}

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

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

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

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

	== About ==		== About ==

Randallkinard at 18:24, 29 April 2024

2024-04-29T18:24:08Z

← Older revision		Revision as of 13:24, 29 April 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}
	~~<section begin="glossary" />~~
	<blockquote>		<blockquote>{{#lst:Glossary\|Delimited Extract}}</blockquote>
	~~'''''~~Delimited Extract~~''''' is a '''Data Table''' extraction method. This method extracts tabular data from a delimiter-separated text file, such as a CSV file.~~
	</blockquote>
	~~<section end="glossary" />~~
	This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.		This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.

Randallkinard: Randallkinard moved page 2023:Delimited Extract to 2023:Delimited Extract (Table Extract Method) without leaving a redirect: new naming convention

2024-04-16T21:31:06Z

Randallkinard moved page 2023:Delimited Extract to 2023:Delimited Extract (Table Extract Method) without leaving a redirect: new naming convention

← Older revision	Revision as of 16:31, 16 April 2024
(No difference)

Randallkinard: removed centering from images // via Wikitext Extension for VSCode

2024-03-08T18:39:05Z

removed centering from images // via Wikitext Extension for VSCode

← Older revision		Revision as of 13:39, 8 March 2024
Line 282:		Line 282:
	{\|cellpadding=10 cellspacing=5		{\|cellpadding=10 cellspacing=5
	\|valign=top style="width:30%"\|		\|valign=top style="width:30%"\|
	[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_08.png~~\|center~~]]		[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_08.png]]
	\|valign=top style="width:30%"\|		\|valign=top style="width:30%"\|
	[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_09.~~png\|center~~]]		[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_09.pngr]]
	\|}		\|}

Line 300:		Line 300:
	\|}		\|}

	[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_10.png~~\|center~~]]		[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_10.png]]


Line 311:		Line 311:
	In this case, the last '''''Mapping Method''''' option, ''Mapped'' may be more suitable.		In this case, the last '''''Mapping Method''''' option, ''Mapped'' may be more suitable.

	[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_11.png~~\|center~~]]		[[File:2023_Delimited-Extract_02_How-To_02_Delimited-Extract-Configuration_11.png]]

Randallkinard: adjusted header issues // via Wikitext Extension for VSCode

2024-03-07T22:12:34Z

adjusted header issues // via Wikitext Extension for VSCode

← Older revision		Revision as of 17:12, 7 March 2024
Line 209:		Line 209:
	# ''Mapped''		# ''Mapped''

	=== ~~<span style~~=~~"color:#662d91">~~Named~~</span>~~ ===		===== Named =====

	The ''Named'' option will use column headers in the delimiter-separated file to map columns to the '''Data Columns''' in our '''Data Table'''. As long as the names match, '''Grooper''' will populate the '''Data Column''' with the data in the correspondingly named column in the CSV or TXT file.		The ''Named'' option will use column headers in the delimiter-separated file to map columns to the '''Data Columns''' in our '''Data Table'''. As long as the names match, '''Grooper''' will populate the '''Data Column''' with the data in the correspondingly named column in the CSV or TXT file.
Line 272:		Line 272:
	\|}		\|}

	=== ~~<span style~~=~~"color:#662d91">~~Positional~~</span>~~ ===		===== Positional =====

	The document from the previous example is actually a good candidate for the ''Positional'' '''''Mapping Method'''''. This method does not rely on how columns are ''named'' but instead how they are ''ordered''. It presumes the first column in the delimiter-separated file is the '''Data Table's''' first child '''Data Column'''.		The document from the previous example is actually a good candidate for the ''Positional'' '''''Mapping Method'''''. This method does not rely on how columns are ''named'' but instead how they are ''ordered''. It presumes the first column in the delimiter-separated file is the '''Data Table's''' first child '''Data Column'''.
Line 314:		Line 314:


	=== ~~<span style~~=~~"color:#662d91">~~Mapped~~</span>~~ ===		===== Mapped =====

	The ''Mapped'' '''''Mapping Method''''' gives you the most control, dictating what '''Data Column''' matches which column in the delimited file. You can use a '''Lexicon''' or a '''''Local Entries''''' text editor and specific syntax to dictate this.		The ''Mapped'' '''''Mapping Method''''' gives you the most control, dictating what '''Data Column''' matches which column in the delimited file. You can use a '''Lexicon''' or a '''''Local Entries''''' text editor and specific syntax to dictate this.

Randallkinard: removed tables and tabs // via Wikitext Extension for VSCode

2024-03-07T22:04:38Z

removed tables and tabs // via Wikitext Extension for VSCode

Show changes

Randallkinard: changed naming convention of ZIP files // via Wikitext Extension for VSCode

2024-03-07T18:45:51Z

changed naming convention of ZIP files // via Wikitext Extension for VSCode

← Older revision		Revision as of 13:45, 7 March 2024
Line 16:		Line 16:
	<br>		<br>
	Please upload the '''Project''' to your '''Grooper''' environment before uploading the '''Batch'''. This will allow the documents within the '''Batch''' to maintain their classification status.		Please upload the '''Project''' to your '''Grooper''' environment before uploading the '''Batch'''. This will allow the documents within the '''Batch''' to maintain their classification status.
	* [[Media:2023_Wiki_Delimited-~~Exract_Batch~~.zip]]		* [[Media:2023_Wiki_Delimited-Extract_Batch.zip]]
	* [[Media:2023_Wiki_Delimited-Extract_Project.zip]]		* [[Media:2023_Wiki_Delimited-Extract_Project.zip]]
	\|}		\|}

Randallkinard: changed naming convention of ZIP file // via Wikitext Extension for VSCode

2024-03-07T18:31:18Z

changed naming convention of ZIP file // via Wikitext Extension for VSCode

← Older revision		Revision as of 13:31, 7 March 2024
Line 16:		Line 16:
	<br>		<br>
	Please upload the '''Project''' to your '''Grooper''' environment before uploading the '''Batch'''. This will allow the documents within the '''Batch''' to maintain their classification status.		Please upload the '''Project''' to your '''Grooper''' environment before uploading the '''Batch'''. This will allow the documents within the '''Batch''' to maintain their classification status.
	* [[Media:~~Delimited_Extract_~~-~~_Project_(v2023)~~.zip]]		* [[Media:2023_Wiki_Delimited-Exract_Batch.zip]]
	* [[Media:~~Delimited_Extract_~~-~~_Batch_(v2023)~~.zip]]		* [[Media:2023_Wiki_Delimited-Extract_Project.zip]]
	\|}		\|}

← Older revision		Revision as of 14:20, 21 November 2024
Line 407:		Line 407:
	(Alternatively, we could have created a single parent '''Data Model''' and taken advantage of a '''Document Type's''' '''''Data Element Override''''' properties. Both approaches accomplish the same task. The point is we would need to classify the different types of files as different '''Document Types''' and used different configurations of '''''Delimited Extract''''', one applicable to CSV files and one to pipe-delimited TXT files.)		(Alternatively, we could have created a single parent '''Data Model''' and taken advantage of a '''Document Type's''' '''''Data Element Override''''' properties. Both approaches accomplish the same task. The point is we would need to classify the different types of files as different '''Document Types''' and used different configurations of '''''Delimited Extract''''', one applicable to CSV files and one to pipe-delimited TXT files.)
	\|}		\|}

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

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

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

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

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

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

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

	~~<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>'''Document Type'''</big></u>: {{#lst:Glossary\|Document Type}}~~

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

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

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

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

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

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

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

	~~<u><big>'''Microsoft Office Integration'''</big></u>: {{#lst:Glossary\|Microsoft Office Integration}}~~

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

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

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

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

← Older revision		Revision as of 13:12, 8 May 2024
Line 4:		Line 4:

	This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.		This is the fastest, simplest and most effective method of extracting data from character delimited files, such as comma delimited CSV files or TXT files delimited by commas or other characters.

			== Glossary ==
			<u><big>'''Batch Folder'''</big></u>: {{#lst:Glossary\|Batch Folder}}

			<u><big>'''Batch Process'''</big></u>: {{#lst:Glossary\|Batch Process}}

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

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

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

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

			<u><big>'''Content Type'''</big></u>: {{#lst:Glossary\|Content Type}}

			<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>'''Document Type'''</big></u>: {{#lst:Glossary\|Document Type}}

			<u><big>'''Document Viewer'''</big></u>: {{#lst:Glossary\|Document Viewer}}

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

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

			<u><big>'''File Store'''</big></u>: {{#lst:Glossary\|File Store}}

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

			<u><big>'''Grooper Repository'''</big></u>: {{#lst:Glossary\|Grooper Repository}}

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

			<u><big>'''Microsoft Office Integration'''</big></u>: {{#lst:Glossary\|Microsoft Office Integration}}

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

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

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

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

	== About ==		== About ==