How To - Perform a manual export of data from SIPP/SSAS~Pro and import into Report~Pro

Overview:

Within FileMaker, there is a file called 'ExportRP.FP5' which exports the data that sits in SIPP/SSAS~Pro into a series of CSV's that are then imported into Report~Pro. This process is normally handled by an automated scheduled task called 'ExportRP' that runs once an evening ahead of the overnight import into Report~Pro (DMM SQL databases).

Disabling the ExportRP Scheduled Task

For the 'ExportRP' process to run properly, the 'FileMaker Server' service must be stopped. Before stopping the service, please follow this link for instructions on how to ensure no one is logged into FileMaker - https://forms.office.com/r/kbZmHS9EaY

Open 'Services', look for the service 'FileMaker Server' right click it and select 'Stop'
Now open 'Task Scheduler' and locate the 'ExportRP' scheduled task (this may reside within a folder called 'Delta')
Right click the task and select 'Run'
The status will then change to 'Running' and, upon completion, the status will go back to 'Ready'
Once the status goes back to 'Ready' you can proceed with running the SQL import job

Manually running the SQL import job

To run the SQL import job, please do the following:

Open 'SQL Server Management Studio', and connect to the desired SQL instance
In the left hand pane, select 'SQL Server Agent' and select 'Jobs', you will then see a list of the SQL jobs that have been configured
To run the SIPP import, right click the job called 'Delta SIPP~Pro Import, Process and Export Files' and select 'Start Job at Step' and select 'Start'. To run the SSAS import, right click the job called 'Delta SSAS~Pro Import, Process and Export Files'
A small window will then pop up and show the progress of the job.

How to disable jobs

Disabling the ExportRP Scheduled Task

Open 'Task Scheduler' and locate the 'ExportRP' scheduled task (this may reside within a folder called 'Delta')

Right click the task and select 'Disable'
Once disabled, you will see the 'Status' column change to show that the job is now disabled

Disabling the SQL Import Job

To disable the SQL import job, please do the following:

Open 'SQL Server Management Studio', and connect to the desired SQL instance
In the left hand pane, select 'SQL Server Agent' and select 'Jobs', you will then see a list of the SQL jobs that have been configured
To run the SIPP import, right click the job called 'Delta SIPP~Pro Import, Process and Export Files' and select 'Disable'. To disable the SSAS import, right click the job called 'Delta SSAS~Pro Import, Process and Export Files' and select 'Disable'