|
Using the Data Pump with Holidays or One-Time-Dates |
  
|
Using the Data Pump with Holidays or One-Time-Dates
|
Using the Data Pump with Holidays or One-Time-Dates |
|
To export or import Holidays and One-Time-Dates to technical support, or a Q++ user at a different location, use the Data Pump (to export to an MS-Excel file, see exporting recurring holidays and exporting one-time-dates).
Select the corresponding menu item from the Data menu, to import/export Recurring Holidays or One-Time-Dates.
To export :
•Set the source to QppShare (ANSI) or Q++ Shared Database (Unicode).
•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++ 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.
To import :
•Set the target to QppShare (ANSI) or Q++ Shared Database (Unicode).
•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.
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 the holidays rules it contains 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 Holidays Rules on the left. |
Advanced Update |
To compare a holidays set you copied from the Q++ Samples with the original, and lets you update the set using holidays synchronization. |
Note that you can set both the source and targets to QppShare (ANSI) or Q++ Shared Database (Unicode), which allows you to copy data from one data set to another if the shared database.
You can also export to Excel both Recurring Holidays and One-Time-Dates. These Excel files are not re-useable by Q++, but have the advantage of being a standard format which can be shared with colleagues in other departments such as proof-reading.