ResourceCalendarImport

This is able to import specific resource calendars from a CSV file.

Example parameters

Example import file

"1","R119","26-08-2009 07:30","26-08-2009","Illness","closed"
"1","R119","27-08-2009 07:30","27-08-2009 16:00","Illness"
"2","R119","28-08-2009 07:30","28-08-2009 13:30","Vacation"
"3","R119","29-08-2009 16:30","30-08-2009 22:30","Overtime","open"

Description of the columns:

1. The first column represents the absense code. The absense codes must be mentioned in the absenseCodeMapping field in the Macro.
2. This is the resourceID.
3. Start period
4. End period
5. Cause. The description of the period. This text is shown as a tool tip text on the Gantt chart if the mouse is hovered on the period. This column is optional. If not specified the cause from the field ‘absenseCodeMapping’ is used. However if column six (availability) is specified this column must also be specified.
6. Availability. (open/closed). This column is optional. Default closed.

Parameter descriptions

(* = configuration required)

absenseCodeMapping ^*
Each mapping consists of three columns which is separated by commas. The mappings are separated by a semicolon.
A mapping consists of

1. The absense code.
2. the cause.
3. An html color.

dateFormat ^*
The date format of the start and end period.

The default is “dd-MM-yyyy HH:mm”.

deleteAfterImport
true The file(s) are deleted after import.
false

delimiter ^*
Specify how the columns in the import file are delimited.

fileName ^*
File name or file pattern of the import file(s).
Example. If we have three import files to import, named resourceCalendars1.csv, resourceCalendars2.csv and resourceCalendars3.csv, just specify resourceCalendars*.csv.

renameBeforeImport
true The file(s) are renamed before import. The text ‘_renamed’ is added to the filename. If file could not be renamed, the macro is stopped.
false

textQualifier
Specify the character or sequence which is wrapping each column in the import file. Default is “ (quotation mark).