Integrate Settings
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.
There are four formatting presets present. Comma & Period Preset is the default preset as shown in the image below.
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.
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.
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.