Skip to content
  • There are no suggestions because the search field is empty.

Integrate Settings

How to Configure Integrate Settings

First log in as an Administrator (see instructions).


Number Format Preference

Number format preference allows you to choose from a set of presets, each representing common formatting styles and the possibility to customise them. It gives you control over the number formatting within your reporting project. Your chosen settings are applied throughout the project. To ensure that you preference is applied correctly when using Integrate, it's important to use the default thousand separator in your Excel number formats.

Please note: You need to set the number format reference before you upload your data source file. If you need to modify your preference after you have already added your data source file in CtrlPrint, an update will be available for all linked elements. Then, you need to refresh your documents with the updates (see this support article on how to refresh data source).

Administrators can modify the number format preference as shown in the images below.

Screenshot 2025-03-03 at 20.56.42.png

Comma and Period.png

There are four formatting presets present. Comma & Period Preset is the default preset as shown in the image below. 

Preference.png

You can also set up a custom format if needed for the thousand separator, decimal separator and negative sign as shown in the image below.

Custom Format.png


Date and Time Format Preference

Date and time format preference allows you to select a date and time format in Integrate. It directly affects how date and time values from your Excel data source are displayed when used in a chapter in the project. Integrate targets default Excel date formats, including short date, long date, short time, long time and translations of months and days.

Please Note: Custom date formats from the Excel data source are not affected by the date and time format settings, except for translations of months and days in both short and long written forms (e.g., January, Jan, Monday, Mon).

Administrators can modify the number format preference as shown in the images below.

Date.png

Date and Time format.png

If you find that a specific date and time format locale you require in your project is not currently available within Integrate, please let us know.


Restore Data Sources

Restore Data Sources allow you to restore and recover data sources that have been deleted from your project. To restore a data source, navigate to Integrate Settings and access the Restore Data Sources tab. You will see a list of deleted data sources. Click Restore next to the data source as shown in the image below.

The data source owner and administrators can restore the deleted data sources. To see who has permission to perform all the actions related to Integrate settings, please go to Manage Permissions

 

Restore.png