From Fishbowl
Jump to navigation Jump to search

Icon.Schedule.png The Schedule Module is where you set Fishbowl to automatically backup your database as well as import or export information such as exporting to QuickBooks, or importing orders from an internet shopping cart such as Yahoo Shopping Cart. You can schedule tasks as close together as seconds or as far apart as years.

The following functions are available through the Schedule Module:

  • Create a new scheduled task
  • Edit or delete an existing scheduled task
  • Activate or inactivate a scheduled task
  • View a history of scheduled tasks

Create a New Schedule Task

In the Setup Module Group | Schedule Module click the New File:New.JPG button located on the Module Toolbar. Choose a Name and Description for the type of Schedule you wish to create.


Next choose the frequency for which you would like the task to run. You may select every Second, Minute, Hour, Day, Week, Month, Year, or upon Event. Most of the schedules will also ask a time for the task to run. If you chose to run upon an event, select from the drop down list which event to run after.


After you have scheduled your date and/or time, specify the type of task you would like whether it be an import, export, javaclass, QuickBooks export, or database backup.

  • Import: Customers using EDI may want to import items such as Sales Orders, Purchase Orders, etc. If importing you will need to browse to the directory of where your file is stored. Then enter in the Mask (usually .csv) and select the import type.

  • Export: First you will need to browse to the directory of where you would like to export to. You can then enter in the file name and the type of file to be exported.

  • Java Class: A Java Class can be scheduled to run either at a scheduled time or during an event. The file to be run must implement the com.fbi.TimerTask.IFBRunnable interface. Once the file is compiled it can be added to the class path where the server will be able to load it and run. It can be added to the class path by placing it in the /server/lib directory.

  • QuickBooks Export: You may schedule an export to QuickBooks by selecting the type QuickBooks Export. In order to export through the scheduler Fishbowl and QuickBooks need to have been synced through the Accounting Configuration Wizard. [Note: the directory settings on import and export are for the directories on the Server. If somebody is using a Client rather than the Server, they must make sure they are mapping to a directory on the Server. Mapping to a directory on the Client and not the Server will cause the import/export to fail.]

  • Database Backup: Simply select the Database backup type and then browse to the directory of where you would like Fishbowl to create a backup. For information on how to restore a backup database see How do I restore a backup database?

Once you have created your task click Save in the Module Toolbar to finalize your settings.

View Schedule History

You may view any Scheduled Task's history by double clicking on the task in the search panel then clicking the History subtab on the main screen. The History will inform you of the date, time, and result of the task.


Edit or Delete a Scheduled Task

A scheduled task may be edited or deleted by going to the Setup Module Group | Schedule Module. Double Click the desired task from the Search column and wait until the information for the task is displayed on the main screen. If the task is being edited, simply change any of the allowed information shown on the main screen. After the correct changes have been made, make sure to choose the save icon from the Module Toolbar to save your changes.

If you wish to delete a scheduled task, simply double click the desired task from the Search column and wait until the information is displayed on the main screen. Next, choose the Delete icon from the Module Toolbar. The task will be deleted; however it may be re-created again at any time using the Create a new schedule task instructions.