To export or import holidays and one-time-dates in the native Q++Studio database format use the corresponding sub-menu item of the data pump menu item of the admin menu.
Exporting
To export:
1.Set the source to Q++ Shared Database.
2.Set the target to a path of your choice.
3.If export tables already exist in the selected path, then the exported data will be added to the existing tables. Otherwise Q++Studio will ask you if it should create the export tables.
4.Select the Recurring Holidays or One-Time-Dates you wish to export.
5.Select the target Holidays Set.
Importing
To import:
1.Set the target to Q++ Shared Database.
2.Set the source to a path containing the tables from which to import.
3.Select the Recurring Holidays or One-Time-Dates you wish to import.
4.Select the target Holidays Set.
Data Pump Actions
You then have 3 possibilities:
Copy Items |
Copies items selected on the left into the Holidays Set selected on the right. The source and destination sets must be leaves (not folders). |
Set Only |
Creates a duplicate of the Holidays Set selected on the left, below the Holidays Set selected on the right. The destination set must be a folder. Only the set information is copied; none of its contents are copied. |
Set and Items |
Creates a duplicate of the Holidays Set selected on the left, below the Holidays Set selected on the right. The destination set must be a folder. The set information is copied and any selected one-time-dates on the left. |
Usage
You can set both the source and targets to Q++ Shared Database which allows you to copy data from one data set to another in the shared database.
You can also set the source path to Q:\Q++ServerXE3\UnicodeSamples\ and the target to Q++ Shared Database, and import into your database some of the sample public holidays available in the worldwide holidays folder.
See also: exporting recurring holidays to Excel and exporting one-time-dates to Excel.
Topic 108967, last updated on 14-Aug-2023
