Introduction #

Streamline Your 3CX Holiday Schedule with Our Free Tool – Say Goodbye to Manual Configuration

Discover a hassle-free solution for configuring holidays on your 3CX installation – introducing the free VoIPTools tool. Easily select National and Religious holidays from various countries worldwide and import them directly into your 3CX system, eliminating manual data entry and time-consuming searches. With the capability to import holidays up to 2029, you’ll save countless hours on holiday schedule updates. Don’t miss this opportunity to streamline your holiday scheduling and focus on business growth.

Why chose 3CX Holiday Importer? #

	SIMPLIFY HOLIDAY SCHEDULE CONFIGURATION	3CX Holiday Importer facilitates effortless import of National and Religious holidays from various countries into your 3CX system, streamlining the process and eliminating the need for manual configuration.
	TIME SAVING EFFECIENY	3CX Holiday Importer lets you import holidays up to the year 2029, eliminating the need for frequent updates and ensuring that your holiday schedule stays current for years ahead, thus freeing up your time for other essential tasks.
	INTERNATIONAL COMPATABILITY	The 3CX Holiday Importer allows businesses with international operations to choose holidays from countries worldwide. It offers comprehensive holiday coverage and ensures compliance across different regions.
	HASSLE-FREE HOLIDAY MANAGEMENT	Bid farewell to the stress of holiday schedule management with our complimentary tool that streamlines the entire process. Effortlessly import all your national and religious holidays, guaranteeing precision and preventing any overlooked dates.

Prerequisites #

Before installing ‘3CX Holiday Importer’, you need to ensure that your computer meets the minimum requirements mentioned below:

1. 3CX Version V18
2. Net framework 4.7.2
3. VoIPTools Relay installed on the 3CX server
4.  Microsoft Internet Information Server (IIS) 7.0 or above

NOTE:

• When installing SQL Server, we recommend you install it in “Mixed Mode” to include SQL Authentication, and install SQL Management Studio

• When installing IIS, be sure to install Basic Authentication, .Net Extensibility, and ASP.Net 4.X

Installation overview #

	DOWNLOAD SOFTWARE	You can order 3CX Holiday Importer online at https://www.voiptools.com.  Your order confirmation email will include your license key and a link to download the software.
	INSTALL PREREQUISITES	There are a number of prerequisites that must be installed prior to installing the 3CX Holiday Importer. These prerequisites include Microsoft Internet Information Server (IIS) and Microsoft SQL Server
	INSTALL 3CX HOLIDAY IMPORTER	This User Guide contains step-by-step instructions to successfully install 3CX Holiday Importer. Begin by extracting the installer from the downloaded zip file (Step 1 above), then run the setup program named HolidayImporter.exe
	REGISTER YOUR SOFTWARE	You must register your license key to activate 3CX Holiday Importer. Your license key is included in your order confirmation email, and can also be found in your order history on our website.

Step By Step Installation Procedure #

The following section guides you through a detailed walk-through of the installation process:

Step 1:  Download ‘3CX Holiday Importer’.   #

1. Find the software download link in the Order Confirmation Email, or you can find it in your order history on our website and download the 3CX Holiday Importer application.
2. In the Microsoft Defender SmartScreen, click the More Info option.

3. Click the Run Anyway option to start the installation.

Step 2:  Install Prerequisites #

Click on the software installer that was downloaded in step 1 above. The installation wizard will automatically identify the needed prerequisites and assist you with the install of the prerequisites needed to run ‘3CX Holiday Importer’. These include .NET Framework (Web Installer), SQL Server Express (Web Installer) and, SQL Server Management Studio.

1. Click the downloaded installer executable to launch the Prerequisites Setup Wizard and click Next.

2. In the Prerequisites window, the installer will identify the missing prerequisites. It is important that you install all the required prerequisites. However, you can select/unselect the applications to be installed based on your unique requirements. Click Next to continue.

The installer will download and install the selected applications.

Step 3: Start the installation process #

1. After all the prerequisites are installed, the 3CX Holiday Importer Setup Wizard appears. Click Next to Continue.

2. On the Select Installation Folder window, the Folder field displays the path where the 3CX Holiday Importer gets installed. You cannot change the location path.
3. Click Next to continue with the installation.

The installation is in progress. This may take several minutes to complete.

4. Click Next to continue when the installation is complete.

Step 4: Test Relay Settings #

1. In the 3CX Relay Services window, in the Relay Host field, enter the FQDN of your 3CX server.
2. Enter 8801 in the Relay Port field.
3. Enter the public key you took from VoIPTools Relay services in the Public Key text area.

4. Click the Test Relay Settings to confirm ‘3CX Auto Logout’ can communicate with the Relay services running on the 3CX server.
5. If the ‘3CX Auto Logout’ is successfully able to communicate with the Relay services that run on the 3CX server, a Success message box appears. Click OK. If the test fails, you will not be able to continue until communication with the relay is established.
6. Click Next to continue with the installation.

NOTE:

• You must set the Relay Port to 8801.
• If the Relay test fails, you cannot continue the installation until you establish communication with the Relay. Confirm the following if the test was unsuccessful,
  • Confirm you have the correct firewall port open (default TCP 8801) on the 3CX server and the firewall protecting the 3CX server.
  • Confirm that you have entered the correct FQDN for the 3CX server.
  • Confirm that the 3CX Auto Logout and Relay use the same port and protocol.

