2023:Microsoft Office Integration - Revision history

Dgreenwood: Dgreenwood moved page 2023:Microsoft Office Integration (Concept) to 2023:Microsoft Office Integration

2026-04-03T15:51:13Z

Dgreenwood moved page 2023:Microsoft Office Integration (Concept) to 2023:Microsoft Office Integration

← Older revision	Revision as of 10:51, 3 April 2026
(No difference)

Dgreenwood at 21:36, 21 May 2025

2025-05-21T21:36:10Z

← Older revision		Revision as of 16:36, 21 May 2025
Line 32:		Line 32:
	* This only applies to Microsoft Word. Grooper will still execute the "Excel to CSV" command, even if Excel is not installed on the machine.		* This only applies to Microsoft Word. Grooper will still execute the "Excel to CSV" command, even if Excel is not installed on the machine.
	* If you are executing this command from the Grooper web app, Word must be installed on the Grooper web server.		* If you are executing this command from the Grooper web app, Word must be installed on the Grooper web server.
			**<li class="attn-bullet"> If you right-click a Batch Folder with a Word doc attachment and do not see the "Word to PDF" command, Microsoft Word is not appropriately installed on the Grooper web server.
	* If an Activity Processing service is executing this command, Word must be installed on the processing server.		* If an Activity Processing service is executing this command, Word must be installed on the processing server.
	* If you see a "COMException" error, the most likely reason is Microsoft Word is not installed on the machine processing the command.		**<li class="attn-bullet"> If you execute the "Word to PDF" command and see a "COMException" error, the ''most likely'' reason is Microsoft Word is not installed on the machine processing the command.
	* The bit version of Grooper and Microsoft Data Access Components (MDAC) ''must'' match. If you are running the 64-bit version of Grooper, you must use the 64-bit MDAC components.		* The bit version of Grooper and Microsoft Data Access Components (MDAC) ''must'' match. If you are running the 64-bit version of Grooper, you must use the 64-bit MDAC components.
	\|}		\|}

Dgreenwood: /* How to Use */

2025-05-21T21:31:19Z

How to Use

← Older revision		Revision as of 16:31, 21 May 2025
Line 29:		Line 29:
	⚠		⚠
	\|		\|
	To make use of ~~this feature~~, '''ensure that Microsoft ~~Office~~ is installed on the machine ~~running'''~~ '''Grooper ~~Design Studio'''~~.		To make use of the "Word to PDF" command, '''ensure that Microsoft Word is installed on the machine processing the Word to PDF command.'''
			* This only applies to Microsoft Word. Grooper will still execute the "Excel to CSV" command, even if Excel is not installed on the machine.
	~~Furthermore~~, the bit version of Grooper and Microsoft Data Access Components (MDAC) ''must'' match.		* If you are executing this command from the Grooper web app, Word must be installed on the Grooper web server.
	* If you are running the 64-bit version of Grooper, you must use the 64~~-bit MDAC components.~~		* If an Activity Processing service is executing this command, Word must be installed on the processing server.
	* If you are using the 32-bit version of Grooper you must use the 32-bit MDAC components.		* If you see a "COMException" error, the most likely reason is Microsoft Word is not installed on the machine processing the command.
			* The bit version of Grooper and Microsoft Data Access Components (MDAC) ''must'' match. If you are running the 64-bit version of Grooper, you must use the 64-bit MDAC components.
	\|}		\|}

