2023:Data Export (Export Definition) - Revision history

Dgreenwood: /* Glossary */

2025-03-03T18:01:43Z

Glossary

← Older revision		Revision as of 13:01, 3 March 2025
Line 745:		Line 745:

	[[File:2023_Data-Export_02_HowTo_04_Applying-the-Export-Activity-and-Reviewing-the-Results_04.png]]		[[File:2023_Data-Export_02_HowTo_04_Applying-the-Export-Activity-and-Reviewing-the-Results_04.png]]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Randallkinard at 16:06, 26 August 2024

2024-08-26T16:06:43Z

@@ Line 2: / Line 2: @@
 <blockquote>{{#lst:Glossary|Data Export}}</blockquote>
 ==About==
@@ Line 802: / Line 745: @@
 [[File:2023_Data-Export_02_HowTo_04_Applying-the-Export-Activity-and-Reviewing-the-Results_04.png]]

Randallkinard at 20:05, 3 May 2024

2024-05-03T20:05:21Z

← Older revision		Revision as of 15:05, 3 May 2024
Line 2:		Line 2:

	<blockquote>{{#lst:Glossary\|Data Export}}</blockquote>		<blockquote>{{#lst:Glossary\|Data Export}}</blockquote>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	==About==		==About==

Randallkinard at 16:22, 24 April 2024

2024-04-24T16:22:48Z

← Older revision		Revision as of 11:22, 24 April 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}
	~~<section begin="glossary" />~~
	<blockquote>		<blockquote>{{#lst:Glossary\|Data Export}}</blockquote>
	~~'''''~~Data Export''''' is one of the '''''Export Types''''' available when configuring an '''''Export Behavior'''''. It exports extracted document data over a '''Data Connection''', allowing users to export data to a SQL or ODBC compliant database.
	</blockquote>
	~~<section end="glossary" />~~
	==About==		==About==

	{\|class="download-box"		{\|class="download-box"
	\|		\|
Line 17:		Line 14:
	* [[Media:2023_Wiki_Data-Export_Batch.zip]]		* [[Media:2023_Wiki_Data-Export_Batch.zip]]
	\|}		\|}


	The most important goal of '''Grooper''' is to deliver accurate data to line of business systems that allow the information to be integrated into impactful business decisioning. [https://en.wikipedia.org/wiki/Table_(information) Tables] in [https://en.wikipedia.org/wiki/Database databases] remain, to this day, one of the main vessels by which this information is stored. '''''Data Export''''' is one of the main ways to deliver data collected in Grooper.		The most important goal of '''Grooper''' is to deliver accurate data to line of business systems that allow the information to be integrated into impactful business decisioning. [https://en.wikipedia.org/wiki/Table_(information) Tables] in [https://en.wikipedia.org/wiki/Database databases] remain, to this day, one of the main vessels by which this information is stored. '''''Data Export''''' is one of the main ways to deliver data collected in Grooper.

Randallkinard: Randallkinard moved page 2023:Data Export (Export Type) to 2023:Data Export (Export Definition) without leaving a redirect

2024-04-24T14:42:37Z

Randallkinard moved page 2023:Data Export (Export Type) to 2023:Data Export (Export Definition) without leaving a redirect

← Older revision	Revision as of 09:42, 24 April 2024
(No difference)

Randallkinard: Randallkinard moved page 2023:Data Export to 2023:Data Export (Export Type) without leaving a redirect: new naming convention

2024-04-16T19:07:57Z

Randallkinard moved page 2023:Data Export to 2023:Data Export (Export Type) without leaving a redirect: new naming convention

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

Randallkinard: changed naming convention of ZIP files, removed tables and tabs // via Wikitext Extension for VSCode

2024-03-07T21:09:26Z

changed naming convention of ZIP files, removed tables and tabs // via Wikitext Extension for VSCode

Show changes

Dgreenwood at 15:38, 12 January 2024

2024-01-12T15:38:40Z

← Older revision		Revision as of 10:38, 12 January 2024
Line 73:		Line 73:
	We discuss how to create '''Data Connections''', add a new database from a '''Data Connection''', and add a new database table from a '''Data Connection''' in the [[#Configuring a Data Connection]] tutorial below.		We discuss how to create '''Data Connections''', add a new database from a '''Data Connection''', and add a new database table from a '''Data Connection''' in the [[#Configuring a Data Connection]] tutorial below.

	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="fyi-box"
	\|~~-style="background-color:#36b0a7; color:white"~~		\|
	~~\|style="font-size:14pt"\|~~'''FYI'''\|\|We have improved integration with PostgreSQL, Db2, MySQL, and Oracle using the ODBC connection type in version 2021!		'''FYI'''
			\|
			We have improved integration with PostgreSQL, Db2, MySQL, and Oracle using the ODBC connection type in version 2021!

	While not fully supported in previous versions of Grooper, you can now connect to these data sources with a '''Data Connection''' seamlessly in Grooper, allowing for full database export operations via '''''Data Export'''''.		While not fully supported in previous versions of Grooper, you can now connect to these data sources with a '''Data Connection''' seamlessly in Grooper, allowing for full database export operations via '''''Data Export'''''.
Line 232:		Line 234:

	\|valign=top\|		\|valign=top\|
	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="fyi-box"
	\|~~-style="background-color:#36b0a7; color:white"~~		\|
	~~\|style="font-size:14pt"\|~~'''FYI'''\|\|Were the document classified (the '''Batch Folder''' assigned a '''Document Type'''), but not successfully extracted (the '''Extract''' activity not applied), the data structure would be present, but the fields empty.		'''FYI'''
			\|
			Were the document classified (the '''Batch Folder''' assigned a '''Document Type'''), but not successfully extracted (the '''Extract''' activity not applied), the data structure would be present, but the fields empty.

	At that point the '''Batch Folder''' would have the '''Document Type's''' '''Data Model''' associated to it, but would not have applied its extraction logic to collect values (That's what the '''Extract''' activity is for).		At that point the '''Batch Folder''' would have the '''Document Type's''' '''Data Model''' associated to it, but would not have applied its extraction logic to collect values (That's what the '''Extract''' activity is for).
Line 373:		Line 377:
	\|-		\|-
	\|valign=top\|		\|valign=top\|
	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="fyi-box"
	\|~~-style="background-color:#36b0a7; color:white"~~		\|
	~~\|style="font-size:14pt"\|~~'''FYI'''\|\|If you connect to the server in Microsoft SQL Management Studio, you can verify the database is created.		'''FYI'''
			\|
			If you connect to the server in Microsoft SQL Management Studio, you can verify the database is created.

	See here, the "Export_Example_DB" is added to the list of databases. Through the '''Data Connection''' Grooper has a direct connection to this SQL environment to add and alter databases.		See here, the "Export_Example_DB" is added to the list of databases. Through the '''Data Connection''' Grooper has a direct connection to this SQL environment to add and alter databases.
Line 489:		Line 495:
	When the '''Export''' activity processes each '''Batch Folder''' it will execute the '''''Export Behaviors''''', according to their configuration settings.		When the '''Export''' activity processes each '''Batch Folder''' it will execute the '''''Export Behaviors''''', according to their configuration settings.

	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="fyi-box"
	\|~~-style="background-color:#36b0a7; color:white"~~		\|
	~~\|style="font-size:14pt"\|~~'''FYI'''\|\|In general, users will choose to configure '''''Export Behaviors''''' either on the '''Content Type''' object it applies to ''or'' local to the '''Export''' activity step in a '''Batch Process'''.		'''FYI'''
			\|
			In general, users will choose to configure '''''Export Behaviors''''' either on the '''Content Type''' object it applies to ''or'' local to the '''Export''' activity step in a '''Batch Process'''.

	This may just boil down to personal preference. There is no functional difference between an '''''Export Behavior''''' configured on a '''Content Type''' or an '''''Export Behavior''''' configured on an '''Export Step''', upon completing their configuration. In either case, they will accomplish the same goal.		This may just boil down to personal preference. There is no functional difference between an '''''Export Behavior''''' configured on a '''Content Type''' or an '''''Export Behavior''''' configured on an '''Export Step''', upon completing their configuration. In either case, they will accomplish the same goal.
Line 761:		Line 769:


	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="fyi-box"
	\|~~-style="background-color:#36b0a7; color:white"~~		\|
	~~\|style="font-size:14pt"\|~~'''FYI'''\|\|Here, we added two sets of table mappings to two database tables in the same database. What if you wanted to add two sets of mappings to database tables in ''different'' databases?		'''FYI'''
			\|
			Here, we added two sets of table mappings to two database tables in the same database. What if you wanted to add two sets of mappings to database tables in ''different'' databases?

	That's easily doable. You would need two '''Data Connections''', one to connect Grooper to each individual database. Then, you would need to add two '''''Data Export''''' definitions, each one using one of the two '''Data Connections'''. From there, you'd add the individual table mappings to each individual '''''Data Export'''''.		That's easily doable. You would need two '''Data Connections''', one to connect Grooper to each individual database. Then, you would need to add two '''''Data Export''''' definitions, each one using one of the two '''Data Connections'''. From there, you'd add the individual table mappings to each individual '''''Data Export'''''.

Dgreenwood at 14:37, 12 January 2024

2024-01-12T14:37:55Z

← Older revision		Revision as of 09:37, 12 January 2024
Line 7:		Line 7:
	==About==		==About==

	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="download-box"
	\|-		\|
	~~\|style="font-size:14pt; color:#f89420; border: 2px solid #f89420; width:40px"\|~~[[File:Asset 22@4x.png]]		[[File:Asset 22@4x.png]]
	~~\|style="border: 2px solid #f89420"~~\|		\|
	You may download and import the file(s) below into your own Grooper environment (version 2023). There is a '''Batch''' with the example document(s) discussed in this tutorial, as well as a '''Project''' configured according to its instructions.		You may download and import the file(s) below into your own Grooper environment (version 2023). There is a '''Batch''' with the example document(s) discussed in this tutorial, as well as a '''Project''' configured according to its instructions.
	<br>		<br>
Line 129:		Line 129:
	This document is meant to demonstrate how to export to multiple tables via one '''''Export Behavior'''''.		This document is meant to demonstrate how to export to multiple tables via one '''''Export Behavior'''''.

	{\|~~cellpadding~~="~~10" cellspacing="5~~"		{\|class="attn-box"
	\|~~-style="background-color:#f89420; color:white"~~		\|
	~~\|style="font-size:22pt"\|'''~~⚠~~'''\|~~\|DISCLAIMER: The author of this article is not a lawyer.		⚠
			\|
			DISCLAIMER: The author of this article is not a lawyer.

	For educational purposes we divided "Personnel Information" into two sets: "non-PII" and "PII"		For educational purposes we divided "Personnel Information" into two sets: "non-PII" and "PII"
	~~:• ~~ non-PII: Employee ID, Phone Number, E-mail address, IP Address, Gender, ZIP		* non-PII: Employee ID, Phone Number, E-mail address, IP Address, Gender, ZIP
	~~:• ~~ PII: First Name, Last Name, SSN, Street Number, Street Name, City, State.		* PII: First Name, Last Name, SSN, Street Number, Street Name, City, State.

	'''''DO NOT TAKE THIS TO MEAN THIS INFORMATION IS OR IS NOT PERSONALLY IDENTIFIABLE INFORMATION.'''''		'''''DO NOT TAKE THIS TO MEAN THIS INFORMATION IS OR IS NOT PERSONALLY IDENTIFIABLE INFORMATION.'''''

Dgreenwood at 18:19, 9 January 2024

2024-01-09T18:19:01Z

← Older revision		Revision as of 13:19, 9 January 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}
	<section begin="~~data_export_glossary~~" />		<section begin="glossary" />
	<blockquote>		<blockquote>
	'''''Data Export''''' is one of the '''''Export Types''''' available when configuring an '''''Export Behavior'''''. It exports extracted document data over a '''Data Connection''', allowing users to export data to a SQL or ODBC compliant database.		'''''Data Export''''' is one of the '''''Export Types''''' available when configuring an '''''Export Behavior'''''. It exports extracted document data over a '''Data Connection''', allowing users to export data to a SQL or ODBC compliant database.
	</blockquote>		</blockquote>
	<section end="~~data_export_glossary~~" />		<section end="glossary" />
	==About==		==About==

← Older revision		Revision as of 13:01, 3 March 2025
Line 745:		Line 745:

	[[File:2023_Data-Export_02_HowTo_04_Applying-the-Export-Activity-and-Reviewing-the-Results_04.png]]		[[File:2023_Data-Export_02_HowTo_04_Applying-the-Export-Activity-and-Reviewing-the-Results_04.png]]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

← Older revision		Revision as of 15:05, 3 May 2024
Line 2:		Line 2:

	<blockquote>{{#lst:Glossary\|Data Export}}</blockquote>		<blockquote>{{#lst:Glossary\|Data Export}}</blockquote>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	==About==		==About==