Using the Data Pump with Holidays or One-Time-Dates

Navigation:  Holidays >

Using the Data Pump with Holidays or One-Time-Dates

Previous pageReturn to chapter overviewNext page

To export or import holidays and one-time-dates in the native Q++Studio database format use the Data Pump from the corresponding menu item of the data menu.

 

 

Exporting

 

To export:

 

Set the source to Q++ Shared Database.

Set the target to a path of your choice.

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.

Select the Recurring Holidays or One-Time-Dates you wish to export.

Select the target Holidays Set.

 

Importing

 

To import:

 

Set the target to Q++ Shared Database.

Set the source to a path containing the tables from which to import.

Select the Recurring Holidays or One-Time-Dates you wish to import.

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 languages available in the UnicodeSamples folder.

 

See also: exporting recurring holidays to Excel and exporting one-time-dates to Excel.


Topic 108967 updated on 06-Feb-2019.
Topic URL: https://www.qppstudio.net/webhelp_xe3/index.html?importingrecurringholidays.htm