Line 40:		Line 41:
	'''FYI'''		'''FYI'''
	\|		\|
	~~{\|class="inner-box" cellpadding=10 cellspacing=5~~		<big>Thick client advice only</big>
	~~\|valign=top style="width~~:~~50%"~~\|		[[File:MS Office Integration - Path Error.png\|right]]
	If you have completed these prerequisites and ''both'' Office and the appropriate MDAC component's installed, you may see this error message if you select a '''Batch Folder''' in a '''Batch''' with an attached Excel file.		If you have completed these prerequisites and ''both'' Office and the appropriate MDAC component's installed, you may see this error message if you select a '''Batch Folder''' in a '''Batch''' with an attached Excel file.

	If this is case, try closing '''Grooper Design Studio''' and re-open it as an administrator. This will create and/or provide access rights to the required directory indicated by the error message.		If this is case, try closing '''Grooper Design Studio''' and re-open it as an administrator. This will create and/or provide access rights to the required directory indicated by the error message.
	\|
	~~[[File:MS Office Integration - Path Error.png\|center]]~~
	\|}
	\|}		\|}

Line 53:		Line 52:

	Like any '''Activity''', the '''Execute''' activity can be applied to a document in an "ad hoc" manner in '''Grooper Design Studio'''. This is typical for Grooper architects testing and designing solutions before building a '''Batch Process'''.		Like any '''Activity''', the '''Execute''' activity can be applied to a document in an "ad hoc" manner in '''Grooper Design Studio'''. This is typical for Grooper architects testing and designing solutions before building a '''Batch Process'''.

	~~{\|class="attn-box"~~
	\|-
	\|⚠
	\|
	Microsoft Word needs to be installed on the computer/server where Grooper is installed for the conversion to work. This only applies to Microsoft Word. Grooper will still convert Excel to CSV, even if Excel is not installed on the machine.
	\|}

	<tabs style="margin:20px">		<tabs style="margin:20px">

Randallkinard at 21:50, 21 November 2024

2024-11-21T21:50:32Z

← Older revision		Revision as of 16:50, 21 November 2024
Line 162:		Line 162:
	[[File:2023 Microsoft Office Integration - 2023 01 How To 03 Batch Processing Execution 01.png]]		[[File:2023 Microsoft Office Integration - 2023 01 How To 03 Batch Processing Execution 01.png]]
	\|}		\|}

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

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

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

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

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

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

Randallkinard at 14:53, 27 August 2024

2024-08-27T14:53:08Z

@@ Line 14: / Line 14: @@
 * [[Media:2023 Wiki MS-Office-Integration Batch.zip]]
 |}
 ==About==
@@ Line 183: / Line 162: @@
 [[File:2023 Microsoft Office Integration - 2023 01 How To 03 Batch Processing Execution 01.png]]
 |}

Randallkinard at 16:02, 10 May 2024

2024-05-10T16:02:59Z

@@ Line 14: / Line 14: @@
 * [[Media:2023 Wiki MS-Office-Integration Batch.zip]]
 |}
 ==About==
 '''[https://en.wikipedia.org/wiki/Microsoft_Office Microsoft Office]''' integration allows a '''Grooper''' user to leverage the native text of files generated in the Microsoft Office Suite such as '''[https://en.wikipedia.org/wiki/Microsoft_Word Microsoft Word]''' documents and '''[https://en.wikipedia.org/wiki/Microsoft_Excel Microsoft Excel]''' '''[https://en.wikipedia.org/wiki/Personal_Storage_Table spreadsheets]'''. This feature can pull the native text from and perform type-specific activities on these files.

Randallkinard: Randallkinard moved page 2023:Microsoft Office Integration to 2023:Microsoft Office Integration (Concept) without leaving a redirect: new naming convention

2024-04-17T14:50:50Z

Randallkinard moved page 2023:Microsoft Office Integration to 2023:Microsoft Office Integration (Concept) without leaving a redirect: new naming convention

← Older revision	Revision as of 09:50, 17 April 2024
(No difference)

Dgreenwood: /* About */

2024-03-26T20:51:09Z

About

← Older revision		Revision as of 15:51, 26 March 2024
Line 6:		Line 6:
	</blockquote>		</blockquote>
	<section end="glossary" />		<section end="glossary" />
			{\|class="download-box"
			\|
			[[File:Asset 22@4x.png]]
			\|
			You may download the ZIP(s) below and upload it into your own Grooper environment (version 2023). The first contains a '''Project''' with resources used in examples throughout this article. The second contains one or more '''Batches''' of sample documents.
			* [[Media:2023 Wiki MS-Office-Integration Project.zip]]
			* [[Media:2023 Wiki MS-Office-Integration Batch.zip]]
			\|}
	==About==		==About==
	'''[https://en.wikipedia.org/wiki/Microsoft_Office Microsoft Office]''' integration allows a '''Grooper''' user to leverage the native text of files generated in the Microsoft Office Suite such as '''[https://en.wikipedia.org/wiki/Microsoft_Word Microsoft Word]''' documents and '''[https://en.wikipedia.org/wiki/Microsoft_Excel Microsoft Excel]''' '''[https://en.wikipedia.org/wiki/Personal_Storage_Table spreadsheets]'''. This feature can pull the native text from and perform type-specific activities on these files.		'''[https://en.wikipedia.org/wiki/Microsoft_Office Microsoft Office]''' integration allows a '''Grooper''' user to leverage the native text of files generated in the Microsoft Office Suite such as '''[https://en.wikipedia.org/wiki/Microsoft_Word Microsoft Word]''' documents and '''[https://en.wikipedia.org/wiki/Microsoft_Excel Microsoft Excel]''' '''[https://en.wikipedia.org/wiki/Personal_Storage_Table spreadsheets]'''. This feature can pull the native text from and perform type-specific activities on these files.

Dgreenwood: /* How to Use */

2024-03-26T20:50:52Z

How to Use

@@ Line 16: / Line 16: @@
 ==How to Use==
 {|class="attn-box"
+|

Rpatton at 20:13, 13 March 2024

2024-03-13T20:13:57Z

← Older revision		Revision as of 15:13, 13 March 2024
Line 22:		Line 22:
	\|		\|
	You may download the ZIP(s) below and upload it into your own Grooper environment (version 2023). The first contains a '''Project''' with resources used in examples throughout this article. The second contains one or more '''Batches''' of sample documents.		You may download the ZIP(s) below and upload it into your own Grooper environment (version 2023). The first contains a '''Project''' with resources used in examples throughout this article. The second contains one or more '''Batches''' of sample documents.
			* [[Media:2023 Wiki MS-Office-Integration Project.zip]]
	* [[Media:2023 Wiki MS-Office-Integration Batch.zip]]		* [[Media:2023 Wiki MS-Office-Integration Batch.zip]]
	* [[Media:2023 Wiki MS-Office-Integration Project.zip]]
	\|}		\|}

← Older revision		Revision as of 16:50, 21 November 2024
Line 162:		Line 162:
	[[File:2023 Microsoft Office Integration - 2023 01 How To 03 Batch Processing Execution 01.png]]		[[File:2023 Microsoft Office Integration - 2023 01 How To 03 Batch Processing Execution 01.png]]
	\|}		\|}

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

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

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

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

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

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