Step 5: Installing 3CX Holiday Importer #

1. In the Ready to Install window, click Install to start the installation of the ‘3CX Holiday Importer’.

The installation is in progress. This may take several minutes to complete.

2. Once the installation is complete, check Launch 3CX Holiday Importer check box and then click Finish. The 3CX Holiday Importer configuration screen opens. If you want to simply close the installer without opening the configuration screen, then simply uncheck Launch 3CX Holiday Importer check box and then click Finish

Step 7: Register your Software #

To ensure the authorization of your license key, it is necessary to complete the registration process. By registering with VoIPTools, you gain access to a range of benefits:

Key Replacement Assistance	In the unfortunate event of a lost license key, registering with VoIPTools lets us provide you with a replacement key promptly.
Product Updates and Reminders	By registering, you will receive timely notifications from VoIPTools regarding any product updates. Additionally, we will send reminders when your key is nearing its renewal date, ensuring uninterrupted access to our services.

Follow the procedure to register your software,

1. Double-click the 3CX Holiday Importer desktop icon to open the configuration application.
2. Click the License tab, and then in the License Key field, enter a valid license key.
3. Click Register to complete the registration.

NOTE:

The license key permits you to install this software on one computer. This is not free software.

3CX Holiday Importer Configuration Screen #

The 3CX Holiday Importer Settings configuration screen enables you to register software, import holidays for a specific country for a specific year, add custom holidays and edit or delete existing holidays.

Holidays Screen #

The holiday’s tab enables you to import holidays for a specific country for a specific year, add custom holidays and edit or delete existing holidays.

Toolbar definition #

The Toolbar lets you edit the custom holidays and the existing holidays in easy way.

	APPEND	Lets you add a new custom holiday.
	DELETE	Lets you delete an existing holiday or a new holiday that was created.
	EDIT	Lets you edit an existing holiday or a new holiday that was created.
	END EDIT	Lets you end editing the holidays
	CANCEL EDIT	Lets you cancel the edits done to the holidays.l

 Import Holidays #

1. On the 3CX Holiday Importer configuration screen, Click Holidays tab.
2. From the Country Holidays dropdown, select the country for which you want to import the holidays.
3. Click Get Holidays button to import the holidays of the selected country for the desired year.
4. Press the “Get Holidays” button to display a list of holidays.
5. Click Save to 3CX to import the holidays into 3CX.

NOTE:

• You can edit the list of holidays prior to importing into 3CX.

• Importing holidays replaces any existing holidays already configured in 3CX.

 Add/ Edit/ Delete Holidays #

You may wish to add custom holidays or choose not to import all of the holidays displayed. 3CX Holiday Importer enables you to add your own holidays, edit existing holidays, or remove holidays prior to importing them into 3CX.

At the bottom of the grid, you will see a list of controls for managing holiday records. Hovering over each control will display a tool-tip describing the function of each button. Using these buttons you can scroll through the list, add, edit, or delete holiday records.

Add Custom Holiday #

To add your own holidays, simply scroll to the bottom of the list of holidays displayed. At the bottom, you will see a blank row where you can add additional holidays.

1. Click the Append button to add a custom holiday.
2. In the Holiday field, enter the name of the holiday.
3. In the Day combo box, select or type the date for the holiday.
4. In the Month combo box, select or type the month for the holiday.
5. From the Year dropdown, select the year for the holiday.
6. Click Save to 3CX button to save the custom holiday to 3CX server.

Edit Holidays #

To edit an existing holiday, simply click on the holiday to be edited and make the desired changes. You can cancel your edits by pressing the “X” button. To save your edits, click on the checkmark control, or click on a different record.

1. From the holiday list, select the holiday that you want to edit.
2. At the bottom of the grid and from the toolbar, click the Edit button.
3. Observe that the Edit  symbol appears beside the holiday you want to edit.
4. Make the required changes to the holiday.
5. From the toolbar, click the End Edit button to end the modification.
6. Click the Save to 3CX button to save the changes to the 3CX server.
7. If you want to cancel the modification, click the Cancel button before you save the changes.

Delete Holidays #

• From the holiday list, select the holiday that you want to delete.
• At the bottom of the grid and from the toolbar, click  Delete button to delete the holiday.
• Click the Save to 3CX button to save the changes to the 3CX server.

NOTE:

This does not remove the holiday from the list of available holidays.

Clear Holiday List #

If you want to start over, you can clear the displayed list of holidays and start over again by reimporting the desired holidays.

1. On the 3CX Holiday Importer configuration screen, click Holidays tab.
2. Click the Clear Holidays button. This will remove any displayed holidays.

Reoccuring Holidays #

For those holidays that occur on the same day each year (‘New Year’s Day’ for example), you can set a holiday to reoccur every year.

1. Create a holiday that reoccurs every year on the same day.
2. From the Day and Month drop downs, select appropriate date and time.
3. From the Year drop down, select Each option.

Need Support? #

You get quick answers to most of your inquiries in our online manual. If you prefer direct contact, we offer various support channels, including phone, email, live chat, and our helpful VoIPTools forums.