SmartFusion Modules > System Setup > Data Entry > System File > Open Gov

Recent Change: 
6.138
- Changed the daily actuals export to pull all entries with posting date from 7/01/2020 to the current date.

6.130
- Enabled all the file paths.
6.126
- Added new system setting for exporting daily Budget Prep actuals/budget amendments.
- Added stored procedures and a view to create a SQL Server Agent Job and execute it

Introduction

A license for OpenGov Export will be needed to access this functionality. This system setting allows the creation of the daily export files and historical/future budget data files to the export path set up in the System File.

In addition, a compatible version of SQL Server with SQL Server Agent functionality is required. Specifically, SQL Server Express is not supported.

Selections

Daily Export Settings

• File Path For Daily Actuals
• File Path For Daily Budget Amendments

• Time Increment (in hours)

• File Path For Historical Exports

• File Path For Future Budget Export

Export File Layout for Daily/Historical Budget Prep data:

http://rand-wiki.harriscomputer.com/Page/5774/OpenGovBudgetPrepLayout

Outline of Process

• The SQL Server Agent service will need to be running
• User will need to login using a SQL server name and not "localhost"
• User will complete field selections
• On "Save", the user will be asked if they want to create/update a SQL Server Agent job; If they answer "Yes" the settings will be saved and the job will be started with the new settings; If they answer "No" the settings will not be saved and the job will not be started (The user will be notified accordingly)