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:

While installing SQL Server, ensure the following,

• Uninstall the previous versions of SQL Management Studio manually before installing the new version.
• Install it in “Mixed Mode” to include SQL Authentication, and install SQL Management Studio

NOTE:

• 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.

3. In the Microsoft SQL Server License Terms click the Accept button to acknowledge the license terms and continue.
   • This page appears if you do not have SQL Server Express preinstalled in your device.

4. View the SQL Server Media target location in the Media Location field. If required, you can click the Browse button to change the location. Click Install to begin the installation of SQL Server Express.

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

5. Click the Close button once the prerequisites are installed.

Microsoft SQL Management Studio installation is in progress. This may take several minutes to complete.

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 #

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.

24/7 Support Availability #

Rest assured, our dedicated team is here to assist you around the clock, every day of the year. Whether you’re based in the USA or India, we’re ready to provide prompt responses to your technical queries.

Windows Event Log for VoIPTools Applications and Services #

For troubleshooting any application errors, our Windows Event Log contains a comprehensive list of error messages, warnings, and informative notes related to all our VoIPTools applications and services. It’s a valuable resource to help you pinpoint and resolve any issues you may encounter.

Join Our Forum Community #

Are you looking to collaborate with other VoIPTools customers facing similar challenges? Our forum is the perfect platform to exchange ideas, solutions, and best practices. Join the conversation at: https://www.voiptools.com/community/

Real-Time Live Chat Assistance #

Got questions that need immediate answers? Our chat support team is available to assist you in real time. Just click on the Live Chat button located at the lower right corner of our website, and we’ll acknowledge your queries right away.

Efficient Email Support #

To ensure a thorough understanding of your concerns, email us at support@voiptools.com. Describe your issue in detail, and we’ll get back to you within one business day with the support you need.

Reach Us by Phone #

If you prefer to speak with a representative directly, you can reach us at +1 801-642-4655. Our attentive team is available to take your calls from 8:00 AM to 6:00 PM (Central Standard Time).

Free Support #

If you’ve purchased our products through a VoIPTools Partner, rest assured that they provide first-level support at no additional cost. Partners have access to 100% free technical assistance and actively participate in the troubleshooting process.

VoIPTools customers enjoy access to our online manuals and receive support through emails (with responses within one business day) and live chat. However, please note that we do not provide remote server login assistance.

Paid Support #

For a more hands-on experience, consider our “Installation Support” package. Our expert support team can log in to your servers, and install and configure all our tools. This comprehensive service includes setting up SQL Server Express and Internet Information Server if necessary. We’ll work closely with you to tailor our applications to meet your requirements.

We’re committed to providing top-notch support to ensure your VoIPTools experience is smooth and hassle-free. Contact us today, and let us assist you in making the most of our powerful tools!