You can periodically import the latest folder (or specified folder).

You can periodically run Wagby's import function.

Figure 1 Job settings
  1. Log on with an account with administrator privileges.
  2. Open the "Job Management" "Job Schedule Search" screen from the menu.
  3. Click the "Register Screen" button to register a new job schedule.
  4. Select "RegularImport" from the job name."Import" is displayed in the explanation column below that.
  5. Write job parameters.[To be described later]
  6. Specify the schedule.
  7. Check the "valid" flag.
  8. Enter the account and password of the administrator who will execute this job.From the security point of view, the import job can only be run by the administrator (admin).
  9. Register the job schedule.The job will be executed at the specified time.

Maintenance mode is automatically entered while this job is running.During this time, other users can not log on.(There is also an option not to switch to maintenance mode.)

How to specify the import folder

Specify the job parameter dir.The origin folder is export.

Automatically use the latest export folder

If you do not specify the job parameter dir, the data_XXX folder of the newest date in the export folder will be imported.However, the data_init and data_build folders are excluded.If the corresponding folder does not exist, the import process will not be performed.

In addition, folders once imported will be skipped the next time.This is a measure to prevent accidents importing the same folder twice.(A file called ".autoimport" is prepared in the folder imported by the job.This is a marker.)

Designation of models not to be imported

For models not to be imported by jobs, specify the model name using job parameter exclude.

For example, if you import a job schedule (jfcjobschedule) model, an operation mistake is assumed that the job schedule whose job name is RegularImport is erased.In this case, troubles can be avoided by specifying jfcjobschedule as the job parameter exclude.

Job parameter list

You can specify more than one parameter to specify for the job. The parameters that can be specified here are as follows.

Parameter name Required Description Description example
dir Specify the name of the folder to be imported.The starting point is export.If this parameter is not specified, the folder with the latest date (and the folder which has not been imported by the job yet) existing in the export folder is selected.For compressed files, give ".zip".
target If you write a model name (English) with a space separator, only this model will be imported.If this parameter is not specified, all models are eligible. customer support
exclude If you write a model name (English) with a space separator, you exclude this model from the import. staff product
drop Normally, the import process involves table deletion and recreation processing.But if you set this option to false, we will use the existing table as it is.However, when operating, it is necessary to consider separately deleting existing data in SQL delete statement in advance.When this specification is omitted, it is treated as true. true
maintenance When executing this job, specify whether to switch to maintenance mode.Default is "true" (maintenance mode is applied). false
maintenanceOption Specify how to respond to the account that was logged on when switching to maintenance mode.[Optional] Logout: Force logout of the account logged on before job execution.
Fail: If there is an account logged on before job execution, cause the job to fail.
(Default): Switch the mode while leaving the logged on account unchanged.
The execution result of the job is described in the log file (system.log).
If more than one parameter with the same name is defined, the last parameter is valid.

You can temporarily disable the job.

  1. Log on with an account with administrator privileges.
  2. Open the "Job" "Job Schedule Search" screen from the menu.
  3. Search the applicable "Job Schedule" and open the maintenance screen.
  4. Uncheck the "Enabled" flag and save it.
    Figure 2 Disable Job

You can send the job execution result by e-mail.

Multiple job execution can not be performed.

If you make a job start every minute, if execution of this job is not completed in 1 minute, a new job will not be executed.

If there are many data to be imported, the web browser may time out before the processing is completed normally by operation from the "Import Export" screen.To make this correspondence, I will explain how to use the immediate execution function of import job.

Confirm export file

Use the "External command execution" function to check the contents of the export folder beforehand.

  1. The command to be executed is cmd/C "dir .. \ .. \ export".(Windows OS case)
  2. Sets the execution result to be sent by e-mail.
  3. Execute the external command immediately.The result will be sent to the specified mail address.Check the target export folder name.

Immediate execution of import job

  1. Specify the dir parameter.(When using default, use the latest export folder.For details, please read "Specifiable job parameters")
  2. Specify the target parameter.When omitting, all models are targeted.
  3. Specify other parameters as necessary.
  4. Specify the function to send the job result by e-mail.
  5. Specify the job execution account.The job does not have to be valid.
  6. Execute the job immediately.When the import process is completed, the result will be sent by e-mail.

In the import job, the two models "juser" and "jprincipal" are alwaysNot covered.