;********************************************************************* ;* * ;* File name : downtime.txt * ;* Author : Luca Albanese, BaanSCS Technical Support * ;* Creation date : February 3, 2000 * ;* Reference : sched_brimport_guide.pdf (Scheduler docum.) * ;* * ;* Description : * ;* * ;* BRImport example file that can be used to import downtime lists * ;* for specific machines. Edit the [Data] section, replacing the * ;* "CUT-11" and "CUT-12" with the machines codes you wish to update * ;* in your database. You can add as many blocks as needed to cover * ;* all your machines. Edit the downtime periods so that they * ;* represent your needs, but make sure to use the same date format, * ;* e.g. YYYY-MM-DD HH:MM, or modify it in the [Config] section * ;* accordingly. * ;* * ;* * ;* Utilization : * ;* * ;* x:\[Scheduler PATH]\Import\BRImport.exe * ;* /DATA:[import file PATH]\downtime.txt * ;* /USER:[Scheduler DB name] /PSW:[Scheduler DB password] * ;* /DSN:[Oracle alias pointing to Scheduler's server] * ;* /DBTYPE:oracle * ;* * ;* Note: Verify that the paths specified below for the ErrorFilePath * ;* and LogFilePath parameters, in the [Config] section, exist. * ;* Modify them if needed. * ;* * ;********************************************************************* [Config] ErrorFilePath=d:\ LogFilePath=d:\ DateFormat="%Y-%m-%d %H:%M" VariablePrefixChar=% Language=ENU LogInfo=False [Format] ;*** Vector's Declaration RSC =Resource: Code RSCDT =RscDownTime: StartDate, EndDate [Data] ;*** Create downtime list for specified machines =UPDATE(RSC, Code, "CUT-11"): =M_INSERT(DownTimeList, RSCDT): 2000-01-31 15:00, 2000-02-01 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-01 15:00, 2000-02-02 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-02 15:00, 2000-02-03 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-03 15:00, 2000-02-04 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-04 15:00, 2000-02-05 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-05 15:00, 2000-02-06 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-06 15:00, 2000-02-07 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-07 15:00, 2000-02-08 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-08 15:00, 2000-02-09 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-09 15:00, 2000-02-10 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-10 15:00, 2000-02-11 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-11 15:00, 2000-02-12 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-12 15:00, 2000-02-13 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-13 15:00, 2000-02-14 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-14 15:00, 2000-02-15 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-15 15:00, 2000-02-16 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-16 15:00, 2000-02-17 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-17 15:00, 2000-02-18 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-18 15:00, 2000-02-19 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-19 15:00, 2000-02-20 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-20 15:00, 2000-02-21 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-21 15:00, 2000-02-22 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-22 15:00, 2000-02-23 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-23 15:00, 2000-02-24 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-24 15:00, 2000-02-25 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-25 15:00, 2000-02-26 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-26 15:00, 2000-02-27 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-27 15:00, 2000-02-28 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-28 15:00, 2000-02-29 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-29 15:00, 2000-03-01 07:00 =UPDATE(RSC, Code, "CUT-12"): =M_INSERT(DownTimeList, RSCDT): 2000-01-31 15:00, 2000-02-01 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-01 15:00, 2000-02-02 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-02 15:00, 2000-02-03 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-03 15:00, 2000-02-04 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-04 15:00, 2000-02-05 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-05 15:00, 2000-02-06 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-06 15:00, 2000-02-07 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-07 15:00, 2000-02-08 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-08 15:00, 2000-02-09 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-09 15:00, 2000-02-10 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-10 15:00, 2000-02-11 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-11 15:00, 2000-02-12 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-12 15:00, 2000-02-13 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-13 15:00, 2000-02-14 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-14 15:00, 2000-02-15 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-15 15:00, 2000-02-16 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-16 15:00, 2000-02-17 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-17 15:00, 2000-02-18 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-18 15:00, 2000-02-19 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-19 15:00, 2000-02-20 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-20 15:00, 2000-02-21 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-21 15:00, 2000-02-22 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-22 15:00, 2000-02-23 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-23 15:00, 2000-02-24 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-24 15:00, 2000-02-25 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-25 15:00, 2000-02-26 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-26 15:00, 2000-02-27 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-27 15:00, 2000-02-28 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-28 15:00, 2000-02-29 07:00 =M_INSERT(DownTimeList, RSCDT): 2000-02-29 15:00, 2000-03-01 07:00