Exact Synergy Enterprise

Exact.Jobs.FinExcel

Introduction

There are several ways of exchanging data from Exact Globe to Exact Synergy Enterprise. One of the means is the import of a Microsoft Excel file which is attached to a document. The imported entry can be stored as a budget entry or as an actual financial entry. Detailed information of the functionality can be found in this document. For the purpose of this document, it is sufficient to know that your users can create documents in specific categories and the attachments of these documents can be imported as financial entries via this background job. Based on the document type, it can be determined whether a budget or actual transaction is imported.

Technical information

The table involved in the creation of entries is gbkmut.

The former syntax is as follows:

E:\Program Files\Exact Software\Exact Synergy\bin\ RPExcelImport.exe /S:ServerName /D:DatabaseName

The new syntax is as follows:

Exact.Process.exe /DBCONFIG:<virtualdirectory> /ASSEMBLY:<bgJob Assembly> /CLASS:<bgJob Class>

This results in:

E:\Program Files\Exact Software\Exact Synergy\bin\Exact.Process.exe /DBCONFIG:SynergyNET /ASSEMBLY:Exact.Jobs.FinExcel /CLASS:FinExcel

Parameters

There are no specific parameters for the FinExcel background job. The command line parameters are case-sensitive.

Syntax

As the syntax of this background process is relatively straightforward, refer to the previous paragraph that describes the sample syntax.

Troubleshooting